ORA-00600: Internal error code, parameter: [kqlnrc_1]

Source: Internet
Author: User

Error: 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: Internal error code, parameter: [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: Internal error code, parameter: [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 file: DDE: Problem Key 'ora 600 [kqlnrc_1] 'was flood controlled (0x2) (incident: 28377)
ORA-00600: Internal error code, parameter: [kqlnrc_1], [0x7000003F55C3B60], [], [], [], [], [], [], [] [], []

LibraryHandle: Address = 7000003f55c3b60 Hash = 20d1_4d LockMode = S PinMode = S LoadLockMode = 0 Status = INVL
ObjectName: Name = ABC. DEF @ GH
FullHashValue = 566b232f34009a84471734df20d1_4d 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 = 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 ^ 20d1_4d pins = 0 Change = NONE
Heap = 7000003f4cf3fe8 Pointer = 7000003b5547040 Extent = 7000003b5546f20 Flags = I/-/P//-/-
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: Internal error code, parameter: [kqlnrc_1], [0x7000003F55C3B60], [], [], [], [], [], [], [] [], []

The cause is that the synonym is invalid. refer to the following sentence in TRRACE: ObjectName: Name = ABC. DEF @ GH
FullHashValue = 566b232f34009a84471734df20d1_4d Namespace = TABLE/PROCEDURE (01) Type = SYNONYM (05) Identifier = 0 OwnerIdn = 2147483644
Statistics: InvalidationCount = 2 ExecutionCount = 0 LoadCount = 1 ActiveLocks = 1 TotalLockCount = 6 TotalPinCount = 6
You can re-create ABC. DEF @ GH. If it is useless, delete it and pull it down.
######################################## ############
See The MOS document for reference: How To Find The Object That Causing ORA-600 [kqlnrc_1] (Document ID 1190673.1)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.