Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus & TNSListener
> The only way to verify that your listener is running is to issue the
> 'lsnrctl status' command. I've noticed on Windows that there is a
> problem where the service starts, yet the Oracle software is not
> running, on occasion. So verify that the listener is in fact running.
> Also verify that the listener is running on the port you are trying to
> contact.
Actually the service is running
The "lsnrctl status" command line provides the following dump (sorry it's in
french :)):
For each database (BASE1 & BASE2) I have two service manager
>D:\oracle\ora81\bin>lsnrctl status
>LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 10-SEP-2003
08:46:27
>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))STATUT du
LISTENER
>------------------------
>Alias LISTENER
>Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 -
Production
>Date de départ 09-SEP-2003 17:01:06
>Durée d'activité 0 jours 15 heures 45 min. 21 sec
>Niveau de trace off
>Sécurité OFF
>SNMP OFF
>Fichier de paramètres du listener
D:\oracle\ora81\network\admin\listener.ora
>Fichier journal listener
D:\oracle\ora81\network\log\listener.log
>Récapitulatif services...
> BASE1 \ 1 gestionnaires de services
> BASE1 \ 2 gestionnaires de services
> PLSExtProc \ 1 gestionnaires de services
> BASE2 \ 1 gestionnaires de services
> BASE \ 2 gestionnaires de services
>La commande a réussi
Received on Wed Sep 10 2003 - 02:29:27 CDT