Expand To Show Full Article
Oracle Error ORA-12533: TNS:illegal ADDRESS parameters - Developer Publish

Oracle Error ORA-12533: TNS:illegal ADDRESS parameters

Oracle Error Message

ORA-12533: TNS:illegal ADDRESS parameters

Reason for 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.

Solution

Verify that the destination can be reached using the specified protocol. Check the parameters within the ADDRESS section of TNSNAMES.ORA. Legal ADDRESS parameter formats may be found in the Oracle operating system specific documentation for your platform. Protocols that resolve names at the transport layer (such as DECnet object names) are vulnerable to this error if not properly configured or names are misspelled.