Shulou(Shulou.com)06/01 Report--

64bit Redhat Linux

[oracle@DB] $uname-a

Linux DB 2.6.32-279.el6.x86_64 # 1 SMP Wed Jun 13 18:24:36 EDT 2012 x86 "64 GNU/Linux

When 16G of physical memory is allocated to SGA, instance can start normally. If it exceeds 4G, an error of "out of memory" will be 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 say that the problem is that the kernel parameter shmall is too small. Check the current kernel parameter settings:

$cat / proc/sys/kernel/shmall

2097152

Usually this value is also the default value, so it is recommended to increase it. Modify the kernel parameter configuration file / etc/sysctl.cfg:

Kernel.shmmax = 8294967295

Kernel.shmmni = 4096

Kernel.shmall = 4194304

Implementation 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

Start the instance again, normal.

Reference documentation:

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

Https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=678630284455922&id=301830.1&displayIndex=20&_afrWindowMode=0&_adf.ctrl-state=sjckvzhrj_101

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.