HomeOracleOracle Error ORA-12520: TNS:listener could not find available handler for requested type of server

Oracle Error ORA-12520: TNS:listener could not find available handler for requested type of server

Oracle Error Message

ORA-12520: TNS:listener could not find available handler for requested type of server

Reason for the Error

None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection.

Solution

Run “lsnrctl services” to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...