How to fix the Oracle error TNS-12221: TNS:illegal ADDRESS parameters?

In this post, you’ll learn more about the Oracle ErrorTNS-12221: TNS:illegal ADDRESS parameters with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

TNS-12221: TNS:illegal ADDRESS parameters

Reason for the Error TNS-12221: TNS:illegal ADDRESS parameters

Cause: An illegal set of protocol adapter parameters was specified. In some cases, this error is returned when a connection cannot be made to the protocol transport.

How to fix the Error TNS-12221: TNS:illegal ADDRESS parameters ?

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

Action: Verify that the destination can be reached using the specified protocol. Check the parameters within the ADDRESS section of TNSNAMES.ORA or in the directory. Legal ADDRESS parameter formats may be found in the Oracle operating system specific documentation or the Oracle Net Administrator’s Guide. Protocols that resolve names at the transport layer are vulnerable to this error if not properly configured or names are misspelled.

Tags :

Leave Your Comment