ORA-00600:internal error code, arguments..的问题(三)
n the same object.
Workaround :
sql>alter system flush buffer cache' to flush the buffer in the cache.
Patch Details:
Check Metalink for Patch 4430244 availability.
Bug 5859511 -----> Closed as Duplicate of Unpublished Bug 4592596
Abstract: INTERMITTENT ORA-600 [KCBZ_CHECK_OBJD_TYP_3] FROM PARALLEL SLAVES
Fixed releases : 10.2.0.4, 11.0.0.0
Details: www.2cto.com
Corruption can occur using a multi-table insert SQL with
direct load operations. Eg: If the SQL goes parallel.
This can result in subsequent ORA-1410 type errors on selects
from the target table/s.
Symptoms :
1.Select on table fails with ORA-600 [kcbz_check_objd_typ_3] after multi-table insert with direct load was done.
2.Analyze on the table fails with ORA-1410
3.Call Stack :- kcbassertbd3 kcbz_check_objd_typ kcbzib kcbgtcr ktrget kdst_fetch kdstf0010101km
kdsttgr qertbFetch qergiFetch qertqoFetch
Workaround: -
Do not use direct path (APPEND or PQ) in a multi-table insert SQL
Check Metalink for Patch 4592596 availability.
Unpublished Bug 5754708 ----> Closed as Duplicate of Unpublished Bug 4996133
Abstract: ORA-600 [KCBZ_CHECK_OBJD_TYP_3] FROM "SYS.DBMS_STATS"
Fixed version : 9.2.08 ,A203, B106
Symptoms : -
www.2cto.com
1. Running in RAC mode
2. Reading the overflow segment of an IOT
3. Call Stack :- kdsgnp kafger qerixGetNonKeyCol qerixFetchByLogicalRowid
Or
Call Stack :- kcbassertbd3 kcbz_check_objd_typ kcbzib kcbgtcr ktrget kdsgrp kdsfbr qertbFetchByRowID
Workaround:
Flush the buffer cache (10g onwards)
or
Restart the instance to clear its buffer cache.
Bug 5348204
Abstract: ORA-600 [KCBZ_CHECK_OBJD_TYP_3] IMPORTING TRANSPORTABLE TABLESPACE FROM 10.1
Fixed In Ver: 10.2.0.1
Symptoms :-
1.Cross Platform tablespace Import using Transportable tablespace option fails with following error message
ORA-39083: Object type TABLE failed to create with error
ORA-600: internal error code, arguments: [kcbz_check_objd_type_3]
2.Call Stack :- kcbz_check_objd_typ kcbzib kcbgtcr ktecgsc ktecgetsh ktecgshx ktsscd_segment ktsscf_segment kdicpsc kdicrws
Workaround: -
Check Metalink for Patch 4331909 availability.
www.2cto.com
Bug 5689412
ORA-600 [kcbz_check_objd_typ_3] after SCN
Symptoms : -
1> Primary and Standby Configuration
2>ORA-600 [kcbz_check_objd_typ_3] after SCN based recovery to SCN just before
a TRUNCATE operation.
Example
On primary
create table y (d date, v varchar2(30));
insert into y values (SYSDATE, 'test1');
insert into y values (SYSDATE, 'test2');
truncate table y;
Recover the standby to a point just prior to the truncate to recover this specific table. (Detemine the SCN by mining the redo)
www.2cto.com
recover standby database until change ;
-> media recovery completes successfully
alter database open read only;
select * from y;
^
ORA-600 [kcbz_check_objd_typ_3]
Workaround :-
Check Metalink for Patch 5689412 availability.
作者 wuweilong