[Solved] Oracle Semaphore Error: "ORA-27154: ORA-27300: ORA-27301: ORA-27302:"


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: sskgpsemsper
SQL>

Cause: kernel semaphore parameter value not set properly.

Solution:  Follow below steps:
[root@ole1]# echo "250 1500 100 128" > /proc/sys/kernel/sem
[root@ole1]# vi /etc/sysctl.conf
                      kernel.sem = 250 1500 100 128 set this value in file.

SQL> startup
ORACLE instance started.

Total System Global Area  640286720 bytes
Fixed Size    1338420 bytes
Variable Size  402654156 bytes
Database Buffers  230686720 bytes
Redo Buffers    5607424 bytes
Database mounted.
Database opened.
SQL>

Hurry !!! Its Working ... :) :) 

Comments