If you're on Linux, truss/strace it. You'll see exactly which files it's
reading.
Ta,
Phil
On 17 May 2016, at 19:32, Storey, Robert (DCSO) <RStorey@xxxxxxxxxxxxxxxxxx>
wrote:
A simple thing, tnsping. However, its causing me much grief today.
Troubleshooting connectivity issue and so I immediately do a tnsping from the
client station. Tnsping returns the expected information. App still will
not connect.
I go look at the tnsnames.ora file and the service name does NOT exist in my
file. Yet, the tnsping is returning the proper values for the service name I
am asking for (which is the default service name for our app that we put on
all computers).
I added the service name via net manager but only setup 1 of the two ports we
normally used. I also created a different service name (Service B) with the
same information. Once I added the expected service name to my tnsnames file,
the app works.
However, a tnsping returns BOTH ports I normally configure for the service
name. Not just the one I configured new. Tnsping of Service B returns just
the one value.
The screen shows me it is using the TNSNAMES adapter, but, I have no idea
where it is finding the information.
Thoughts?