ORA-00600 : internal error code, arguments: [qertbFetchByRowID]
檢查alert.log時發現錯誤：
Errors in file /u01/app/oracle/admin/bakdb/udump/bakdb2_ora_1097.trc:
ORA-00600 : internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], []
, []
這個錯誤是oracle的bug(4258825, 4000840)引起的，雖然官方宣稱這兩個bug已經在10.2.0.1版本上修復了（我們的版本是10.2.0.2），實際上看，已經修復的bug未必就不再發生。
絕對地來說Oracle在更新表時肯定會自動維護索引的, 不過由於程式的Bug(4258825, 4000840)在有些條件下Insert/Delete/Update表的記錄後, Oracle沒有維護索引, 就好象是這樣的情況, 表中有5條記錄(ID=1,2,3,4,5), 這時索引是好的, 現在刪除ID=5的記錄留下四條, 然後Oracle沒有維護這個索引還是保留了5條, 當我們發出WHERE ID=5這樣的查詢時, 就出現問題了, 因為根據ROWID找出來的記錄是不對的, 這個稱為Orphan ROWID.可以選擇重建索引來解決這個問題. 一般遇到的是Index上的記錄數比表的多, 反過來的可能是觀察不到的.
處理方法：重建索引
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/670493/viewspace-1024972/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [15753]Error
- ORA-00600: internal error code, arguments: [17087]Error
- ORA-00600: internal error code, arguments: [Cursor not typechecked],Error
- ORA-00600: internal error code, arguments: [32695]Error
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],Error
- ORA-00600: internal error code, arguments: [2662], [0],Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnCloseError
- 轉載：ORA-00600: internal error code, arguments: [504]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]Error
- ORA-00600: internal error code, arguments: [15709]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [],Error
- ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [2131], [9], [8]Error
- ORA-00600: internal error code, arguments: [13011]Error
- 案例ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [kssadd: null parent]ErrorNull
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [729], [4280], [space leak]Error
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ErrorAST
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],ErrorAST
- ORA-00600: internal error code, arguments: [ksuinfos_modact1]ErrorUI
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [2103]錯誤Error
- ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]Error
- ORA-00600: internal error code, arguments: [4194], [30], [30], [],Error
- ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250]Error
- ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [Error
- ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46]Error
- ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [ktecgeb-2], （一）Error
- ORA-00600: internal error code, arguments: [kcblasm_1], [103], []ErrorASM
- 遭遇ORA-00600: internal error code, arguments: [kcrrrfswda.11], [4], [368], [], [], [], [], []Error