Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-00104: deadlock detected; all public servers blocked
waiting for resources
- 1 Answers
- 3501 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-16509: the request timed out
ORA-16622: Two or more broker database objects resolve to one physical database.
ORA-09888: osnTXtt: txipc channel creation failed
ORA-09879: sstascre/sstasat: shmat error, unable to attach tas read page
PLS-00735: Attempted to declare more than one formal ellipsis parameter
SQL-02105: Inconsistent cursor cache. Global cursor not found
ORA-14110: partitioning column may not be of type ROWID
ORA-08238: smsfre: cannot detach from SGA
PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE
ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
ORA-12566: TNS:protocol error
TNS-12554: TNS:current operation is still in progress
Oracle Errors 
