ORA-00845: MEMORY_TARGET not supported on this system

I have created a pfile with memory_target=1G parameter and tried to start the database.

[oracle@node3 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 13 20:03:37 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile=/oradisk/DATA/TEST/initTEST.ora
ORA-00845: MEMORY_TARGET not supported on this system
SQL> quit

This is because “/dev/shm” (tmpfs) file system is less than 1G of size. we should have more space than memory_target parameter.

Solution :-

Before increasing the space

[oracle@node3 ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda5             9.5G  649M  8.4G   8% /
/dev/sda9             2.9G   70M  2.7G   3% /opt
/dev/sda8             4.8G  139M  4.4G   4% /home
/dev/sda7             4.8G  2.7G  1.8G  60% /usr
/dev/sda10            1.9G   36M  1.8G   2% /usr/local
/dev/sda6             4.8G  209M  4.3G   5% /var
/dev/sda3             9.5G  153M  8.9G   2% /tmp
/dev/sda1             2.9G   77M  2.7G   3% /boot
tmpfs                1006M     0 1006M   0% /dev/shm
/dev/sda11             25G  8.2G   16G  36% /oradisk
/dev/hdc              3.4G  3.4G     0 100% /media/RHEL_5.4 x86_64 DVD
192.9.1.101:/u01/BACKUP
                       59G   18G   38G  33% /BKP

[root@node3 ~]# umount /dev/shm

[root@node3 ~]# mount -t tmpfs -o size=5g tmpfs /dev/shm

[root@node3 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda5             9.5G  649M  8.4G   8% /
/dev/sda9             2.9G   70M  2.7G   3% /opt
/dev/sda8             4.8G  139M  4.4G   4% /home
/dev/sda7             4.8G  2.7G  1.8G  60% /usr
/dev/sda10            1.9G   36M  1.8G   2% /usr/local
/dev/sda6             4.8G  209M  4.3G   5% /var
/dev/sda3             9.5G  153M  8.9G   2% /tmp
/dev/sda1             2.9G   77M  2.7G   3% /boot
/dev/sda11             25G  8.2G   16G  36% /oradisk
/dev/hdc              3.4G  3.4G     0 100% /media/RHEL_5.4 x86_64 DVD
192.9.1.101:/u01/BACKUP
                       59G   18G   38G  33% /BKP
tmpfs                 5.0G     0  5.0G   0% /dev/shm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s