ORA-00104: deadlock detected; all public servers blocked
waiting for resources
- 1 Answers
- 2504 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 |
TNS-00200: Unable to do nsanswer on context result=string
DRG-11527: end token not found on line string
ORA-29512: incorrectly formed name resolver specification
NZE-29112: Cannot access attributes from a PKCS #12 certificate bag.
ORA-09216: sdnfy: bad value 'string' for parameter string
SQL*Loader-00419: input datatype for column string is not supported when loading varrays
RMAN-08121: keep attributes for the backup are deleted
RMAN-08162: executing Memory Script
ORA-06815: TLI Driver: could not link SPX and IPX streams
ORA-14314: resulting List partition(s) must contain atleast 1 value
NCR-03022: NCRO: Cannot send the break
LRM-00106: out of memory
Oracle Errors 
