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: globalenqueue=0 releasecount=0
pininstance: 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)
本文永久更新链接地址：
，