ORA-27300: OS system dependent operation:semget failed with status: 28

Getting below error while startup after adding process parameter to 20000
 
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates
Solution:
SEMMNI should be increased to accomodate more semaphores.

1. Query the current semaphore values in the kernel
     # /sbin/sysctl -a | grep sem


2. Modify SEMMNI value in the /etc/sysctl.conf.

From
kernel.sem = 250 32000 100 128

To
kernel.sem = 250 32000 100 200


3. # /sbin/sysctl -p
Reference:
Database Startup Fails with ORA-27300: OS system dependent operation:semget failed with status: 28 (Doc ID 949468.1)
  • February 19, 2018 | 14 views