Oracle Cloud DBCS listener port 확인

DBCS provisioning 후 listener port 확인

 

기본은 1521이며 다른 포트로 변경하는것은 권장하지 않고 있다.

 

[oracle@gtplus102 ~]$ ps -ef |grep tns
root        22     2  0 05:55 ?        00:00:00 [netns]
grid      9983     1  0 05:57 ?        00:00:00 /u01/app/18.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid      9993     1  0 05:57 ?        00:00:00 /u01/app/18.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle   47177 36087  0 06:07 pts/0    00:00:00 grep tns

SYS@GTPLUS 06:07:45> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
forward_listener                     string
listener_networks                    string      (( NAME=net1)(LOCAL_LISTENER=(
                                                 ADDRESS=(PROTOCOL=TCP)(HOST=10
                                                 .0.0.3)(PORT=1521))))
local_listener                       string      LISTENER_GTPLUS
remote_listener                      string

[oracle@gtplus102 ~]$ srvctl config listener -a
Name: LISTENER
Type: Database Listener
Network: 1, Owner: grid
Home: 
  /u01/app/18.0.0.0/grid on node(s) gtplus102
End points: TCP:1521
Listener is enabled.
Listener is individually enabled on nodes: 
Listener is individually disabled on nodes: 

[oracle@gtplus102 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
Registration invited nodes: 
Registration invited subnets: 
SCAN Listener is disabled.
SCAN Listener is individually enabled on nodes: 
SCAN Listener is individually disabled on nodes: 

[oracle@gtplus102 ~]$ srvctl config listener -l ASMNET1LSNR_ASM
Name: ASMNET1LSNR_ASM
Type: ASM Listener
Owner: grid
Subnet: 192.168.16.0
Home: 
End points: TCP:1525
Listener is enabled.
Listener is individually enabled on nodes: 
Listener is individually disabled on nodes: 


[oracle@gtplus102 ~]$ lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 21-MAY-2019 06:09:08

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date                21-MAY-2019 05:57:37
Uptime                    0 days 0 hr. 11 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/18.0.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/gtplus102/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.3)(PORT=1521)))
Services Summary...
Service "+APX" has 1 instance(s).
  Instance "+APX1", status READY, has 1 handler(s) for this service...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "894ba6bc89eb7f72e0530300000ac70b.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
  Instance "GTPLUS", status READY, has 2 handler(s) for this service...
Service "GTPLUSXDB.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
  Instance "GTPLUS", status READY, has 1 handler(s) for this service...
Service "GTPLUS_icn1t9.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
  Instance "GTPLUS", status READY, has 2 handler(s) for this service...
Service "pdb1.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
  Instance "GTPLUS", status READY, has 2 handler(s) for this service...
The command completed successfully


[oracle@gtplus102 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       gtplus102                STABLE
ora.DATA.COMMONSTORE.advm
               ONLINE  ONLINE       gtplus102                STABLE
ora.DATA.dg
               ONLINE  ONLINE       gtplus102                STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       gtplus102                STABLE
ora.RECO.dg
               ONLINE  ONLINE       gtplus102                STABLE
ora.data.commonstore.acfs
               ONLINE  ONLINE       gtplus102                mounted on /opt/orac
                                                             le/dcs/commonstore,S
                                                             TABLE
ora.net1.network
               ONLINE  ONLINE       gtplus102                STABLE
ora.ons
               ONLINE  ONLINE       gtplus102                STABLE
ora.proxy_advm
               ONLINE  ONLINE       gtplus102                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       gtplus102                Started,STABLE
ora.cvu
      1        ONLINE  ONLINE       gtplus102                STABLE
ora.gtplus102.vip
      1        ONLINE  ONLINE       gtplus102                STABLE
ora.gtplus_icn1t9.db
      1        ONLINE  ONLINE       gtplus102                Open,HOME=/u01/app/o
                                                             racle/product/18.0.0
                                                             .0/dbhome_1,STABLE
ora.qosmserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        OFFLINE OFFLINE                               STABLE
--------------------------------------------------------------------------------