Re: tnsnames not working. tnsping picks sqlnet.ora

On 28 jun, 12:56, -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
>
> 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

What if you put the serverIP instead of <servername> in tnsnames.ora? (Could be name/IP resolution related).

Also:

ping <servername>

ping <serverIP>

and see what happens...

HTH Saludos.

Carlos. Received on Thu Jun 28 2007 - 06:20:19 CDT