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?
I forgot to inform everyone that this is on a SunOS 5.8 Generic_108528-21 sun4u sparc SUNW,Sun-Fire-880 box/OS...
check out the installtion guide for Oracle, it has the kernel params in there - those params are dependant on the number od DBs on the server and processes, there is a forumale to work it out.
Did you re-boot after setting SEMMSL & SEMMNI in /etc/systm?
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
how about you look in the installation guide, where it tells you what you want to know
What is the phy RAM in your unix box?
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.
Click Here to Expand Forum to Full Width