ORA-27302 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-27302 error

  1. #1
    Join Date
    Jul 2002
    Posts
    3
    Hello all,

    for some purpose i tried to change the init.ora parameter processes from 60 to 100 and i get the following messages when trying to restart the database:

    ORA-27302: failure occurred at: skgpwreset1
    ORA-27303: additional information: invalid shared ctx
    ORA-27146: post/wait initialization failed
    ORA-27300: OS system dependent operation:semget failed with status: 28
    ORA-27301: OS failure message: No space left on device
    ORA-27302: failure occurred at: sskgpsemsper

    anybody who can help me out?

    thanx
    Chris

  2. #2
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Increase the size of your SGA. It may not be large enough to cater this many processes.
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  3. #3
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    From metalink:
    Increase semaphores parameters in /etc/system
    SEMMSL & SEMMNI

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