Re: problem with listener on oracle 8.1.7

From: VasantKumar Naidu <vask001_at_yahoo.com>
Date: 28 Jul 2003 02:05:00 -0700
Message-ID: <d9a73221.0307280105.3365f5fd@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<vme4ivcna1ovo6qq4q8hs354ihqupc8780_at_4ax.com>...
> On 26 Jul 2003 00:55:47 -0700, vask001_at_yahoo.com (VasantKumar Naidu)
> wrote:
>
> >I get the following when I check for the listener status on the server.
> >
> >Services Summary...
> > cbi has 3 service handler(s)
> > PLSExtProc has 1 service handler(s)
> > cbi has 3 service handler(s)
> > cbi has 3 service handler(s)
> >The command completed successfully
> >
> >Why does this happen, sometimes the transaction stop, the query hangs
> >but the if I restart the listener everything is fine for the sometime.
>
> I don't see any problem here, and no clues to troubleshoot the
> problem.
> Oracle 8i databases register themselves automatically with the
> listener. This will result in extra endpoints using the (service_name
> = ) syntax instead of the (sid_name = ) syntax. If you have
> multithreaded server configured (another case of self registration)
> you will see additional endpoint.
> So: you don't seem to have a listener problem at all, you don't post
> any error messages, so your 'problem' can't be adressed at all
>
> What you would need to do is
> lsnrctl
> set displaymode verbose
> services
>
> and post the mts_ parameters from your init.ora
> so in that case anyone can check the services.
>
> You would also need to come up with something better than 'the
> transaction stops'
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Hi sybrand,

I get the following output:

LSNRCTL> set displaymode verbose
Service display mode is VERBOSE
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) Services Summary...

Service "MODOSE"                has 1 instances.
    Instance "cbi"
      Status: READY  Total handlers: 3  Relevant handlers: 1
      Class: ORACLE
        D000 established:0 refused:0 current:0 max:1022 state:ready
        (ADDRESS=(PROTOCOL=tcp)(HOST=cbicpp.cbicpp)(PORT=32817))
            Session: NS
Service "PLSExtProc"            has 1 instances.
    Instance "PLSExtProc"
      Status: READY  Total handlers: 1  Relevant handlers: 1
      Class: ORACLE
        DEDICATED established:0 refused:0 current:0 max:0 state:ready
        (ADDRESS=(PROTOCOL=beq)(PROGRAM=/home/app/oracle/product/817/bin/extproc)(ENVS='ORACLE_HOME=/home/app/oracle/product/817,ORACLE_SID=PLSExtProc')(ARGV0=extprocPLSExtProc)(ARGS='(LOCAL=NO)'))
Service "cbi"           has 2 instances.
    Instance "cbi"
      Status: READY  Total handlers: 1  Relevant handlers: 1
      Class: ORACLE
        DEDICATED established:0 refused:0 current:0 max:0 state:ready
        (ADDRESS=(PROTOCOL=beq)(PROGRAM=/home/app/oracle/product/817/bin/oracle)(ENVS='ORACLE_HOME=/home/app/oracle/product/817,ORACLE_SID=cbi')(ARGV0=oraclecbi)(ARGS='(LOCAL=NO)'))
    Instance "cbi"
      Status: READY  Total handlers: 3  Relevant handlers: 2
      Class: ORACLE
        DEDICATED established:45 refused:0 current:0 max:0 state:ready
        (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=/home/app/oracle/product/817/bin/oracle)(ARGV0=oraclecbi)(ARGS='(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))')(ENVS='_=/home/app/oracle/product/817/bin/sqlplus,TZ=:US/Eastern,PATH=/usr/bin:/usr/ccs/bin:/usr/ccs/bin:/usr/sbin:/usr/java/bin:/home/app/oracle/product/817/bin:/bin:/opt/bin:/usr/bin:/usr/ccs/bin:/usr/java/bin:/usr/lib/X11:/usr/bin/X11:/usr/X/l

b/X11/locale/C:.,LANG=en_IN,XKEYBOARD=C/US,LOGNAME=oracle,ENV=/home/oracle/.kshrc,DISPLAY=unix:0.0,SHELL=/usr/bin/ksh,ORACLE_SID=cbi,HZ=,ORACLE_HOME=/home/app/oracle/product/817,ORACLE_TERM=vt100,XNLSPATH=/usr/X/lib/Xsi/C/US,XMODIFIERS=@im=Local,NUMLOCK=no,KEYBOARD=C/US,PWD=/home/app/oracle/product/817/admin/cbi/pfile,MAPCHAN=/usr/lib/mapchan/88591.dk,SHIFTDOWN=yes,HOME=/home/oracle,TERMCAP=/etc/t rmcap,_TTYNAME=/dev/pts011,TERM=dtterm,_AST_FEATURES=UNIVERSE - att,ORA_NET2_DESC=7,10')(ENV_POLICY=NONE))

            Session: NS
        D001 established:0 refused:0 current:0 max:1022 state:ready
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cbicpp.cbicpp)(PORT=32818))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW))
            Presentation: oracle.aurora.server.SGiopServer
            Session: RAW

The command completed successfully

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Intel SVR4 UNIX: Version
8.1.7.0.0 - Production
Start Date                26-JUL-2003 11:40:16
Uptime                    2 days 2 hr. 36 min. 4 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/home/app/oracle/product/817/network/admin/listener.ora Listener Log File
/home/app/oracle/product/817/network/log/listener.log Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.1.179)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cbicpp.cbicpp)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
Services Summary...
Service "MODOSE"                has 1 instances.
    Instance "cbi"
      Status: READY  Total handlers: 3  Relevant handlers: 1
      Class: ORACLE
Service "PLSExtProc"            has 1 instances.
    Instance "PLSExtProc"
      Status: READY  Total handlers: 1  Relevant handlers: 1
      Class: ORACLE
Service "cbi"           has 2 instances.
    Instance "cbi"
      Status: READY  Total handlers: 1  Relevant handlers: 1
      Class: ORACLE
    Instance "cbi"
      Status: READY  Total handlers: 3  Relevant handlers: 2
      Class: ORACLE

The command completed successfully
LSNRCTL>

vasant

Received on Mon Jul 28 2003 - 04:05:00 CDT