Re: TNSPING question

I am always setting TNS_ADMIN. That way, I know which files are being used.

On 10/13/2016 11:23 AM, Storey, Robert (DCSO) wrote:
>
> Figured it out.
>
> When I brought up the command window to start TNSPING, comes up with
> my default home drive, which is a network share. While I had worked
> my way through part of a list of locations, I had not got to this
> share yet.
>
> At the root level of the share, where the CMD prompt was, there was a
> tnsnames file with the bad entries in it. Soon as I deleted it, the
> tnsping worked correctly.
>
> Thanks for all of the inputs.
>
> *From:*Seth Miller [mailto:sethmiller.sm_at_gmail.com]
> *Sent:* Tuesday, October 11, 2016 3:55 PM
> *To:* Kevin Lidh
> *Cc:* jithinsarath_at_gmail.com; Storey, Robert (DCSO); Oracle-L
> Freelists; Powell, Mark; TJ Kiernan
> *Subject:* 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
> <mailto: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
> <mailto:oracle-l-bounce_at_freelists.org>> on behalf of Jithin Sarath
> <jithinsarath_at_gmail.com <mailto:jithinsarath_at_gmail.com>>
> *Reply-To: *<jithinsarath_at_gmail.com <mailto:jithinsarath_at_gmail.com>>
> *Date: *Tuesday, October 11, 2016 at 2:42 PM
> *To: *<RStorey_at_dcso.nashville.org <mailto:RStorey_at_dcso.nashville.org>>
> *Cc: *<oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>>,
> "Powell, Mark" <mark.powell2_at_hpe.com <mailto:mark.powell2_at_hpe.com>>,
> TJ Kiernan <tkiernan_at_pti-nps.com <mailto: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 <mailto: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
> <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>
> [mailto: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
> <mailto:mark.powell2_at_hpe.com>>; Oracle L <oracle-l_at_freelists.org
> <mailto: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]
> *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
> <mailto:oracle-l-bounce_at_freelists.org>
> <oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>> on behalf of Storey,
> Robert (DCSO) <RStorey_at_DCSO.nashville.org
> <mailto: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?
>

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


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