ORA-00104: deadlock detected; all public servers blocked
waiting for resources
- 1 Answers
- 2889 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-38401: synonym string not allowed
ORA-32318: cannot rename a materialized view
PCC-00116: This array already given in an ARRAYLEN statement
DRG-50928: reserved failure on line string on column string
ORA-12720: operation requires database is in EXCLUSIVE mode
NCR-01011: NCRS: Send message failure.
ORA-38495: data type for the stored attribute string is inconsistent.
LSX-00341: ENTITY or ENTITIES type may only be used in attributes
RMAN-06491: controlfile autobackup format "string" contains more than one "string" format specifier
ORA-06979: X.25 Driver: server cannot start oracle
ORA-19722: datafile string is an incorrect version
ORA-33064: (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
Oracle Errors 
