由于业务需求,需要进行业务地址变更,使用之前的业务地址。生产环境是rac,所以需要修改集群的scan ip。在正式生产环境操作前,提前在测试环境进行测试,整个修改测试过程如下:
本次测试是要将scan-ip:192.168.80.24 修改为:192.168.80.25
修改步骤如下:
查看scan_listener状态
[oracle@nxyddb1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node nxyddb2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node nxyddb2
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node nxyddb2
查看scan_listener配置
[oracle@nxyddb1 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
查看scan状态
[oracle@nxyddb1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node nxyddb2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node nxyddb2
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node nxyddb2
查看scan配置
[oracle@nxyddb1 ~]$ srvctl config scan
SCAN name: nxyddb-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /nxyddb-scan.us.oracle.com/192.168.80.24
SCAN VIP name: scan2, IP: /nxyddb-scan.us.oracle.com/192.168.80.22
SCAN VIP name: scan3, IP: /nxyddb-scan.us.oracle.com/192.168.80.23
停止scan_listener
[oracle@nxyddb1 ~]$ srvctl stop scan_listener
停止scan
[oracle@nxyddb1 ~]$ srvctl stop scan
确认停止后的状态
[oracle@nxyddb1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is not running
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is not running
确认停止后的状态
[oracle@nxyddb1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
SCAN VIP scan2 is enabled
SCAN VIP scan2 is not running
SCAN VIP scan3 is enabled
SCAN VIP scan3 is not running
修改和scan IP相关的文件
[root@nxyddb1 ~]# vi /var/named/192.168.80.local
[root@nxyddb1 ~]# vi /var/named/us.oracle.com.zone
重启服务
[root@nxyddb1 ~]# service named restart
Stopping named: . [ OK ]
Starting named: [ OK ]
修改scan IP
[root@nxyddb1 ~]# /u01/app/11.2.0/grid/bin/srvctl modify scan -n nxyddb-scan.us.oracle.com
查看是否修改成功
[root@nxyddb1 ~]# /u01/app/11.2.0/grid/bin/srvctl config scan
SCAN name: nxyddb-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /nxyddb-scan.us.oracle.com/192.168.80.22
SCAN VIP name: scan2, IP: /nxyddb-scan.us.oracle.com/192.168.80.23
SCAN VIP name: scan3, IP: /nxyddb-scan.us.oracle.com/192.168.80.25
确认修改成功后启动scan_listener
[oracle@nxyddb1 ~]$ srvctl start scan_listener
查看启动后scan_listener的状态
[oracle@nxyddb1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node nxyddb1
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node nxyddb2
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node nxyddb1
查看启动后scan的状态
[oracle@nxyddb1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node nxyddb1
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node nxyddb2
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node nxyddb1
查看scan修改后的配置
[oracle@nxyddb1 ~]$ srvctl config scan
SCAN name: nxyddb-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /nxyddb-scan.us.oracle.com/192.168.80.22
SCAN VIP name: scan2, IP: /nxyddb-scan.us.oracle.com/192.168.80.23
SCAN VIP name: scan3, IP: /nxyddb-scan.us.oracle.com/192.168.80.25