Setting the semaphores parms in /etc/system SEMMSL & SEMMNI
I increased my processes from 150 to 600 in my init.ora file and bounced the database. I got the following error:
symptom: ORA-27302: failure occurred at: skgpwreset1
symptom: ORA-27303: additional information: invalid shared ctx
symptom: ORA-27146 : post/wait initialization failed
symptom: ORA-27300: OS system dependent operation:semget failed with status: 28
symptom: ORA-27301: OS failure message: No space left on device
symptom: ORA-27302: failure occurred at: sskgpcreates
I found on metalink the following to fix the problem:
1. Set session parameter in init.ora to lower value (Which I did)
2. Increase semaphores parameters in /etc/system SEMMSL & SEMMNI
I sent this fix statement to my SYSTEMS ADMIN and he is asking me what to set these parameters to. I don't know what they need set to, hence this forum question...
These are the current parms he sent me:
Any idea as to what these need set to in order for the processes to be increased to 600?
Solutions are not up to the mark
I am also interested in this question but answer are not clear please moderators look in to this matter and show some light on this question