After SAN migration of database everything gone fine and system worked for 1 days successfully . But in an instant because of multipath configuration db has crashed due to dbwr failure.After fixing storage unit failure whenever would like to open database below error occured. Actually there was no configuration change on database but immediately following error occured.
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
Mon Mar 05 12:32:54 2018
According to notes inadequate setting of semaphore can cause not to accommodate the request. Setting semaphore to higher value resolved issue
In /etc/sysctl.conf
Before change
kernel.sem = 250 32000 100 128
After change
kernel.sem = 250 32000 100 256
After applying settings as root execute "sysctl -p" command
No comments:
Post a Comment