ORA-600[kqlnrc_1]

ORA-600[kqlnrc_1]

目录

• ORA-600[kqlnrc_1]
  • 1.现象
  • 2.处理

1.现象

oracle后台日志alert.log，报错

Errors in file /oracle/diag/rdbms/airxxxx/airxxxx1/trace/airxxxx1_ora_152214.trc  (incident=32162):
ORA-00600: �ڲ���������, ����: [kqlnrc_1], [0x50AA46990], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

Trace日志：

DDE: Problem Key 'ORA 600 [kqlnrc_1]' was flood controlled (0x2) (incident: 32162)
ORA-00600: , : [kqlnrc_1], [0x50AA46990], [], [], [], [], [], [], [], [], [], []

LibraryHandle:  Address=0x50aa46990 Hash=b47f860 LockMode=S PinMode=S LoadLockMode=0 Status=INVL 
  ObjectName:  Name=IT_JGXXXX.T_FXXXTLEG@FIXX_NEW_V2   
    FullHashValue=e6195dd5bf7f91e725bfc05f0b47f860 Namespace=TABLE/PROCEDURE(01) Type=SYNONYM(05) Identifier=0 OwnerIdn=2147483644 
  Statistics:  InvalidationCount=2 ExecutionCount=0 LoadCount=1 ActiveLocks=1 TotalLockCount=11 TotalPinCount=11 
  Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=11 HandleInUse=11 HandleReferenceCount=0 
  Concurrency:  DependencyMutex=0x50aa46a40(0, 13, 0, 0) Mutex=0x50aa46ad0(606, 488, 0, 6) 
  Flags=REM/PIN/TIM/[00022801] 
  WaitersLists:  
    Lock=0x50aa46a20[0x50aa46a20,0x50aa46a20] 
    Pin=0x50aa46a00[0x50aa46a00,0x50aa46a00] 
    LoadLock=0x50aa46a78[0x50aa46a78,0x50aa46a78] 
  Timestamp:  Current=05-30-2019 17:18:36 
  HandleReference:  Address=0x50aa46b78 Handle=(nil) Flags=[00] 
  LockInstance:  id='LBe6195dd5bf7f91e7' GlobalEnqueue=(nil) ReleaseCount=0 
  PinInstance:  id='NBe6195dd5bf7f91e7' GlobalEnqueue=(nil) 
  ReferenceList:  
    Reference:  Address=0xae579a80 Handle=0x149cee4d8 Flags=DEP[01] 
      Timestamp=05-30-2019 17:18:36 InvalidatedFrom=0 
  LibraryObject:  Address=0xa3e88040 HeapMask=0000-0001-0001-0000 Flags=EXS/LOC[0004] Flags2=[0000] PublicFlags=[0000] 
    DataBlocks:  
      Block:  #='0' name=KGLH0^b47f860 pins=0 Change=NONE   
        Heap=0x50954e4f8 Pointer=0xa3e880e0 Extent=0xa3e87fc0 Flags=I/-/P/A/-/- 
        FreedLocation=0 Alloc=0.257812 Size=4.000000 LoadTime=14352109710 DDE: Problem Key 'ORA 600 [kqlnrc_1]' was flood controlled (0x2) (incident: 32163)
ORA-00600: , : [kqlnrc_1], [0x50AA46990], [], [], [], [], [], [], [], [], [], []

Library中的对象失效，指向未dblink的一个同义词。dblink远端恢复以后，该错误消失。

2.处理

等待dblink的远端处理正常。