Re: tnsping phantom file

From: Justin Mungal <justin_at_n0de.ws>
Date: Wed, 18 May 2016 02:15:20 -0500
Message-ID: <CAO9=aUwcnsXcvEmtz0dVM=AQXyS75tn2Yp__OG84KKvDe7JvPw_at_mail.gmail.com>



Hmm, interesting... that comment got my attention. I get *TNS-03505: Failed to resolve name* if I try to tnsping an invalid service name.

On Tue, May 17, 2016 at 5:26 PM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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 - 09:15:20 CEST

Original text of this message