【翻译自mos文章】11.2 RAC: In "crsctl stat res -t" State Details May Be Missing or Incorrect
来源:互联网 发布:网站漏洞检测软件 编辑:程序博客网 时间:2024/06/16 06:35
11.2 RAC: In "crsctl stat res -t" State Details May Be Missing or Incorrect (Doc ID 1086563.1)
适用于:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.
症状:
在crsctl stat res -t的输出中,对于有些或者全部的asm或者db 资源,state_details列的显示 丢失(即:空的) 或者不正确
Case 1
当资源被事实上open 或者started后,state_details列的显示 空白,而不是显示"Open" or "Started" ,虽然STATE列能正确的显示资源为online
$ crsctl stat res -t-------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------Local Resources-------------------------------------------------------------ora.asmONLINE ONLINE oranode1 <<=== missing ONLINE ONLINE oranode2 Started-------------------------------------------------------------Cluster Resources-------------------------------------------------------------ora.tst.db1 ONLINE ONLINE oranode1 <<=== missing2 ONLINE ONLINE oranode2 Open
In this case, the STATE details only show for the most recently started instance of each group ie. in the above, +ASM2 and TST2 were the most recently started.
Case 2
当在一个node上重启CRS stack后,在其他节点上的某些资源的state_details列可能显示错误并且与state列不匹配,或者是missing状态:
-------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------Local Resources-------------------------------------------------------------ora.asmONLINE ONLINE oranode1 Started ONLINE ONLINE oranode2 <<=== missing-------------------------------------------------------------Cluster Resources-------------------------------------------------------------ora.tst.db1 ONLINE ONLINE oranode1 Open 2 ONLINE ONLINE oranode2 Instance Shutdown <<=== wrong
原因:
Case 1
This is caused by partially published bug:
BUG 9377625 - STATE_DETAILS ONLY SHOWED LAST STARTED ASM "STARTED" FOR 'CRSCTL STATUS RES -T"
This bug will be fixed in future release 12.1.
Case 2
This is caused by unpublished bug:
BUG 8516657 (Unpublished): CONFUSING 'STATE_DETAILS' FOR ASM/DB INSTANCE FROM 'CRSCTL STAT RES -T'
解决方案:
These issues will be patched in future versions and/or CRS PSU's. Check My Oracle Support to see if one-off patches are available.
In the meantiume:
•These errors are informational only, in other words, functionality of the database, asm or other resources are not affected. Further, the STATE is not affected, only STATE details may be inaccurate. Inaccurate STATE details can simply be ignored.
@INTERNAL NOTE: unpublishing this piece because 'crs_stat' is officially deprecated in 11.2: --->crs_stat命令已经在11.2中被废弃。
@crs_stat -l and/or crs_stat -t can be used to give a listing without STATE details.
- 【翻译自mos文章】11.2 RAC: In "crsctl stat res -t" State Details May Be Missing or Incorrect
- 11.2 RAC: In "crsctl stat res -t" State Details May Be Missing or Incorrect [ID 1086563.1]
- 11.2 RAC: In "crsctl stat res -t" State Details May Be Missing or Incorrect (文档 ID 1086563.1)
- crsctl stat res -t
- crsctl stat res -t显示没有实例
- crsctl stat res -t 和crsctl stat res -t -init 中STATE_DETAILS的解释
- 【翻译自mos文章】解释 datafile name中的MISSING关键字
- os刚刚启动时的crsctl stat res -t
- 【翻译自mos文章】Oracle Database In-Memory Advisor
- 【翻译自mos文章】在11.2 和12.1 rac中,启动关闭CRS, OHAS, ASM, RDBMS & ACFS Services的步骤
- 【翻译自mos文章】在RAC database中怎么独立于instance来kill session?
- 【翻译自mos文章】什么是Oracle Clusterware 和RAC中的脑裂
- 【翻译自mos文章】services与rac中的 Distributed Transaction Processing (DTP)
- 【翻译自mos文章】私有网络所用的协议 与 Oracle RAC
- 【翻译自mos文章】由于sys.audses$的cache值太小导致的RAC hang
- 【翻译自mos文章】在11gR2 rac中启用Dead Connection Connection(DCD)功能
- 【翻译自mos文章】在RHEL7 or OEL7上安装oracle 11.2.0.4 db时的要求
- SIM May not be in stable state.....
- Struts 2 标签使用的总结
- Ogre 粒子系统及粒子脚本
- 机器视觉学习系列二:敏感图像识别
- Hibernate操作步骤
- SSH免密码登录的原理
- 【翻译自mos文章】11.2 RAC: In "crsctl stat res -t" State Details May Be Missing or Incorrect
- Intent的Data和Type和Flag属性-amdroid学习之旅(五十一)
- hadoop2.0 做spider下载集群的设置
- 使用jQuery.form插件,实现完美的表单异步提交
- 机器视觉学习系列三:验证码识别
- 通达信经典指标组合图文详解
- 由于SSH配置文件的不匹配,导致的Permission denied (publickey)及其解决方法
- 黑马程序员----面向对象三大特征之继承
- hdu 2054 A == B ?