Setting the semaphores parms in /etc/system SEMMSL & SEMMNI

All,

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)
or
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:
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=10
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmns=1000
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=250
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

Any idea as to what these need set to in order for the processes to be increased to 600?

James Bennett
Healthnet, Inc.
916 935-3060

I forgot to inform everyone that this is on a SunOS 5.8 Generic_108528-21 sun4u sparc SUNW,Sun-Fire-880 box/OS...

Regards,

James Bennett

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?

Regards,

Thomas

Hi
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
Abhishek

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?

http://metalink.oracle.com/metalink/...&p_id=144638.1

http://metalink.oracle.com/metalink/...T&p_id=15566.1
http://metalink.oracle.com/metalink/...p_id=1011658.6

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.

- jeff

Hi

21 yera olds can get a account for free at otn.oracle.com the oracle operating ssytem documentation has this inof for free

regards
Hrishy