ORA-12509 TNS:listener failed to redirect client to service handler
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-12509 from Oracle 11g ?
The dispatcher terminated unexpectedly
How to deal with ORA-12509 from Oracle 11g ?
Attempt to connect again and if the same error occurs, contact the DBA to check the state of the dispatchers for this SID. If the problem persists, turn on tracing in the listener to determine the TNS error caused by the redirect.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-12502 TNS:listener received no CONNECT_DATA from client
- ORA-12504 TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
- ORA-12505 TNS:listener does not currently know of SID given in connect descriptor
- ORA-12508 TNS:listener could not resolve the COMMAND given
- ORA-12510 TNS:database temporarily lacks resources to handle the request
- ORA-12511 TNS:service handler found but it is not accepting connections
- ORA-12513 TNS:service handler found but it has registered for a different protocol
- ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
- ORA-12515 TNS:listener could not find a handler for this presentation
- ORA-12516 TNS:listener could not find available handler with matching protocol stack