删除数据报ORA-00600: internal error code, arguments: [ktbesc_plugged]

Oracle在删除数据是以下错误:

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

原因是由于进行过表空间的传输操作。

解决方法:

ALTER TABLE 表名 MOVE tablespace 表空间名 ;

 

 

Ora-600 [Ktbesc_plugged] Error On Insert Or Delete (文档 ID 1372941.1) 转到底部

In this Document



 

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 Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to 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.

时间: 2024-10-28 00:01:24

删除数据报ORA-00600: internal error code, arguments: [ktbesc_plugged]的相关文章

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

使用PlateSpin复制出来的一数据库服务器(Oracle 10g)在启动数据库实例时遇到"ORA-00600: internal error code, arguments: [4194]....."错误,实例在启动后,会自然Down掉.具体情况如下所示: Successfully onlined Undo Tablespace 54. Mon Nov 21 11:34:03 2016 SMON: enabling tx recovery Mon Nov 21 11:34:03 2

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []

故障现象:     在查询wwl005这张表的时候,报内部错误,对于这张表我们刚才是做了不一致性恢复,之后在查询报如下错误,对于这种现象一般都是由于bug或坏块引起. 15:43:53 SQL> select * from wwl005; select * from wwl005               * ERROR at line 1: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0]

ORA-00600: internal error code, arguments: [17281], [1001], [0x1FF863EE8], [], [], [], [], []

我们生产服务器中的一个数据库发出监控告警日志的邮件,内容如下所示,在31号09:11分出现了大名鼎鼎的ORA-00600错误. Dear All:   The Instance xxx' alert log occured the ora errors ,please see the detail blow and take action for it. many thanks! -----------------------------------------  The errors is b

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

案例环境:                操作系统版本: Red Hat Enterprise Linux ES release 4                数据库版本  : 10.2.0.4.0 32 bit 案例介绍: 今天我 执行stop_oracle.sh脚本关闭数据库时遭遇了ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []. 其中

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

    今天在PlateSpin Forge(关于PlateSpin相关介绍,请见最下面部分简单介绍) 复制出来的一台数据库服务器上,测试数据库能否正常启动时,遇到了"ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []"错误:   在官方文档介绍中,这个错误主要出现在磁盘出现故障导致数据库崩溃后,实例启动失败,并报ORA-00600: arguments: [k

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]错误处理

机器断电以后,重新启动报如下错误: [oracle@zhuxg ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed May 1 11:28:49 2013 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to an idle instance. SQL> startupORACLE instance started. Tot

使用DBLINK查询时报ORA-00600: internal error code, arguments: [kzdlk_zt2 err]

  >                           >                                          > >                 > >                                                                   <>   <><>     <>  <>                        

Error Code: 500 Internal Server Error.

问题背景: 先前一个网站 www.xxx.com 部署在Windows Server 2008服务器A上,运行了一段时间后,被部署到了CentOS6.3服务器B上,但域名没变,现在遇到一个问题,那些URL中含有中文的链接统统打不开,提示如下错误: Error Code: 500 Internal Server Error. The request was rejected by the HTTP filter. Contact the server administrator. (12217)

JVM BUG: Internal Error (classFileParser.cpp:3161), pid=1116, tid=3912 Error: ShouldNotReachHere()

涉及到线程安全的部分出现了JVM BUG--不解,Eclipse返回的信息如下, # # A fatal error has been detected by the Java Runtime Environment: # #  Internal Error (classFileParser.cpp:3161), pid=1116, tid=3912 #  Error: ShouldNotReachHere() # # JRE version: 6.0_21-b07 # Java VM: Jav