Re: tnsnames not working. tnsping picks sqlnet.ora

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



.

Relevant Pages

  • Re: Finding the users ISPs outgoing mail server?
    ... The problem IMHO is that there is no bar to entry, ... So the database schema is completely incorrect ... they tend to be used only by people with proer software dev experience. ... people with Oracle running on their PC! ...
    (comp.mail.misc)
  • Re: MS Oracle Data Provider BUG: Data corrupt after 16 rows with O
    ... Unicode into a UTF8 database, when you insert Unicode data it inserts ... True Unicode providers like odp.net and the oracle managed ... provider will instead return the "garbage". ... >> It is really strange that both ODP.NET and the Oracle Client managed ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Apparent DBD::Oracle 1.16 unicode regression
    ... >> I suspect an oracle client version mismatch with the server. ... database, and from a 9.2 client to a 9.2 database. ... oracle client software or OLDER versions of oracle on the database side. ... Since you say this breaks _every_ one of your customers, however, I find ...
    (perl.dbi.users)
  • Re: question on Asp.net and Oracle
    ... I have already reboot the machine since i nstalled the oracle client. ... >> to access the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Accessing an Oracle database with vb.net
    ... an Oracle database before). ... I installed the oracle dll and added it as reference (I get the same ... If not, I would install the ... oracle client and include SQL plus during the installation. ...
    (microsoft.public.dotnet.languages.vb)