Oracle Errors Question:
Download Job Interview Questions and Answers PDF
ORA-12510: TNS:database temporarily lacks resources to handle the request?
Answer:
Cause: The dispatchers appear to be busy handling other
requests.
Action: Attempt the connection again. If error persists, ask
the DBA to increase the number of dispatchers and/or
dispatchers' limit on number of connections/sessions that
they can accept.
requests.
Action: Attempt the connection again. If error persists, ask
the DBA to increase the number of dispatchers and/or
dispatchers' limit on number of connections/sessions that
they can accept.
Download Oracle Errors Interview Questions And Answers
PDF
| Previous Question | Next Question |
| ORA-12511: TNS:service handler found but it is not accepting connections? | ORA-12509: TNS:listener failed to redirect client to service handler? |