Re: 8i Listener Problem

From: John McNamee <reedpacific_at_bigpond.com>
Date: Wed, 23 Aug 2000 14:10:10 +1000
Message-ID: <J5Io5.36167$c5.101173@newsfeeds.bigpond.com>

Thankyou for your reply

telnet is ok the port is open and ready. I have some more information below that I think is causing my problem

When I start the listener I get

TNSLSNR for Linux: Version 8.1.6.0.0 - Production System parameter file is
/u01/ora8/app/oracle/8i_8.1.6/network/admin/listener.ora Log messages written to
/u01/ora8/app/oracle/8i_8.1.6/network/log/listener.log Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=holly.mv)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=holly.mv)(PORT=1521))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.1.6.0.0 - Production
Start Date                23-AUG-2000 09:23:48
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      ON

Listener Parameter File
/u01/ora8/app/oracle/8i_8.1.6/network/admin/listener.ora Listener Log File
/u01/ora8/app/oracle/8i_8.1.6/network/log/listener.log Services Summary...
PLSExtProc has 1 service handler(s)
ora8 has 1 service handler(s)
The command completed successfully

***EOF For around 50 -65 seconds after this I can connect and reconnect etc After this time if I do a lsnrctl status I get ( Note the 3 extra handlers on ora8 )

LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 23-AUG-2000 09:24:39

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=holly.mv)(PORT=1521))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.1.6.0.0 - Production
Start Date                23-AUG-2000 09:23:48
Uptime                    0 days 0 hr. 0 min. 51 sec
Trace Level               off
Security                  OFF
SNMP                      ON

Listener Parameter File
/u01/ora8/app/oracle/8i_8.1.6/network/admin/listener.ora Listener Log File
/u01/ora8/app/oracle/8i_8.1.6/network/log/listener.log Services Summary...
  PLSExtProc has 1 service handler(s)
  ora8 has 1 service handler(s)
  ora8 has 3 service handler(s) <======== ??????? The command completed successfully

***EOF Once these extra handlers appear, I can no longer connect to the server. Here is my listener.ora file

# LISTENER.ORA Configuration
File:/u01/ora8/app/oracle/8i_8.1.6/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = holly.mv)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/ora8/app/oracle/8i_8.1.6)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = ora8)
(ORACLE_HOME = /u01/ora8/app/oracle/8i_8.1.6)
(SID_NAME = ora8)

)
  )

***EOF Any ideas on if this is related to my problem

Regards
John

Peter Köhler <sorrynospammails_at_nodomain.de> wrote in message news:01c00c47$306af0a0$3c3b1e10_at_ws_koehler...

> Hi John,
>
> maybe You try a telnet to port 1521 (or to whatever it is configured) of
> the server; if there is a connection the listener is running.
> Another possibility is to use tnsping with a correct tnsnames.ora on the
> client.
>
> hth
>
> Peter
> --
> Peter Koehler
> DBA in Frankfurt/Germany
> E-Mail: p k o e h l e r  @ g m x . d e
>
> John McNamee <myvoice_at_zipworld.com.au> schrieb im Beitrag
> <8ntam3$61d$1_at_nina.pacific.net.au>...
> > Hi
> >
> > I'm having problems with our Linux 8i server.
> >
> > Software has been installed ok and I can get client connections with a
> > freshly started listener (LSNRCTL start) using the DBA studio client.
> >
> > Once I disconnect and then attempt to reconnect I get a "Target not

found"

> > error. But, if I restart the listener on the server then try to connect
> > again all is fine.
> >
> > It seems to me that the listener once started waits a certain amount of

time

> > and then goes to "sleep" and becomes stale???
> >
> > If I nmap the server the listener appears on the right port etc so I

dont

> > know what's wrong
> >
> > Any ideas appreciated
> >
> > John
> >
> >
> >

Received on Tue Aug 22 2000 - 23:10:10 CDT