虚拟IP ora.hisdb2.vip状态为INTERMEDIATE、FAILED OVER

系统：oel 7.9

数据库：oracle 19.12

环境：rac (双节点)

问题描述：查看集群状态时，发现节点2的ora.hisdb2.vip状态为“INTERMEDIATE”、“FAILED OVER”，如下所示：

[grid@hisdb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       hisdb1                   STABLE
               ONLINE  OFFLINE      hisdb2                   STABLE
ora.chad
               ONLINE  ONLINE       hisdb1                   STABLE
               ONLINE  ONLINE       hisdb2                   STABLE
ora.net1.network
               ONLINE  ONLINE       hisdb1                   STABLE
               ONLINE  ONLINE       hisdb2                   STABLE
ora.ons
               ONLINE  ONLINE       hisdb1                   STABLE
               ONLINE  ONLINE       hisdb2                   STABLE
ora.proxy_advm
               OFFLINE OFFLINE      hisdb1                   STABLE
               OFFLINE OFFLINE      hisdb2                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   STABLE
      2        ONLINE  ONLINE       hisdb2                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   STABLE
      2        ONLINE  ONLINE       hisdb2                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       hisdb1                   STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   STABLE
      2        ONLINE  ONLINE       hisdb2                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   Started,STABLE
      2        ONLINE  ONLINE       hisdb2                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   STABLE
      2        ONLINE  ONLINE       hisdb2                   STABLE
ora.cvu
      1        ONLINE  ONLINE       hisdb2                   STABLE
ora.heal.db
      1        ONLINE  ONLINE       hisdb1                   Open,HOME=/u01/app/o
                                                             racle/product/19.12.
                                                             0/db,STABLE
      2        ONLINE  ONLINE       hisdb2                   Open,HOME=/u01/app/o
                                                             racle/product/19.12.
                                                             0/db,STABLE
ora.hisdb1.vip
      1        ONLINE  ONLINE       hisdb1                   STABLE
ora.hisdb2.vip
      1        ONLINE  INTERMEDIATE hisdb1                   FAILED OVER,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       hisdb2                   STABLE
      1        ONLINE  ONLINE       hisdb1                   STABLE
--------------------------------------------------------------------------------

异常原因：两个节点同时启动，造成VIP资源抢夺导致.

解决方案：重启集群监听.

解决过程：

[grid@hisdb1 ~]$ srvctl stop listener -l LISTENER
[grid@hisdb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               OFFLINE OFFLINE      hisdb1                   STABLE
               OFFLINE OFFLINE      hisdb2                   STABLE
……

[grid@hisdb1 ~]$ srvctl start listener -l LISTENER
[grid@hisdb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       hisdb1                   STABLE
               ONLINE  ONLINE       hisdb2                   STABLE
ora.chad
               ONLINE  ONLINE       hisdb1                   STABLE
               ONLINE  ONLINE       hisdb2                   STABLE
ora.net1.network
               ONLINE  ONLINE       hisdb1                   STABLE
               ONLINE  ONLINE       hisdb2                   STABLE
ora.ons
               ONLINE  ONLINE       hisdb1                   STABLE
               ONLINE  ONLINE       hisdb2                   STABLE
ora.proxy_advm
               OFFLINE OFFLINE      hisdb1                   STABLE
               OFFLINE OFFLINE      hisdb2                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   STABLE
      2        ONLINE  ONLINE       hisdb2                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   STABLE
      2        ONLINE  ONLINE       hisdb2                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       hisdb1                   STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   STABLE
      2        ONLINE  ONLINE       hisdb2                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   Started,STABLE
      2        ONLINE  ONLINE       hisdb2                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       hisdb1                   STABLE
      2        ONLINE  ONLINE       hisdb2                   STABLE
ora.cvu
      1        ONLINE  ONLINE       hisdb2                   STABLE
ora.heal.db
      1        ONLINE  ONLINE       hisdb1                   Open,HOME=/u01/app/o
                                                             racle/product/19.12.
                                                             0/db,STABLE
      2        ONLINE  ONLINE       hisdb2                   Open,HOME=/u01/app/o
                                                             racle/product/19.12.
                                                             0/db,STABLE
ora.hisdb1.vip
      1        ONLINE  ONLINE       hisdb1                   STABLE
ora.hisdb2.vip
      1        ONLINE  ONLINE       hisdb2                   STABLE
ora.qosmserver
      1        ONLINE  ONLINE       hisdb2                   STABLE
      1        ONLINE  ONLINE       hisdb1                   STABLE
--------------------------------------------------------------------------------

说明：重启监听后，ora.hisdb2.vip显示正常.