Re: Tnsnames mystery
Date: Tue, 21 Aug 2012 16:45:05 +0100
Message-ID: <5033AD01.20906_at_dunbar-it.co.uk>
Robert,
> 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/10.2.0.4/network/admin/sqlnet.ora
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,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 21 2012 - 10:45:05 CDT