DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

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

  1. #1
    Join Date
    Jul 2003
    Location
    Sacto
    Posts
    5

    Smile 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

  2. #2
    Join Date
    Jul 2003
    Location
    Sacto
    Posts
    5
    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

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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.

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Reboot..?

    Did you re-boot after setting SEMMSL & SEMMNI in /etc/systm?

    Regards,

    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    Solutions are not up to the mark

    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

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    how about you look in the installation guide, where it tells you what you want to know

  7. #7
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is the phy RAM in your unix box?

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  10. #10
    Join Date
    Jun 2004
    Posts
    1

    semaphores

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width