The following error is reported:
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)