将MEMORY_TARGET调整为2048M后,重启数据库报错
$ oerr ora 845 00845, 00000, "MEMORY_TARGET not supported on this system" // *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux. // *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.
这是由于MEMORY_TARGET设置大于/dev/shm,在11g中Oracle引入了MEMORY_TARGET参数管理内存,但这个参数不能大于/dev/shm,否则会报错,Oracle在metalink的文档:Doc ID:Note:460506.1中进行了说明。
解决方法:
因之前没有做spfile的备份,只能修改/dev/shm的大小,修改如下
# vi /etc/fstab 将 tmpfs /dev/shm tmpfs defaults 0 0 改为 tmpfs /dev/shm tmpfs defaults,size=4096M 0 0 保存退出。 # umount /dev/shm # mount /dev/shm
原文:http://www.cnblogs.com/B97128721/p/3568705.html