Oracle Solution for Error ora-12509
ORA-12509: TNS:listener failed to redirect client to service handler
What triggered the Error:
The dispatcher terminated unexpectedlyWhat should we do to fix it:
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.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
