子网掩码变更集群资源异常修复

由于业务网络环境变更，需要修改Oracle RAC IP的子网掩码，同时修改集群network资源属性。

数据库版本：Oracle Database 11.2.0.4

1.查看集群资源情况

grid@db1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       db1                                       
               ONLINE  ONLINE       db2                                       
ora.LISTENER.lsnr
               ONLINE  OFFLINE      db1                                       
               ONLINE  OFFLINE      db2                                       
ora.asm
               ONLINE  ONLINE       db1                   Started             
               ONLINE  ONLINE       db2                   Started             
ora.gsd
               OFFLINE OFFLINE      db1                                       
               OFFLINE OFFLINE      db2                                       
ora.net1.network
               ONLINE  OFFLINE      db1                                       
               ONLINE  OFFLINE      db2                                       
ora.ons
               ONLINE  OFFLINE      db1                                       
               ONLINE  OFFLINE      db2                                       
ora.registry.acfs
               ONLINE  ONLINE       db1                                       
               ONLINE  ONLINE       db2                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  OFFLINE                                                   
ora.cvu
      1        ONLINE  OFFLINE                                                   
ora.db.db
      1        ONLINE  ONLINE       db1                   Open                
      2        ONLINE  ONLINE       db2                   Open                
ora.db1.vip
      1        ONLINE  OFFLINE                                                   
ora.db2.vip
      1        ONLINE  OFFLINE                                                   
ora.oc4j
      1        ONLINE  ONLINE       db2                                       
ora.scan1.vip
      1        ONLINE  OFFLINE                                               

network、listener、vip资源offline状态，需要修改network属性

2.修改network属性

查看network注册属性

grid@db1:~> srvctl config network
Network exists: 1/xxx.xxx.52.0/255.255.255.192/bond0, type static

查看主机ip信息

db2:~ # ifconfig
bond0     Link encap:Ethernet  HWaddr 6C:92:BF:4B:41:CC  
          inet addr:xxx.xxx.52.57  Bcast:xxx.xxx.52.63  Mask:255.255.255.224
          inet6 addr: fe80::6e92:bfff:fe4b:41cc/64 Scope:Link
          UP BROADCAST RUNNING MASTER MULTICAST  MTU:1500  Metric:1
          RX packets:286330 errors:0 dropped:148727 overruns:0 frame:0
          TX packets:22254 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:17646617 (16.8 Mb)  TX bytes:1722898 (1.6 Mb)

查看iflist信息

grid@db1:~> oifcfg iflist
bond0  xxx.xxx.52.32  --更改后224的掩码,产生新的网段

修改network属性

db1:/opt/oracrs/grid/11.2.0/grid/bin # ./srvctl modify network -k 1 -S xxx.xxx.52.32/255.255.255.224/bond0 -w static -v
Successfully modified Network.

-k 现有注册网络的编号为1,默认就是1,需要查询srvctl config network
如果有多个public网络，也可以指定这个编号

3.集群服务资源恢复

随后启动network、vip和listener即可

db1:/opt/oracrs/grid/11.2.0/grid/bin # ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       db1                                       
               ONLINE  ONLINE       db2                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       db1                                       
               ONLINE  ONLINE       db2                                       
ora.asm
               ONLINE  ONLINE       db1                   Started             
               ONLINE  ONLINE       db2                   Started