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...@xxxxxxxxxxxx> wrote:
On 28 jun, 12:56, -Nacho- <lironli...@xxxxxxxxx> 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...@xxxxxxxxx> wrote:

On Jun 28, 12:14 pm, -Nacho- <lironli...@xxxxxxxxx> 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.


.