问题描述
客户10.2.0.5 RAC在验证表的逻辑结构是出现ORA-7445错误。
错误信息如下：
Sun Mar 31 03:45:16 EAT 2013Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_4039.trc: ORA-07445: 出现异常错误: 核心转储 [kjbcrcomplete()+5521] [SIGSEGV] [Invalid permissions FOR mapped object] [0x00000002A] [] []
专家解答
详细TRACE信息为：
Ioctl ASYNC_CONFIG error, errno = 1 *** 2013-03-31 02:20:45.846 *** ACTION NAME:() 2013-03-31 02:20:45.846 *** MODULE NAME:(sqlplus@db2 (TNS V1-V3)) 2013-03-31 02:20:45.846 *** SERVICE NAME:(SYS$USERS) 2013-03-31 02:20:45.846 *** SESSION ID:(2053.926) 2013-03-31 02:20:45.846 WARNING:Could NOT increase the asynch I/O LIMIT TO 32 FOR SQL direct I/O. It IS SET TO 0 *** 2013-03-31 03:45:16.545 Exception signal: 11 (SIGSEGV), code: 2 (Invalid permissions FOR mapped object), addr: 0x2a, PC: [0x40000000053973d1, kjbcrcomplete()+5521] r1: 60000000000ba268 r20: 0 br5: 0 r2: c0000030f2636d20 r21: 21 br6: c00000000042a870 r3: c000000028da7000 r22: 0 br7: c00000000043d720 r4: 0 r23: 5c3412c0 ip: 40000000053973d1 r5: c000000000000408 r24: c0000030f598d9e8 iipa: 0 r6: c0000000000443e0 r25: 60000000000ac688 cfm: 14b1 r7: 9fffffffbf7f8de8 r26: 60000000000ca6b8 um: 1a r8: 0 r27: 1 rsc: 1f r9: c00000145dfc536c r28: 60000000000ac650 bsp: 9fffffffbf801600 r10: 60000000000ca6c0 r29: c0000030f6695ec8 bspstore: 9fffffffbf801600 r11: 20 r30: 9fffffffbf372318 rnat: 0 r12: 9ffffffffffd9360 r31: 20 ccv: 2000000000000030 r13: 9fffffffbf3fd4b0 NaTs: 0 unat: 0 r14: 60000000000ac650 PRs: c000000000398309 fpsr: 9804c8a76433f r15: 5c3412cd br0: 40000000053964e0 pfs: c0000000000014b1 r16: 0 br1: c000000000299260 lc: 0 r17: 60000000000ca6c0 br2: c00000000029ba60 ec: 0 r18: 20 br3: 0 isr: 9fffffffbf801600 r19: 9ffffffffffd9330 br4: 0 ifa: 0 Reason code: 0053 *** 2013-03-31 03:45:16.590 ksedmp: internal OR fatal error ORA-07445: 出现异常错误: 核心转储 [kjbcrcomplete()+5521] [SIGSEGV] [Invalid permissions FOR mapped object] [0x00000002A] [] [] CURRENT SQL statement FOR this SESSION: analyze TABLE c_inter VALIDATE STRUCTURE CASCADE ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- ksedst()+64 CALL ksedst1() 000000001 ? 000000001 ? ksedmp()+2176 CALL ksedst() 000000001 ? C000000000000D20 ? 4000000004032B40 ? 000000000 ? 000000000 ? 000000000 ? ssexhd()+1264 CALL ksedmp() 000000003 ? 6000000000247DA0 ? 60000000000BA268 ? 6000000000248370 ? C000000000000B9F ? 4000000006C1DF80 ? C00000000039B6CD ? 60000000000C7420 ? <kernel> CALL ssexhd() C0000030F54A95F0 ? 60000000000C9570 ? C000000028DAE8C8 ? 60000000000BA268 ? kjbcrcomplete()+552 CALL <kernel> 600000000024C200 ? 1 20000000B ? 600000000024C010 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? kclwcrs()+69392 CALL kjbcrcomplete() 0001703A6 ? 0001F0000 ? 0000188C5 ? C0000030F0307B48 ? 000000001 ? C0000030F0307B48 ? 000000000 ? 9FFFFFFFFFFD9390 ? kclgclk()+21824 CALL kclwcrs() C00000145DFC537A ? 000000800 ? 60000000000CAA68 ? 60000000000C6F68 ? 9FFFFFFFFFFE0A10 ? 9FFFFFFFFFFE0958 ? 9FFFFFFFFFFE0D10 ? 9FFFFFFFFFFE2460 ? $cold_kcbzib()+8640 CALL kclgclk() 9FFFFFFFFFFDBDD8 ? 000000800 ? 60000000000CAA68 ? 60000000000C8A38 ? 000000040 ? 9FFFFFFFFFFE0D10 ? 00000026D ? 9FFFFFFFFFFE0A10 ? kcbgtcr()+9536 CALL $cold_kcbzib() C00000308A416408 ? 9FFFFFFFFFFE0D10 ? 9FFFFFFFFFFE0A10 ? 000000004 ? 000000003 ? 00000026D ? 000000000 ? 000000000 ? ktrgtc()+1120 CALL kcbgtcr() 9FFFFFFFFFFE0D10 ? 9FFFFFFFFFFE0A10 ? 00000026D ? 000000000 ? 60000000000BA268 ? kdifbk()+6608 CALL ktrgtc() 9FFFFFFFFFFE0D00 ? 9FFFFFFFFFFE2430 ? 4000000001CA99C0 ? 9FFFFFFFFFFE0C20 ? 00000026D ? 000100000 ? 4000000001CA99E0 ? kdgvsp()+15888 CALL kdifbk() 9FFFFFFFFFFE0C44 ? 9FFFFFFFFFFE0D2C ? 000000001 ? 9FFFFFFFFFFE0DE8 ? 000000000 ? 000000000 ? 000000000 ? 9FFFFFFFFFFE1320 ? kdgvss()+432 CALL kdgvsp() 9FFFFFFFFFFE8DB8 ? 000000000 ? 9FFFFFFFFFFE2468 ? 000000000 ? 00C100000 ? C0000030FA5CBF20 ? kdavls()+6624 CALL kdgvss() 9FFFFFFFBF2F3780 ? 000000001 ? 9FFFFFFFFFFE9C80 ? 9FFFFFFFFFFE9170 ? 4000000001CAB230 ? C0000030FA5CBF20 ? 9FFFFFFFBF2F3780 ? 000000001 ? kkndgd()+2960 CALL kdavls() 9FFFFFFFFFFEB4C0 ? 4000000006557450 ? C000000000390061 ? 9FFFFFFFFFFE8FB4 ? 000000001 ? 60000000000AE7A8 ? 000000001 ? 9FFFFFFFBF2F3BB4 ? kknpat()+1648 CALL kkndgd() C000002F2B449B18 ? 0000142B9 ? 000000002 ? 00000000A ? C000002F2B4498DE ? 000000014 ? C000002F2B4498A6 ? 9FFFFFFFFFFEBE40 ? kknpob()+448 CALL kknpat() C000002F2B449B18 ? 9FFFFFFFFFFEBE40 ? 000000001 ? C000002F2B6BC670 ? 9FFFFFFFFFFF2F10 ? 9FFFFFFFFFFEBD60 ? C000000000001838 ? 400000000655AF30 ? kknls()+1872 CALL kknpob() C000002F2B449B18 ? 9FFFFFFFFFFEBE40 ? 9FFFFFFFFFFEC1B0 ? FFFFFFFFFFFFFFFF ? 000100000 ? 000100000 ? 60000000000BA268 ? C0000029B20453AF ? kkndrv()+64 CALL kknls() 000000000 ? $cold_opiexe()+7600 CALL kkndrv() C000000000002450 ? 4000000003637C80 ? 60000000000CAA68 ? 60000000000C8A38 ? 000000040 ? 9FFFFFFFFFFE0D10 ? 00000026D ? 9FFFFFFFFFFE0A10 ? opiosq0()+8144 CALL $cold_opiexe() 9FFFFFFFFFFF6130 ? 4000000002F89200 ? 00002821B ? 9FFFFFFFFFFF44B0 ? 60000000000BA268 ? C000000000001838 ? 9FFFFFFFFFFF44B4 ? 60000000000C6CA0 ? kpooprx()+416 CALL opiosq0() 000000003 ? 9FFFFFFFFFFF6D90 ? 4000000002AEB2A0 ? 00002F21B ? C000000000000815 ? kpoal8()+1152 CALL kpooprx() 000000003 ? 9FFFFFFFFFFF9AD0 ? 000000048 ? 9FFFFFFFFFFF6DD0 ? 000000001 ? 0000000A4 ? 60000000000BA268 ? 60000000000A7E20 ? opiodr()+2144 CALL kpoal8() 9FFFFFFFFFFF7590 ? C0000000000018B7 ? 9FFFFFFFFFFF9C70 ? 9FFFFFFFFFFF6EB0 ? 60000000000BA268 ? 4000000002F33E40 ? ttcpip()+1680 CALL opiodr() 00000005E ? 000000017 ? 4000000001BF80B0 ? 0000046C0 ? 9FFFFFFFFFFF75A0 ? opitsk()+2368 CALL ttcpip() 600000000003DF40 ? 000000001 ? 9FFFFFFFFFFF9C70 ? 000000001 ? 9FFFFFFFFFFF9DE0 ? 9FFFFFFFFFFF9BD4 ? 4000000001CE0810 ? 000000000 ? opiino()+1664 CALL opitsk() 000000000 ? 000000000 ? 60000000000BA268 ? 400000000293B500 ? 000028089 ? 4000000001BF80C8 ? opiodr()+2144 CALL opiino() 00000003C ? 9FFFFFFFFFFFC630 ? 9FFFFFFFFFFFEDD0 ? 9FFFFFFFFFFFBAF0 ? 60000000000BA268 ? C0000000000018B7 ? opidrv()+1248 CALL opiodr() 00000003C ? 000000004 ? 4000000001BF7B60 ? 0000046C0 ? 9FFFFFFFFFFFC640 ? 60000000000BA268 ? sou2o()+240 CALL opidrv() 00000003C ? 60000000000C6C98 ? 9FFFFFFFFFFFEDD0 ? opimai_real()+496 CALL sou2o() 9FFFFFFFFFFFEDF0 ? 00000003C ? 000000004 ? 9FFFFFFFFFFFEDD0 ? main()+240 CALL opimai_real() 000000000 ? 9FFFFFFFFFFFEE20 ? main_opd_entry()+80 CALL main() 000000002 ? 9FFFFFFFFFFFF2D8 ? 60000000000BA268 ? C000000000000004 ? --------------------- Binary Stack Dump ---------------------
在MOS中找不到这个ORA-7445[kjbcrcomplete]错误的记录，但是从详细的TRACE可以判断，问题导致的原因是验证表的结构时出现了异常。显然是表或索引上存在逻辑坏块，导致Oracle在验证其逻辑结构时发现异常。
解决这个问题的方式是通过逻辑方式重建表和索引。
最后修改时间：2019-04-14 10:52:42
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
