Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting error on connecting to oracle listener
Hi
use
lsnrctl stat
to poll the listener status.. if it is not running then start.
good luck..
pradhan
Qaiser Rasheed wrote:
> 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 Thu Jan 28 1999 - 00:50:22 CST