How to solve Oracle Database Error 104 (ora-00104)

Oracle Error Code
   ora-00104

Description
   deadlock detected; all public servers blocked waiting for resources

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.
How to Solve
   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.

Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-00017    ORA-00018    ORA-00019    ORA-00104    ORA-00105    ORA-00106    ORA-00107  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares