邏輯STANDBY上的ORA-00600: internal error code, arguments: [krvtadc], [], [], [], [], []
下午收到報警，說邏輯STANDBY有很大資料同步延遲，於是登陸上來，首先檢查ALERT檔案，發現了標題所示的ORA-00600錯誤。首先嚐試重啟一下資料庫試試吧，重啟後，開啟APPLY程式，結果同步到相同的地方，相同的600錯誤重新報出來了，看來重啟是過不去了。只好去翻翻METALINK了，結果翻到了有一個相似的BUG，說是操作壓縮表的時候，日誌同步到邏輯STANDBY庫或者STREAM進行日誌挖掘的時候，有可能報這個錯誤，可是ORACLE說的版本跟我這裡不一致，他那裡提到的是10.2.0.3，而我的是10.2.0.2的版本的。詢問下同事，確實在生產上對壓縮表做了些操作，看來基本就是這個BUG了，於是找到一個4061534的PATCH，裡面有10.2.0.2版本的64位LINUX的PATCH，看來我這個版本確實也存在這樣的問題，不然怎麼會有對應版本的PTACH呢。下下來，看看PATCH中的README，然後把庫宕下來，打補丁，然後起來，就這樣問題就過去了。
這個案例不值得一寫，也沒有多少值得學習的地方，只不過是因為這個是自己第一次打PATCH，記錄一下
[@more@]來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25016/viewspace-1010446/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 邏輯備庫 ORA-00600: internal error code, arguments: [krvxbpx20]Error
- ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]邏輯壞塊解決ErrorAST
- 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: [qertbFetchByRowID]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