HomeOracleOracle Error ORA-00104: deadlock detected; all public servers blocked waiting for resource

Oracle Error ORA-00104: deadlock detected; all public servers blocked waiting for resource

Oracle Error Message

ORA-00104: deadlock detected; all public servers blocked waiting for resource

Reason for the Error

This message is displayed when a client locks a resource and the maximum number of shared servers are occupied by other clients requesting a locked resource. The original client is unable to obtain a shared server and thus cannot release the resource lock.

Solution

The system automatically starts new servers to break the deadlock until the number of servers reaches the MTS MAX SERVERS value. If this problem occurs frequently, increase the value of the initialization parameter MTS SERVERS or MTS MAX SERVERS to ensure that more shared servers are available at the next restart of the instance.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...