客户的数据库告警日志中出现这个错误。
详细错误信息如下：
Wed Oct 26 15:38:14 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc: ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264] [SIGSEGV] [Address NOT mapped TO object] [0x000003058] [] [] Wed Oct 26 15:38:27 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc: ORA-00081: address range [0x6000000000127430, 0x6000000000127434) IS NOT readable ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264] [SIGSEGV] [Address NOT mapped TO object] [0x000003058] [] [] |
对应的TRACE文件内容为：
/oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production WITH the Partitioning, OLAP AND DATA Mining options ORACLE_HOME = /oracleapp/oracle10g System name: HP-UX Node name: db1 Release: B.11.31 Version: U Machine: ia64 Instance name: ora10 Redo thread mounted BY this instance: 1 Oracle process NUMBER: 575 Unix process pid: 8209, image: oracleora10@db1 *** 2011-10-26 15:38:14.196 *** SERVICE NAME:(SYS$USERS) 2011-10-26 15:38:14.169 *** SESSION ID:(309.9118) 2011-10-26 15:38:14.169 Exception signal: 11 (SIGSEGV), code: 1 (Address NOT mapped TO object), addr: 0x3058, PC: [0x4000000002c96060, $cold_qerfxArrayMaxSize()+15264] r1: 600000000011d1c0 r20: 8 br5: 0 r2: 52c57 r21: ffffffffffffffdf br6: c00000000027d420 r3: c000000018118c90 r22: ffffffffffffffff br7: 400000000251a3a0 r4: 6000000000127670 r23: 58244b474c535400 ip: 4000000002c96060 r5: 0 r24: 58244b474c535400 iipa: 0 r6: 9fffffffffff7910 r25: c000000018118c98 cfm: 58e r7: 9fffffffffff5e60 r26: ffffffffffffff00 um: 1a r8: 139 r27: ffffffffffffff00 rsc: 1f r9: 28 r28: 0 bsp: 9fffffffbf800200 r10: 0 r29: 2 bspstore: 9fffffffbf800200 r11: 0 r30: 4000000001868418 rnat: 0 r12: 9fffffffffff5ce0 r31: c000000000001329 ccv: 0 r13: 9fffffffbf5dd4b0 NaTs: 20500 unat: 0 r14: 3058 PRs: 5cd57 fpsr: 9804c8a74433f r15: 3058 br0: 400000000250ebd0 pfs: c000000000001329 r16: 0 br1: c0000000000536d0 lc: 0 r17: 0 br2: 0 ec: 0 r18: 10 br3: 0 isr: 9fffffffbf800200 r19: 9fffffffbf586f40 br4: 0 ifa: 0 Reason code: 0008 *** 2011-10-26 15:38:14.260 ksedmp: internal OR fatal error ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264] [SIGSEGV] [Address NOT mapped TO object] [0x000003058] [] [] CURRENT SQL statement FOR this SESSION: SELECT decode(SUM(pins),0,0,round(100*(1 - SUM(reloads)/SUM(pins)),2)) FROM sys.v_$librarycache ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- ksedst()+64 CALL _etext_f()+23058430 000000001 ? 000000001 ? 09017162224 ksedmp()+1680 CALL _etext_f()+23058430 000000001 ? 09017162224 C000000000000D20 ? 40000000052B0470 ? 000000000 ? 000000000 ? 000000000 ? ssexhd()+1552 CALL _etext_f()+23058430 000000003 ? 09017162224 9FFFFFFFFFFEC9A0 ? 4000000004120D30 ? 6000000000127B2C ? 0000586D5 ? 6000000000127B30 ? 000000001 ? 6000000000127450 ? <kernel> CALL _etext_f()+23058430 9FFFFFFFFFFECFA8 ? 09017162224 9FFFFFFFFFFECF98 ? 40000000011BD908 ? 000000007 ? $cold_qerfxArrayMax CALL _etext_f()+23058430 9FFFFFFFFFFF0E00 ? SIZE()+15264 09017162224 10000000B ? 9FFFFFFFFFFF0C10 ? qerfxStart()+368 CALL _etext_f()+23058430 400000000184FD42 ? 09017162224 000000007 ? 000000007 ? 600000000011D1C0 ? 400000000251A510 ? qergsStart()+1376 CALL _etext_f()+23058430 400000000184FD78 ? 09017162224 000000010 ? 000000230 ? 000000001 ? 000000140 ? 000000011 ? 400000000184FD78 ? 000000007 ? selexe()+1792 CALL 0000000000000007 C0000003B6B69118 ? 000000001 ? 600000000011D1C0 ? opiexe()+8320 CALL 0000000000000001 C0000003B650EB10 ? 9FFFFFFFFFFF5F80 ? 000004658 ? 600000000011D1C0 ? 9FFFFFFFFFFF5F96 ? 9FFFFFFFFFFF5F8A ? 9FFFFFFFFFFF5F94 ? 9FFFFFFFFFFF5F90 ? kpoal8()+3600 CALL _etext_f()+23058430 000000180 ? 09016042352 9FFFFFFFBF590F0C ? 9FFFFFFFFFFF5FC0 ? 9FFFFFFFFFFF5D30 ? 600000000011D1C0 ? 9FFFFFFFFFFF5D3C ? 9FFFFFFFBF590E00 ? 9FFFFFFFBF590E10 ? opiodr()+2064 CALL _etext_f()+23058430 9FFFFFFFFFFF80B0 ? 09016090224 400000000304FDD0 ? 000000000 ? 9FFFFFFFFFFF79F0 ? 600000000011D1C0 ? C000000000001836 ? ttcpip()+1824 CALL __text_start_f()+22 6000000000129A70 ? 768464 6000000000015DD0 ? 9FFFFFFFFFFFA790 ? 6000000000015DD0 ? 9FFFFFFFFFFF80C0 ? 600000000011D1C0 ? 000000017 ? 6000000000021838 ? opitsk()+2224 CALL 0000000000000017 6000000000021830 ? 000000000 ? 9FFFFFFFFFFFA790 ? 000000001 ? 9FFFFFFFFFFFA900 ? 9FFFFFFFFFFFA6F4 ? 4000000001EA0780 ? 9FFFFFFFFFFFA6E8 ? opiino()+1920 CALL _etext_f()+23058430 000000000 ? 000000000 ? 09016090072 600000000011D1C0 ? 40000000023A45D0 ? 000008001 ? 9FFFFFFFFFFFA6E4 ? opiodr()+2064 CALL _etext_f()+23058430 00000003C ? 09016090072 9FFFFFFFFFFFF0D0 ? 9FFFFFFFFFFFF0C0 ? 9FFFFFFFFFFFBE00 ? 000000084 ? 600000000010EC20 ? opidrv()+1104 CALL __text_start_f()+22 6000000000129A70 ? 767104 6000000000015DD0 ? 9FFFFFFFFFFFF0C0 ? 6000000000015DD0 ? 9FFFFFFFFFFFC950 ? 600000000011D1C0 ? sou2o()+240 CALL _etext_f()+23058430 00000003C ? 000000004 ? 09017120608 9FFFFFFFFFFFF0C0 ? opimai_real()+240 CALL _etext_f()+23058430 9FFFFFFFFFFFF0E0 ? 09017120608 00000003C ? 000000004 ? 9FFFFFFFFFFFF0C0 ? main()+352 CALL _etext_f()+23058430 000000000 ? 09017120608 9FFFFFFFFFFFF110 ? main_opd_entry()+80 CALL _etext_f()+23058430 000000002 ? 09017120608 9FFFFFFFFFFFF5C0 ? C000000000033910 ? 000000000 ? --------------------- Binary Stack Dump --------------------- |
查询MOS发现，这是HP UNIX上的一个bug，ORA-07445[$cold_qerfxArrayMaxSize()] running 10.2 on HP-UX [ID 1339184.1]，在HP UNIX上的10.2版本可能碰到这个问题，当前数据库的版本是10.2.0.2 for HP unix，满足错误发生条件。
这个bug是指定平台上的问题，所以大的补丁集中可能并不会包含这个问题的解决，因此可以通过单独的补丁patch: 5442780来解决这个问题。