Oracle 11.2.0.4 RAC修改SCAN IP

      本实验是在Redhat 6.5 && Oracle 11.2.0.4 RAC 环境下做的,生产中有时会需要修改RAC的scan-ip,

往往一些Oracle 学习爱好者或者相关管理人员在进行修改时遇到各类问题,这里我将自己的实验过程展示

出来,希望能给更多Oracle 学习爱好者一些帮助。

    本次实验是要将scan-ip:192.168.80.24 修改为:192.168.80.25

修改步骤如下: 
查看scan_listener状态 
[oracle@vastdata1 ~]$ srvctl status scan_listener 
SCAN Listener LISTENER_SCAN1 is enabled 
SCAN listener LISTENER_SCAN1 is running on node vastdata2 
SCAN Listener LISTENER_SCAN2 is enabled 
SCAN listener LISTENER_SCAN2 is running on node vastdata2 
SCAN Listener LISTENER_SCAN3 is enabled 
SCAN listener LISTENER_SCAN3 is running on node vastdata2

查看scan_listener配置 
[oracle@vastdata1 ~]$ 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@vastdata1 ~]$ srvctl status scan 
SCAN VIP scan1 is enabled 
SCAN VIP scan1 is running on node vastdata2 
SCAN VIP scan2 is enabled 
SCAN VIP scan2 is running on node vastdata2 
SCAN VIP scan3 is enabled 
SCAN VIP scan3 is running on node vastdata2

查看scan配置 
[oracle@vastdata1 ~]$ srvctl config scan 
SCAN name: vastdata-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0 
SCAN VIP name: scan1, IP: /vastdata-scan.us.oracle.com/192.168.80.24 
SCAN VIP name: scan2, IP: /vastdata-scan.us.oracle.com/192.168.80.22 
SCAN VIP name: scan3, IP: /vastdata-scan.us.oracle.com/192.168.80.23

停止scan_listener 
[oracle@vastdata1 ~]$ srvctl stop scan_listener

停止scan 
[oracle@vastdata1 ~]$ srvctl stop scan

确认停止后的状态 
[oracle@vastdata1 ~]$ 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@vastdata1 ~]$ 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@vastdata1 ~]# vi /var/named/192.168.80.local 
[root@vastdata1 ~]# vi /var/named/us.oracle.com.zone

重启服务 
[root@vastdata1 ~]# service named restart 
Stopping named: . [ OK ] 
Starting named: [ OK ]

修改scan IP 
[root@vastdata1 ~]# /u01/app/11.2.0/grid/bin/srvctl modify scan -n vastdata-scan.us.oracle.com

查看是否修改成功 
[root@vastdata1 ~]# /u01/app/11.2.0/grid/bin/srvctl config scan 
SCAN name: vastdata-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0 
SCAN VIP name: scan1, IP: /vastdata-scan.us.oracle.com/192.168.80.22 
SCAN VIP name: scan2, IP: /vastdata-scan.us.oracle.com/192.168.80.23 
SCAN VIP name: scan3, IP: /vastdata-scan.us.oracle.com/192.168.80.25

确认修改成功后启动scan_listener 
[oracle@vastdata1 ~]$ srvctl start scan_listener

查看启动后scan_listener的状态 
[oracle@vastdata1 ~]$ srvctl status scan_listener 
SCAN Listener LISTENER_SCAN1 is enabled 
SCAN listener LISTENER_SCAN1 is running on node vastdata1 
SCAN Listener LISTENER_SCAN2 is enabled 
SCAN listener LISTENER_SCAN2 is running on node vastdata2 
SCAN Listener LISTENER_SCAN3 is enabled 
SCAN listener LISTENER_SCAN3 is running on node vastdata1

查看启动后scan的状态 
[oracle@vastdata1 ~]$ srvctl status scan 
SCAN VIP scan1 is enabled 
SCAN VIP scan1 is running on node vastdata1 
SCAN VIP scan2 is enabled 
SCAN VIP scan2 is running on node vastdata2 
SCAN VIP scan3 is enabled 
SCAN VIP scan3 is running on node vastdata1

查看scan修改后的配置 
[oracle@vastdata1 ~]$ srvctl config scan 
SCAN name: vastdata-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0 
SCAN VIP name: scan1, IP: /vastdata-scan.us.oracle.com/192.168.80.22 
SCAN VIP name: scan2, IP: /vastdata-scan.us.oracle.com/192.168.80.23 
SCAN VIP name: scan3, IP: /vastdata-scan.us.oracle.com/192.168.80.25

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值