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

From: Ariji Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 28 Feb 2005 01:30:01 -0800
Message-ID: <1109583001.385248.34440@f14g2000cwb.googlegroups.com>

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 Received on Mon Feb 28 2005 - 03:30:01 CST