Re: TNS Resolve Problem

From: <tomtailor_at_freesurf.fr>
Date: 8 Sep 2005 02:02:05 -0700
Message-ID: <1126170125.169184.194760@g44g2000cwa.googlegroups.com>

OK now i tried
D:\>sqlplus sysman/****@KTP.ci-test.CI_BHG

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 8 10:44:40 2005

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:
^V

and
D:\>sqlplus sysman/****

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 8 10:44:52 2005

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
^V
D:\>

As you can see, there is no chance to connect. In the NetManager there is also an "Test" option and it means:
Versuch, die Verbindung mit folgender Benutzer-Id herzustellen: op Der Verbindungstest war erfolgreich.
-> Witch means everything is OK.

So my SQLNET.ora contains:
D:\>type D:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora # sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\a
dmin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES) ... seems to be ok, tnsnames is in the path.

The winXP Registry seems to be too complex to me, it's not quite easy than the Enviroments under my SuSE Oracle (witch works very well). Thing is, I have to do this damn Oracle Thing under Windows and it seems to be impossible to get it work.

I am realy stumped ...
Christain Received on Thu Sep 08 2005 - 04:02:05 CDT