Re: tnsnames not working. tnsping picks sqlnet.ora

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

On 28 jun, 12:51, sybrandb <sybra..._at_gmail.com> wrote:
> On Jun 28, 12:14 pm, -Nacho- <lironli..._at_gmail.com> wrote:
>
>
>
> > Hi all
> > My oracle client has been working fine till today. I tried to connect
> > to a new database, after editing the tnsmaes and adding the entry for
> > that new connection, TOAD begun to answer a strange and empty dialog.
> > I triend to tnsping the new database and any other old database and I
> > always got the message:
>
> > C:\oracle\ora92\bin>tnsping mqsitmp_pr
>
> > TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
> > 28-JUN-20
> > 07 11:47:03
>
> > Copyright (c) 1997 Oracle Corporation. All rights reserved.
>
> > Archivos de parßmetros utilizados:
> > C:\oracle\ora92\network\admin\sqlnet.ora
>
> > TNS-03505: Fallo al resolver el nombre
>
> > The client is in Spanish locale, but it says that used file is
> > sqlnet.ora ¿instead tnsnames.ora?
>
> > Where could be the problem. Anyone can point where to look?
>
> > Thanks in advance.
> > -
> > Nacho
>
> The message about sqlnet.ora is normal behavior.
> You need to look in your tnsnames.ora.
> Note that a syntax error or a missing ( or ) will result in tns-12514
> using normal connects and 3505 during tnsping.
> Conclusion: if you edited your tnsnames.ora manually, you made a
> mistake, and screwed it up.
> If it is really screwed netca won't read it.
> I would recommend removing everything you added and use netca (Net
> configuration assistant) to add the entry again.
> It will be correct now.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Jun 28 2007 - 05:56:29 CDT