ORA-27102: out of memory

ORA-27102: out of memory

64bit RedHat Linux,

[Oracle @ DB ~] $ Uname-
Linux DB 2.6.32-279. el6.x86 _ 64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

The physical memory is 16 GB. When the SGA allocates 4 GB memory, the instance can be started normally. If the memory usage exceeds 4 GB, an error "out of memory" is reported.

SQL> startup nomount pfile = '/home/oracle/init. ora'
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device

Check metalink and check the current Kernel Parameter settings because the Kernel Parameter shmall is too small:

$ Cat/proc/sys/kernel/shmall
2097152

This value is also the default value. We recommend that you increase the value. Modify the kernel parameter configuration file/etc/sysctl. cfg:

Kernel. shmmax = 8294967295
Kernel. shmmni = 4096
Kernel. shmall = 4194304

The execution takes effect:

[Root @ DB ~] # Sysctl-p
Net. ipv4.ip _ forward = 0
Net. ipv4.conf. default. rp_filter = 1
Net. ipv4.conf. default. accept_source_route = 0
Kernel. sysrq = 0
Kernel. core_uses_pid = 1
Net. ipv4.tcp _ syncookies = 1
Kernel. msgmnb = 65536
Kernel. msgmax = 65536
Kernel. shmmax = 8294967295
Kernel. shmmni = 4096
Kernel. shmall = 4194304
Kernel. msgmax = 8192
Kernel. msgmnb = 32768
Kernel. msgmni= 2048
Kernel. sem = 512 64000 128 512
Fs. file-max = 65536
Fs. aio-max-nr = 1048576
Net. core. rmem_max = 262144
Net. core. wmem_max = 262144
Net. core. rmem_default = 262144
Net. core. wmem_default = 262144
Net. ipv4.ip _ local_port_range = 1024 65000
Net. ipv4.tcp _ rmem = 262144 262144 262144
Net. ipv4.tcp _ wmem = 262144 262144 262144

It is normal to start the instance again.

Reference:

Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device (Documentation ID 301830.1)

Https://support.oracle.com/epmos/faces/DocumentDisplay? _ AfrLoop = 678630284455922 & id = 301830.1 & displayIndex = 20 & _ afrWindowMode = 0 & _ adf. ctrl-state = sjckvzhrj_101

-------------------------------------- Split line --------------------------------------

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

-------------------------------------- Split line --------------------------------------