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 ?
<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来解决这个问题。

This entry was posted in BUG and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *