最近大量trc日志产生 ORA-00600: 内部错误代码, 参数: [17059]

原创

程序员石磊 2021-05-12 17:00:40 ©著作权

文章标签 内部错误代码 ORA-00600 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者程序员石磊的原创作品，请联系作者获取转载授权，否则将追究法律责任

大量报错产生
trc日志

Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_10164.trc  (incident=230262):
ORA-00600: 内部错误代码, 参数: [17059], [0x2E0E6F0B0], [0x2E0E6F948], [0x2F69D37D0], [], [], [], [], [], [], [], []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_230262\orcl_ora_10164_i230262.trc
Tue Oct 29 10:24:46 2019
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_10164.trc  (incident=230263):
ORA-00600: 内部错误代码, 参数: [17059], [0x2E0E6F0B0], [0x2E0E6F948], [0x2F69D37D0], [], [], [], [], [], [], [], []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_230263\orcl_ora_10164_i230263.trc
Tue Oct 29 10:24:56 2019
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_10164.trc  (incident=230264):
ORA-00600: 内部错误代码, 参数: [17059], [0x2E0E6F0B0], [0x2E0E6F948], [0x2F69D37D0], [], [], [], [], [], [], [], []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_230264\orcl_ora_10164_i230264.trc
Tue Oct 29 10:25:06 2019
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_10164.trc  (incident=230265):
ORA-00600: 内部错误代码, 参数: [17059], [0x2E0E6F0B0], [0x2E0E6F948], [0x2F69D37D0], [], [], [], [], [], [], [], []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_230265\orcl_ora_10164_i230265.trc
Tue Oct 29 10:25:17 2019
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_10164.trc  (incident=230266):
ORA-00600: 内部错误代码, 参数: [17059], [0x2E0E6F0B0], [0x2E0E6F948], [0x2F69D37D0], [], [], [], [], [], [], [], []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_230266\orcl_ora_10164_i230266.trc
Tue Oct 29 10:25:27 2019
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_10164.trc  (incident=230267):
ORA-00600: 内部错误代码, 参数: [17059], [0x2E0E6F0B0], [0x2E0E6F948], [0x2F69D37D0], [], [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_10164.trc  (incident=230268):
ORA-00600: 内部错误代码, 参数: [17059], [0x2E0E6F0B0], [0x2E0E6F948], [0x2F69D37D0], [], [], [], [], [], [], [], []

alert.log

LibraryHandle:  Address=f69d37d0 Hash=1f181f64 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD 
  ObjectName:  Name=SELECT 1 FROM DUAL WHERE T2.C > 0  AND T1.AREA_ID = :1  AND T1.SCH_DATE_IDX = :2  AND T1.TIME_SLICE_ID = :3  AND T1.TICKET_ITEM_ID = :4  

    FullHashValue=7aa396b98ba5a7b5406963cf1f181f64 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=521674596 OwnerIdn=91 
  Statistics:  InvalidationCount=32768 ExecutionCount=0 LoadCount=32769 ActiveLocks=1 TotalLockCount=32861 TotalPinCount=1 
  Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=0 KeepHandle=0 BucketInUse=32860 HandleInUse=32860 
  Concurrency:  DependencyMutex=f69d3880(0, 92, 0, 0) Mutex=f69d38f8(25, 1080164642, 0, 6) 
  Flags=RON/PIN/TIM/PN0/DBN/[10012841] 
  WaitersLists:  
    Lock=f69d3860[f69d3860,f69d3860] 
    Pin=f69d3870[f69d3840,f69d3840] 
  Timestamp:  Current=10-29-2019 09:12:46 
  LibraryObject:  Address=e0e6f0b0 HeapMask=0000-0001-0001 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000] 
    DataBlocks:  
      Block:  #='0' name=PCUR^1f181f64 pins=0 Change=NONE   
        Heap=cf3134c8 Pointer=e0e6f198 Extent=e0e6f030 Flags=I/-/P/A/-/- 
        FreedLocation=0 Alloc=1.515625 Size=4.000000 LoadTime=6097515049 
    ChildTable:  size='32768' 
      Child:  id='0' Table=e0e6ff60 Reference=e0e6fa00 Handle=cffa3ec0 
      Child:  id='1' Table=e0e6ff60 Reference=e0e6fd00 Handle=a6188c00 
      Child:  id='2' Table=e0e6ff60 Reference=e0cc52d8 Handle=f6e88d10 
      Child:  id='3' Table=e0e6ff60 Reference=e0cc5590 Handle=15711af0 
      Child:  id='4' Table=e0e6ff60 Reference=e0cc5848 Handle=15767b28 
      Child:  id='5' Table=e0e6ff60 Reference=e0cc5b00 Handle=d7fb4120 
      Child:  id='6' Table=e0e6ff60 Reference=e0cc5db8 Handle=e5b81ad8 
      Child:  id='7' Table=e0e6ff60 Reference=ea71dc08 Handle=1507b8 
      Child:  id='8' Table=e0e6ff60 Reference=ea71dec0 Handle=e5af60b8 
      Child:  id='9' Table=e0e6ff60 Reference=ea71e178 Handle=e51d8900 
      Child:  id='10' Table=e0e6ff60 Reference=ea71e430 Handle=cf6448f0 
      Child:  id='11' Table=e0e6ff60 Reference=ea71e6e8 Handle=e526e9a0 
      Child:  id='12' Table=e0e6ff60 Reference=fea93f08 Handle=cf46daf0

alert日志太大，采用我之前Python日志分割器进行分割，代码如下

import math
i=0
filename=''
write=''
Rline = ''

def writeFile(fileName,line):
    global filename
    global write
    global Rline

    if filename!=fileName and filename=='':
        write = open('i:/logs/'+fileName+".log", 'a+')
        write.write(line)
    elif  filename!=fileName  and Rline!='':
        write.close()
    else:
        write.write(line)
        filename = fileName
    Rline = line
with open('C:/Users/ZL\Desktop/trace/orcl_ora_10244.trc','r') as infile:
    for line in infile:
        name = i/50000
        # print(math.floor(name))
        writeFile(str(math.floor(name)),line)
        i=i+1