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