Re: tnsnames not working. tnsping picks sqlnet.ora

On 28 jun, 15:11, -Nacho- <lironli..._at_gmail.com> wrote:
> 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

żNo tendras un 'default domain' en el sqlnet.ora?

Saludos.

Carlos. Received on Thu Jun 28 2007 - 08:38:25 CDT