ORA-7445($cold_qerfxArrayMaxSize)错误
客户的数据库告警日志中出现这个错误。
详细错误信息如下：
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 ?
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来解决这个问题。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/4227/viewspace-712145/ ，如需转载，请注明出处，否则将追究法律责任。
