-
加我微信
加我QQ
标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-01595 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,756)
- DB2 (22)
- MySQL (76)
- Oracle (1,598)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (163)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (69)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (588)
- Oracle安装升级 (96)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (84)
- PostgreSQL (30)
- pdu工具 (6)
- PostgreSQL恢复 (9)
- SQL Server (32)
- SQL Server恢复 (13)
- TimesTen (7)
- 达梦数据库 (3)
- 达梦恢复 (1)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (39)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (22)
-
最近发表
- Oracle Recovery Tools恢复案例总结—202505
- ORA-600 kddummy_blkchk 数据库循环重启
- 记录一次asm disk加入到vg通过恢复直接open库的案例
- CHECKDB 发现了 N 个分配错误和 M 个一致性错误
- 达梦数据库dm.ctl文件异常恢复
- Oracle Recovery Tools修复ORA-00742、ORA-600 ktbair2: illegal inheritance故障
- 可能是 tempdb 空间用尽或某个系统表不一致故障处理
- 11.2.0.4库中遇到ORA-600 kcratr_nab_less_than_odr报错
- [MY-013183] [InnoDB] Assertion failure故障处理
- Oracle 19c 202504补丁（RUs+OJVM）-19.27
- Oracle Recovery Tools修复ORA-600 6101/kdxlin:psno out of range故障
- pdu完美支持金仓数据库恢复(KingbaseES)
- 虚拟机故障引起ORA-00310 ORA-00334故障处理
- pg创建gbk字符集库
- PostgreSQL运行日志管理
- ora-600 kdsgrp1 错误描述
- GAM、SGAM 或 PFS 页上存在页错误处理
- ORA-600 krhpfh_03-1208
- VMware勒索加密恢复(vmdk勒索恢复)
- ORA-39773: parse of metadata stream failed故障处理
分类目录归档：ORA-xxxxx
ORA-600 ktbsdp2 处理
客户反馈数据库异常:两个节点rac,两个节点都启动,其中一个节点无法正常open,另外一个节点一段时间后也会挂。以下是无法正常open节点报错信息(正常open节点最终挂掉报错信息也是类似)
2022-03-30T19:19:12.870813+08:00 [84321] Successfully onlined Undo Tablespace 4. Undo initialization finished serial:0 start:1728252021 end:1728256302 diff:4281 ms (4.3 seconds) Verifying minimum file header compatibility for tablespace encryption.. Verifying file header compatibility for tablespace encryption completed for pdb 0 2022-03-30T19:19:13.953252+08:00 Database Characterset is ZHS16GBK 2022-03-30T19:19:14.538155+08:00 Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_p02o_85718.trc (incident=1093927): ORA-00600: internal error code, arguments: [ktbsdp2], [18446744073709551615], [], [], [], [], [], [], [], [], [], [] Incident details in: /oracle/app/oracle/diag/rdbms/xff/xff2/incident/incdir_1093927/xff2_p02o_85718_i1093927.trc 2022-03-30T19:19:15.536582+08:00 ORACLE Instance xff2 (pid = 57) - Error 607 encountered while recovering transaction (73, 12) on object 112841. 2022-03-30T19:19:33.699944+08:00 Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_smon_84007.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [ktbsdp2], [18446744073709551615], [], [], [], [], [], [], [], [], [], [] 2022-03-30T19:19:34.673840+08:00 Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_smon_84007.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [ktbsdp2], [18446744073709551615], [], [], [], [], [], [], [], [], [], [] 2022-03-30T19:19:34.673954+08:00 Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_smon_84007.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [ktbsdp2], [18446744073709551615], [], [], [], [], [], [], [], [], [], [] Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_smon_84007.trc (incident=1092704): ORA-607 [] [] [] [] [] [] [] [] [] [] [] [] Incident details in: /oracle/app/oracle/diag/rdbms/xff/xff2/incident/incdir_1092704/xff2_smon_84007_i1092704.trc 2022-03-30T19:19:35.422779+08:00 ***************************************************************** An internal routine has requested a dump of selected redo. This usually happens following a specific internal error, when analysis of the redo logs will help Oracle Support with the diagnosis. It is recommended that you retain all the redo logs generated (by all the instances) during the past 12 hours, in case additional redo dumps are required to help with the diagnosis. ***************************************************************** 2022-03-30T19:19:36.154689+08:00 Starting background process GTX0 2022-03-30T19:19:36.169007+08:00 GTX0 started with pid=370, OS id=87409 2022-03-30T19:19:36.645876+08:00 USER (ospid: 84007): terminating the instance due to error 607 2022-03-30T19:19:36.680109+08:00 opiodr aborting process unknown ospid (87439) as a result of ORA-1092 2022-03-30T19:19:36.681091+08:00 ORA-1092 : opitsk aborting process 2022-03-30T19:19:36.740357+08:00 System state dump requested by (instance=2, osid=84007 (SMON)), summary=[abnormal instance termination]. System State dumped to trace file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_diag_83895_20220330191936.trc 2022-03-30T19:19:40.135579+08:00 Instance terminated by USER, pid = 84007
对于上述报错信息分析,初步判断是由于事务异常导致,查询mos发现类似报错Bug 32208691 – After upgrade from 12.1 to 19.3 drop columns fails ORA-600[ktbsdp2] ORA-600[4512] (Doc ID 32208691.8),通过咨询客户,确认他们这边是通过plsql dev工具对id为112841表进行增加列的时候网络中断导致增加失败,后续我尝试对该表进行查询发现也报该错误,基本上可以确认由于该表事务异常导致,通过dul把该表数据恢复,然后drop 该表,数据库启动正常,未见其他报错,通过hcheck检查,数据库字典基本一致(除一些统计信息异常,原则上不影响数据库运行)
[oracle@xifenfei2 ~]$ sqlplus / as sysdba @hcheck.sql
SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 31 00:38:32 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
HCheck Version 07MAY18 on 31-MAR-2022 00:38:34
----------------------------------------------
Catalog Version 12.2.0.1.0 (1202000100)
db_name: xff
Is CDB?: NO
Catalog Fixed
Procedure Name Version Vs Release Timestamp
Result
------------------------------ ... ---------- -- ---------- --------------
------
.- LobNotInObj ... 1202000100 <= *All Rel* 03/31 00:38:34 PASS
.- MissingOIDOnObjCol ... 1202000100 <= *All Rel* 03/31 00:38:34 PASS
.- SourceNotInObj ... 1202000100 <= *All Rel* 03/31 00:38:34 PASS
.- OversizedFiles ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS
.- PoorDefaultStorage ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS
.- PoorStorage ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS
.- TabPartCountMismatch ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS
.- OrphanedTabComPart ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS
.- MissingSum$ ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS
.- MissingDir$ ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS
.- DuplicateDataobj ... 1202000100 <= *All Rel* 03/31 00:38:40 PASS
.- ObjSynMissing ... 1202000100 <= *All Rel* 03/31 00:38:42 PASS
.- ObjSeqMissing ... 1202000100 <= *All Rel* 03/31 00:38:42 PASS
.- OrphanedUndo ... 1202000100 <= *All Rel* 03/31 00:38:44 PASS
.- OrphanedIndex ... 1202000100 <= *All Rel* 03/31 00:38:44 PASS
.- OrphanedIndexPartition ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- OrphanedIndexSubPartition ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- OrphanedTable ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- OrphanedTablePartition ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- OrphanedTableSubPartition ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- MissingPartCol ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- OrphanedSeg$ ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- OrphanedIndPartObj# ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- DuplicateBlockUse ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- FetUet ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- Uet0Check ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- SeglessUET ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- BadInd$ ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- BadTab$ ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- BadIcolDepCnt ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- ObjIndDobj ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- TrgAfterUpgrade ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- ObjType0 ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- BadOwner ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- StmtAuditOnCommit ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS
.- BadPublicObjects ... 1202000100 <= *All Rel* 03/31 00:38:46 PASS
.- BadSegFreelist ... 1202000100 <= *All Rel* 03/31 00:38:50 PASS
.- BadDepends ... 1202000100 <= *All Rel* 03/31 00:38:50 PASS
.- CheckDual ... 1202000100 <= *All Rel* 03/31 00:38:57 PASS
.- ObjectNames ... 1202000100 <= *All Rel* 03/31 00:38:57 WARN
HCKW-0018: OBJECT name clashes with SCHEMA name (Doc ID 2363142.1)
Schema=MHWZ PACKAGE=MHWZ.MHWZ
Schema=MHWZ PACKAGE BODY=MHWZ.MHWZ
.- BadCboHiLo ... 1202000100 <= *All Rel* 03/31 00:39:01 WARN
HCKW-0019: HIST_HEAD$.LOWVAL > HIVAL (Doc ID 1361047.1)
OBJ# 324163 INTCOL#=22
OBJ# 482668 INTCOL#=4
OBJ# 442865 INTCOL#=31
OBJ# 436924 INTCOL#=31
OBJ# 580529 INTCOL#=8
OBJ# 459432 INTCOL#=31
OBJ# 451260 INTCOL#=31
OBJ# 530980 INTCOL#=21
OBJ# 498442 INTCOL#=5
OBJ# 652114 INTCOL#=8
OBJ# 701695 INTCOL#=21
OBJ# 831961 INTCOL#=31
OBJ# 831962 INTCOL#=31
OBJ# 831963 INTCOL#=31
.- ChkIotTs ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS
.- NoSegmentIndex ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS
.- BadNextObject ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS
.- DroppedROTS ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS
.- FilBlkZero ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS
.- DbmsSchemaCopy ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS
.- OrphanedIdnseqObj ... 1202000100 > 1201000000 03/31 00:39:09 PASS
.- OrphanedIdnseqSeq ... 1202000100 > 1201000000 03/31 00:39:09 PASS
.- OrphanedObjError ... 1202000100 > 1102000000 03/31 00:39:09 PASS
.- ObjNotLob ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS
.- MaxControlfSeq ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS
.- SegNotInDeferredStg ... 1202000100 > 1102000000 03/31 00:39:13 PASS
.- SystemNotRfile1 ... 1202000100 > 902000000 03/31 00:39:13 PASS
.- DictOwnNonDefaultSYSTEM ... 1202000100 <= *All Rel* 03/31 00:39:13 PASS
.- OrphanTrigger ... 1202000100 <= *All Rel* 03/31 00:39:13 PASS
.- ObjNotTrigger ... 1202000100 <= *All Rel* 03/31 00:39:13 PASS
---------------------------------------
31-MAR-2022 00:39:13 Elapsed: 39 secs
---------------------------------------
Found 0 potential problem(s) and 16 warning(s)
Contact Oracle Support with the output and trace file
to check if the above needs attention or not
PL/SQL procedure successfully completed.
Statement processed.
Complete output is in trace file:
/oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_26887_HCHECK.trc
12c启动报kcratr_nab_less_than_odr
ORA-600 kcratr_nab_less_than_odr这个错误,以前的认知里面,主要是11.2.0.1中比较常见,这次在12c中见到了,记录下
数据库版本
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. Windows NT Version V6.1
数据库启动报错
Fri Apr 30 23:11:16 2021 Completed redo scan read 20 KB redo, 26 data blocks need recovery Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5744.trc (incident=28863): ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [6872], [23015], [23017], [], [], [], [], [], [], [] Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\incident\incdir_28863\orcl12c_ora_5744_i28863.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Fri Apr 30 23:11:17 2021 Slave encountered ORA-10388 exception during crash recovery Fri Apr 30 23:11:17 2021 Slave encountered ORA-10388 exception during crash recovery Fri Apr 30 23:11:17 2021 Aborting crash recovery due to error 600 Fri Apr 30 23:11:17 2021 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5744.trc: ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [6872], [23015], [23017], [], [], [], [], [], [], [] Fri Apr 30 23:11:17 2021 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5744.trc: ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [6872], [23015], [23017], [], [], [], [], [], [], [] ORA-600 signalled during: alter database open...
这个故障处理比较简单参考:ORA-600 kcratr_nab_less_than_odr故障解决
KGL-heap-size-exceeded报错
alert日志报错
2021-04-19T15:06:08.208159+08:00
Memory Notification: Library Cache Object loaded into SGA
Heap size 512000K exceeds notification threshold (51200K)
Details in trace file /mnt/app/diag/rdbms/xff/xff/trace/xff_ora_12300.trc
2021-04-19T15:06:08.208212+08:00
KGL object name :select DISTINCT(BEGIN_TIME) beginTime,
MILE mile,
END_TIME endTime,
LAST_TIME lastTime,
BEGIN_TIME beginTime2,
END_TIME endTime2,
TEMPERATURE1 temperature1,
TEMPERATURE2 temperature2,
TEMPERATURE3 temperature3,
TEMPERATURE4 temperature4,
LATITUDE latitude,
LONGITUDE longitude
from T_XIFENFEI
where VEHICLE_ID = :1
and END_TIME is not null
and BEGIN_TIME BETWEEN TO_DATE(:2 , 'yyyy-MM-dd hh24:mi:ss') and TO_DATE(:3 , 'yyyy-MM-dd hh24
Errors in file /mnt/app/diag/rdbms/xff/xff/trace/xff_ora_12300.trc (incident=162089):
ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded],
[0x1C4782708], [0], [524288008], [], [], [], [], [], [], [], []
Incident details in: /mnt/app/diag/rdbms/xff/xff/incident/incdir_162089/xff_ora_12300_i162089.trc
Use ADRCI or Support Workbench to package the incident.
数据库版本信息
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125 ORACLE_HOME: /mnt/app/product/12.2.0/dbhome_1 System name: Linux Node name: izbp1399kdj96ra6bjtwyxz Release: 3.10.0-693.2.2.el7.x86_64 Version: #1 SMP Tue Sep 12 22:26:13 UTC 2017 Machine: x86_64
Call Stack信息
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+119 call kgdsdst() 7FFD6CB9A258 000000002
7FFD6CB7BCC0 ? 7FFD6CB7BDD8 ?
000000000 000000082 ?
dbkedDefDump()+1200 call ksedst() 000000000 000000002 ?
7FFD6CB7BCC0 ? 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
ksedmp()+259 call dbkedDefDump() 000000003 000000002
7FFD6CB7BCC0 ? 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
dbgexPhaseII()+2130 call ksedmp() 0000003EB 000000002 ?
7FFD6CB7BCC0 ? 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
dbgexExplicitEndInc call dbgexPhaseII() 7F4853DB46C0 7F4853DB77A0
()+602 7FFD6CB9E388 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
dbgeEndDDEInvocatio call dbgexExplicitEndInc 7F4853DB46C0 7F4853DB77A0
nImpl()+658 () 7FFD6CB9E388 ? 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
kglLargeHeapWarning call dbgeEndDDEInvocatio 7F4853DB46C0 7F4853DB77A0
()+1544 nImpl() 7F4853DF49A0 7FFD6CB7BDD8 ?
7F4853DF49A0 000000082 ?
kglHeapAllocCbk()+2 call kglLargeHeapWarning 7F4853DF49A0 ? 1C4782708 ?
27 () 000000000 01F400060 ?
0B6DADD88 000000082 ?
kghalp()+1086 call kglHeapAllocCbk() 7F4853DF49A0 ? 1C4782708 ?
2EE171B70 01F400060 ?
000000058 ? 000000082 ?
kkocsRegBindEqvCtxC call kghalp() 7F4853DF49A0 ? 0B6DADD88 ?
ommon()+145 2EE171B70 ? 000000001 ?
000000058 ? 0119E7860 ?
kkocsAddBeElem()+81 call kkocsRegBindEqvCtxC 7F4853DF49A0 ? 7FFD6CB9F460 ?
1 ommon() 2EE171B70 ? 000000001 ?
000000002 ? 0119E7860 ?
kkocsProcBSensPredC call kkocsAddBeElem() 7F484E2EF998 ? 7F484E2EFAC8 ?
B()+431 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
qksopVisitPreds()+5 call kkocsProcBSensPredC 7F484E2EF998 ? 7FFD6CB9F640 ?
39 B() 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
kkocsBuildBESelCtx( call qksopVisitPreds() 7F484E2EF998 ? 7FFD6CB9F640 ?
)+153 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
kkocsBindSensCheck( call kkocsBuildBESelCtx( 7F484E2EF998 ? 7FFD6CB9F640 ?
)+585 ) 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
kkoipt()+901 call kkocsBindSensCheck( 7F484E2EFA20 ? 7FFD6CB9F640 ?
) 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
kkoqbc()+4677 call kkoipt() 7F484E31F1E0 ? 7FFD6CB9F640 ?
0BBED4798 ? 209DFEA60 ?
000000002 ? 000000000
apakkoqb()+183 call kkoqbc() 7F484E31F1E0 ? 7F4853CC2958 ?
0BBED4798 ? 209DFEA60 ?
000000001 000000000 ?
apaqbdDescendents() call apakkoqb() 7FFD6CBA1870 ? 000000EB5 ?
+503 0BBED4C18 ? 209DFEA60 ?
000000001 ? 000000000 ?
apaqbd()+136 call apaqbdDescendents() 7FFD6CBA1870 ? 7F4853CC2958 ?
0BBED4C18 ? 209DFEA60 ?
000000001 ? 000000000 ?
apadrv()+1228 call apaqbd() 7FFD6CBA1870 ? 7F4853CC2958 ?
0BBED4C18 ? 209DFEA60 ?
000000001 ? 000000000 ?
opitca()+2139 call apadrv() 0BBED4C18 ? 7F4853CC2958 ?
0BBED4C18 ? 209DFEA60 ?
000000001 ? 000000000 ?
kksFullTypeCheck()+ call opitca() 7F484E2F2A08 0BBED4C18
86 7FFD6CBA42F0 209DFEA60 ?
000000001 ? 000000000 ?
rpiswu2()+627 call kksFullTypeCheck() 7FFD6CBA2FF8 ? 0BBED4C18 ?
7FFD6CBA42F0 ? 209DFEA60 ?
000000001 ? 000000000 ?
kksLoadChild()+8003 call rpiswu2() 7FFD6CBA2FF8 ? 0BBED4C18 ?
7FFD6CBA42F0 ? 209DFEA60 ?
7FFD6CBA24F8 ? 00000006A ?
kxsGetRuntimeLock() call kksLoadChild() 7F4853DF49A0 0BBED4C18 ?
+2029 7FFD6CBA42F0 ? 209DFEA60 ?
7FFD6CBA24F8 ? 00000006A ?
kksfbc()+15091 call kxsGetRuntimeLock() 7F4853DF49A0 7F484E2F2A08
7FFD6CBA4270 209DFEA60 ?
7FFD6CBA24F8 ? 1C4782708
opiexe()+2932 call kksfbc() 7F484E2F2A08 7F484E2F2A08 ?
7FFD6CBA4270 ? 209DFEA60 ?
7FFD6CBA24F8 ? 1C4782708 ?
kpoal8()+2679 call opiexe() 000000049 7F484E2F2A08 ?
7FFD6CBA58F0 209DFEA60 ?
7FFD6CBA24F8 ? 1C4782708 ?
opiodr()+1229 call kpoal8() 00000005E 000000026
7FFD6CBA9300 209DFEA60 ?
7FFD6CBA24F8 ? 1C4782708 ?
ttcpip()+1257 call opiodr() 00000005E 000000026
7FFD6CBA9300 000000000
7FFD6CBA24F8 ? 1C4782708 ?
opitsk()+1940 call ttcpip() 7F4853E11750 ? 000000026 ?
7FFD6CBA9300 00000017D ?
7FFD6CBA8D50 7FFD6CBA955C
opiino()+941 call opitsk() 000000000 000000000
7FFD6CBA9300 ? 00000017D ?
7FFD6CBA8D50 ? 7FFD6CBA955C ?
opiodr()+1229 call opiino() 00000003C 000000004
7FFD6CBAAA18 00000017D ?
7FFD6CBA8D50 ? 7FFD6CBA955C ?
opidrv()+1021 call opiodr() 00000003C 000000004
7FFD6CBAAA18 000000000
7FFD6CBA8D50 ? 7FFD6CBA955C ?
sou2o()+145 call opidrv() 00000003C 000000004
7FFD6CBAAA18 000000000 ?
7FFD6CBA8D50 ? 7FFD6CBA955C ?
opimai_real()+455 call sou2o() 7FFD6CBAA9F0 00000003C
000000004 7FFD6CBAAA18
7FFD6CBA8D50 ? 7FFD6CBA955C ?
ssthrdmain()+417 call opimai_real() 000000000 7FFD6CBAAD00
000000004 ? 7FFD6CBAAA18 ?
7FFD6CBA8D50 ? 7FFD6CBA955C ?
main()+262 call ssthrdmain() 000000000 000000002
7FFD6CBAAD00 000000001
000000000 7FFD6CBA955C ?
__libc_start_main() call main() 000000000 7FFD6CBAAF38
+245 7FFD6CBAAD00 ? 000000001 ?
000000000 ? 7FFD6CBA955C ?
_start()+41 call __libc_start_main() 000D04D40 000000002
7FFD6CBAAF38 7F484F241555 ?
000000000 ? 7FFD6CBA955C ?
--------------------- Binary Stack Dump ---------------------
根据官方描述,该问题是由于Bug 20917487 – CORRUPT KKOCS STRUCTURES AFTER PARTIAL PURGE OF CURSOR HEAP引起
解决方案：
1. 升级数据库到19.1+版本
2. 应用 Patch 20917487
3. Disable adaptive cursor sharing
alter system set "_optimizer_adaptive_cursor_sharing" = false; alter system set "_optimizer_extended_cursor_sharing_rel" = "none";
4. 通过隐含参数设置一个足够大的值
alter system set "_kgl_large_heap_warning_threshold"=83886080 scope=spfile; --一个足够大的值 --or alter system set "_kgl_large_heap_warning_threshold"=0 scope=spfile; alter system set "_kgl_large_heap_assert_threshold"=0 scope=spfile; shutdown immediate startup
参考文档：
ORA-600 [KGL-heap-size-exceeded] Errors in the Alert Log (Doc ID 2628072.1)
Memory Notification: Library Cache Object loaded into SGA / ORA-600 [KGL-heap-size-exceeded] (Doc ID 330239.1)