程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SyBase數據庫 >> SyBase教程 >> 【翻譯自mos文章】11.2RAC:In"crsctlstatres-t"StateDetailsMayBeMissingorIncorrect

【翻譯自mos文章】11.2RAC:In"crsctlstatres-t"StateDetailsMayBeMissingorIncorrect

編輯:SyBase教程

【翻譯自mos文章】11.2RAC:In"crsctlstatres-t"StateDetailsMayBeMissingorIncorrect


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.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
當在一個node上重啟CRS stack後,在其他節點上的某些資源的state_details列可能顯示錯誤並且與state列不匹配,或者是missing狀態:

-------------------------------------------------------------
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

原因:
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.

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved