Oracle Solution for Error ora-12221

ORA-12221: TNS:illegal ADDRESS parameters

What triggered the Error:

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.

What should we do to fix it:

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.