[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
Post a Comment