ORA-27102: Out of memory error

 

ORA-27102: Out of memory error

Doc ID:

Note:430492.1

 

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.3
Linux x86

Symptoms

ORA-27102, Out of memory error

Cause

For 32 bit system running smp kernel, we cannot have SGA > 1.7 GB directly. This is because of
limitation of 32 bit systems of not being able to address memory > 4GB directly by a user process.
If SGA is kept higher than 1.7 GB, it will results in ORA 27102 errors.

While invoking dbca or creating starter database, by default it takes 40% of memory for SGA.
Hence the size can accidentally exceed 1.7 GB

Solution

The workaround is to create a new database, and specify the size of SGA approximate to be 1.5 to
1.7 GB.

References

Note 260152.1 - Summary About the Large SGA & Address Space on RH Linux

Errors

ORA-27102 out of memory

 

有一次在 linux 32位os 、物理内存是16G、 oracle9i 环境， 将 kernel.shmmax 调整为 8G，结果报这个错，数据库无法启动，还来改回原来的2G ，

启动正常。   32位os 上oracle sga 最大限制是1.7G， 但是对pga 没有这个限制。