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.