My Oracle Support Banner

HOWTO : Use sqlnet tracing to track down which tnsnames.ora file is used in the connection? (Doc ID 846822.1)

Last updated on JANUARY 08, 2020

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:
<appuser>/<appuser password>@<sampledb_1121> 
Error - ORA-12154: Data source name not found and no default driver specified
Error - ORA-01012: not logged on


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

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