While connecting to the sqlplus command prompt and running the startup command the database instance we received the following error message.
SQL> startup
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
To resolve the above error simply login into the server as a root user and follow the following steps.
Open the /etc/sysctl.conf file and set the following value for the kernet.sem
kernel.sem = 250 32000 100 256
Now run the command
sysctl -p
After running above command, startup command is running fine.
SQL> startup
ORACLE instance started.Total System Global Area 1586708480 bytes
Fixed Size 2213736 bytes
Variable Size 956303512 bytes
Database Buffers 620756992 bytes
Redo Buffers 7434240 bytes
Database mounted.
Database opened.
SQL> exit
