DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, November 3, 2014

Database is getting failed with ORA-27300: OS system dependent operation:semget failed with status: 28 while starting up the database

We got the following error while starting up the database,

SYS> startup mount pfile=initabc.ora
ORA-32006: PARALLEL_SERVER initialization parameter has been deprecated
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: sskgpbitsper


The solution is to increase the semaphore values in the kernel parameter.

We have increased the semaphore values in the kernel parameter as below and were able to startup the database after the change,


From:

[oracle@abc] cat /etc/sysctl.conf | grep -i sem
kernel.sem = 250 32000 100  128

To:

[oracle@abc] cat /etc/sysctl.conf | grep -i sem
kernel.sem = 250 32000 100  200

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.