ORA-27302: failure occurred at: sskgpsemsper

oracle 起动错误

SQL> startup;
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

Cause of the problem
The error may mislead you. Though it indicates No space left on device but whenever I issue df -h on my OS there is enough space. The problem happened because of short of semaphores setting in the OS.

Solution of the problem
Solution 1)
Increase number of semaphores on operating system. You set semmns 32767 .
To make the setting permanent make an entry in /etc/sysctl.conf file on linux system.
sem = semmsl semmns semopm semmni
kernel.sem = 256 32768 100 228

Solution 2)
Change the initialization parameter processes to a lower one in the initialization file and then startup the database. In my initialization file processes was set to 555. Whenever I start my database it fails with above error. I then reduced it to by 55 and it started my database successfully.

g11@feb dbs]$ cat initg11.ora
spfile=spfileg11.ora
*.processes=50

问题解决

SQL> startup pfile=initg11.ora
ORACLE instance started.

Total System Global Area 3340451840 bytes
Fixed Size            2217952 bytes
Variable Size         1811941408 bytes
Database Buffers     1509949440 bytes
Redo Buffers           16343040 bytes
Database mounted.
Database opened.