Re: TNSPING question

Find every file called tsunamis.ora sorry about autocorrect. And rename to tsunamis.ora.bak reboot and try again

On 13 Oct 2016 14:10, "Mladen Gogala" <gogala.mladen_at_gmail.com> wrote:

> 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 DBAhttp://mgogala.freehostia.com
>
>

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