[Oracle] Verfier etat d'un listener

vérifier état d'un listener sur un serveur.

[sql]
(server) [root] /home/root > ps -ef | grep pmon
  ora102  880834       1   0 03:18:05      -  0:06 ora_pmon_LDREF01
  ora102 1712218       1   0 03:17:45      -  0:06 ora_pmon_LDREP01
    root 1732796  806948   0 14:12:37  pts/4  0:00 grep pmon
(server) [root] /home/root > su - ora102
============================================
= You are connected with a [LOCAL] account =
============================================
(server) [ora102] /home/ora102 > lsnrctl

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 23-APR-2009 14:14:47

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status LDR01
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LDR01)))
STATUS of the LISTENER
------------------------
Alias                     LDR01
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date                16-NOV-2008 08:24:08
Uptime                    158 days 5 hr. 51 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /appl/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File         /appl/oracle/product/10.2.0/network/log/ldr01.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LDR01)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1549)))
Services Summary...
Service "LDR01" has 1 instance(s).
  Instance "LDR01", status READY, has 1 handler(s) for this service...
Service "LDR01_XPT" has 1 instance(s).
  Instance "LDR01", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

bien vérifier la présence de l'entrée dans le fichier local D:\oracle\product\10.2.0\client_2\network\admin\tnsnames.

[sql]
LDR01.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = server.mondomaine.com)(PORT = 1548))
    )
    (CONNECT_DATA =
      (SID = LDR01)
      (SRVR = DEDICATED)
    )
  )