Trcroute Fails with TNS - 12197 (Doc ID 786719.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Net Services - Version: 10.2.0.4.0
This problem can occur on any platform.

Symptoms

You are unable to trcroute to a tns service name entry in your tnsnames.ora or in LDAP.

TNS-12197: TNS:keyword-value resolution error
TNS-12533: TNS:illegal ADDRESS parameters
TNS-12560: TNS:protocol adapter error
TNS-03601: Failed in route information collection

Still the tnsping and connections using sqlplus works well with the same tns service name entry.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms