How to fix the Oracle error ORA-12222: TNS:no support is available for the protocol indicated?

In this post, you’ll learn more about the Oracle ErrorORA-12222: TNS:no support is available for the protocol indicated with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-12222: TNS:no support is available for the protocol indicated

Reason for the Error ORA-12222: TNS:no support is available for the protocol indicated

The protocol requested in the ADDRESS portion of the connect descriptor identified through the net service name is not available. If the supplied ADDRESS is typographically correct then support for that protocol is not installed.

How to fix the Error ORA-12222: TNS:no support is available for the protocol indicated ?

You can fix this error in Oracle by following the below steps

Install support for the protocol or correct typographical error, as appropriate. Note: if the supplied address was derived from resolving the net service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA) or in the directory server.