tomtailor_at_freesurf.fr wrote:
> 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
>
> Copyright (c) 1997, 2003, Oracle. All rights reserved.
>
> 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
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> ERROR:
> ORA-12154: TNS:could not resolve the connect identifier specified
>
>
> Enter user-name:
>
> Need Help!
>
> THX
> Christian Meier
>
Check your path... your sqlplus originates from another
directory tree (also known as oracle_home).
Introduce tns_admin as local variable (also known as
registry under windows), or copy your *.ora entries over
to the network admin subdirectory of the other (the sqlplus)
oracle_home
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Sep 07 2005 - 09:45:51 CDT
