Oracle Error ORA-12510: TNS:database temporarily lacks resources to handle the request

Oracle Error Message

ORA-12510: TNS:database temporarily lacks resources to handle the request

Reason for the Error

The dispatchers appear to be busy handling other requests.

Solution

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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...