Re: tnsnames not working. tnsping picks sqlnet.ora

Hi Sybrand.
I posted here after several tries and tests, not as first choice. I'm a usenet user for more than 10 years and I look for help only after looking a solution in the web, in the usenet archives and doing all my best to find the solution. And usually I post the solution if I find it by other mean, serving this way as a knowledge base. ;) Just because I DO NOT know the solution at all (for the moment) :D

I have only one tnsnames.ora, and it works fine on my friend PC, so I assumed the tnsnames.ora is not wrong. After that I tried to create a fresh new tnsnames.ora with only ONE database entry, and after trying different databases it did not work with the same error (TNS-03503. So I think that problem is not in tnsnames.ora but in any other place of the Oracle client :)

Thanks!
Nacho

On 28 jun, 14:12, sybrandb <sybra..._at_gmail.com> wrote:
> 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
Received on Thu Jun 28 2007 - 08:11:43 CDT