vérifier état d'un listener sur un serveur.
(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.
LDR01.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.mondomaine.com)(PORT = 1548))
)
(CONNECT_DATA =
(SID = LDR01)
(SRVR = DEDICATED)
)
)
Derniers commentaires