Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus & TNSListener

Re: SQLPlus & TNSListener

From: Malderez Cédric <cedric.malderez_at_answork.com>
Date: Wed, 10 Sep 2003 09:29:27 +0200
Message-ID: <3f5ed2a7$0$13279$626a54ce@news.free.fr>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US