Amazon Partner

Thursday 19 November 2009

ORA-27154: post/wait create failed / +ASM1 instance startup failed

+ASM1 instance startup failed :

SQL> startup nomount;
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


Cause of the problem
The error may mislead you. Though it indicates No space left on device but whenever I issue df -h on my OS there is enough space. The problem happened because of short of semaphores setting in the OS.


Solution:

add the following line in /etc/sysctl.conf
kernel.sem = 256 32768 100 228
Posted by at

5 comments:

  1. meryniki13 May 2010 at 13:49

    You are my hero! This was the solution for my problem, thanks!

    ReplyDelete
  2. Unknown11 June 2010 at 14:19

    You are the legend. It solved this problem eventually after my week's googling. Thank heaps.

    ReplyDelete
  3. tushar15 December 2010 at 03:32

    thanks a lot mate ....

    ReplyDelete
  4. mwevromans18 July 2011 at 05:52

    you are my hero!! I've was searching for this a long time!!

    ReplyDelete
  5. Srikanth15 July 2012 at 06:00

    Thanks a million mate ... :-)

    ReplyDelete

Subscribe to: Post Comments (Atom)