【error】DiskGroup resource are not running on nodes. Database instance may not come up on these nodes
2018年08月16日 13:52:20 阅读数：80
使用DBCA创建新库的时候报错：
查看资源状态：
Local Resources
-------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE rac1 OFFLINE OFFLINE rac2 ora.FRA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.LISTENER.lsnr ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.OCR.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.asm ONLINE ONLINE rac1 Started ONLINE ONLINE rac2 Started ora.gsd OFFLINE OFFLINE rac1 OFFLINE OFFLINE rac2 ora.net1.network ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.ons ONLINE ONLINE rac1 ONLINE ONLINE rac2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE rac2 ora.cvu 1 ONLINE ONLINE rac2 ora.oc4j 1 ONLINE ONLINE rac2 ora.rac1.vip 1 ONLINE ONLINE rac1 ora.rac2.vip 1 ONLINE ONLINE rac2 ora.scan1.vip 1 ONLINE ONLINE rac2[grid@rac2 ~]$ asmcmd ASMCMD> ls -l State Type Rebal Name MOUNTED EXTERN N FRA/ MOUNTED EXTERN N OCR/缺少DATA/
解决方法:
重新mount一下没发现的磁盘组data
[root@rac2 ~]# su - grid
[grid@rac2 ~]$ sqlplus / as sysasm
SQL> alter diskgroup data mount;
[grid@rac2 ~]$ crsctl stat res -t
-------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.FRA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.LISTENER.lsnr ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.OCR.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.asm ONLINE ONLINE rac1 Started ONLINE ONLINE rac2 Started ora.gsd OFFLINE OFFLINE rac1 OFFLINE OFFLINE rac2 ora.net1.network ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.ons ONLINE ONLINE rac1 ONLINE ONLINE rac2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE rac2 ora.cvu 1 ONLINE ONLINE rac2 ora.oc4j 1 ONLINE ONLINE rac2 ora.rac1.vip 1 ONLINE ONLINE rac1 ora.rac2.vip 1 ONLINE ONLINE rac2 ora.scan1.vip 1 ONLINE ONLINE rac2[grid@rac2 ~]$ asmcmd
ASMCMD> ls -l State Type Rebal NameMOUNTED EXTERN N DATA/ MOUNTED EXTERN N FRA/ MOUNTED EXTERN N OCR/然后可以继续安装！
补充：
也有人遇到类似问题，通过以下方法解决了问题
To find out diskgroup resource status:$GRID_HOME/bin/srvctl status diskgroup -g diskgroupname -aTo start or sync diskgroup resource:$GRID_HOME/bin/srvctl start diskgroup -g diskgroupname