Re: Getting error on connecting to oracle listener

Here are the steps :

lsnrctl start

This must show you the status of the listener. If you don't get any problem at this step then connect using the connect string that you specified in tnsnames.ora i.e GL

Connect to sqlplus e.g

sqlplus scott/tiger_at_GL

hope this helps. Try using the tnsping utility,

tnsping GL

If it returns OK then your listener is up

Omar Siddique wrote in message <78nit6$2lm2_at_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=d bs1)(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 - 20:03:56 CST