(No Ratings Yet)
Loading ...« Linux Oracle tuning parameter : ulimits | Main | Linux Oracle tuning parameter : Tune TCP »
Linux vs. Oracle Tuning, Error : ORA-00845: MEMORY_TARGET not supported on this system
By Martin | June 5, 2009
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
Topics: LINUX, Oracle | No Comments »
Trackback URL for this post: http://www.bearparc.info/2009/06/05/linux-vs-oracle-tuning-error-ora-00845-memory_target-not-supported-on-this-system/trackback/
Comments
You must be logged in to post a comment.