Monday, September 17, 2018

OS Semaphores issue with multiple errors


When we have multiple DB with high processes for each database we will see this below semaphores issue when they are set to default numbers.

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: sskgpcreates



edit /etc/sysctl.conf file from defaults.
kernel.sem = 250 32000 100 128 

change that to 
kernel.sem = 250 32000 100 256

you can change them on run time using below command

/sbin/sysctl -p 


on Linux check these...
ipcs -s | awk '{print $5}' |awk '{ sum+=$1} END {print sum}'
ipcs | wc -l ---- this number should not be more than "max number of arrays in ipcs -ls"  ... if you see higher number then try to increase the number.


Ref: Doc ID 949468.1 Doc applies to 12c, too. 

Hope this helps .....

No comments:

Post a Comment

PostgreSql: Useful Commands-

 1)   ************************* Users ***************************  -- List of users with roles assigned: SELECT usename AS role_name,   CASE...