Re: Tnsnames mystery

From: Norman Dunbar <>
Date: Tue, 21 Aug 2012 16:45:05 +0100
Message-ID: <>


> But I'm seeing no indication in tnsping or such as to WHICH file its going for.

DOes this mean that when you "tnsping" you don't see a message, as Kevin Lange pointed out earlier in this thread, of which parameter file tnsping used to resolve the name?

I'm pretty sure that from 9i onwards you get a display of the parameter file used by tnsping. You certainly do in 10g and 11g.

 > Used parameter files:
 > /u03/home/oracle/product/

Once you have the sqlnet.ora file, you will most likely find the tnsnames.ora file it is using, and if not, you can look inside for more clues.

Alternatively, once you know the sqlnet.ora file, you can set a trace within it so that it will give you more information to go on.

HTH Cheers,

Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
Received on Tue Aug 21 2012 - 10:45:05 CDT

Original text of this message