-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|