ORA-7445 [PC:0x0] Errors Without Call Stack (Doc ID 1644281.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

A (long and complex) select query is generating ORA 7445 [PC:0x0] errors with each execution as shown in the alert log:

...
Fri Apr 04 12:25:30 2014
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x0, {empty}] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/idwqual/IDWQUAL1/trace/IDWQUAL1_ora_114436.trc (incident=353436):
ORA-07445: exception encountered: core dump [PC:0x0] [SIGSEGV] [ADDR:0x0] [PC:0x0] [Address not mapped to object] []          <<<<<<
Incident details in: /u01/app/oracle/diag/rdbms/idwqual/IDWQUAL1/incident/incdir_353436/IDWQUAL1_ora_114436_i353436.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Apr 04 12:25:31 2014
Dumping diagnostic data in directory=[cdmp_20140404122531], requested by (instance=1, osid=114436), summary=[incident=353436].
Fri Apr 04 12:25:33 2014
Sweep [inc][353436]: completed
Sweep [inc2][353436]: completed
Fri Apr 04 12:29:29 2014
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x0, {empty}] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/idwqual/IDWQUAL1/trace/IDWQUAL1_ora_9310.trc (incident=353684):
ORA-07445: exception encountered: core dump [PC:0x0] [SIGSEGV] [ADDR:0x0] [PC:0x0] [Address not mapped to object] []          <<<<<<
Incident details in: /u01/app/oracle/diag/rdbms/idwqual/IDWQUAL1/incident/incdir_353684/IDWQUAL1_ora_9310_i353684.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Apr 04 12:29:30 2014
Dumping diagnostic data in directory=[cdmp_20140404122930], requested by (instance=1, osid=9310), summary=[incident=353684].
Fri Apr 04 12:29:33 2014
Sweep [inc][353684]: completed
Sweep [inc2][353684]: completed


In the trace file, the select is shown in the current sql like:

----- Current SQL Statement for this session (sql_id=dkdnczy3nunjs) -----
select
   fad_prd_abr_cd as fundCode,
   hnt_mjr_act_nu as accountNumberMajor,
   hnt_mnr_act_nu as accountNumberMinor,
   rpt_ptf_shr_cla_nm as portfolioName,
   currency,
   hnt_cur_id,
   subStrategyName,
   terminated,
   sum(IssuerCount) as issuerCount,
   sum(YearMinus4_TNA) as yearMinus4_TNA,
   sum(YearMinus3_TNA) as yearMinus3_TNA,
   sum(YearMinus2_TNA) as yearMinus2_TNA,
   sum(YearMinus1_TNA) as yearMinus1_TNA,
   sum(QuarterMinus4_TNA) as quarterMinus4_TNA,
   sum(QuarterMinus3_TNA) as quarterMinus3_TNA,
   sum(QuarterMinus2_TNA) as quarterMinus2_TNA,
   sum(QuarterMinus1_TNA) as quarterMinus1_TNA,
   sum(Current_TNA) as currentTNA,
   sum(YearMinus4_NetCashFlow) as yearMinus4_NetCashFlow,
   sum(YearMinus3_NetCashFlow) as yearMinus3_NetCashFlow,
   sum(YearMinus2_NetCashFlow) as yearMinus2_NetCashFlow,
   sum(YearMinus1_NetCashFlow) as yearMinus1_NetCashFlow,
   sum(QuarterMinus4_NetCashFlow) as quarterMinus4_NetCashFlow,
   sum(QuarterMinus3_NetCashFlow) as quarterMinus3_NetCashFlow,
   ...


The call stack in the trace file shows only:

----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
skdstdst()+36        call     kgdsdst()            000000000 ? 000000000 ?
                                                  7F26E05E3098 ? 000000001 ?
                                                  000000001 ? 000000003 ?
ksedst1()+98         call     skdstdst()           000000000 ? 000000000 ?
                                                  7F26E05E3098 ? 000000001 ?
                                                  000000000 ? 000000003 ?
ksedst()+34          call     ksedst1()            000000001 ? 000000001 ?
                                                  7F26E05E3098 ? 000000001 ?
                                                  000000000 ? 000000003 ?
dbkedDefDump()+2741  call     ksedst()             000000001 ? 000000001 ?
                                                  7F26E05E3098 ? 000000001 ?
                                                  000000000 ? 000000003 ?
ksedmp()+36          call     dbkedDefDump()       000000003 ? 000000003 ?
                                                  7F26E05E3098 ? 000000001 ?
                                                  000000000 ? 000000003 ?
ssexhd()+2458        call     ksedmp()             000000003 ? 000000003 ?
                                                  7F26E05E3098 ? 000000001 ?
                                                  000000000 ? 000000003 ?
__sighandler()       call     ssexhd()             00000000B ? 7F26E05EBD70 ?
                                                  7F26E05EBC68 ? 000000001 ?
                                                  000000000 ? 000000003 ?
0000000000000000     signal   __sighandler()       0C9D62690 ? 000000000 ?
                                                  000001918 ? 000000000 ?
                                                  000000010 ? 000000010 ?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms