deadlock detected; all public servers blocked waiting for resources

Solution ID:ORA-00104

Type: Oracle

Cause

All available public servers are servicing requests that require resources locked by a client which is unable to get a public server to release the resources.

Actions

Increase the limit for the system parameter MAX_SHARED_SERVERS as the system will automaticaly start up new servers to break the deadlock until the number of servers reaches the value specified in MAX_SHARED_SERVERS.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


http://docs.oracle.com/cd/E16655_01/timesten.121/e21636/awt_trouble.htm


https://community.oracle.com/message/3563978


https://community.oracle.com/message/1783737


https://community.oracle.com/message/1228927


https://community.oracle.com/message/1742100


Browse all solutions to database errors from Oracle, MS SQL, or MySQL