Chinaunix首页 | 论坛 | 博客
  • 博客访问: 641341
  • 博文数量: 70
  • 博客积分: 145
  • 博客等级: 入伍新兵
  • 技术积分: 1150
  • 用 户 组: 普通用户
  • 注册时间: 2012-10-11 08:15
个人简介

没有简介就是最好的简介

文章分类

全部博文(70)

文章存档

2020年(1)

2018年(2)

2017年(3)

2016年(11)

2015年(12)

2014年(16)

2013年(19)

2012年(6)

我的朋友

分类: Oracle

2018-05-09 09:33:00

目标:
修改数据库一个节点的vip
初始信息如下:
hostname:ggjjzhzzdb02
vip:192.168.19.10/255.255.255.0
修改后vip信息如下:
vip:192.168.19.12/255/255.255.0

1,操作系统版本信息
[root@ggjjzhzzdb01 ~]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 7.2 (Maipo)
2,查看/etc/hosts信息
[grid@ggjjzhzzdb02 ~]$ cat /etc/hosts
127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4
::1        localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.19.7 ggjjzhzzdb01
192.168.19.9 ggjjzhzzdb02


192.168.19.6 ggjjzhzzdb01-vip
192.168.19.10 ggjjzhzzdb02-vip

192.168.1.19  ggjjzhzzdb01-pri
192.168.1.20  ggjjzhzzdb02-pri

192.168.19.11 ggjjzhzzdb-scan
3,使用grid用户查看现在vip配置情况
[grid@ggjjzhzzdb02 ~]$ srvctl config nodeapps  -a
Network exists: 1/192.168.19.0/255.255.255.0/bond0, type static
VIP exists: /ggjjzhzzdb01-vip/192.168.19.6/192.168.19.0/255.255.255.0/bond0, hosting node ggjjzhzzdb01
VIP exists: /ggjjzhzzdb02-vip/192.168.19.10/192.168.19.0/255.255.255.0/bond0, hosting node ggjjzhzzdb02
4,查看vip状态
[grid@ggjjzhzzdb02 ~]$ crs_stat -t | grep vip
ora....b01.vip ora....t1.type ONLINE    ONLINE    ggjj...db01
ora....b02.vip ora....t1.type ONLINE    ONLINE    ggjj...db02
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    ggjj...db01
使用crsctl stat res -t 显示vips的状态为Online
使用ifconfig -a 查看vip逻辑网卡对应物理网卡
[grid@ggjjzhzzdb02 ~]$ ifconfig -a
bond0: flags=5187  mtu 1500
        inet 192.168.19.9  netmask 255.255.255.240  broadcast 192.168.19.15
        inet6 fe80::84b1:7bff:feac:2d83  prefixlen 64  scopeid 0x20
        ether 6c:92:bf:4c:73:35  txqueuelen 0  (Ethernet)
        RX packets 211416  bytes 51979457 (49.5 MiB)
        RX errors 0  dropped 81256  overruns 0  frame 0
        TX packets 24056  bytes 2539918 (2.4 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

bond0:1: flags=5187  mtu 1500
        inet 192.168.19.10  netmask 255.255.255.240  broadcast 192.168.19.15
        ether 6c:92:bf:4c:73:35  txqueuelen 0  (Ethernet)

bond1: flags=5187  mtu 1500
        inet 192.168.1.20  netmask 255.255.255.0  broadcast 192.168.1.255
        inet6 fe80::a236:9fff:fedc:5c48  prefixlen 64  scopeid 0x20
        ether a0:36:9f:dc:5c:48  txqueuelen 0  (Ethernet)
        RX packets 3267408  bytes 2183229107 (2.0 GiB)
        RX errors 0  dropped 92935  overruns 4298  frame 0
        TX packets 3682761  bytes 3085923418 (2.8 GiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
开始修改
1,停止nodeapps资源
[grid@ggjjzhzzdb02 ~]$ srvctl stop instance -d ggjjzhzzdb -n ggjjzhzzdb02
[grid@ggjjzhzzdb02 ~]$ srvctl stop vip -n ggjjzhzzdb02 -f
2,验证VIP状态处于OFFLINE状态,并且不再绑定到公共网卡
[grid@ggjjzhzzdb02 ~]$ ifconfig -a
bond0: flags=5187  mtu 1500
        inet 192.168.19.9  netmask 255.255.255.240  broadcast 192.168.19.15
        inet6 fe80::84b1:7bff:feac:2d83  prefixlen 64  scopeid 0x20
        ether 6c:92:bf:4c:73:35  txqueuelen 0  (Ethernet)
        RX packets 212850  bytes 52187517 (49.7 MiB)
        RX errors 0  dropped 81810  overruns 0  frame 0
        TX packets 24301  bytes 2575291 (2.4 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

bond1: flags=5187  mtu 1500
        inet 192.168.1.20  netmask 255.255.255.0  broadcast 192.168.1.255
        inet6 fe80::a236:9fff:fedc:5c48  prefixlen 64  scopeid 0x20
        ether a0:36:9f:dc:5c:48  txqueuelen 0  (Ethernet)
        RX packets 3285480  bytes 2195451678 (2.0 GiB)
        RX errors 0  dropped 93557  overruns 4298  frame 0
        TX packets 3704086  bytes 3104892925 (2.8 GiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
3,修改/etc/hosts相关信息
[root@ggjjzhzzdb02 ~]# vi /etc/hosts
127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4
::1        localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.19.7 ggjjzhzzdb01
192.168.19.9 ggjjzhzzdb02


192.168.19.6 ggjjzhzzdb01-vip
192.168.19.12 ggjjzhzzdb02-vip

192.168.1.19  ggjjzhzzdb01-pri
192.168.1.20  ggjjzhzzdb02-pri

192.168.19.11 ggjjzhzzdb-scan
4,用户root用户修改vip
srvctl modify nodeapps -n ggjjzhzzdb02 -A ggjjzhzzdb02-vip/255.255.255.0/bond0
验证修改成功
[grid@ggjjzhzzdb02 ~]$ srvctl config nodeapps -a
Network exists: 1/192.168.19.0/255.255.255.0/bond0, type static
VIP exists: /ggjjzhzzdb01-vip/192.168.19.6/192.168.19.0/255.255.255.0/bond0, hosting node ggjjzhzzdb01
VIP exists: /ggjjzhzzdb02-vip/192.168.19.12/192.168.19.0/255.255.255.0/bond0, hosting node ggjjzhzzdb02
启动nodeapp及其他状态
[grid@ggjjzhzzdb02 ~]$ srvctl start vip -n ggjjzhzzdb02
[grid@ggjjzhzzdb02 ~]$ srvctl start listener -n ggjjzhzzdb02
[grid@ggjjzhzzdb02 ~]$ srvctl start instance -d ggjjzhzzdb -i ggjjzhzz2
验证VIP状态为ONLINE并且已经绑定到集群公共网卡
 crsctl stat res -t
[grid@ggjjzhzzdb02 ~]$ ifconfig -a
bond0: flags=5187  mtu 1500
        inet 192.168.19.9  netmask 255.255.255.240  broadcast 192.168.19.15
        inet6 fe80::84b1:7bff:feac:2d83  prefixlen 64  scopeid 0x20
        ether 6c:92:bf:4c:73:35  txqueuelen 0  (Ethernet)
        RX packets 215380  bytes 52532880 (50.0 MiB)
        RX errors 0  dropped 82599  overruns 0  frame 0
        TX packets 25107  bytes 2689898 (2.5 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

bond0:1: flags=5187  mtu 1500
        inet 192.168.19.12  netmask 255.255.255.240  broadcast 192.168.19.15
        ether 6c:92:bf:4c:73:35  txqueuelen 0  (Ethernet)
如果集群其他节点也需要修改,按照上面步骤进行修改。

备注:
查看instance name 及 node name
SQL> select instance_name,HOST_NAME from gv$instance;     

INSTANCE_NAME    HOST_NAME
---------------- ----------------------------------------------------------------
ggjjzhzz2        ggjjzhzzdb02
ggjjzhzz1        ggjjzhzzdb01
阅读(3883) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~