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.