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?