When we start our database instance it can fail with the following error
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
Let us describe this error
]$oerr ora 27154
You see this error when number of oracle related process exceeds the limitations set by kernel parameters semaphores. You will face this error generally when you start multiple instances on the same server . If you set the proper value of kernel.sem then it will allow us to start desired number of processes.
Set the values of semaphores as following .
kernel.sem = 250 32000 100 128
Start the instance now
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
Let us describe this error
]$oerr ora 27154
ORA-27154: post/wait create failed
Cause: internal error, multiple post/wait creates attempted simultaneously
Action: check errno and contact Oracle Support
You see this error when number of oracle related process exceeds the limitations set by kernel parameters semaphores. You will face this error generally when you start multiple instances on the same server . If you set the proper value of kernel.sem then it will allow us to start desired number of processes.
Set the values of semaphores as following .
kernel.sem = 250 32000 100 128
Start the instance now
No comments:
Post a Comment