基于不同网段的RAC架构VIP修改

--确认集群当前状态 crsctl check crs crs_stat -t

--关闭集群当前服务 srvctl stop database -d raw srvctl stop asm -n s1-11g srvctl stop asm -n s2-11g srvctl stop nodeapps -n s1-11g srvctl stop nodeapps -n s2-11g

--查看当前配置： [grids1-11g oracle]# oifcfg getif -global eth0 192.168.72.0 global public eth1 10.0.0.0 global cluster_interconnect

--删除当前配置 [grids1-11g oracle]# oifcfg delif -global eth0 [grids1-11g oracle]# oifcfg delif -global eth1 [grids1-11g oracle]# oifcfg getif

--重新添加 [grids1-11g oracle]# oifcfg setif -global eth0/192.168.200.0:public [grids1-11g oracle]# oifcfg setif -global eth1/11.11.11.0:cluster_interconnect [grids1-11g oracle]# oifcfg getif eth0 192.168.200.0 global public eth1 11.0.0.0 global cluster_interconnect

[grids1-11g oracle]# oifcfg iflist eth0 192.168.200.0 eth1 11.0.0.0

--启动集群当前服务 srvctl start database -d raw srvctl start asm -n s1-11g srvctl start asm -n s2-11g srvctl start nodeapps -n s1-11g srvctl start nodeapps -n s2-11g

--关闭相关集群服务 [grids1-11g ~]$srvctl stop scan [grids1-11g ~]$ srvctl stop scan_listener [grids1-11g ~]$srvctl stop vip -i s1-11g-vip [grids1-11g ~]$ srvctl stop vip -i s2-11g-vip [grids1-11g ~]$ srvctl stop listener

--在两节点/etc/hosts下修改scan IP vi /etc/hosts 192.168.200.90 scan 192.168.200.93 s1-11g-vip 192.168.200.94 s2-11g-vip 192.168.200.70 scan 192.168.200.73 s1-11g-vip 192.168.200.74 s2-11g-vip

[grids1-11g ~]$which srvctl /oracle/grid/crs_1/bin/srvctl [grids1-11g ~]$ exit logout [roots1-11g ~]# /oracle/griwww.pizei.comd/crs_1/bin/srvctl modify scan -n scan [roots1-11g ~]# /oracle/grid/crs_1/bin/srvctl modify nodeapps -n s1-11g -A 192.168.200.73/255.255.255.0/eth0 [roots1-11g ~]# /oracle/grid/crs_1/bin/srvctl modify nodeapps -n s2-11g -A 192.168.200.74/255.255.255.0/eth0如果相对electron有更多直观理解的, 也可以参考其格式如下:

页游：www.pizei.com

[grids1-11g ~]$srvctl start scan [grids1-11g ~]$ srvctl start vip -i s1-11g [grids1-11g ~]$srvctl start vip -i s2-11g [grids1-11g ~]$ srvctl start listener [grids1-11g ~]$ srvctl start scan_listener

--手动设置local_listener参数 alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.73)(PORT=1521))' scope=both sid='hzmc1'; alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.74)(PORT=1521))' scope=both sid='hzmc2';

--手动设置remote_listener页游参数 alter system set remote_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.70)(PORT=1521)))' scope=both sid='*';

--在两节点上测试用scan IP来进行数据库连接 sqlplus system/oracle192.168.200.70:1521/hzmc

--在两节点上测试用VIP来进行数据库连接 sqlplus system/oracle192.168.200.73:1521/hzmc sqlplus system/oracle192.168.200.74:1521/hzmc