This is a discussion on lsnrctl start wait long time within the Oracle Database forums, part of the Database Server Software category; --> I am using a Oracle 8.1.7.4 database on a linux server. When I start the listener, it hangs up ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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@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.bac kup)(PORT=2484))) Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)) ) Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROD))) Connexion à (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhos t)(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.bac kup)(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 |
| ||||
| On 31 Oct 2003 10:36:47 -0800, pablorico@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@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.bac kup)(PORT=2484))) >Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)) ) >Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROD))) > >Connexion à (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhos t)(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.bac kup)(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 DBA |
| Thread Tools | |
| Display Modes | |
|
|