ORA-07445: 出现异常错误: 核心转储 [evaopn3()+252]

最新推荐文章于 2025-05-03 10:42:07 发布

原创

最新推荐文章于 2025-05-03 10:42:07 发布 · 2.9k 阅读

0 ·

CC 4.0 BY-SA版权

这篇博客详细记录了在一个SOLARIS 10环境中，Oracle 11.2.0.1数据库遇到的ORA-07445异常错误，该错误涉及到核心转储[evaopn3()+252]。问题出现在带有聚合子查询的SQL执行过程中，并给出了详细的alert.log和trace文件内容，包括异常堆栈信息和注册表状态。博主还引用了一个相关的Bug 8780281，并提供了两种解决策略，包括审查执行计划和与Oracle全球客户支持联系提供测试用例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一：环境介绍

操作系统版本:SOLARIS 10

数据库版本:11.2.0.1

架构组成：2节点RAC

二：问题

第一次出现：

---alert.log

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x10481C59C, evaopn3()+252] [flags: 0x0, count: 1]
Errors in file ../ceacrew1/trace/ceacrew1_ora_6791.trc (incident=120789):
ORA-07445: 出现异常错误: 核心转储 [evaopn3()+252] [SIGSEGV] [ADDR:0x0] [PC:0x10481C59C] [Address not mapped to object] []
Incident details in: ../incdir_120789/ceacrew1_ora_6791_i120789.trc

----../ceacrew1/trace/ceacrew1_ora_6791.trc

*** 2013-07-23 16:16:42.415
*** SESSION ID:(1603.29445) 2013-07-23 16:16:42.415
*** CLIENT ID:() 2013-07-23 16:16:42.415
*** SERVICE NAME:(ceacrew) 2013-07-23 16:16:42.415
*** MODULE NAME:(WebDev.WebServer40.exe) 2013-07-23 16:16:42.415
*** ACTION NAME:() 2013-07-23 16:16:42.415

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x10481C59C, evaopn3()+252] [flags: 0x0, count: 1]
Incident 120789 created, dump file: ../incdir_120789/ceacrew1_ora_6
791_i120789.trc
ORA-07445: 出现异常错误: 核心转储 [evaopn3()+252] [SIGSEGV] [ADDR:0x0] [PC:0x10481C59C] [Address not mapped to object] []

ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL

----

========= Dump for incident 120789 (ORA 7445 [evaopn3()+252]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x10481C59C, evaopn3()+252] [flags: 0x0, count: 1]
Registers:
----------
%o0: 0x0000000ec8e163d0 %o1: 0xffffffff7a0518a8 %o2: 0x000000010a10c168
%o3: 0x000000000000000b %o4: 0x000000000200001b %o5: 0x000000010b36d9e8
%o6: 0xffffffff7fff6920 %o7: 0x0000000105abefac
%g1: 0x000000000000003f %g2: 0x0000000080000002 %g3: 0x0000000000200000
%g4: 0x0000000000004000 %g5: 0x0000000000000e18 %g6: 0x0000000000000000
%g7: 0xffffffff7bd00200
%pc: 0x000000010481c59c %npc: 0x000000010481c5a0 %y: 0x0000000000000000
Stack info:
---------- ../incdir_120789/ceacrew1_ora_6791_i120789.trc
ss_sp: 0xffffffff7e000000 ss_size: 0x0000000002000000 ss_flags: 0

*** 2013-07-23 16:16:42.547
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=5rbtwfd8x2r44) -----
select distinct W.*, U.qlf_code
                                  from (select t.flight_id,
                                               t.flight_date,
                                               t.p_code,
                                             &nbs