DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-07252: spcre: semget error, could not allocate semaphores.

  1. #1
    Join Date
    Nov 2000
    Posts
    3

    Unhappy

    I run into this error only with one of several db's which all
    have same Semaphore settings, though different Hardware
    config. All SUN boxes are dedicated to run Oracle only.

    --basic config of the troubled box:

    SUN Sparc/Solairs 7/256 MB RAM
    Oracle 805

    set shmsys:shminfo_shmmax=4384354560
    set shmsys:shminfo_shmmin=1
    set shmsys:shminfo_shmmni=100
    set shmsys:shminfo_shmseg=10

    set shmsys:seminfo_semmni=1000
    set shmsys:seminfo_semmns=1000
    set shmsys:seminfo_semmsl=200

    set shmsys:seminfo_semmnu=200
    set shmsys:seminfo_semume=50

    any help will be greatly appreciated !!

  2. #2
    Join Date
    Nov 2000
    Posts
    3
    btw, the complete Error message is:

    SVRMGR> startup
    ORA-07252: spcre: semget error, could not allocate semaphores.
    SVR4 Error: 28: No space left on device




    I checked disk spaces and they looks ok.

  3. #3
    Join Date
    Nov 1999
    Posts
    226

    Incerease SEMMSL

    Please try to increase the semmsl figure and then bounce the server and see if it corrects the problem .

    regards

  4. #4
    Join Date
    Nov 2000
    Posts
    3
    Thank you, the problem is sovled !!

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