TNS-03505 eror

From: Jerome Poirier <jerome.poirier_at_lip6.fr>
Date: 2000/05/17
Message-ID: <ilBU4.196$2y1.463985@nnrp1.proxad.net>#1/1

Hello,

First, I apologize for my "frenchy" english. I try to connect a NT client to a Oracle 8.1 remote database, and I have some TNS problems.

Here is the file oracle\network\admin\tnsnames.ora :

# D:\ORACLE\NETWORK\ADMIN\TNSNAMES.ORA Configuration
File:D:\oracle\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle Net8 Assistant
    MYBASE.MYNET.FR =

      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = casanova.mynet.fr)(PORT =
1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = GENERAL)
        )
      )

When I try "tnsping MYBASE.MYNET.FR" or "tnsping MYBASE", the following error occurs : "TNS-03505: Failed to resolve name". When I try "SQL Plus", the following error occurs : "ORA-12154: TNS:could not resolve service name".

I have this other file : oracle\designer\network\admin\tnsnames.ora. And when I add MYBASE.MYNET into it, the tnsping works great... (So I think that tnsping don't use the good tnsnames.ora file) But with this configuration, when I try to connect "SQL Plus" the ORA-12154 error occurs again !

How can I configure my clients so they use the good tnsnames.ora file ?

Thank you a lot

Ps : here is the oracle\network\admin\sqlnet.ora:

# D:\ORACLE\NETWORK\ADMIN\SQLNET.ORA Configuration
File:D:\oracle\network\admin\sqlnet.ora

# Generated by Oracle Net8 Assistant
    NAMES.DEFAULT_DOMAIN = mynet.fr
    SQLNET.AUTHENTICATION_SERVICES= (NTS)     NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES) Jerome Poirier
jerome.poirier_at_lip6.fr Received on Wed May 17 2000 - 00:00:00 CDT