0%

完美解决ORA-00845 MEMORY_TARGET not supported on this system

Linux下,Oracle 11g的自动内存管理不能指定大于这个/dev/shm的总量内存。否则就会出现如下错误:

1
ORA-00845: MEMORY_TARGET not supported on this system

修改/etc/fstab,修改tmpfs大小,如果没有则需要自己添加:

1
2
3
# vi /etc/fstab

tmpfs /dev/shm tmpfs defaults,size=10240M 0 0

重新挂载:

1
2
3
4
5
6
# mount -o remount /dev/shm
# df -h

Filesystem Size Used Avail Use% Mounted on
/dev/sda1 9.7G 4.6G 4.7G 50% /
tmpfs 10.0G 228K 10.0G 1% /dev/shm