ORA-27154: post/wait create failed ORA-27300
- By Preneesh AV --
- 14-Aug-2016 --
- 1 Comments
I was trying to startup my database, but the system throws an error ” ORA-27300, ORA-27300″.
So, below are some of the steps.
[oracle@rac1 ~]$ sqlplus “/as sysdba”
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 7 13:59:52 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
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> exit
Disconnected
As per the Oracle ,the value for the semaphore should be :kernel.sem = 250 32000 100 200
Connect as root and edit
# vi /etc/sysctl.conf
Post restart of server the database will start normally.