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