1、环境介绍
Oracle 11gR2 RAC 64bit
Oracle Enterprise Linux 5.7 64bit
2、/etc/hosts内容
192.168.1.201 jzh1.oracle.com jzh1
192.168.1.203 jzh2.oracle.com jzh2
10.10.10.201 jzh1-priv
10.10.10.203 jzh2-priv
192.168.1.202 jzh1-vip
192.168.1.204 jzh2-vip
192.168.1.205 jzh-cluster jzh-cluster-scan
Oracle 11gR2 RAC 64bit
Oracle Enterprise Linux 5.7 64bit
2、/etc/hosts内容
192.168.1.201 jzh1.oracle.com jzh1
192.168.1.203 jzh2.oracle.com jzh2
10.10.10.201 jzh1-priv
10.10.10.203 jzh2-priv
192.168.1.202 jzh1-vip
192.168.1.204 jzh2-vip
192.168.1.205 jzh-cluster jzh-cluster-scan
3、测试需求
将scan ip 192.168.1.205改为192.168.1.206
4、查看当前scan ip状态信息 (需以root用户执行)
[root@jzh1 bin]# ./srvctl config scan
SCAN name: jzh-cluster-scan, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /jzh-cluster-scan/192.168.1.205
5、以root用户停止scan_listener,scan ip服务
[root@jzh1 bin]# ./srvctl stop scan_listener
[root@jzh1 bin]# ./srvctl stop scan
[root@jzh1 bin]# ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
6、在所有节点/etc/hosts文件中修改新scan ip地址
192.168.1.201 jzh1.oracle.com jzh1
192.168.1.203 jzh2.oracle.com jzh2
10.10.10.201 jzh1-priv
10.10.10.203 jzh2-priv
192.168.1.202 jzh1-vip
192.168.1.204 jzh2-vip
192.168.1.206 jzh-cluster jzh-cluster-scan
7、以root用户修改scan ip
[root@jzh1 bin]# ./srvctl modify scan -n 192.168.1.206
8、修改后确认
[root@jzh1 bin]# ./srvctl config scan
SCAN name: 192.168.1.206, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.1.206/192.168.1.206
可以看到已经修改过来了。
9、 启动scan_listener,scan
[root@jzh1 bin]# ./srvctl start scan
[root@jzh1 bin]# ./srvctl start scan_listener
10、进行ping测试
[root@jzh1 bin]# ping 192.168.1.206
PING 192.168.1.206 (192.168.1.206) 56(84) bytes of data.
64 bytes from 192.168.1.206: icmp_seq=1 ttl=64 time=1.78 ms
64 bytes from 192.168.1.206: icmp_seq=2 ttl=64 time=1.23 ms
64 bytes from 192.168.1.206: icmp_seq=3 ttl=64 time=0.444 ms
64 bytes from 192.168.1.206: icmp_seq=4 ttl=64 time=0.512 ms
64 bytes from 192.168.1.206: icmp_seq=5 ttl=64 time=0.891 ms
11、确认scan,scan_listener.ora状态
[grid@jzh1 ~]$ crs_stat -t | grep scan
ora.scan1.vip ora....ip.type ONLINE ONLINE jzh2
[grid@jzh1 ~]$ crs_stat -t | grep lsnr
ora....ER.lsnr ora....er.type ONLINE ONLINE jzh1
ora....N1.lsnr ora....er.type ONLINE ONLINE jzh2
ora....H1.lsnr application ONLINE ONLINE jzh1
ora....H2.lsnr application ONLINE ONLINE jzh2
修改scan ip无需停止数据库实例,asm或crs。
将scan ip 192.168.1.205改为192.168.1.206
4、查看当前scan ip状态信息 (需以root用户执行)
[root@jzh1 bin]# ./srvctl config scan
SCAN name: jzh-cluster-scan, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /jzh-cluster-scan/192.168.1.205
5、以root用户停止scan_listener,scan ip服务
[root@jzh1 bin]# ./srvctl stop scan_listener
[root@jzh1 bin]# ./srvctl stop scan
[root@jzh1 bin]# ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
6、在所有节点/etc/hosts文件中修改新scan ip地址
192.168.1.201 jzh1.oracle.com jzh1
192.168.1.203 jzh2.oracle.com jzh2
10.10.10.201 jzh1-priv
10.10.10.203 jzh2-priv
192.168.1.202 jzh1-vip
192.168.1.204 jzh2-vip
192.168.1.206 jzh-cluster jzh-cluster-scan
7、以root用户修改scan ip
[root@jzh1 bin]# ./srvctl modify scan -n 192.168.1.206
8、修改后确认
[root@jzh1 bin]# ./srvctl config scan
SCAN name: 192.168.1.206, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.1.206/192.168.1.206
可以看到已经修改过来了。
9、 启动scan_listener,scan
[root@jzh1 bin]# ./srvctl start scan
[root@jzh1 bin]# ./srvctl start scan_listener
10、进行ping测试
[root@jzh1 bin]# ping 192.168.1.206
PING 192.168.1.206 (192.168.1.206) 56(84) bytes of data.
64 bytes from 192.168.1.206: icmp_seq=1 ttl=64 time=1.78 ms
64 bytes from 192.168.1.206: icmp_seq=2 ttl=64 time=1.23 ms
64 bytes from 192.168.1.206: icmp_seq=3 ttl=64 time=0.444 ms
64 bytes from 192.168.1.206: icmp_seq=4 ttl=64 time=0.512 ms
64 bytes from 192.168.1.206: icmp_seq=5 ttl=64 time=0.891 ms
11、确认scan,scan_listener.ora状态
[grid@jzh1 ~]$ crs_stat -t | grep scan
ora.scan1.vip ora....ip.type ONLINE ONLINE jzh2
[grid@jzh1 ~]$ crs_stat -t | grep lsnr
ora....ER.lsnr ora....er.type ONLINE ONLINE jzh1
ora....N1.lsnr ora....er.type ONLINE ONLINE jzh2
ora....H1.lsnr application ONLINE ONLINE jzh1
ora....H2.lsnr application ONLINE ONLINE jzh2
修改scan ip无需停止数据库实例,asm或crs。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10271187/viewspace-1478341/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-1478341/