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

Thread: ORA-07265: sppst: semop error, unable to increment semaph

  1. #1
    Join Date
    Mar 2001
    Posts
    82
    Can anyone explain what this means and how do I fix it??

    Thanks

    ------- PSIS alert log -------
    /oracle/PSIS/dmp/alert_PSIS.03Oct2001_0530:ORA-07265: sppst: semop error, unable to increment semaph
    ore.
    /oracle/PSIS/dmp/alert_PSIS.03Oct2001_0530:ORA-07265: sppst: semop error, unable to increment semaph
    ore.
    /oracle/PSIS/dmp/alert_PSIS.03Oct2001_0530:ORA-01092: ORACLE instance terminated. Disconnection forc
    ed
    /oracle/PSIS/dmp/alert_PSIS.03Oct2001_0530:ORA-01092: ORACLE instance terminated. Disconnection forc
    ed

  2. #2
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    Have you recently done a shutdown abort? If so here is some information....


    Error: ORA 7265
    Text: sppst: semop error, unable to increment semaphore.
    -------------------------------------------------------------------------------
    Cause: Semop system call returned an error. Semaphore set may not exist.
    Action: Check errno. Semaphore id is returned in sercose[0]. Check
    semaphore set existence. A possible cause for this error is that a
    "shutdown abort" was done while this process was running.

    *** Important: The notes below are for experienced users - See [NOTE:22080.1]



    Explanation:
    Oracle on Unix uses semaphores to signal between processes.
    This error means that an Oracle process tried to signal another
    Oracle process but for some reason the semaphores no longer exist.


    Diagnosis:
    This is an extremely common error which is reported to the ALERT
    log when an instance has been shutdown (and possibly restarted).

    Check the trace files for any other errors reported at the same
    time. If there are none this error can be safely ignored as it
    is almost certainly from an oracle process which was running before
    the database was shutdown and restarted.
    Doug

  3. #3
    Join Date
    Mar 2001
    Posts
    144
    Looks like the database was forced to shutdown, ie., shutdown abort. Is there more to this log file?

    It just mentions the forced shutdown while your process was running. Either another admin did a shutdown abort or a scheduled program (like cron) took the database down in abort mode OR something major happened to the database instance (like an ora-600).

    are there any other trace files in the bdump or udump directories? They may tell you more.

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