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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值