Re: tnsping phantom file

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 17 May 2016 18:26:27 -0400
Message-ID: <573B9A93.3030508_at_gmail.com>

On 05/17/2016 02:32 PM, Storey, Robert (DCSO) 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?
>

Robert, all that tnsping checks is whether the listener is running on the port specified in the tnsnames.ora file. That's it. It doesn't check whether the listener knows about the service. Listener emulated using the "netcat" (nc) utility. I even have a perl script doing that. Regards.

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


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

Received on Wed May 18 2016 - 00:26:27 CEST