반응형
[사전확인사항]
Database의 Init Parameter 중 remote_listener 파리미터 확인
-만약 remote_listener 파라미터에 IP로 되어 있는 경우 SCAN 재기동 전에 tnsnames.ora 파일에 수정 해야 한다.
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string rac-scan:1521
SQL>
[Oracle SCAN IP 변경 전 상태 확인]
[oracle@rac2 ~]$ srvctl config scan
SCAN name: rac-scan, Network: 1
Subnet IPv4: 192.168.56.0/255.255.255.0/enp0s8, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.168.56.110
SCAN VIP is enabled.
[oracle@rac2 ~]$
[oracle@rac2 ~]$ lsnrctl status LISTENER_SCAN1
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-SEP-2021 15:06:46
Copyright (c) 1991, 2021, 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 19.0.0.0.0 - Production
Start Date 27-SEP-2021 14:51:19
Uptime 0 days 0 hr. 15 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/rac2/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.110)(PORT=1521)))
Services Summary...
Service "TST" has 2 instance(s).
Instance "TST1", status READY, has 1 handler(s) for this service...
Instance "TST2", status READY, has 1 handler(s) for this service...
Service "TSTXDB" has 2 instance(s).
Instance "TST1", status READY, has 1 handler(s) for this service...
Instance "TST2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac2 ~]$[Oracle SCAN IP 변경]
[oracle@rac2 ~]$ srvctl stop scan_listener
[oracle@rac2 ~]$ srvctl stop scan
--모든 Node에 /etc/hosts 파일에 sacn ip 부분을 변경
[root@rac2 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@rac2 bin]# ./srvctl modify scan -n rac-scan
[root@rac2 bin]# ./srvctl config scan
SCAN name: rac-scan, Network: 1
Subnet IPv4: 192.168.56.0/255.255.255.0/enp0s8, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.168.56.115
SCAN VIP is enabled.
[root@rac2 bin]#[변경된 SCAN IP로 SCAN 기동 및 상태 확인]
[oracle@rac2 ~]$ srvctl start scan
[oracle@rac2 ~]$ srvctl start scan_listener
[oracle@rac2 ~]$ crsctl status res ora.scan1.vip -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
[oracle@rac2 ~]$
[oracle@rac1 ~]$ lsnrctl status LISTENER_SCAN1
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-SEP-2021 15:19:03
Copyright (c) 1991, 2021, 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 19.0.0.0.0 - Production
Start Date 27-SEP-2021 15:17:25
Uptime 0 days 0 hr. 1 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/rac1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.115)(PORT=1521)))
Services Summary...
Service "TST" has 2 instance(s).
Instance "TST1", status READY, has 1 handler(s) for this service...
Instance "TST2", status READY, has 1 handler(s) for this service...
Service "TSTXDB" has 2 instance(s).
Instance "TST1", status READY, has 1 handler(s) for this service...
Instance "TST2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac1 ~]$How to Update the IP Address of the SCAN VIP Resources (ora.scan{n}.vip) (문서 ID 952903.1)
반응형