Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device (Doc ID 301830.1)
Issue:
======
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
Solution:
=========
1. Ask SA to increase "kernel.shmall" in /etc/sysctl.conf
Formula:
RAM * 1024 * 1024 * 1024 / page_size
Ex:-
RAM = 50GB
$getconf PAGE_SIZE ==> 4096
50*1024*1024*1024/4096 = 13107200 ==> kernel.shmall
2. After updating kernel.shmall, ask SA to do "sysctl -p" to activate changes.
3. Start the DB
Note:
====
Kernel values will be set in below files
1. Updating below files doesn't require system reboot.
/proc/sys/kernel/shmmax
/proc/sys/kernel/shmall
/proc/sys/kernel/shmmni
Usage: # echo "536870912" > /proc/sys/kernel/shmmax
# sysctl –p ---------> Dynamically reload the parameters.
2. To make the changes permanent, update below file and do system reboot
/etc/sysctl.conf
OR
Reduce SGA_MAX_SIZE
Other Issue:
===========
Kernel panic - not syncing: Out of memory and no killable processes
Fix:
====
System Out of Memory Due To Incorrect Seting of /etc/sysctl.conf min_free_kbytes (Doc ID 1436855.1)
Comments
Post a Comment