ORA-00845: MEMORY_TARGET not supported on this system - Linux Servers

Customer may receive the below error messages on Linux Machines ::

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> STARTUP NOMOUNT PFILE="/opt/oracle/admin/day/pfile/day2.ini";
ORA-00845: MEMORY_TARGET not supported on this system

Solution

Increase the /dev/shm mountpoint size.

For example:

# mount -t tmpfs shmfs -o size=7g /dev/shm

Also, to make this change persistent across system restarts, add an entry in /etc/fstab similar to the following:

shmfs /dev/shm tmpfs size=7g 0

NOTE: You should check with your OS Administrator and/or alert.log for information on "best" size fo shm.[@more@]