-
加我微信
加我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 2131故障说明
oracle 12c数据库启动报ORA-600 2131错误
Mon Nov 26 09:43:57 2018 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = D:\app\Administrator alter database mount exclusive Mon Nov 26 09:44:00 2018 Using default pga_aggregate_limit of 2048 MB Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_3040.trc (incident=375524): ORA-00600: ??????, ??: [2131], [9], [8], [], [], [], [], [], [], [], [], [] Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\incident\incdir_375524\orcl12c_ora_3040_i375524.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. ORA-600 signalled during: alter database mount exclusive...
这个日志比较明显,数据库无法mount,在mount操作的时候报ORA-600 2131错误.
trace文件报错
Error: kccpb_sanity_check_2
Control file sequence number mismatch!
fhcsq: 497844 bhcsq: 497849 cfn 0 rpbn 16
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst1()+92 CALL??? skdstdst() 000000001 000004000 000030000
016301338
kccpb_sanity_check( CALL??? ksedst1() 1492761E0 0000798B4 0000798B9
)+834 000000000
kccbmp_get()+275 CALL??? kccpb_sanity_check( 000000000 000000000 000000000
) 000004000
kccsed_rbl()+174 CALL??? kccbmp_get() 000017E28 015A67E14 015592200
000000001
kccocx()+1399 CALL??? kccsed_rbl() 100000010 100000001 0000354D8
000035508
kccocf()+167 CALL??? kccocx()+528 016303990 000000000
7FF00000001 000000000
kcfcmb()+1254 CALL??? kccocf() 000000000 000000000 000000000
000000000
kcfmdb()+69 CALL??? kcfcmb() 000000000 7FF59FFF856
000000007 7FE00000000
adbdrv_options()+43 CALL??? kcfmdb() 0163083E0 14903FF2C 000000005
724 000000000
adbdrv()+149 CALL??? adbdrv_options() 000000000 000000000 0163084A0
851F2CC90B75
opiexe()+22668 CALL??? adbdrv() 7FF00000023 000000003
000000000 016309380
opiosq0()+6009 CALL??? opiexe() 000000000 000000000 016309990
000000000
kpooprx()+410 CALL??? opiosq0() 000000003 000000000 000000000
0000000A4
kpoal8()+994 CALL??? kpooprx() 0146A57FC 000000001 0146A5820
000000001
opiodr()+1601 CALL??? kpoal8() 000000000 015523288 015523270
0159FCDD0
ttcpip()+1223 CALL??? opiodr() 7FE0000005E 00000001F
01630DA20 7FE00000000
opitsk()+2160 CALL??? ttcpip() 0146C0690 000000000 000000000
000000000
opiino()+1079 CALL??? opitsk() 000000007 000000000 01630F200
01630E970
opiodr()+1601 CALL??? opiino() 00000003C 000000000 01630F470
000000000
opidrv()+842 CALL??? opiodr() 00000003C 000000004 01630F470
000000000
sou2o()+94 CALL??? opidrv()+156 10000003C 7FE00000004
01630F470 0154E6A30
opimai_real()+276 CALL??? sou2o() 1D4851F4C467583 00A9D55E0
8001A000B07E2 1004B0039001E
opimai()+170 CALL??? opimai_real() 000000000 851F2CB1B179
00A9D55E0 01630F628
OracleThreadStart() CALL??? opimai() 000000000 149031F90 000000050
+713 0000005C8
00000000775259CD CALL??? OracleThreadStart() 000000000 000000000 000000000
000000000
000000007765A561 CALL??? 00000000775259C0 000000000 000000000 000000000
000000000
--------------------- Binary Stack Dump ---------------------
这个错误和以往版本中的kccpb_sanity_check_2比较类似,由于数据库异常关闭导致ctl写丢失导致
ORA-600 2131/kccpb_sanity_check_2解释
DESCRIPTION: This internal error is raised when the sequence number (seq#) of the current block of the controlfile is greater than the seq# in the controlfile header. The header value should always be equal to, or greater than the value held in the control file block(s). This extra check was introduced in Oracle 10gR2 to detect lost writes or stale reads to the header. ARGUMENTS: Arg [a] seq# in control block header. Arg [b] seq# in the control file header. Arg 1 FUNCTIONALITY: Kernel Cache layer Control file component.
ORA-00600 dbkif_find_next_record_1
数据库版本信息
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for 64-bit Windows: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production
数据库启动报ORA-00600 dbkif_find_next_record_1错误
alter database open Beginning crash recovery of 1 threads parallel recovery started with 3 processes Started redo scan Completed redo scan read 133 KB redo, 72 data blocks need recovery Started redo application at Thread 1: logseq 49070, block 14720 Recovery of Online Redo Log: Thread 1 Group 2 Seq 49070 Reading mem 0 Mem# 0: D:\APP\xff\ORADATA\ORCL\REDO02.LOG Completed redo application of 0.09MB Errors in file d:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_ora_2340.trc (incident=477756): ORA-00600: ??????, ??: [dbkif_find_next_record_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\app\xff\diag\rdbms\orcl\orcl\incident\incdir_477756\orcl_ora_2340_i477756.trc Wed Sep 26 10:52:07 2018 Trace dumping is performing id=[cdmp_20180926105207] Wed Sep 26 10:52:08 2018 Aborting crash recovery due to error 600 Errors in file d:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_ora_2340.trc: ORA-00600: ??????, ??: [dbkif_find_next_record_1], [], [], [], [], [], [], [], [], [], [], [] Errors in file d:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_ora_2340.trc: ORA-00600: ??????, ??: [dbkif_find_next_record_1], [], [], [], [], [], [], [], [], [], [], [] ORA-600 signalled during: alter database open...
这里比较明显，数据库是在做实例恢复的时候遭遇到ORA-600 dbkif_find_next_record_1错误,无法正常应用日志导致该错误,具体原因由于:the NAB and finds it is less than the block# from the on-disk-RBA recorded，对于这种问题，通过人工修改next available block# in the Online Redo Log的相关记录,即可正常open数据库,而且理论上数据0丢失
ORA-07445 qcdlgcd
SQL执行报ORA-03113错误
SQL> SELECT * FROM USER.TABLE_NAME t WHERE t.YEAR = '2019' AND t.UPPCODE = '51010000' AND t.MONTH = '01'; 2 3 4 5 SELECT * * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 68389 Session ID: 2419 Serial number: 34370
数据库版本等信息
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options ORACLE_HOME = /oracle/product/db12cr1 System name: Linux Node name: Tkfcsdb Release: 2.6.32-431.el6.x86_64 Version: #1 SMP Sun Nov 10 22:19:54 EST 2013 Machine: x86_64
alert日志报错
Thu Sep 27 17:41:15 2018 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0xCDFB0C6, qcdlgcd()+70] [flags: 0x0, count: 1] Errors in file /oracle/diag/rdbms/tst12uf/tst12uf/trace/tst12uf_ora_234433.trc (incident=126129) (PDBNAME=PTST12UF): ORA-07445:exception encountered:core dump[qcdlgcd()+70][SIGSEGV][ADDR:0x4][PC:0xCDFB0C6][Address not mapped to object][] Incident details in: /oracle/diag/rdbms/tst12uf/tst12uf/incident/incdir_126129/tst12uf_ora_234433_i126129.trc Use ADRCI or Support Workbench to package the incident.
trace文件
----- Beginning of Customized Incident Dump(s) -----
Dumping swap information
Memory (Avail / Total) = 948.73M / 63736.63M
Swap (Avail / Total) = 30025.52M / 32255.99M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0xCDFB0C6, qcdlgcd()+70] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000000 %rbx: 0x000000020c3da3f0 %rcx: 0x00007fc492268a40
%rdx: 0x00007fc49239eab0 %rdi: 0x000000022cd5da20 %rsi: 0x00007fc492f2bc80
%rsp: 0x00007fffbd9c9430 %rbp: 0x00007fffbd9c94a0 %r8: 0x00000002372efcb8
%r9: 0x000000022cd5da20 %r10: 0x00007fc49239eab0 %r11: 0x00007fc492268a40
%r12: 0x000000022cd5da20 %r13: 0x00007fc492f2bc80 %r14: 0x00007fc49239eab0
%r15: 0x00007fc492268a40 %rip: 0x000000000cdfb0c6 %efl: 0x0000000000010206
qcdlgcd()+53 (0xcdfb0b5) mov %rdi,%r12
qcdlgcd()+56 (0xcdfb0b8) mov 0x10(%rax),%rbx
qcdlgcd()+60 (0xcdfb0bc) jz 0xcdfb29e
qcdlgcd()+66 (0xcdfb0c2) mov 0x60(%r15),%rax
> qcdlgcd()+70 (0xcdfb0c6) movzwl 0x4(%rax),%r8d
qcdlgcd()+75 (0xcdfb0cb) cmp $30,%r8d
qcdlgcd()+79 (0xcdfb0cf) jnle 0xcdfb277
qcdlgcd()+85 (0xcdfb0d5) pxor %xmm0,%xmm0
qcdlgcd()+89 (0xcdfb0d9) movaps %xmm0,-0x40(%rbp)
*** 2018-09-27 17:41:15.110
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=52chysuyh36t4) -----
SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune
no_monitoring optimizer_features_enable(default)
no_parallel result_cache(snapshot=3600) */
SUM(C1) FROM (SELECT /*+ qb_name("innerQuery")
NO_INDEX_FFS( "T") */ 1 AS C1 FROM "USER"."TABLE_NAME" "T"
WHERE ("T"."MONTH"='01') AND ("T"."UPPCODE"='51010000') AND ("T"."YEAR"='2019')) innerQuery
[TOC00004-END]
[TOC00005]
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+45 call kgdsdst() 7FC492BAB678 000000003
7FC492B8D0B0 ? 7FC492B8D1C8 ?
7FC492BAAEA8 ? 000000083 ?
ksedst()+119 call skdstdst() 7FC492BAB678 000000001
000000001 7FC492B8D1C8 ?
7FC492BAAEA8 ? 000000083 ?
dbkedDefDump()+1119 call ksedst() 000000001 000000001 ?
000000001 ? 7FC492B8D1C8 ?
7FC492BAAEA8 ? 000000083 ?
ksedmp()+261 call dbkedDefDump() 000000003 000000003
000000001 ? 7FC492B8D1C8 ?
7FC492BAAEA8 ? 000000083 ?
ssexhd()+2650 call ksedmp() 00000044F 000000003 ?
000000001 ? 000000003
7FC492BAAEA8 ? 000000083 ?
sslsshandler()+456 call ssexhd() 202F206C69617641
3D20296C61746F54
4D33372E38343920
3633373336202F20
6177530A4D33362E 000000083 ?
__sighandler() call sslsshandler() 000002000 000000000 000000000
3633373336202F20 ?
6177530A4D33362E ?
000000083 ?
qcdlgcd()+70 signal __sighandler() 22CD5DA20 7FC492F2BC80
7FC49239EAB0 7FC492268A40 ?
2372EFCB8 ? 22CD5DA20 ?
kkdlgcd()+118 call qcdlgcd() 22CD5DA20 ? 7FC492F2BC80 ?
7FC49239EAB0 ? 7FC492268A40 ?
2372EFCB8 ? 22CD5DA20 ?
kkmfbtic()+17 call kkdlgcd() 7FC49239EAB0 ? 7FC492268A40 ?
7FC49239EAB0 ? 7FC492268A40 ?
2372EFCB8 ? 22CD5DA20 ?
qcsgcic()+163 call kkmfbtic() 7FC49239EAB0 ? 7FC492268A40 ?
7FC49239EAB0 ? 7FC492268A40 ?
2372EFCB8 ? 22CD5DA20 ?
kkmgkc()+147 call qcsgcic() 22CD5DA20 ? 7FC492F2BC80 ?
7FC49239EAB0 ? 7FC492268A40 ?
000000007 22CD5DA20 ?
kokscit()+65 call kkmgkc() 22CD5DA20 ? 7FC492F2BC80 ?
7FC49239EAB0 ? 7FC492268A40 ?
000000007 ? 22CD5DA20 ?
qkebCreateColById() call kokscit() 22CD5DA20 ? 7FC492F2BC80 ?
+298 7FC49239EAB0 ? 7FC492268A40 ?
000000007 ? 22CD5DA20 ?
qksvcGetGuardCol()+ call qkebCreateColById() 000000002 7FC4923A4078
161 7FC49239EAB0 ? 000000007 ?
7FC492268A40 ? 22CD5DA20 ?
qksvcProcessVCColum call qksvcGetGuardCol() 7FC49239D9D8 ? 7FC4923A4078 ?
ns()+1625 7FC49239EAB0 ? 000000007 ?
7FC492268A40 ? 22CD5DA20 ?
qkacol()+405 call qksvcProcessVCColum 000000000 ? 000000000 ?
ns() 7FC49239EAB0 ? 000000007 ?
7FC492268A40 ? 22CD5DA20 ?
qkadrv()+933 call qkacol() 7FC49239EAB0 ? 000000000 ?
7FC49239EAB0 ? 000000007 ?
7FC492268A40 ? 22CD5DA20 ?
opitca()+2417 call qkadrv() 7FC4923A4078 ? 000000001 ?
7FC49239EAB0 ? 000000007 ?
7FC492268A40 ? 22CD5DA20 ?
kksFullTypeCheck()+ call opitca() 7FC4922F4BD0 22CD5DC40
79 7FFFBD9CF3B0 000000007 ?
7FC492268A40 ? 22CD5DA20 ?
rpiswu2()+2235 call kksFullTypeCheck() 7FFFBD9CDF08 ? 22CD5DC40 ?
7FFFBD9CF3B0 ? 000000007 ?
7FC492268A40 ? 22CD5DA20 ?
kksLoadChild()+7590 call rpiswu2() 7FFFBD9CDF08 ? 22CD5DC40 ?
7FFFBD9CF3B0 ? 000000008 ?
7FC492F5D260 ? 22CD5DA20 ?
kxsGetRuntimeLock() call kksLoadChild() 7FFFBD9CDF08 ? 22CD5DC40 ?
+2155 000000000 000000008 ?
7FC492F5D260 ? 22CD5DA20 ?
kksfbc()+14306 call kxsGetRuntimeLock() 7FC492F2BC80 7FC4922F4BD0
7FFFBD9CF330 22D1E7C28 ?
7FC492F5D260 ? 22D1E7C28
kkspsc0()+3146 call kksfbc() 7FC4922F4BD0 7FC4922F4BD0 ?
7FFFBD9CF330 ? 22D1E7C28 ?
7FC492F5D260 ? 22D1E7C28 ?
kksParseCursor()+11 call kkspsc0() 7FC4928321A0 7FC49235D198
8 00000015F 000000003 000000006
000000020
opiosq0()+2210 call kksParseCursor() 7FFFBD9D0178 ? 7FC49235D198 ?
00000015F ? 000000003 ?
000000006 ? 000000020 ?
opiall0()+4530 call opiosq0() 000000003 7FC49235D198 ?
7FC492F5D260 ? 000000020
000000000 000000020 ?
opikpr()+567 call opiall0() 000000003 ? 000000022
7FFFBD9D0A50 000000000
000000000 ? 000000020 ?
opiodr()+1165 call opikpr() 000000065 ? 000000022 ?
7FFFBD9D22F0 000000000 ?
000000000 ? 000000020 ?
rpidrus()+206 call opiodr() 000000065 00000001F
7FFFBD9D22F0 ? 000000000 ?
000000000 ? 100000001
skgmstack()+144 call rpidrus() 7FFFBD9D1B70 00000001F ?
7FC492F2BE78 000000000 ?
000000000 ? 100000001 ?
rpiswu2()+723 call skgmstack() 7FFFBD9D1B48 ? 7FC492F2B7A0 ?
00000F618 ? 00CBFE570 ?
7FFFBD9D1B70 ? 100000001 ?
kprball()+1163 call rpiswu2() 7FFFBD9D1B48 ? 7FC492F2B7A0 ?
00000F618 ? 000000002 ?
7FC492F5D260 ? 100000001 ?
qksdsExeStmt()+2411 call kprball() 7FFFBD9D22F0 004000180
00000F618 ? 000000002 ?
7FC492F5D260 ? 100000001 ?
qksdsExecute()+959 call qksdsExeStmt() 7FFFBD9D2B98 7FC49235D150
000000001 000000008
7FFFBD9D28C8 100000001 ?
kkoatVerifyEst()+30 call qksdsExecute() 7FFFBD9D2B98 7FC49235D150 ?
85 000000001 ? 000000008 ?
7FFFBD9D28C8 ? 100000001 ?
kkeAdjSingTabCard() call kkoatVerifyEst() 300000001 7FC4923E9DA8
+714 1EE909D75846 7FC49235D108
000000000 100000001 ?
kkecdn()+3803 call kkeAdjSingTabCard() 7FC4923E9DA8 7FC4923EA328
7FFFBD9D2E30 ? 7FC49235D108 ?
000000000 ? 100000001 ?
kkotap()+13019 call kkecdn() 7FC4923ECF08 000000003 ?
7FFFBD9D2E30 ? 7FC4923EA328 ?
000000000 ? 100000001 ?
kkoiqb()+8331 call kkotap() 7FC492F5D260 ? 000000000 ?
000000011 000000000 000000000
100000001 ?
kkooqb()+532 call kkoiqb() 000000000 ? 000000000
000000000 000000000 ?
000000000 ? 100000001 ?
kkoqbc()+2385 call kkooqb() 7FC4927F8BC0 ? 000000006
000000000 ? 000000000 ?
000000000 ? 100000001 ?
apakkoqb()+182 call kkoqbc() 7FC4927F8BC0 ? 7FC4927F8BC0 ?
000000001 000000000 ?
000000000 ? 100000001 ?
apaqbdDescendents() call apakkoqb() 000000000 ? 7FC4927F8BC0 ?
+488 21EE306B8 ? 000000000 ?
000000000 ? 100000001 ?
apadrv()+5383 call apaqbdDescendents() 7FFFBD9DC2B0 ? 7FC4927F8BC0 ?
21EE306B8 ? 000000000 ?
000000000 ? 100000001 ?
opitca()+2106 call apadrv() 21EE306B8 ? 7FC4927F8BC0 ?
21EE306B8 ? 000000000 ?
000000000 ? 100000001 ?
kksLoadChild()+7318 call opitca() 7FC492845648 21EE306B8
7FFFBD9DE6F0 000000000 ?
000000000 ? 100000001 ?
kxsGetRuntimeLock() call kksLoadChild() 7FC492845648 ? 21EE306B8 ?
+2155 000000000 000000000 ?
000000000 ? 100000001 ?
kksfbc()+14306 call kxsGetRuntimeLock() 7FC492F2BC80 7FC492845648
7FFFBD9DE670 232AE3E98 ?
000000000 ? 232AE3E98
kkspsc0()+3146 call kksfbc() 7FC492845648 7FC492845648 ?
7FFFBD9DE670 ? 232AE3E98 ?
000000000 ? 232AE3E98 ?
kksParseCursor()+11 call kkspsc0() 7FC492832108 7FFFBD9E0A28
8 000000081 000000003 000000006
0000000A4
opiosq0()+2210 call kksParseCursor() 7FFFBD9DF4B8 ? 7FFFBD9E0A28 ?
000000081 ? 000000003 ?
000000006 ? 0000000A4 ?
kpoal8()+1223 call opiosq0() 000000003 7FFFBD9E0A28 ?
7FC492F5D260 ? 0000000A4
000000000 0000000A4 ?
opiodr()+1165 call kpoal8() 00000005E 00000001F
7FFFBD9E3278 0000000A4 ?
000000000 ? 0000000A4 ?
ttcpip()+2699 call opiodr() 00000005E 00000001F
7FFFBD9E3278 ? 0000000A4 ?
000000000 ? 100000000
opitsk()+1734 call ttcpip() 7FC492F41070 ? 00000005E ?
7FFFBD9E3278 000000000 ?
7FFFBD9E2CD8 7FFFBD9E3484
opiino()+945 call opitsk() 000000400 000000000
7FFFBD9E3278 ? 000000000 ?
7FFFBD9E2CD8 ? 7FFFBD9E3484 ?
opiodr()+1165 call opiino() 00000003C 000000004
7FFFBD9E4918 000000000 ?
7FFFBD9E2CD8 ? 7FFFBD9E3484 ?
opidrv()+587 call opiodr() 00000003C 000000004
7FFFBD9E4918 ? 000000000 ?
7FFFBD9E2CD8 ? 000000000
sou2o()+145 call opidrv() 00000003C 000000004
7FFFBD9E4918 000000000 ?
7FFFBD9E2CD8 ? 000000000 ?
opimai_real()+154 call sou2o() 7FFFBD9E48F0 00000003C
000000004 7FFFBD9E4918
7FFFBD9E2CD8 ? 000000000 ?
ssthrdmain()+412 call opimai_real() 000000000 7FFFBD9E4C00
000000004 ? 7FFFBD9E4918 ?
7FFFBD9E2CD8 ? 000000000 ?
main()+236 call ssthrdmain() 000000000 000000002
7FFFBD9E4C00 000000001
000000000 000000000 ?
__libc_start_main() call main() 7FFFBD9E559F 7FFFBD9E55AD
+253 7FFFBD9E4C00 ? 000000001 ?
000000000 ? 000000000 ?
_start()+41 call __libc_start_main() 000BBD640 000000002
7FFFBD9E4E48 000000000 ?
000000000 ? 000000000 ?
[TOC00005-END]
[TOC00006]
--------------------- Binary Stack Dump ---------------------
解决方法
这里比较明显,我们可以发现这个sql执行报错，其实本质是由于递归执行动态采样报错而引起异常的.通过设置_fix_control来规避这个问题
SQL> alter session set "_fix_control"='14191778:0';
Session altered.
SQL> SELECT *
FROM USER.TABLE_NAME t
WHERE t.YEAR = '2019'
AND t.UPPCODE = '51010000'
AND t.MONTH = '01';
2 3 4 5
ID EMPCODE COMCODE YEAR QUARTER
---------- -------------------- -------------------- ---------- ----------
PUSHRATIO D A CREATECODE UPDATECODE CREATEDATE
---------- - - -------------------- -------------------- -------------------
UPDATEDATE UPPCODE CLAIM MONTH
------------------- -------------------- -------------------- ----------
77813 5101000166 51010702 2019 1
50 0 0 1777 2018-07-18 17:44:19
51010000 50 01
77909 8000545245 51010702 2019 1
0 0 0 1777 1777 2018-07-18 17:35:12
2018-07-18 17:41:20 51010000 100 01
ID EMPCODE COMCODE YEAR QUARTER
---------- -------------------- -------------------- ---------- ----------
PUSHRATIO D A CREATECODE UPDATECODE CREATEDATE
---------- - - -------------------- -------------------- -------------------
UPDATEDATE UPPCODE CLAIM MONTH
------------------- -------------------- -------------------- ----------
77912 5101000047 51010702 2019 1
0 0 0 1777 1777 2018-07-18 17:41:03
2018-07-18 17:44:28 51010000 100 01
SQL> SQL>