Re: tnsping phantom file

From: Phil Jones <phil_at_phillip.im>
Date: Tue, 17 May 2016 19:47:56 +0100
Message-Id: <050ACC2B-C7F8-4EC3-BCC4-609317F6CCA3_at_phillip.im>

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_at_DCSO.nashville.org> 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?

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

Received on Tue May 17 2016 - 20:47:56 CEST