ITPub博客

首页 > 数据库 > Oracle > Bug 12919564 - ORA-600 [ktbesc_plugged]

Bug 12919564 - ORA-600 [ktbesc_plugged]

原创 Oracle 作者:lucyne 时间:2015-09-07 10:53:26 0 删除 编辑
在执行物化视图同步时,发生以下错误

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORA-39142
下一篇: Oracle oerr
请登录后发表评论 登录
全部评论
. . 一个 DBA. . .

注册时间:2012-01-06

  • 博文量
    84
  • 访问量
    741717