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