Today i came accross a very strange error. After rebooting one cluster node (which ran flawlessly before!) ASM instance came up fine but database instance failed with:
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
It turned out the kernel settings were insufficent. The semaphore settings caused problems.
In /etc/sysctl.conf:
kernel.sem = 250 32000 100 128
This line needs to be changed to:
kernel.sem = 250 32000 100 256
Note the change of the last number from 128 to 256. After that applying the settings is done as root with:
sysctl -p
After that all instances came up just fine.
Thanks.. this worked for me.
Thank you! It has worked for me too!
It could be due to the number of processes in initialization parameter files
Pingback: » Oracle: semget failed! PSST0101
And it worked for me too!!! Thanks Ronny!
Worked Thanks!
Thanks it works for me too..
Ronny, you are my hero! Worked for me too
Thank u Ronny , U R My Hero!!!
Hi Ronny,
I was facing similar issue. Increasing the sysctl value to higher helped. Thanks a lot for sharing the information.
GRacias, funciono para mi :)… me salvo el pellejo jejejeje
I love you, Google and Ronny!
It’s worked.
Thanks that worked for me as well!!!
Awesome work man.. i guess “runfix.sh” script does the same at the time of installation ;).. appreciate ur talent.. :) thanks alot man @@@@
Thanks very much. It’s worked for me too.
But could you please explain these parameters?
Thank you very much! It worked for me too!