Bug 12919564 - ORA-600 [ktbesc_plugged]

在执行物化视图同步时，发生以下错误

SQL> exec dbms_mview.refresh('TUSER.USER_BC');

dBEGIN dbms_mview.refresh('TUSER.USER_BC'); END;

*

ERROR at line 1:

ORA-12008: error in materialized view refresh path

ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [],

[], [], [], [], [], [], []

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745

ORA-06512: at line 1

 

经MOS查询是由于bug造成，以下是mos上的解决方案，我在此采用的是move tablspace 但长久的方法是apply one-off Patch:12919564！

 

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.3 to 11.2.0.3 - Release: 11.2 to 11.2
This problem can occur on any platform.

Symptoms

Receiving the following error on insert or delete against one particular table.

ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], []

Call Stack Trace = ktbesc -> kdiescpin -> kdifind -> kdiblTestPrefixUniqueness -> kdiblLockPiece -> kdiblLockRange

Changes

Table is located on a recently plugged in tablespace into an 11.2.0.3 database.

Cause

Bug:12919564 where this problem was introduced in 11.2.0.3. 

Solution

We successfully used a temporary workaround of moving the problem table to another tablespace.  Once moved, we were able to insert or delete without issue.

alter table <table name> move tablespace <tablespace name>;

There is an additional workaround of setting "_fastpin_enable"=0 which is discussed in Document 12919564.8.  Long term resolution would be to apply one-off Patch:12919564.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26390465/viewspace-1793126/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26390465/viewspace-1793126/