Re: Tnsnames.ora /Listener.ora config probs...Urgent

Ariji Chatterjee wrote:
> Dear Faculties,
>
> Platform- windows 2003 enterprise server
> Oracle - 8.1.7
>
> I faced this problem again...
> I have Database called sysdb.shanta.local
>
> LISTENER.ORA
> ============
> # LISTENER.ORA Network Configuration File:
> D:\Oracle\iSuites\NETWORK\ADMIN\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = systel1.shanta.local)(PORT =
> 1521))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = sysdb.shanta.local)
> (ORACLE_HOME = d:\oracle\isuite)
> (SID_name = sysdb)
> )
> )
> ============
> TNSNAMES.ORA
> ============
>
> SYSDB.SHANTA.LOCAL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = systel1.shanta.local)(PORT
=
> 1521))
> )
> (CONNECT_DATA =
> (SID = sysdb)
> (SRVR = DEDICATED)
> )
> )
> =============================
> lsnrctl start STATEMENT
> ========================
> C:\Documents and Settings\Administrator>lsnrctl start
>
> LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on
> 28-FEB-2005 14:44:01
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Starting tnslsnr: please wait...
>
> TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
> System parameter file is

D:\Oracle\iSuites\network\admin\listener.ora
> Log messages written to D:\Oracle\iSuites\network\log\listener.log
> Listening on:
>

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=systel1.Shanta.local)(PORT=1521)))
>
> Connecting to
>

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=systel1.shanta.local)(PORT=1521)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for 32-bit Windows: Version
> 8.1.7.0.0 - Production
> Start Date 28-FEB-2005 14:44:03
> Uptime 0 days 0 hr. 0 min. 2 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File
> D:\Oracle\iSuites\network\admin\listener.ora
> Listener Log File

D:\Oracle\iSuites\network\log\listener.log
> Services Summary...
> sysdb has 1 service handler(s)
> The command completed successfully
> =================================
> lsnrctl services STATEMENT
> ==========================
> C:\Documents and Settings\Administrator>lsnrctl services
>
> LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on
> 28-FEB-2005 14:44:50
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connecting to
>

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=systel1.shanta.local)(PORT=1521)))
> Services Summary...
> sysdb has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> The command completed successfully
>
> C:\Documents and Settings\Administrator>
> ==================================
> Now when I trying to login as system/manager getting the error but
not
> as an root user..
> ==============
> As Root User
> ============
> C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Mon Feb 28 14:46:25 2005
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> SQL>
> =========================
> But as system/manager
> =====================
> C:\Documents and Settings\Administrator>SQLPLUS system/manager_at_sysdb
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Mon Feb 28 14:47:22 2005
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12154: TNS:could not resolve service name
> =======================
> Need some suggestion.Thanks in advance.
> Regards
> Arijit Chatterjee

Either enter this line in the sqlnet.ora file NAMES.DEFAULT_DOMAIN = SHANTA.LOCAL
OR
include the domain name in the connect string as user/pwd_at_SYSDB.SHANTA.LOCAL

BTW... This is NOT paid support where you are posting so putting "Urgent" in the message title is useless.

Regards
/Rauf Received on Mon Feb 28 2005 - 04:06:15 CST