ORA-07252: spcre: semget error, could not allocate semaphores.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Hi,

    Im getting this error message when I tried to open my database. Anybody could give me some advice, please?

    SVRMGR> Connected.
    SVRMGR> ORA-01034: ORACLE not available
    SVRMGR> ORA-07252: spcre: semget error, could not allocate semaphores.
    Intel SVR4 UNIX Error: 28: No space left on device
    SVRMGR> alter database mount standby database
    *
    ORA-01034: ORACLE not available
    SVRMGR> ORA-01034: ORACLE not available
    SVRMGR> ORA-01012: not logged on
    SVRMGR>
    Server Manager complete.


    Thank you in advance.

    regards,
    feroz

  2. #2
    Join Date
    Oct 2001
    Posts
    126
    You need to check your OS kernal parameters. Add the requirement parameters or increase value of the parameters.

    Susan

  3. #3
    Hi,

    This is what I have. Any recommendation? I have about 3 open database and 2 standby database.

    SEMMNI 400
    SEMMNS 400
    SEMMNU 400
    SEMMSL 700
    SEMMAP 400
    SHMMAX 1073741824

    regards,
    feroz

  4. #4
    Join Date
    Oct 2001
    Posts
    126

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    sometimes it's because the semaphores are not cleared when you shutdown an instance

    use ipcs to check if it is shutdown cleanly and ipcrm to free/delete the resources

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