11.2 RAC: In "crsctl stat res -t" State Details May Be Missing or Incorrect [ID 1086563.1]

最新推荐文章于 2021-11-01 11:40:50 发布

转载最新推荐文章于 2021-11-01 11:40:50 发布 · 1.3k 阅读

文章标签：

#resources #deprecated #server #oracle #database #output

本文探讨了在Oracle Server Enterprise Edition 11.2及后续版本中使用crsctl stat res-t命令时出现的状态详情缺失或错误的问题。具体表现为部分ASM和DB资源的状态详情不正确或完全缺失，即使资源实际上处于在线状态。文章详细介绍了两种常见情况及其原因，并指出了这些错误仅具信息性质，不影响实际功能。

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

In output of "crsctl stat res -t", for some or all ASM and/or DB resources, the state_details are missing or incorrect.

Case 1

The state_details may be blank instead of showing "Open" or "Started" when the resource is in fact open/started, although STATE correctly lists the resource as online:

 
  $ crsctl stat res -t
-------------------------------------------------------------
NAME           TARGET  STATE     SERVER    STATE_DETAILS    
-------------------------------------------------------------
Local Resources
-------------------------------------------------------------
ora.asm
             ONLINE  ONLINE    oranode1                      <<=== missing 
             ONLINE  ONLINE    oranode2    Started
-------------------------------------------------------------
Cluster Resources
-------------------------------------------------------------
ora.tst.db
    1        ONLINE  ONLINE    oranode1                       <<=== missing
    2        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

After restarting CRS stack on one node, the state_details of some resources on the other node(s) may simply be wrong and not matching with the state, or may be missing altogether:

       


 
  $ crsctl stat res -t
-------------------------------------------------------------
NAME           TARGET  STATE     SERVER    STATE_DETAILS     
-------------------------------------------------------------
Local Resources
-------------------------------------------------------------
ora.asm
             ONLINE  ONLINE    oranode1    Started               
             ONLINE  ONLINE    oranode2                       <<=== missing
-------------------------------------------------------------
Cluster Resources
-------------------------------------------------------------
ora.tst.db
    1        ONLINE  ONLINE    oranode1    Open                
    2        ONLINE  ONLINE    oranode2    Instance Shutdown  <<=== wrong

Cause

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'

Solution

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 -l and/or crs_stat -t can be used to give a listing without STATE details.