記一次ORA-00600: internal error code, arguments: [kdtdelrow-2]的處理
晚上，接到客戶電話說資料庫當機了。立馬起來檢查資料庫，從alert log 中可以看到大量的600錯誤，錯誤資訊如下：
Mon Dec 9 22:50:37 2013
Errors in file /oracle/SP1/saptrace/usertrace/sp1_ora_14237.trc:
ORA-00600: internal error code, arguments: [kdtdelrow-2], [4], [4], [], [], [], [], []
ORA-01116: error in opening database file 131
ORA-01110: data file 131: '/dev/VGORA/rlvol1'
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
這裡資訊已經明確給出了問題點，ORA-27041: unable to open file HPUX-ia64 Error: 13: Permission denied，這個檔案/dev/VGORA/rlvol1時我下午新新增的資料檔案，怎麼會缺少許可權呢？
檢查發現rlvol1的許可權是正確的，但是從oracle賬戶無法訪問這個lv，檢查發現VGORA目錄的屬組是root:system，其他賬戶許可權為0。這就是導致問題的原因。同主機同志溝通後瞭解到，他開始的時候給了o+x 許可權，也就是我可以新增資料檔案。後來他覺得這個不安全，又把這個許可權給取消了。這個可能是我同主機同志溝通上出現了點問題，導致了這次的故障。以後要吸取經驗教訓啊。
這個處理起來就比較容易了，將VGORA的屬組修改成oracle後，問題解決。
Mon Dec 9 22:50:37 2013
Errors in file /oracle/SP1/saptrace/usertrace/sp1_ora_14237.trc:
ORA-00600: internal error code, arguments: [kdtdelrow-2], [4], [4], [], [], [], [], []
ORA-01116: error in opening database file 131
ORA-01110: data file 131: '/dev/VGORA/rlvol1'
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
這裡資訊已經明確給出了問題點，ORA-27041: unable to open file HPUX-ia64 Error: 13: Permission denied，這個檔案/dev/VGORA/rlvol1時我下午新新增的資料檔案，怎麼會缺少許可權呢？
檢查發現rlvol1的許可權是正確的，但是從oracle賬戶無法訪問這個lv，檢查發現VGORA目錄的屬組是root:system，其他賬戶許可權為0。這就是導致問題的原因。同主機同志溝通後瞭解到，他開始的時候給了o+x 許可權，也就是我可以新增資料檔案。後來他覺得這個不安全，又把這個許可權給取消了。這個可能是我同主機同志溝通上出現了點問題，導致了這次的故障。以後要吸取經驗教訓啊。
這個處理起來就比較容易了，將VGORA的屬組修改成oracle後，問題解決。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11590946/viewspace-1062832/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-00600: internal error code, arguments: [4194] 錯誤處理Error
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- ORA-00600: internal error code, arguments: [15709], [29], [1]-故障處理Error
- ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]錯誤處理ErrorAST
- 簡單記錄一次ORA-00600: internal error code, arguments: [2662]Error
- 簡單記錄一次ORA-00600: internal error code, arguments: [4194]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: [keltnfy-ldmInit], [46], [1], [], [], [], [], []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: [4194]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