原hosts
19.16.10.55 rac1
19.16.10.56 rac2
19.16.10.57 rac1-vip
19.16.10.58 rac2-vip
19.16.12.20 rac1-priv
19.16.12.206 rac2-priv
19.16.10.59 scan
修改为
19.16.10.45 rac1
19.16.10.46 rac2
19.16.10.47 rac1-vip
19.16.10.48 rac2-vip
19.16.12.20 rac1-priv
19.16.12.206 rac2-priv
19.16.10.49 scan
一、停止crs及相关资源
1 禁止所有节点自动启动并关闭两边节点数据库、监听
[grid@rac1~]srvctl disable listener
[grid@rac1~]srvctl stop listener //关监听
[grid@rac1~]srvctl disable database -d hyw //hyw是数据库名
[grid@rac1~]srvctl stop database -d hyw -o immediate //关数据库
2 禁止所有节点自动启动并停止VIP(名字要对应hosts)
[root@rac1~]/u01/app/11.2.0/grid/bin/srvctl disable vip -i "rac1-vip"
[root@rac1~]/u01/app/11.2.0/grid/bin/srvctl disable vip -i "rac2-vip"
[grid@rac1~]$ srvctl stop vip -n rac1
[grid@rac1~]$ srvctl stop vip -n rac2
3 禁止所有节点的SCAN_LISTENER的启动,停止所有节点的SCAN_LISTENER
[grid@rac1~]$ srvctl disable scan_listener
[grid@rac1~]$ srvctl stop scan_listener
4 禁止所有节点的SCAN的启动,停止所有节点的SCAN
[root@rac1 ~]#/u01/app/11.2.0/grid/bin/srvctl disable scan
[grid@rac1~]$ srvctl stop scan
5 停止crs //两个节点都要执行
[root@rac1 ~]#/u01/app/11.2.0/grid/bin/crsctl stop crs
[root@rac2 ~]#/u01/app/11.2.0/grid/bin/crsctl stop crs
二、修改publicip, vip,scan ip
1 修改两边的/etc/hosts文件
#修改前最好做个备份
修改后如下
19.16.10.45 rac1
19.16.10.46 rac2
19.16.10.47 rac1-vip
19.16.10.48 rac2-vip
19.16.12.20 rac1-priv
19.16.12.206 rac2-priv
19.16.10.49 scan
2 修改rac1及rac2网卡配置
(1)rac1:vi /etc/sysconfig/network-scripts/ifcfg-eth0
修改ip为19.16.10.45掩码255.255.255.0
service network restart//重启网卡
(2)rac2:vi/etc/sysconfig/network-scripts/ifcfg-eth0
修改ip为19.16.10.46掩码 255.255.255.0
service network restart//重启网卡
3 两边节点启动crs
[root@rac1 ~]#/u01/app/11.2.0/grid/bin/crsctl start crs
[root@rac2 ~]#/u01/app/11.2.0/grid/bin/crsctl start crs
4 集群的public IP 设置(如果属于同一网段,可不修改)----###此步骤未测试
start crs后,请稍等一会儿再执行
[root@rac1bin]# ./oifcfg getif //查看下集群的VIP
eth0 19.16.0.0 global public
eth1 5.1.1.0 global cluster_interconnect
[root@rac1bin]# ./oifcfg delif -global eth0
[root@rac1bin]# ./oifcfg setif -global eth0/19.16.5.0:public
[root@rac1/2bin]# ./oifcfg getif //两边查看下集群的VIP
这里是举例子,像我这次修改没有更改字段。所以我没有操作这一步。
如果需要修改private ip 则需要先用
[root@rac1bin]# ./oifcfg delif -global eth1
[root@rac1bin]#./oifcfg setif -global eth1/x.x.x.0:cluster_interconnect(注意,我前面修改网卡可没有修改private,private是要在这步先修改后,才可以修改的)
5 集群的VIP设置
[root@rac1bin]#./srvctl config vip -n rac1 //先查看集群的VIP
VIPexists.:rac01
VIP exists.:/rac01-vip/19.16.10.45/255.255.255.0/eth0
[root@rac1 bin]# ./srvctl modify nodeapps -A 19.16.10.45/255.255.255.0/eth0 -n rac1 -----#修改VIP资源必须使用srvctl工具手动更新OCR中的VIP配置。如果客户端使用VIP连接数据库,那么还需要修改客户端hosts文件等相关的VIP配置。
[root@rac1 bin]# ./srvctl modify nodeapps -A 19.16.10.46/255.255.255.0/eth0 -n rac2
[root@rac1/2bin]#./srvctl config vip -n rac1 //两边检查集群的VIP
6 集群的SCANIP设置
[root@rac1bin]# ./srvctl config scan //先查看集群的SCAN IP
SCAN name:rac-scan, Network: 1/19.16.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /19.16.10.59/19.16.0.145
[root@rac1 bin]# ./srvctl modify scan -n 19.16.10.49
6.1如果需要修改private ------#此步骤未测试
(1)rac1:vi /etc/sysconfig/network-scripts/ifcfg-eth0
修改ip为15.1.1.1掩码255.255.255.0
service network restart//重启网卡
(2)rac2:vi/etc/sysconfig/network-scripts/ifcfg-eth0
修改ip为15.1.1.2掩码 255.255.255.0
service network restart//重启网卡
7 启动VIP、监听、scan和scan_listener、数据库
[root@rac1 bin]#./srvctl enable listener
[root@rac1 bin]#./srvctl enable vip -i "rac1-vip"
[root@rac1 bin]#./srvctl enable vip -i "rac2-vip"
[root@rac1 bin]#./srvctl enable scan_listener
[root@rac1 bin]#./srvctl enable scan
[root@rac1 bin]#./srvctl enable database -d hyw
[root@rac1 bin]#./srvctl start listener
[root@rac1 bin]#./srvctl start vip -n rac1
[root@rac1 bin]#./srvctl start vip -n rac2
[root@rac1 bin]#./srvctl start scan_listener
[root@rac1 bin]#./srvctl start scan
[root@rac1 bin]#./srvctl start database -d hyw
修改tnsname
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 19.16.10.48)(PORT = 1521))' sid='hyw2' ;
System altered.
8 检查VIP资源状态
[root@rac1 bin]# ./srvctl status nodeapps
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
GSD is disabled
GSD is not running on node: rac1
GSD is not running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2
19.16.10.55 rac1
19.16.10.56 rac2
19.16.10.57 rac1-vip
19.16.10.58 rac2-vip
19.16.12.20 rac1-priv
19.16.12.206 rac2-priv
19.16.10.59 scan
修改为
19.16.10.45 rac1
19.16.10.46 rac2
19.16.10.47 rac1-vip
19.16.10.48 rac2-vip
19.16.12.20 rac1-priv
19.16.12.206 rac2-priv
19.16.10.49 scan
一、停止crs及相关资源
1 禁止所有节点自动启动并关闭两边节点数据库、监听
[grid@rac1~]srvctl disable listener
[grid@rac1~]srvctl stop listener //关监听
[grid@rac1~]srvctl disable database -d hyw //hyw是数据库名
[grid@rac1~]srvctl stop database -d hyw -o immediate //关数据库
2 禁止所有节点自动启动并停止VIP(名字要对应hosts)
[root@rac1~]/u01/app/11.2.0/grid/bin/srvctl disable vip -i "rac1-vip"
[root@rac1~]/u01/app/11.2.0/grid/bin/srvctl disable vip -i "rac2-vip"
[grid@rac1~]$ srvctl stop vip -n rac1
[grid@rac1~]$ srvctl stop vip -n rac2
3 禁止所有节点的SCAN_LISTENER的启动,停止所有节点的SCAN_LISTENER
[grid@rac1~]$ srvctl disable scan_listener
[grid@rac1~]$ srvctl stop scan_listener
4 禁止所有节点的SCAN的启动,停止所有节点的SCAN
[root@rac1 ~]#/u01/app/11.2.0/grid/bin/srvctl disable scan
[grid@rac1~]$ srvctl stop scan
5 停止crs //两个节点都要执行
[root@rac1 ~]#/u01/app/11.2.0/grid/bin/crsctl stop crs
[root@rac2 ~]#/u01/app/11.2.0/grid/bin/crsctl stop crs
二、修改publicip, vip,scan ip
1 修改两边的/etc/hosts文件
#修改前最好做个备份
修改后如下
19.16.10.45 rac1
19.16.10.46 rac2
19.16.10.47 rac1-vip
19.16.10.48 rac2-vip
19.16.12.20 rac1-priv
19.16.12.206 rac2-priv
19.16.10.49 scan
2 修改rac1及rac2网卡配置
(1)rac1:vi /etc/sysconfig/network-scripts/ifcfg-eth0
修改ip为19.16.10.45掩码255.255.255.0
service network restart//重启网卡
(2)rac2:vi/etc/sysconfig/network-scripts/ifcfg-eth0
修改ip为19.16.10.46掩码 255.255.255.0
service network restart//重启网卡
3 两边节点启动crs
[root@rac1 ~]#/u01/app/11.2.0/grid/bin/crsctl start crs
[root@rac2 ~]#/u01/app/11.2.0/grid/bin/crsctl start crs
4 集群的public IP 设置(如果属于同一网段,可不修改)----###此步骤未测试
start crs后,请稍等一会儿再执行
[root@rac1bin]# ./oifcfg getif //查看下集群的VIP
eth0 19.16.0.0 global public
eth1 5.1.1.0 global cluster_interconnect
[root@rac1bin]# ./oifcfg delif -global eth0
[root@rac1bin]# ./oifcfg setif -global eth0/19.16.5.0:public
[root@rac1/2bin]# ./oifcfg getif //两边查看下集群的VIP
这里是举例子,像我这次修改没有更改字段。所以我没有操作这一步。
如果需要修改private ip 则需要先用
[root@rac1bin]# ./oifcfg delif -global eth1
[root@rac1bin]#./oifcfg setif -global eth1/x.x.x.0:cluster_interconnect(注意,我前面修改网卡可没有修改private,private是要在这步先修改后,才可以修改的)
5 集群的VIP设置
[root@rac1bin]#./srvctl config vip -n rac1 //先查看集群的VIP
VIPexists.:rac01
VIP exists.:/rac01-vip/19.16.10.45/255.255.255.0/eth0
[root@rac1 bin]# ./srvctl modify nodeapps -A 19.16.10.45/255.255.255.0/eth0 -n rac1 -----#修改VIP资源必须使用srvctl工具手动更新OCR中的VIP配置。如果客户端使用VIP连接数据库,那么还需要修改客户端hosts文件等相关的VIP配置。
[root@rac1 bin]# ./srvctl modify nodeapps -A 19.16.10.46/255.255.255.0/eth0 -n rac2
[root@rac1/2bin]#./srvctl config vip -n rac1 //两边检查集群的VIP
6 集群的SCANIP设置
[root@rac1bin]# ./srvctl config scan //先查看集群的SCAN IP
SCAN name:rac-scan, Network: 1/19.16.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /19.16.10.59/19.16.0.145
[root@rac1 bin]# ./srvctl modify scan -n 19.16.10.49
6.1如果需要修改private ------#此步骤未测试
(1)rac1:vi /etc/sysconfig/network-scripts/ifcfg-eth0
修改ip为15.1.1.1掩码255.255.255.0
service network restart//重启网卡
(2)rac2:vi/etc/sysconfig/network-scripts/ifcfg-eth0
修改ip为15.1.1.2掩码 255.255.255.0
service network restart//重启网卡
7 启动VIP、监听、scan和scan_listener、数据库
[root@rac1 bin]#./srvctl enable listener
[root@rac1 bin]#./srvctl enable vip -i "rac1-vip"
[root@rac1 bin]#./srvctl enable vip -i "rac2-vip"
[root@rac1 bin]#./srvctl enable scan_listener
[root@rac1 bin]#./srvctl enable scan
[root@rac1 bin]#./srvctl enable database -d hyw
[root@rac1 bin]#./srvctl start listener
[root@rac1 bin]#./srvctl start vip -n rac1
[root@rac1 bin]#./srvctl start vip -n rac2
[root@rac1 bin]#./srvctl start scan_listener
[root@rac1 bin]#./srvctl start scan
[root@rac1 bin]#./srvctl start database -d hyw
修改tnsname
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 19.16.10.48)(PORT = 1521))' sid='hyw2' ;
System altered.
8 检查VIP资源状态
[root@rac1 bin]# ./srvctl status nodeapps
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
GSD is disabled
GSD is not running on node: rac1
GSD is not running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2