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:51:17 CDT
