说明:
版本: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》