My Oracle Support Banner

Trcroute Fails with TNS - 12197 (Doc ID 786719.1)

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.