Sunday 21 April 2013

ORA-00845: MEMORY_TARGET not supported on this system

ORA-00845: MEMORY_TARGET not supported on this system


I got an error "ORA-00845" while starting up the database first time after the oracle 11gr2 software installation.

 The reason for this error is that shared memory file system size was less than the MEMORY_TARGET initialization parameter value.

so I increased the shared memory file system size to 1500m by using the below command.

mount -t tmpfs shmfs -o size=1500m /dev/shm

To have this value persistently for the mount /dev/shm I have updated the below entry to /etc/fstab file.


tmpfs                   /dev/shm                tmpfs   size=1500m      0 0

This issue has been resolved as the the memory target value can be accomodated in the shared memory file system.



No comments:

Post a Comment