tnsping phantom file

From: Storey, Robert (DCSO) <"Storey,>
Date: Tue, 17 May 2016 18:32:07 +0000
Message-ID: <FE4C2B093843BB4B873D754E5E0BE4DB019990B338_at_DCSOSVMS02.dcso.org>

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?

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

Received on Tue May 17 2016 - 20:32:07 CEST