Re: Listener issue

Faisal Qasim wrote:

> Dear All,
>
> Listener on Oracle 7.3 on AIX 4.3.3 sometimes doesn't work at boot up.
> Though listener process is started but listener refuses connection.
> Manual start of listener resolves the issues. As you can see in log
> below listener doesn't return any error.
>
> What is going wrong, what should I check? I will be grateful for any
> hints.
>
> Regards
>
> Following are the log entries:
>
> "Listener was not working after this "
> "
> TNSLSNR for IBM/AIX RISC System/6000: Version 2.3.4.0.0 - Production
> on 24-OCT-0
> 2 08:25:19
>
> Copyright (c) Oracle Corporation 1994. All rights reserved.
>
> System parameter file is
> /oracle/app/oracle/product/7.3.4/network/admin/listener
> .ora
> Log messages written to
> /oracle/app/oracle/product/7.3.4/network/log/listener.lo
> g
> Trace information written to
> /oracle/app/oracle/product/7.3.4/network/trace/list
> ener.trc
> Trace level is currently 0
>
> Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=10)(HOST=132.155.160.1)(PORT=1528))
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
> CODE
> 24-OCT-02 08:25:21 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=culaprsF80)(USER=oracle)
> )(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=36716544)) *
> status *
> 0
> "
>
> "Manual Start. Listener was fine after this "
>
> TNSLSNR for IBM/AIX RISC System/6000: Version 2.3.4.0.0 - Production
> on 24-OCT-0
> 2 09:35:01
>
> Copyright (c) Oracle Corporation 1994. All rights reserved.
>
> System parameter file is
> /oracle/app/oracle/product/7.3.4/network/admin/listener
> .ora
> Log messages written to
> /oracle/app/oracle/product/7.3.4/network/log/listener.lo
> g
> Trace information written to
> /oracle/app/oracle/product/7.3.4/network/trace/list
> ener.trc
> Trace level is currently 0
>
> Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=10)(HOST=132.155.160.1)(PORT=1528))
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
> CODE
> 24-OCT-02 09:35:01 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=culaprsF80)(USER=oracle)
> )(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=36716544)) *
> status *
> 0

Just wildly speculating on this one ... but you have upgraded your operating system to the current version and your Oracle version is Paleolithic. Why not try a version of Oracle that has been supported during the current millenium? Or at least with your operating system?

Daniel Morgan Received on Thu Oct 24 2002 - 10:56:40 CDT