ORA-00600: internal error code, arguments: [17092], [39119], [], [], [], [], [],

zhulch發表於2007-05-11
...............[@more@]

今天檢查昨天的日誌,發現一個測試庫有如下的ERROR 。。

Fri May 11 03:59:18 2007
Errors in file /oracle/app/oracle/admin/testdb/bdump/testdb2_dw01_950526.trc:
ORA-00600: internal error code, arguments: [17092], [39119], [], [], [], [], [],
[]
ORA-39119: worker process interrupt for delete worker processes call by master p
rocess
Fri May 11 03:59:18 2007
Trace dumping is performing id=[cdmp_20070511035918]
Fri May 11 03:59:20 2007
Errors in file /oracle/app/oracle/admin/testdb/bdump/testdb2_dw01_950526.trc:
ORA-00600: internal error code, arguments: [17092], [39119], [], [], [], [], [],
[]
ORA-39119: worker process interrupt for delete worker processes call by mast


TRACE FILE 有如下日誌
A-31693: Table data object "EXP"."SYS_EXPORT_FULL_07" failed to load/unload an
d is being skipped due to error:
ORA-19502: write error on file "/testdbarch1/exp_imp/testdb_full_0705110300.dmp",
blockno 972298 (blocksize=4096)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 262144
ORA-31693: Table data object "TESTSIT"."xxxxx" failed to load/unload and is be
ing skipped due to error:
ORA-19502: write error on file "/testdbarch1/exp_imp/testdb_full_0705110300.dmp",
blockno 972490 (blocksize=4096)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 262144

經過分析是由於EXPDP 的目錄慢了,造成的。是不是BUG ,還需要確認,以前由於EXPDP 目錄慢,也出現過錯誤,
不過不是ORA-600 [17092], [39119] 錯誤

請參照以前的
http://zhulch.itpub.net/post/17395/283510

發現有大量的如下ERROR .

ORA-19502: write error on file "/qastestarch1/exp_imp/qastest_full_0704230300.dmp", blockno 6704084 (blocksize=4096)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 262144
Mon Apr 23 04:29:48 2007
Trace dumping is performing id=[cdmp_20070423042948]
Mon Apr 23 04:29:49 2007
Errors in file /oracle/app/oracle/admin/qastest/bdump/qastest2_dw01_1204324.trc:
ORA-00600: internal error code, arguments: [729], [23320], [space leak], [], [], [], [], []

原因是 做EXPDP 的目錄滿了,不是BUG

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

相關文章