Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: lsnrctl start wait long time
On 31 Oct 2003 10:36:47 -0800, pablorico_at_hotmail.com (Pablo) wrote:
>I am using a Oracle 8.1.7.4 database on a linux server.
>When I start the listener, it hangs up for 15 minutes and then
>eventualy completes.
>Does someone knows how to fix this delay?
>
>Thank you
>Pablo
>
>during the "freezing":
>my shell output:
>oracle_at_Lisa:~$ lsnrctl start
>
>LSNRCTL for Linux: Version 8.1.7.4.0 - Production on 31-OCT-2003
>19:07:03
>
>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>
>Lancement de /usr/app/oracle/product/8.1.7/bin/tnslsnr: Veuillez
>patienter...
>
>TNSLSNR for Linux: Version 8.1.7.4.0 - Production
>Le fichier de paramètres système est
>/usr/app/oracle/product/8.1.7/network/admin/listener.ora
>Messages de journalisation écrits dans
>/usr/app/oracle/product/8.1.7/network/log/listener.log
>Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stan.backup)(PORT=2484)))
>Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
>Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROD)))
>
>Connexion à (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=2484)))
>
>---------------------------------------------------
>listener.ora:
>
>TNSLSNR for Linux: Version 8.1.7.4.0 - Production on 31-OCT-2003
>18:22:14
>
>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>
>Le fichier de parametres systeme est
>/usr/app/oracle/product/8.1.7/network/admin/listener.ora
>Messages de journalisation ecrits dans
>/usr/app/oracle/product/8.1.7/network/log/listener.log
>Informations d'analyse ecrites dans
>/usr/app/oracle/product/8.1.7/network/trace/listener.trc
>Le niveau d'analyse actuel est 0
>
>Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lisa.backup)(PORT=2484)))
>Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
>Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=FTVPROD)))
>TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
>CODE
I can't see your listener.ora, but looking that you get three
different host names back (localhost, lisa.backup, and stan.backup) I
would assume it is messy.
Post your listener.ora and/or trace the startup by setting
trace_level_<listener_name>= USER|ADMIN
in listener.ora
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Oct 31 2003 - 13:16:28 CST