RE: Tnsnames mystery
Date: Tue, 21 Aug 2012 16:12:20 +0000
Message-ID: <33B09BA255BD7142B217C2C0A0D0183406B7C714_at_DCSOSVMS02.dcso.org>
Mystery part 1 solved, mystery part 2 now. Using Procmon (thanks Rich) and Process Explorer (thank you Srabjit) I determined that the TNSPING was going out to one of her network drives to obtain tnsnames.ora file. I deleted that file and then tnsping read the tnsnames.ora file located in the oracle_home/network/admin folder.
So, mystery part 2. Where would oracle maintain that setting to go to that location? Especially after a complete wipe of the Oracle key from local_machine.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Norman Dunbar
Sent: Tuesday, August 21, 2012 10:45 AM
To: oracle-l_at_freelists.org
Subject: Re: Tnsnames mystery
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-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 21 2012 - 11:12:20 CDT