Jump to Navigation

247 - ORA-27102: out of memory Linux-x86_64 Error

When trying to increase the SGA to approach half available RAM with an Oracle 64-bit
version on a Linux 64-bit operating system, even though shmmax is set to match half the amount of RAM,
you get the following error when trying to start the instance :

SQL> startup nomount

ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device Changes

shmall is too small, most likely is set to the default setting of 2097152

$ cat /proc/sys/kernel/shmall
2097152

Set shmall equal to the sum of all the SGAs on the system, divided by the page size.

The page size can be determined using the following command :

$ getconf PAGE_SIZE
4096

For example, if the sum of all the SGAs on the system is 16GB and the result of 'getconf PAGE_SIZE' is 4096 (4KB).
You should set shmall to 4194304 pages.

As the root user set the shmall to 4194304 in the /etc/sysctl.conf file :
kernel.shmall = 4194304

Run the following command :

# sysctl -p
# cat /proc/sys/kernel/shmall
4194304

 

Oracle:


Main menu 2

Story | by Dr. Radut