20240221-Oracle RAC 修改SCANIP地址

说明：

版本：Oracle 11.2.0.4.0 RAC
将 scan ip 由 192.0.0.101 改成 192.0.0.100

如果修改的是VIP地址，可以参考我的另一篇文章《Oracle RAC 修改VIP地址》

https://blog.itpub.net/29785807/viewspace-2947635/

查看scan状态和配置信息

grid@cjc-db-06:/home/grid$srvctl status scan -v
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node cjc-db-06

root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node cjc-db-06

grid@cjc-db-06:/home/grid$srvctl config scan
SCAN name: cjc-scan, Network: 1/192.0.0.0/255.255.255.0/ens192
SCAN VIP name: scan1, IP: /cjc-scan/192.0.0.101

root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:15212

查看监听状态

grid@cjc-db-06:/home/grid$lsnrctl status
grid@cjc-db-06:/home/grid$lsnrctl status LISTENER_SCAN1

查看集群状态

root@cjc-db-06:/oracle/grid/product/11.2/bin#./crsctl stat res -t

停scan

root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl stop scan_listener
root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl stop scan

停止scan_listener后scan ip 自动移除

ip a

修改 /etc/hosts 记录的scan ip地址

vi /etc/hosts
# scan
# 192.0.0.101   cjc-scan
192.0.0.100   cjc-scan

修改ocr注册信息

root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl modify scan -n cjc-scan
root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl config scan
SCAN name: cjc-scan, Network: 1/192.0.0.0/255.255.255.0/ens192
SCAN VIP name: scan1, IP: /cjc-scan/192.0.0.100
root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl modify scan_listener -u

启动scan

root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl start scan_listener
---root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl start scan
root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node cjc-db-06

查看

root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node cjc-db-06

root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl config scan
SCAN name: cjc-scan, Network: 1/192.0.0.0/255.255.255.0/ens192
SCAN VIP name: scan1, IP: /cjc-scan/192.0.0.100

root@cjc-db-06:/oracle/grid/product/11.2/bin#./srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:15212

检查资源状态

root@cjc-db-06:/oracle/grid/product/11.2/bin#./crsctl stat res -t

检查监听状态

grid@cjc-db-06:/home/grid$lsnrctl status
grid@cjc-db-06:/home/grid$lsnrctl status LISTENER_SCAN1

###chenjuchao 20240221###
欢迎关注我的公众号《IT小Chen》