ORA-00600: 内部错误代码, 参数: [kqlnrc_1]
来源:互联网 发布:淘宝直通车神图 编辑:程序博客网 时间:2024/05/29 02:24
报错如下:
Mon Mar 31 18:45:59 2014Errors 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@GHFullHashValue=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)
0 0
- ORA-00600: 内部错误代码, 参数: [kqlnrc_1]
- ora-00600 内部错误代码 参数:.........
- ORA-00600: 内部错误代码, 参数: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: 内部错误代码, 参数: [qkacon:NFswrwo]
- ORA-00600: 内部错误代码, 参数: [evapls1], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码,参数: [qctcte1], [0], [], [], [], [], [], []
- ORA-00600: 内部错误代码,参数[qerpfAllocateR], [], [], [], [], [],
- ora-00600: 内部错误代码, 参数: [4415], [], [], [], [], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码,参数: [kcratr1_lostwrt], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], []
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: 内部错误代码, 参数: [kkdoilsn1]
- ORA-00600 内部错误代码, 参数 [kdsgrp1]
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: 内部错误代码, 参数: [kdsgrp1]
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: 内部错误代码, 参数: [evapls1], [], [], [], [], [], [], []
- 如何修改oracle数据库默认DATE显示方式
- BW删除转换后,释放请求时报错,怎么破?
- Mina学习之IoBuffer
- 直线Bresenham算法
- DropDownList插入数据
- ORA-00600: 内部错误代码, 参数: [kqlnrc_1]
- 深入理解JavaScript中的this关键字
- js控制播放器
- Android实现程序自动更新实例教程
- Oracle SQL 内置函数大全
- 找出字符串中所有重复的字符及其重复次数
- 转一个各种排序的动画
- 修改tomcat编码格式
- 用typedef简化字符串操作