ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 28: No space left on device

When try to start up an Oracle database, the below errors occur:

 
ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 28: No space left on device
Additional information: 3773
Additional information: 3221225472
 

CAUSE

Kernel parameter kernel.shmall is not set properly.

RESOLUTION

Make sure kernel.shmall  is given the appropriate value.

1)  Calculate the value of shmall.

# getconf PAGE_SIZE
4096
Shmall=total size of the SGAs /PAGE_SIZE.
If the total SGA size is 480GB, then it would be 1024 * 1024 * 1024 * 480 / 4096 = 125829120

2) Edit /etc//etc/sysctl.conf

kernel.shmall = 125829120
3) Apply the change

# sysctl -p  
4) Check shmall value after change.

# sysctl -A | grep shmall
5) Start up database successfully.

 
  • January 22, 2019 | 36 views
  • Comments