Re: tnsping phantom file

You can add the following in your sqlnet.ora and you will get a 'tnsping.trc' in your current directory:

tnsping.trace_directory=.
tnsping.trace_level=admin

Then search for nnftmlf_make_system_addrfile

Regards,
Franck.

Franck Pachot | Senior Consultant & Oracle Technology Leader | Oracle Certified Master 12*c* and Oracle ACE Director

On Wed, May 18, 2016 at 12:27 AM 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