Search Results
Linux vs. Oracle Tuning, Error : ORA-00845: MEMORY_TARGET not supported on this system
The ORA-00845:can arises for the following two reasons on linux system.
1)If the shared memory which is mapped to /dev/shm directory is less than the size of MEMORY_TARGET or MEMORY_MAX_TARGET.
or,
2)If the shared memory is not mapped to /dev/shm directory.
Make sure /dev/shm is properly mounted. You can see it by,
df -h
Filesystem Size Used Avail Use% Mounted on
…
shmfs 30G 15G 15G 30% /dev/shm
As a root user,
mount -t tmpfs shmfs -o size=30g /dev/shm
In order to make the settings persistence so that it will affect after restarting machine add an entry in /etc/fstab similar to the following:
shmfs /dev/shm tmpfs size=13g 0
Posted in LINUX, Oracle | June 5, 2009