TNS Resolve Problem

From: <tomtailor_at_freesurf.fr>
Date: 7 Sep 2005 07:23:32 -0700
Message-ID: <1126103012.293349.100830@g44g2000cwa.googlegroups.com>

Hello!

I've installed 10g on XP Prof and before reboot everything worked ok sql plus and Webadminconsole. After reboot I'm just able to access data via Webclients (Admin or isqlpplus) but I'm not able to access via console sqlplus ore ODBC.

What is the Damn Error??

My listerner and tns.oras are:
D:\oracle\product\10.1.0\db_1\network\admin>type listener.ora
# listener.ora Network Configuration File:
D:\oracle\product\10.1.0\db_1\NETWORK
\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = KTP)
    )
  )

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ci-test.CI_BHG)(PORT = 1521)) )

D:\oracle\product\10.1.0\db_1\network\admin>type tnsnames.ora
# tnsnames.ora Network Configuration File:
D:\oracle\product\10.1.0\db_1\NETWORK
\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

KTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ci-test.CI_BHG)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = KTP)

)
)

and the tnsping result is:
D:\oracle\product\10.1.0\db_1\network\admin>tnsping KTP

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 07-AUG-2
005 16:12:21

Parameterdateien benutzt:
D:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora

Adapter TNSNAMES zur Aufl÷sung des Alias benutzt Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = ci-test.CI_BHG)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SER
VICE_NAME = KTP)))
OK (50 ms)

but a connect to sqlplus fails:
D:\Dokumente und Einstellungen\oracle.CI-TEST>sqlplus sysman/****@KTP

SQL*Plus: Release 10.1.0.2.0 - Production on Sun Aug 7 16:15:18 2005

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

Enter user-name:

Need Help!

THX
Christian Meier Received on Wed Sep 07 2005 - 09:23:32 CDT