os:aix7.1
db:oracle 11.2.0.3 rac

rdbms的alert日志中，从4月份起，m001进程不断的报错大量的600错误，该进程是mmon的slave进程，辅助进行性能诊断监控的，本文主要描述该故障的处理过程及方法。

1、具体的报错信息如下：
ORA-00600: internal error code, arguments: [kcfnew_2], [202], [1702144], [12800], [12800], [], [], [], [], [], [], []
2、查看trc文件，报错时执行的sql为：begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
3、查看trc文件中的call stack，发现有大量的temp方面的操作（kole_templob_init(),koklc_createtemp(),kdlt_createtemp()等），联系报错信息中有202，一般db_files默认为200，所以temp文件编号从200+fileid开始，202可能是代表fileid=2的临时表空间文件，所以猜想是temp表空间文件的问题。
4、查看dba_temp_files发现有临时表空间文件创建在本地。
5、通过600错误的函数在mos找到一个类似的错误EXPDP Failing With Ora-600 [kcfnew_2] (Doc ID 1509971.1)

This was caused by a corrupt segment in the temporary tablespace.

The following errors were seen in the alert.log shortly before the ORA-600 error:

alter database tempfile '/home/oradata/ora_dev/OBA08T/tempfile01' resize 1g
ORA-1516 signalled during: alter database tempfile '/home/oradata/ora_dev/OBA08T/tempfile01' resize 1g...

ORA-00600: internal error code, arguments: [kcfnew_2], [202], [947072], [619519], [619519],

Arg [a] FILE#
Arg [b] block to read
Arg [c] logical size kcflsz
Arg [d] physical size kcffsz

File# 202 belongs to the temporary tablespace in this example.

6、解决方法
重建该临时表空间文件
As the issue is due to a problem with the temporary tablespace, recreation of that tablespace should resolve it.

此处贴出该mos的原文：
EXPDP Failing With Ora-600 [kcfnew_2] (Doc ID 1509971.1)

To Bottom

In this Document

Symptoms

Cause

Solution

References

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Exporting database schemas failing with the following error:

ORA-00600: internal error code, arguments: [kcfnew_2], [202], [947072], [619519], [619519],

With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_14": system/******** dumpfile=OBA08T.dmp logfile=OBA08T.log full=y directory=test
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-00600: internal error code, arguments: [kcfnew_2], [202], [947072], [619519], [619519], [], [], [], [], [], [], []
ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 1714
ORA-06512: at line 2

-- or: --

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00600: internal error code, arguments: [kcfnew_1], [201], [400], [0], [], [], [], []
ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 1397
ORA-06512: at line 2

-- or (for the original export client): --

EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kcfnew_1], [201], [400], [0], [], [], [], []
ORA-06512: at "SYS.DBMS_LOB", line 443
ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 722
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling WMSYS.LT_EXPORT_PKG.system_info_exp

Cause

This was caused by a corrupt segment in the temporary tablespace.

The following errors were seen in the alert.log shortly before the ORA-600 error:

alter database tempfile '/home/oradata/ora_dev/OBA08T/tempfile01' resize 1g
ORA-1516 signalled during: alter database tempfile '/home/oradata/ora_dev/OBA08T/tempfile01' resize 1g...

ORA-00600: internal error code, arguments: [kcfnew_2], [202], [947072], [619519], [619519],

Arg [a] FILE#
Arg [b] block to read
Arg [c] logical size kcflsz
Arg [d] physical size kcffsz

File# 202 belongs to the temporary tablespace in this example.

Solution

As the issue is due to a problem with the temporary tablespace, recreation of that tablespace should resolve it.

References

NOTE:99197.1 - ORA-600 [kcfnew_2] "attempt to read a block past end of logical/physical file"

ITPub博客

ORA-00600 [kcfnew_2], [202], [1702144], [12800], [12800]

Applies to:

Symptoms

Cause

Solution

References

最新文章