Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-00104: deadlock detected; all public servers blocked
waiting for resources
- 1 Answers
- 3419 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 |
NMP-00002: no such SNMP variable name
ORA-09915: Password encryption failed.
PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records
ORA-12855: cannot run parallel or insert direct load in a loopback
PCC-02431: Expecting an expression of type external LOB (BFILE)
PLS-00500: invalid operator binding
ORA-01298: conflicting dictionary option
ORA-29888: cannot create domain index on a table with row movement enabled
ORA-27208: syntax error in device PARMS - environment variable value missing
RMAN-03031: this option of set command needs to be used inside a run block
ORA-38201: assert if pin during flush
ORA-33468: (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
Oracle Errors 
