Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-00104: deadlock detected; all public servers blocked
waiting for resources
- 1 Answers
- 3348 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 |
NNL-00503: repeat <number> <command> [<args>] : repeat a command <number> times
ORA-33261: (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.
ORA-01692: unable to extend lob segment string.string partition string by string in tablespace string
RMAN-11000: message number number not found in recovery manager message file
ORA-02357: no valid dump files
SQL*Loader-00525: OCI return status: success
ORA-16533: inconsistent Data Guard broker state
QSM-00795: the SQL Tuning Set repository has not been implemented
ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled
ORA-29835: ODCIGETINTERFACES routine does not return required interface(s)
NNO-00321: statistic counter dump disabled
ORA-14631: the partition bounds do not match the subpartition bounds of the partition
Oracle Errors 
