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
Recent Posts