Re: TNSPING question

You should also check the registry. If a TNS_ADMIN key is defined, the clients will use it.

On Tue, Oct 11, 2016 at 3:46 PM, Kevin Lidh <kevin.lidh_at_gmail.com> wrote:

> It’s my understanding that if you have a tnsnames.ora in “My Documents”,
> it’ll look there as well.
>
>
>
> *From: *<oracle-l-bounce_at_freelists.org> on behalf of Jithin Sarath <
> jithinsarath_at_gmail.com>
> *Reply-To: *<jithinsarath_at_gmail.com>
> *Date: *Tuesday, October 11, 2016 at 2:42 PM
> *To: *<RStorey_at_dcso.nashville.org>
> *Cc: *<oracle-l_at_freelists.org>, "Powell, Mark" <mark.powell2_at_hpe.com>, TJ
> Kiernan <tkiernan_at_pti-nps.com>
> *Subject: *RE: TNSPING question
>
>
>
> If you're running on windows, use sysinternals process monitor to see what
> exactly tnsping.exe is doing when you launch it. Start the monitor right
> before you launch tnsping and stop it immediately after.
> If this is your first time, it'll tale a while to remove unwanted entries
> and get what you want.
>
> Jithin
>
>
>
> On 12-Oct-2016 01:09, "Storey, Robert (DCSO)" <RStorey_at_dcso.nashville.org>
> wrote:
>
> Tnsnames file was updated just recently, and I tried updating it just to
> see if it would overwrite or such.
>
>
>
> Not seeing it go out anywhere to a network share that I can see….
>
>
>
> *From:* TJ Kiernan [mailto:tkiernan_at_pti-nps.com]
> *Sent:* Tuesday, October 11, 2016 2:38 PM
> *To:* Storey, Robert (DCSO); Powell, Mark; Oracle L
> *Cc:* TJ Kiernan
> *Subject:* RE: TNSPING question
>
>
>
> I would suspect some caching is happening, depending on how long ago your
> TNSNAMES & SQLNET files were changed. Try in a new CMD prompt?
>
>
>
> I’ve also seen some weird things happen when the systems team virtualizes
> local directories. How sure are you that you’re actually changing the
> thing that you think you’re changing?
>
>
>
> HTH,
>
> T. J.
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org <oracle-l-bounce_at_freelists.org>] *On Behalf Of *Storey,
> Robert (DCSO)
> *Sent:* Tuesday, October 11, 2016 2:23 PM
> *To:* Powell, Mark <mark.powell2_at_hpe.com>; Oracle L <
> oracle-l_at_freelists.org>
> *Subject:* RE: TNSPING question
>
>
>
> I did that. Only one path for oracle in my path name.
>
>
>
> Oracle_home is not defined. But there is only 1 oracle home on the
> machine.
>
>
>
> *From:* Powell, Mark [mailto:mark.powell2_at_hpe.com <mark.powell2_at_hpe.com>]
> *Sent:* Tuesday, October 11, 2016 2:15 PM
> *To:* Oracle L; Storey, Robert (DCSO)
> *Subject:* Re: TNSPING question
>
>
>
> Robert, is this a Windows machine? Check the $PATH and look for Oracle
> homes. Then in each check for a tnsnames.ora file under the
> ..../NETWORK/ADMIN directory.
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Storey, Robert (DCSO) <RStorey_at_DCSO.nashville.org>
> *Sent:* Tuesday, October 11, 2016 3:03:13 PM
> *To:* Oracle L
> *Subject:* TNSPING question
>
>
>
> Okay, a small stumper for me.
>
>
>
> My client is oracle11g.
>
>
>
> I am testing a connection using tnpsing. Unfortunately, the service name
> I am tnsping’ing is not in my tnsnames file. The cmd windows tells me it
> is using the tnsnames adaptor at the location of my tnsnames, but the
> service name is not in there.
>
>
>
> Since the target machine is no longer alive, the tnsping generates a tns
> error. But, it correctly displays the old connect information, which did
> exist quite some time ago.
>
>
>
> I do not have tns_admin set.
>
>
>
> As a test, I renamed my tnsnames file. TOAD and my application tools will
> not connect now. BUT, tnsping still works. Still successfully found
> several of the service names from my file.
>
>
>
> Which makes me think it is pulling from another location, but I can’t find
> it.
>
>
>
> My sqlnet.ora file is #’d out, so no information is in there to direct it
> anywhere.
>
>
>
> The question is…where is tnsnames pulling the data from?
>
>
>
> Thoughts?
>
>

--
http://www.freelists.org/webpage/oracle-l