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
2016-07-28 13:46 abce 阅读(1062) 评论(0) 编辑 收藏 举报使用DBCA创建新库的时候报错：
查看资源状态：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | $ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE ONLINE rac11g1 <strong>OFFLINE OFFLINE</strong> 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：
1 2 3 4 5 6 | $ asmcmdASMCMD> ls -lState Type Rebal NameMOUNTED EXTERN N FRA/MOUNTED NORMAL N OCR/ASMCMD> |
解决方法:
重新mount一下没发现的磁盘组data
1 | SQL> alter diskgroup data mount; |
再次查看资源的状态，发现已经处于online状态：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | $ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE ONLINE rac11g1 <strong>ONLINE ONLINE</strong> 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 |
然后可以继续安装！
补充：
也有人遇到类似问题，通过以下方法解决了问题
1 2 3 4 5 6 7 | 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 |
1 | <em id="__mceDel"> </em> |
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识（上）
· 浏览器原生「磁吸」效果！Anchor Positioning 锚点定位神器解析
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布：重大改进与新特性概览！
· AI与.NET技术实操系列（二）：开始使用ML.NET
· .NET10 - 预览版1新功能体验（一）
2015-07-28 11g新特性 -- Virtual Private Catalogs
2015-07-28 自动检查点(Automatic Checkpointing)