Sunday, June 8, 2008

ORA-00845 MEMORY_TARGET not supported on this system

problem:
ORA-00845 MEMORY_TARGET not supported on this system

solution:

login as root ,run
umount /dev/shm
mount -t tmpfs tmpfs /dev/shm -o size=2g (by default, it's half of the system RAM size without swap)

or make it permanent, to add size=2g to /etc/fstab, then run
mount -o remount /dev/shm

note: for more info on tmpfs, search google on 'redhat kbase faq shm size'

kernel documentation on tmpfs is at http://www.kernel.org/pub/linux/kernel/people/marcelo/linux-2.4/Documentation/filesystems/tmpfs.txt

No comments: