ORA-27154: post/wait create failed / ORA-27301: OS failure message: No space left on device when starting ASM or database instance
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.
Categories: Oracle in general
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
And it worked for me too!!! Thanks Ronny!
Worked Thanks!
Thanks it works for me too..