Oracle Error ORA-12519: TNS:no appropriate service handler found

Oracle Error Message

ORA-12519: TNS:no appropriate service handler found

Reason for the Error

The listener could not find any available service handlers that are appropriate for the client connection.

Solution

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