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

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

Solution:

Check the page size:

#getconf PAGE_SIZE

4096

Calculate proper value for shmall:

The value of shmall should be:

Shmall=total size of the SGAs on the system/page size.

Let’s assume the size of the SGA is 16GB in the system then it would be 1024 * 1024 * 1024 * 16 / 4096 = 4194304

Change shmall in /etc/sysctl.conf

vi /etc/sysctl.conf

kernel.shmall = 4194304

Apply the changes:

# sysctl -p

check shmall value after change

# sysctl -A | grep shmall

Start the database

# su - oracle

# sqlplus sys as sysdba

SQL> startup