Friday, March 1, 2019

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: sskgpcreates - When creating new instance

Today I see below errors when trying to create new instance in DEV environment (It has already 3 instance, I was trying to create 4th one).

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: sskgpcreates - When creating new instance

In my case Kernel settings are not sufficient for 4th instance.
Semaphore parameter value caused the issue.
in /etc/sysctl.conf I see kernel.sem = 250 32000 100 128
and changed to kernel.sem = 250 32000 100 256
as a root executed sysctl -p
This fixed my issue and I was able to create 4th instance.

No comments:

Post a Comment