Oracle Error ORA-07469: sppst: mclear error, unable to clear semaphore.

Oracle Error Message

ORA-07469: sppst: mclear error, unable to clear semaphore.

Reason for the Error

The mclear routine returned an error. Semaphore may not exist.

Solution

Check result code in sercerrno. Semaphore number returned in sercose[0].