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?
Hey guys.. the details of my installation aren't important so much as I'm having the same problem as the guy above. I've done my research, followed the guides, and set all the semaphore parameters correctly as per my machine.
Does anyone wanna copy/paste the metalink information? Some of us are 21 year olds trying to learn to use oracle and don't have 10000$ to license oracle and have access to the elite support forums.