HOWTO : Use sqlnet tracing to track down which tnsnames.ora file is used in the connection?

(Doc ID 846822.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version and later
Information in this document applies to any platform.

***Checked for relevance on 10-Mar-2015***


The goal of this document is to describe how to use sqlnet trace to track down problems related to tnsnames.ora file resolution.  Example of error that is related to tns-name resolution:

Trying to connect using:
Error - ORA-12154: Data source name not found and no default driver specified
Error - ORA-01012: not logged on


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