Re: tnsnames not working. tnsping picks sqlnet.ora

On Jun 28, 12:56 pm, -Nacho- <lironli..._at_gmail.com> wrote:
> Hi Sybrand.
> Thanks for your answer. I tried a tnsnames of a workmate that works
> fine in his PC, but it doesn't work on my computer so I discarded the
> possibility of mismatched tnsnames.
>
> żAny other possibility?
> Thanks
> -
> Nacho
>

So you are not using the tnsnames.ora you *think* you are using, and you have multiple tnsnames.ora's on your system. Apart from refraining from top-posting (which is a typical result of exposure to the Evil Empire of William H. Gates III, which makes everyone too lazy to recognize humans don't read from bottom to top), you could consider setting TNS_ADMIN, or follow the Microsoft engineering method of formatting your C-drive and install everything again.

The tnsnames.ora you are using as a result of the tnsping (it is in c: \oracle\ora92) is *definitely* wrong.

If you *think* you know the solution or know better, why post here in the first place?

--
Sybrand Bakker
Senior Oracle DBA