已索引

当启动实例时,可能会发生该错误。

Oracle对该错误说的很清楚:

$ oerr ora 00845
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.

总结为两个原因:
1.MEMORY_TARGET参数太大,实际剩余内存不能满足该参数值
2.如果剩余内存远大于参数值,还是报该错误,则多是/dev/shm的问题,这种情况多发生在生产物理内存扩容,加大MEMORY_TARGET参数后。

$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              967G   22G  896G   3% /
/dev/sda2              99M   12M   82M  13% /boot
tmpfs                1014M  264M  750M  27% /dev/shm

可以在/etc/fstab中通过defaults,size=2G来修改该大小,然后原子remount即可。

-- By 许望(RHCA、OCM、VCP)
最后修改:2023 年 09 月 26 日 02 : 39 PM
如果觉得我的文章对你有用,请随意赞赏