Re: TNS Resolve Problem

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.

Then most certainly your environment is not right. Have you tried writing a little batch script to set ORACLE_SID and ORACLE_HOME? (Or maybe there is an Oracle home selector?)

>
> 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

$sqlplus jeg_at_ZTST

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Sep 7 15:34:55 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name

Enter user-name:
$ sqlplus jeg

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Sep 7 15:35:11 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

SQL> What is happenning here is that ZTST is not defined in the tnsnames.ora, and I don't have TWO_TASK defined. But I do have it defined in $ORACLE_SID and the listener picks it up. So if I specify @ZTST, it looks in the tnsnames.ora, doesn't find it, and spits out ORA-12154. But if I don't specify it and just use the defaults, it finds it just fine. So one thing might be a problem with your tnsnames.ora You might try KTP.ci-test.CI_BHG. Some versions of Oracle are sensitive to messing up tnsnames invisibly with certain editors or copying, you might try regenerating it from scratch. What is in your sqlnet.ora file?

jg

-- 
@home.com is bogus.
http://www.anthemamerica.com/jpeg/whywomen.jpg