Oracle/UNIX Error while creating a database...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle/UNIX Error while creating a database...

  1. #1
    Join Date
    Mar 2001
    Posts
    13
    Hi All,
    I am having the error message below where I try to create a new database. I do not know what is the problem because I have over 600Megs of space on the disks I am using. Can someone please help... any suggestion will be greatly appeciated.

    ORA-07279: spcre: semget error, unable to get first semaphore set.
    HP-UX Error: 28: No space left on device
    Additional information: 1

    Thanks in advance,
    Bond

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your kernal parameters are not setup correctly. Check the installation guide for semephore parameters...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    This would be a normal math for the /etc/system file SEMMNS

    a = 200
    b = 100
    c = 100
    SEMMNS = [ (2*a) +b+c ] + [ No. of instances * 10]


    But I would suggest that you go with

    SEMMNS = [2(a+b+c)] + {#instances * 10}

    Good luck.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Mar 2001
    Posts
    13
    Thanks for your help!!!!

    Bond.

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