[Oracle] Oracle Listener 구성정보 확인

lsnrctl

DBserver에서 lsnrctl 리스너 컨트롤러 접속

[oracle@sua-03 ~]$ lsnrctl

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 16-FEB-2024 11:45:51

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=sua-03.novalocal)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                14-FEB-2024 04:35:35
Uptime                    2 days 7 hr. 10 min. 47 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/sua-03/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sua-03.novalocal)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Services Summary...
Service "ORCL" has 2 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCLXDB" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

 

 

listener 파일

경로 : Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora

LISTENER =
  (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=sua-03.novalocal)(PORT=1521))
        (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

SID_LIST_LISTENER=
   (SID_LIST=
        (SID_DESC=
          (GLOBAL_DBNAME=ORCL)
          (SID_NAME=ORCL)
          (ORACLE_HOME=/opt/oracle/product/19c/dbhome_1)
         )
        )
       )

~
~
~
"/opt/oracle/product/19c/dbhome_1/network/admin/listener.ora" 14L, 338C