Oracle RAC 11.2.0.4 – RHRL 6.4: DiskGroup resource are not running on nodes. Database instance may not come up on these nodes

使用DBCA创建新库的时候报错:

查看资源状态:

$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rac11g1                                      
               OFFLINE OFFLINE      rac11g2                                      
ora.FRA.dg
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.OCR.dg
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.asm
               ONLINE  ONLINE       rac11g1                  Started             
               ONLINE  ONLINE       rac11g2                  Started             
ora.gsd
               OFFLINE OFFLINE      rac11g1                                      
               OFFLINE OFFLINE      rac11g2                                      
ora.net1.network
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.ons
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.registry.acfs
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac11g1                                      
ora.cvu
      1        ONLINE  ONLINE       rac11g1                                      
ora.oc4j
      1        ONLINE  ONLINE       rac11g1                                      
ora.rac11g1.vip
      1        ONLINE  ONLINE       rac11g1                                      
ora.rac11g2.vip
      1        ONLINE  ONLINE       rac11g2                                      
ora.scan1.vip
      1        ONLINE  ONLINE       rac11g1  

可以发现,在第二节点,资源ora.DATA.dg处于offline状态。

使用asmcmd查看也没做发现磁盘组data:

$ asmcmd
ASMCMD> ls -l
State    Type    Rebal  Name
MOUNTED  EXTERN  N      FRA/
MOUNTED  NORMAL  N      OCR/
ASMCMD>

  

解决方法:

重新mount一下没发现的磁盘组data

SQL> alter diskgroup data mount;

再次查看资源的状态,发现已经处于online状态:

$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.FRA.dg
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.OCR.dg
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.asm
               ONLINE  ONLINE       rac11g1                  Started             
               ONLINE  ONLINE       rac11g2                  Started             
ora.gsd
               OFFLINE OFFLINE      rac11g1                                      
               OFFLINE OFFLINE      rac11g2                                      
ora.net1.network
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.ons
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
ora.registry.acfs
               ONLINE  ONLINE       rac11g1                                      
               ONLINE  ONLINE       rac11g2                                      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac11g1                                      
ora.cvu
      1        ONLINE  ONLINE       rac11g1                                      
ora.oc4j
      1        ONLINE  ONLINE       rac11g1                                      
ora.rac11g1.vip
      1        ONLINE  ONLINE       rac11g1                                      
ora.rac11g2.vip
      1        ONLINE  ONLINE       rac11g2                                      
ora.scan1.vip
      1        ONLINE  ONLINE       rac11g1

然后可以继续安装!

补充:

也有人遇到类似问题,通过以下方法解决了问题

To find out diskgroup resource status:

$GRID_HOME/bin/srvctl status diskgroup -g diskgroupname -a

To start or sync diskgroup resource:

$GRID_HOME/bin/srvctl start diskgroup -g diskgroupname
 
原文地址:https://www.cnblogs.com/abclife/p/5714508.html