ORA-27300: OS system dependent operation:semget failed with status: 28

ORA-27154: post/wait create failed

ORA-27300: OS system dependent operation:semget failed withstatus: 28

ORA-27301: OS failure message: No space left on device

ORA-27302: failure occurred at: sskgpsemsper

Although theerror says “No space left on device”, but it is not true. The problem is duekernel semaphore configuration. After setting a proper value(echo"250 1500 100 128" > /proc/sys/kernel/sem), the problemwill be solved:

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on MonJun 21 08:20:51 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-27154: post/wait create failed

ORA-27300: OS system dependentoperation:semget failed with status: 28

ORA-27301: OS failure message: No spaceleft on device

ORA-27302: failure occurred at:sskgpsemsper

SQL> exit

Disconnected

[oracle@localhost ~]$ df -kh

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup00-LogVol00

304G 173G 115G 61% /

/dev/hda1 99M 12M 82M 13% /boot

tmpfs 1.3G 0 1.3G 0% /dev/shm

[root@localhost kernel]# cat /proc/sys/kernel/sem

250 100 32 128

[root@localhost kernel]# echo "250 1500 100 128" > /proc/sys/kernel/sem

[root@localhost kernel]# cat /proc/sys/kernel/sem

250 500 100 128

[root@localhost kernel]#