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@xxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxx]
*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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@
freelists.org <oracle-l-bounce@xxxxxxxxxxxxx>] *On Behalf Of *Storey,
Robert (DCSO)
*Sent:* Tuesday, October 11, 2016 2:23 PM
*To:* Powell, Mark <mark.powell2@xxxxxxx>; Oracle L <
oracle-l@xxxxxxxxxxxxx>
*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@xxxxxxx ;<mark.powell2@xxxxxxx>]
*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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Storey, Robert (DCSO) <RStorey@xxxxxxxxxxxxxxxxxx>
*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?
