Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-00104

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.


Action

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.