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

...............[@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

请使用浏览器的分享功能分享到微信等