Re: TNSPING question

That is nothing that strace or truss could not answer.

On 10/11/2016 03:03 PM, Storey, Robert (DCSO) wrote:
>
> Okay, a small stumper for me.
>
> My client is oracle11g.
>
> I am testing a connection using tnpsing. Unfortunately, the service
> name I am tnsping’ing is not in my tnsnames file. The cmd windows
> tells me it is using the tnsnames adaptor at the location of my
> tnsnames, but the service name is not in there.
>
> Since the target machine is no longer alive, the tnsping generates a
> tns error. But, it correctly displays the old connect information,
> which did exist quite some time ago.
>
> I do not have tns_admin set.
>
> As a test, I renamed my tnsnames file. TOAD and my application tools
> will not connect now. BUT, tnsping still works. Still successfully
> found several of the service names from my file.
>
> Which makes me think it is pulling from another location, but I can’t
> find it.
>
> My sqlnet.ora file is #’d out, so no information is in there to direct
> it anywhere.
>
> The question is…where is tnsnames pulling the data from?
>
> Thoughts?
>

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


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