Re: tnsnames not working. tnsping picks sqlnet.ora

Hi Carlos
Thanks for your answer. I pinged the server name to get the IP and I substituted the hostname with the IP in the TNSNAMES entry, but tnsping returns error TNS-03505 again :(

Nacho

On 28 jun, 13:20, Carlos <miotromailcar..._at_netscape.net> wrote:
> 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:31:21 CDT