An error is reported for a standby database of the database:
ORA-00600: Internal error code, parameter: [kdoilsn1], [], [], [], [], [], [], [], [], [], [], []
According to the trace file, the SQL statement that reports an error is: select * from xxxxx where xx
So what does this error mean? ORA-00600 [kdoilsn1] When Attempting To Move LOB Using ALTER Command
Data Query:
Applies:
Oracle Server-Enterprise Edition-Version: 9.2.0.1 to 9.2.0.7-Release: 9.2 to 9.2
Information in this document applies to any platform.
However, it seems that this error will also occur for 11 GB.
SYMPTOMS
Attempting to move LOB using an alter command fails with the following error and stack trace:
ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], []
----- Call Stack Trace -----
Kkdoilsn kkkdoilci kkdollb kkdolsci kkkdolsoi kkkdlgsci
Kkdlgcd qcscif qcsrctq qcswrc qcsrcr qcsrnr qcsridn qcsraic qcspqb kkmdrv
The trace file contains the following:
Kkdoilsn () + 1423 call kgeasnmierr () 00A99D540? 2B4AFF4712A0?
9e7b5141000000000?
000000000? 000000000?
9D13DF398?
Kkdoilci () + 338 call kkdoilsn () A0EC81A10? 2B4AFF4712A0?
000000000? 949724AE0?
000000000? 9D13DF398?
Kkdollb () + 239 call kkdoilci () A0EC81A10? 91DD07220?
000000000? 000000000?
000000000? 949724AE0?
Kkdolsci () + 119 call kkdollb () A0EC81A10? 949724B88?
91DD07288? 000000002?
000000000? 949724AE0?
Kkdolsoi () + 74 call kkdolsci () A0EC81A10? 00000001E?
000000002? 000000000?
000000000? 949724AE0?
Kkdlgcd () + 191 call kkdolsoi () A0EC81A10? 2B4AFF820B18?
000000002? 000000000?
000000000? 949724AE0?
_ PGOSF148_kkmfbtcn call kkdlgcd () 2B4AFF461BD8? 2b4aff1_8f8?
() + 10 000000002? 000000000?
CAUSE
This is an internal Bug: 2766299. this bug will not be visable via Metalink
@ NOTE: Per Oracle development, this will be fixed in Oracle 9.2.0.8.0 and above;
SOLUTION
Use export and import to move the segment.
Bug: 2766299 is fixed in 10G
This document does not seem accurate.
In actual situations, the lob object is not moved, but the field of a table is changed to the lob type. Finally, the buffer cache is fixed after fush. (Share pool should not use flush)
GoldenGate performs two-way Oracle-Oracle replication without using a Data Pump
One-way Oracle-Oracle Replication Using the GoldenGate Data Pump
How to debug Oracle Data Pump (expdp/impdp)
Oracle Database Export data pump (EXPDP) file storage location
Export of Oracle 10g Data Pump Partition Table