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

Comments