Getting error on connecting to oracle listener

From: Omar Siddique <omar_at_umbc.edu>
Date: 27 Jan 1999 12:37:42 -0500
Message-ID: <78nit6$2lm2@umbc7.umbc.edu>

Hi, I'm a relative newbie to doing Oracle DBA (I'm really a sysadmin), and I'm running into a problem getting my oracle 8.0.3 networking functioning.

I've followed the directions (both in the example files and in a DBA reference) to get the listener up and running on the server.

I start the listener with
a "lsnctrl start" and can telnet to the correct port (1521) and the null connection shows up in the listener's log. However, if I try to test the networked functionality by doing a (on the same machine on which the server runs):

sqlplus <user/pass>@oracle.gl.umbc.edu

I get:

ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

The log file indicates:

TNS-12505: TNS:listener could not resolve SID given in connect descriptor 12-JAN-99 13:37:40 * (CONNECT_DATA=(SID=*)(SERVICE_NAME=oracle.gl.umbc.edu)(CID=(PROGRAM=)(HOST=dbs1)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=130.85.6.13)(PORT=6647)) * establish * oracle.gl.umbc.edu * 12505

My listener.ora file contains:

LISTENER =

  (ADDRESS_LIST=
       (ADDRESS=(PROTOCOL=tcp)(HOST=oracle.gl.umbc.edu)(PORT=1521))
       (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))   

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (SID_NAME = GL) 
      (GLOBAL_DBNAME = GL)
      (ORACLE_HOME= /usr/oracle/app/oracle/product/8.0.3)

    )
  )
TRACE_LEVEL_LISTENER = off

My tnsnames.ora file contains:

GL =
  (DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=oracle.gl.umbc.edu)
(PORT=1521))

(CONNECT_DATA =
(SID=GL)))
Both files are in <oracle_home>/app/oracle/product/8.0.3/network/admin

And my /etc/oratab does indeed identify the instance as GL:

GL:/usr/oracle/app/oracle/product/8.0.3:Y

The server is a SGI Challenge M running Irix 6.2.

Am I missing something basic? I would very much appreciate any advice!

-omar Received on Wed Jan 27 1999 - 11:37:42 CST