Monday, October 30, 2017

ORA-27302: failure occurred at: sskgpsemsper

Upon firing up an old Oracle database that went down unexpectedly, I was getting the following error. It turns out the semaphore was too low. To temporarily changing it and starting it up.

SYS> 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

as root.
echo "300 2000 200 128" > /proc/sys/kernel/sem