[2025-05-26] RAC환경에서 스캔 리스너 포트 설정 변경 (12cR2 기준)

kyoungoh.lee 2025. 7. 11. 17:44

2025. 7. 11. 17:44

1. 테스트 환경 정보

RAC1번 : rdb01p(192.168.0.11) 서버의 PRDB1
RAC2번 : rdb02p(192.168.0.12) 서버의 PRDB2

2. 스캔 리스너 확인

[PRDB1:oracle@rdb01p][/home/oracle]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:

3. 스캔 리스너의 포트를 1521에서 1522로 변경

[+ASM1:grid@rdb01p][/home/grid]$ srvctl modify scan_listener -p 1522

[+ASM1:grid@rdb01p][/home/grid]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1522
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1522
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1522
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:

4. 클러스터 리소스 정보 확인

[+ASM2:grid@rdb02p][/home/grid]$ crsctl stat res -t
.
.
.
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rdb02p                   STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rdb01p                   STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rdb01p                   STABLE
.
.
.

5. 리스너 상태 확인

[+ASM1:grid@rdb01p][/home/grid]$ lsnrctl status LISTENER_SCAN2

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 27-MAY-2025 23:37:27

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN2
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                27-MAY-2025 23:05:30
Uptime                    0 days 0 hr. 31 min. 57 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12c/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/rdb01p/listener_scan2/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.18)(PORT=1522)))
Services Summary...
Service "ANAL" has 1 instance(s).
  Instance "PRDB2", status READY, has 1 handler(s) for this service...
Service "PRDB" has 2 instance(s).
  Instance "PRDB1", status READY, has 1 handler(s) for this service...
  Instance "PRDB2", status READY, has 1 handler(s) for this service...
Service "PRDBXDB" has 2 instance(s).
  Instance "PRDB1", status READY, has 1 handler(s) for this service...
  Instance "PRDB2", status READY, has 1 handler(s) for this service...
The command completed successfully



[+ASM1:grid@rdb01p][/home/grid]$ lsnrctl status LISTENER_SCAN3

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 27-MAY-2025 23:37:36

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN3
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                27-MAY-2025 23:05:29
Uptime                    0 days 0 hr. 32 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12c/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/rdb01p/listener_scan3/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN3)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.19)(PORT=1522)))
Services Summary...
Service "ANAL" has 1 instance(s).
  Instance "PRDB2", status READY, has 1 handler(s) for this service...
Service "PRDB" has 2 instance(s).
  Instance "PRDB1", status READY, has 1 handler(s) for this service...
  Instance "PRDB2", status READY, has 1 handler(s) for this service...
Service "PRDBXDB" has 2 instance(s).
  Instance "PRDB1", status READY, has 1 handler(s) for this service...
  Instance "PRDB2", status READY, has 1 handler(s) for this service...
The command completed successfully



[+ASM2:grid@rdb02p][/home/grid]$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 27-MAY-2025 23:38:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                27-MAY-2025 23:06:55
Uptime                    0 days 0 hr. 31 min. 46 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12c/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/rdb02p/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.17)(PORT=1522)))
Services Summary...
Service "ANAL" has 1 instance(s).
  Instance "PRDB2", status READY, has 1 handler(s) for this service...
Service "PRDB" has 2 instance(s).
  Instance "PRDB1", status READY, has 1 handler(s) for this service...
  Instance "PRDB2", status READY, has 1 handler(s) for this service...
Service "PRDBXDB" has 2 instance(s).
  Instance "PRDB1", status READY, has 1 handler(s) for this service...
  Instance "PRDB2", status READY, has 1 handler(s) for this service...

6. 리스너 설정 변경 최종 확인

[+ASM2:grid@rdb02p][/home/grid]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1522
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1522
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1522
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:


--remote_listener 파라미터의 port정보는 자동으로 바뀌는 것을 확인함 (스캔 리스너의 포트를 바꾸니 알아서 바꿔줌)
[rdb01p]<SYS@PRDB1> show parameter remote_lis

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
remote_listener                      string                             PRDB-scan:1522



[rdb02p] SYS@PRDB2> show parameter remote_lis

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
remote_listener                      string                             PRDB-scan:1522

'Oracle > RAC' 카테고리의 다른 글

[2025-05-29] Interconnect Private IP 정보 변경(네트워크 인터페이스명 변경) (12cR2) (0)	2025.07.13
[2025-05-29] RAC환경에서 ORACLE LOCAL REGISTRY(OLR) 실습 (12cR2) (0)	2025.07.13
[2025-05-25] 2 Node RAC 환경에서 drop database (12cR2) (1)	2025.07.10
[2025-05-25] 2 Node RAC 환경에서 redo log 추가 및 제거 실습 (12cR2) (3)	2025.07.09
[2025-05-25] 2 Node RAC 환경에서 Control File (컨트롤 파일) 다중화 실습 (RMAN 사용) (12cR2) (1)	2025.07.09

db-expert

[2025-05-26] RAC환경에서 스캔 리스너 포트 설정 변경 (12cR2 기준)

1. 테스트 환경 정보

2. 스캔 리스너 확인

3. 스캔 리스너의 포트를 1521에서 1522로 변경

4. 클러스터 리소스 정보 확인

5. 리스너 상태 확인

6. 리스너 설정 변경 최종 확인

'Oracle > RAC' 카테고리의 다른 글

+ Recent posts

티스토리툴바