Re: Tnsnames mystery
Date: Wed, 22 Aug 2012 11:50:20 +0100
I'd check the Oracle home first either using the Oracle Home Selector or Oracle locator express: http://www.dbmotive.com/oracle_home_selector.php These should indicate where in the registry Oracle is reading it's settings.
Process monitor should also indicate where tnsping is looking in the registry.
I would also check that you don't have multiple copies of tnsping on your PC as different versions are likely to look in different places for the configuration information.
The fact that no path information is displayed could be an indicator that you are running an older version of tnsping?
On Tue, Aug 21, 2012 at 5:12 PM, Storey, Robert (DCSO) < RStorey_at_dcso.nashville.org> wrote:
> 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
> -----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
> > 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
> 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.
> Norman Dunbar
> Dunbar IT Consultants Ltd
> Registered address:
> Thorpe House
> 61 Richardshaw Lane
> West Yorkshire
> United Kingdom
> LS28 7EL
> Company Number: 05132767