【故障-ORACLE】ORA-00600: [qesmmCValStat4], [3], [1] 故障處理

浪漫雙魚發表於2011-11-15
Oracle

作業系統：Windows Server 2003 Version V5.2 Service Pack 1

資料庫版本：Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production

日誌報錯：

Fri Nov 11 11:46:35 2011

Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_10012.trc:

ORA-00600: 內部錯誤程式碼, 引數: [qesmmCValStat4], [3], [1], [], [], [], [], []

 

Fri Nov 11 11:46:43 2011

Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_10012.trc:

ORA-00600: 內部錯誤程式碼, 引數: [qesmmCValStat4], [3], [1], [], [], [], [], []

 

又一個ORA-600錯誤，在matelink上查詢了下，發現和Bug 4401437 - CONNECT BY query may fail with OERI qergiStart1相吻合。

Bug 4401437 - CONNECT BY query may fail with OERI:qergiStart1 / OERI:qesmmCValStat4 [ID 4401437.8]

Bug 4401437  CONNECT BY query may fail with OERI:qergiStart1 / OERI:qesmmCValStat4

 This note gives a brief overview of bug 4401437. 
 The content was last updated on: 03-APR-2009
 Click here for details of each of the sections below.

Affects:

Product (Component)

Oracle Server (Rdbms)

Range of versions believed to be affected

Versions < 11

Versions confirmed as being affected

Platforms affected

Generic (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

Description

A connect-by query may fail with ORA-600 [qergiStart1]

 

Workaround

  Add a "no_filtering" hint to the query.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References

Bug:4401437 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

 

    以上文章顯示這是oracle的connect by分析函式的一個bug，採用Add a "no_filtering" hint to the query的方式處理，發現雖然不再報錯，但查詢出來的資料不準確。最終建議客戶升級資料庫到10.2.0.4穩定版本。

    不過升級資料庫是個大操作，需要經過嚴密的應用測試才能實施。所以我建議重啟資料庫測試下，通過重啟資料庫釋放資源，改變了觸發bug的系統環境，使資料庫恢復了正常。

 

 

 

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11088128/viewspace-710955/，如需轉載，請註明出處，否則將追究法律責任。

相關文章