Oracle 11g RAC GRID资源出现INTERMEDIATE与check timed out状态

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:214

Oracle 11g RAC GRID资源出现INTERMEDIATE与check timed out状态

最近oracle 11g rac grid有几个磁盘组资源状态显示INTERMEDIATE与check timed out状态,这种状态可能是某些愿因导致crsd进程异常,在自动重启过程中某些资源启动失败而出现的oracle rac bug。
类似的问题可以参考官方文档:
oraagent.bin Exits After Check Timed Out (文档 ID 1323679.1)
Bug 12771830 - ora.asm CRS resource check timed out (文档 ID 12771830.8)
Bug 12771830 : ORA.ASM CRSD RESOURCE CHECK TIMED OUT -REFERENCE BUG:BUG-12754555
Bug 11814167 - crsd.bin process restarting regularly on one or more nodes [ID 11814167.8]

建议的处理方式:
1、crsctl check resource 资源名
crsctl stat res -t 检查一下,是否正常。
2、如果第一步不行,则重启CRS服务。
3、如果重启CRS服务后资源状态依然为INTERMEDIATE,重启主机一般可解决。
4、长远之计,升级数据库到当前大版本的最新版本。

附:
1、metalink上的类似现象 :
Bug 12771830 - ora.asm CRS resource check timed out (文档 ID 12771830.8)
Bug 12771830 : ORA.ASM CRSD RESOURCE CHECK TIMED OUT -REFERENCE BUG:BUG-12754555
Bug 11814167 - crsd.bin process restarting regularly on one or more nodes [ID 11814167.8]
Bug 12771830 - ora.asm CRS resource check timed out (文档 ID 12771830.8)
Resource shows timed out status from "crsctl stat res" but actually healthy
..
ora.DG01.dg
ONLINE INTERMEDIATE racnode1 CHECK TIMED OUT
..

CAUSE
This is caused by bug 11807012
SOLUTION
bug 11807012 is fixed in 11.2.0.2.3 (GI PSU3), 11.2.0.3, 12.1 and above.

2、关于INTERMEDIATE状态的说明:

A resource can be in the INTERMEDIATE state because of one of
two events:
1. Oracle Clusterware cannot determine the state of the
resource but the resource was either attempting to go online
or was online the last time its state was precisely known.
Usually, the resource transitions out of this state on its own
over time, as the conditions that impeded the check action
no longer apply.

2. A resource is partially online. For example, the Oracle
Database VIP resource fails over to another server when its
home server leaves the cluster. However, applications
cannot use this VIP to access the database while it is on a
non-home server. Similarly, when an Oracle Database
instance is started and not open, the resource is partially
online: it is running but is not available to provide services.
Oracle Clusterware actively monitors resources that are in the
INTERMEDIATE state and, typically, you are not required to
intervene. If the resource is in the INTERMEDIATE state due to
the preceding reason 1, then as soon as the state of the resource
is established, Oracle Clusterware transitions the resource out of
the INTERMEDIATE state.
If the resource is in the INTERMEDIATE state due to the
preceding reason 2, then it stays in this state if it remains
partially online. For example, the home server of the VIP must
rejoin the cluster so the VIP can switch over to it. A database
administrator must issue a command to open the database
instance.
In either case, however, Oracle Clusterware transitions the
resource out of the INTERMEDIATE state automatically as soon
as it is appropriate.Use the STATE_DETAILS resource attribute
to explain the reason for a resource being in the
INTERMEDIATE state and provide a solution to transition the
resource out of this state.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】