ORA-00600: Internal error code, parameter: [kdoilsn1]

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.