Linux Share Memory

最新推荐文章于 2024-11-11 21:43:09 发布

Xuchao_Lee

最新推荐文章于 2024-11-11 21:43:09 发布

阅读量501

点赞数

分类专栏： Linux 文章标签： SHMMALL SHMMAX ORA-27102

本文链接：https://blog.youkuaiyun.com/Xuchao_Lee/article/details/52873185

版权

Linux 专栏收录该内容

0 篇文章

订阅专栏

本文介绍了解决启动Oracle实例时遇到ORA-27102内存不足错误的方法。通过调整Linux系统的shmmax参数，增大共享内存段大小，有效避免了因内存分配失败导致的服务启动问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SHMMAX is the maximum size of a single shared memory segment set in “bytes”.
SHMALL As SHMALL is the total size of Shard Memory Segments System wide,it should always be less than the Physical Memory on the System and should be greater than sum of SGA’s of all the oracle databases on the server.

/proc/sys/kernel/shmmax /etc/sysctl.conf

I got the ORA-27102 error upon instance startup:
SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
The solution was to increase kernel.shmall from 2097152 (as it is in the install doc for oracle 10h and oracle 11g) to 4194304. Probably is better to leave the RHEL5 default which is 4294967296