ORA-00600内部错误代码:参数: [kqlnrc_1]

报错如下:

Mon Mar 31 18:45:59 2014

Errors in file /oracle/app/oracle/diag/rdbms/zscims/zscims2/trace/zscims2_ora_11403518.trc  (incident=28382):

ORA-00600: 内部错误代码, 参数: [kqlnrc_1], [0x7000003F55C3B60], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/app/oracle/diag/rdbms/zscims/zscims2/incident/incdir_28382/zscims2_ora_11403518_i28382.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Mon Mar 31 18:46:02 2014

Dumping diagnostic data in directory=[cdmp_20140331184602], requested by (instance=2, osid=11403518), summary=[incident=28382].

Errors in file /oracle/app/oracle/diag/rdbms/zscims/zscims2/trace/zscims2_ora_11403518.trc  (incident=28383):

ORA-00600: 内部错误代码, 参数: [kqlnrc_1], [0x7000003F55C3B60], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/app/oracle/diag/rdbms/zscims/zscims2/incident/incdir_28383/zscims2_ora_11403518_i28383.trc

Use ADRCI or Support Workbench to package the incident.

######

TRACE文件:

DDE: Problem Key 'ORA 600 [kqlnrc_1]' was flood controlled (0x2) (incident: 28377)

ORA-00600: 内部错误代码, 参数: [kqlnrc_1], [0x7000003F55C3B60], [], [], [], [], [], [], [], [], [], []

LibraryHandle:  Address=7000003f55c3b60 Hash=20d7264d LockMode=S PinMode=S LoadLockMode=0 Status=INVL

ObjectName:  Name=ABC.DEF@GH  

 FullHashValue=566b232f34009a84471734df20d7264d Namespace=TABLE/PROCEDURE(01) Type=SYNONYM(05) Identifier=0 OwnerIdn=2147483644

Statistics:  InvalidationCount=2 ExecutionCount=0 LoadCount=1 ActiveLocks=1 TotalLockCount=6 TotalPinCount=6

Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=0 BucketInUse=5 HandleInUse=5 HandleReferenceCount=0

Concurrency:  DependencyMutex=7000003f55c3c10(0, 5, 0, 0) Mutex=7000003f55c3c90(744, 56, 0, 6)

Flags=REM/PIN/TIM/[00022801]

WaitersLists:  

 Lock=7000003f55c3bf0[7000003f55c3bf0,7000003f55c3bf0]

 Pin=7000003f55c3bd0[7000003f55c3bd0,7000003f55c3bd0]

 LoadLock=7000003f55c3c48[7000003f55c3c48,7000003f55c3c48]

Timestamp:  Current=05-28-2013 16:39:08

HandleReference:  Address=7000003f55c3d38 Handle=0 Flags=[00]

LockInstance:  id='LB566b232f34009a84' GlobalEnqueue=0 ReleaseCount=0

PinInstance:  id='NB566b232f34009a84' GlobalEnqueue=0

LibraryObject:  Address=7000003b5546fa0 HeapMask=0000-0001-0001-0000 Flags=EXS/LOC[0004] Flags2=[0000] PublicFlags=[0000]

 DataBlocks:  

   Block:  #='0' name=KGLH0^20d7264d pins=0 Change=NONE  

     Heap=7000003f4cf3fe8 Pointer=7000003b5547040 Extent=7000003b5546f20 Flags=I/-/P/A/-/-

     FreedLocation=0 Alloc=0.257812 Size=4.000000 LoadTime=44819572096 DDE: Problem Key 'ORA 600 [kqlnrc_1]' was flood controlled (0x2) (incident: 28378)

ORA-00600: 内部错误代码, 参数: [kqlnrc_1], [0x7000003F55C3B60], [], [], [], [], [], [], [], [], [], []

原因就是同义词失效:参考TRRACE中下面这句:

ObjectName:  Name=ABC.DEF@GH  

 FullHashValue=566b232f34009a84471734df20d7264d Namespace=TABLE/PROCEDURE(01) Type=SYNONYM(05) Identifier=0 OwnerIdn=2147483644

Statistics:  InvalidationCount=2 ExecutionCount=0 LoadCount=1 ActiveLocks=1 TotalLockCount=6 TotalPinCount=6

可以重建  ABC.DEF@GH,如没用就删除了拉倒。

####################################################

附参考MOS文档:How To Find The Object That Causing ORA-600 [kqlnrc_1] (文档 ID 1190673.1)

本栏目更多精彩内容:http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

时间: 2025-01-20 18:30:18

ORA-00600内部错误代码:参数: [kqlnrc_1]的相关文章

Cause: java.sql.SQLException: ORA-00600: 内部错误代码, 参数: [6305]

问题描述 Cause:java.sql.SQLException:ORA-00600:内部错误代码,参数:[6305]求解这是什么错误,网上说是jar包冲突,参数6305表示什么呢?

ORACLE ORA-00600: 内部错误代码, 参数: [kokbcvb1]与merge into

                          >><>>                                                                         >                                                                                                                                    

ORA—00904:“某个参数或者变量名”:标识符无效

点击打开链接

[20131027]11G的内部视图X$DBGALERTEXT.txt

[20131027]11G的内部视图X$DBGALERTEXT.txt 链接:http://www.askmaclean.com/archives/11g%E6%96%B0%E7%89%B9%E6%80%A7xdbgalertext%E4%B8%80%E4%B8%AA%E5%BE%88%E9%85%B7%E7%9A%84%E5%86%85%E9%83%A8%E8%A7%86%E5%9B%BE.html 以前我们看alert*.log文件,一般直接进入目录,直接查看.当然也可以通过外部表来访问al

oracle block 格式

oracle 信息参考:  www.ixora.com.au 特别感谢 overtime 大哥对我的无私的帮助和对我一直鼓励支持我的网友这些资料是没得到oracle 支持的 所以不能保证信息的正确性 请谨慎使用 科技无限 随便转载 oracle 8.1.7         8k block          windows xp    create table t(n number);insert into t values(1);   --- 从 dbms_rowid 中看出table t 的

oracle非归档遭遇ora-00600 [kcratr_nab_less_than_odr]的恢复

主要遇到了如下几个问题: 1. mount 发现控制文件异常,通过替换,用pfile mount成功,这个不说了. 2. open报了一个如下的错误: Fri Jul 04 20:03:23 2014 alter database open Beginning crash recovery of 1 threads  parallel recovery started with 15 processes Started redo scan Completed redo scan  read 22

oracle数据库强制关机导致数据库无法正常启动恢复例子

有客户qq找到我,说有朋友推荐,让我帮他们恢复数据库.由于强制关机后,数据库无法正常启动. 数据库recover database失败 Mon Mar 28 10:20:33 2016 ALTER DATABASE RECOVER  database  Media Recovery Start  started logmerger process Parallel Media Recovery started with 32 slaves Mon Mar 28 10:20:36 2016 Rec

oracle数据库insert into aud$引起高版本问题导致ORA-600[17059]

昨天晚上有朋友咨询我,他数据库(win2008 11.2.0.1 单机)出现大量ORA-00600[17059],如下错误,让帮忙分析原因 alert日志报错 Sat Mar 19 21:31:02 2016 Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_3336.trc  (incident=45304): ORA-00600: 内部错误代码, 参数: [17059], [0x49BE74CB0]

oracle故障恢复成功之后报错ORA-600 4155问题

联系:手机(13429648788) QQ(107644445)QQ咨询惜分飞 标题:http://www.xifenfei.com/2015/11/分享某客户存储异常恢复之后oracle故障恢复案例.html 某客户使用win 2003,Oracle 11.2.0.1+ASM架构方式,由于存储异常并且做了存储恢复之后,ASM可以正常mount起来,但是数据库无法打开 使用dbv检查system发现有少量坏块 DBVERIFY - 开始验证: FILE = +DATA/xifenfei/data