Thursday, September 16, 2010

ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28

I started ASM instance, it crashed and found error.
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
if check from OS
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda6 129G 27G 103G 21% /oradata
/dev/sda2 49G 33G 14G 72% /oracle
then check about Semaphore Limits.
# ipcs -la
------ Semaphore Limits --------
max number of arrays = 200
max semaphores per array = 250
max semaphores system wide = 100
max ops per semop call = 100
semaphore max value = 32767
my value wrong, check Document and then modify /etc/sysctl.conf file.
kernel.sem = 250 32000 100 200
run sysctl and check.
# sysctl -p
# sysctl kernel.sem
kernel.sem = 250 32000 100 128
# ipcs -la
------ Semaphore Limits --------
max number of arrays = 200
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767
and then startup ASM instance again. (ASM instance started)

No comments: