- 大量报错产生
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
经过查帖子,发现解决方案