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
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.
1 comment:
Thank you buddy it worked
Post a Comment