ORA-07445 : core dump [evaopn3()+125] [SIGSEGV] exception encountered
(Doc ID 1965567.1)
Last updated on MAY 26, 2023
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database Backup Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Alert log reports ORA-07445 error like:
...
Mon May 12 14:47:14 2014
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x92B536D, evaopn3()+125] [flags: 0x0, count: 1]
Errors in file <diagnostic_dest>/diag/rdbms/<instance_name>/<instance_name>/trace/<instance_name>_ora_7143.trc (incident=25809):
ORA-07445: exception encountered: core dump [evaopn3()+125] [SIGSEGV] [ADDR:0x4] [PC:0x92B536D] [Address not mapped to object] []
Incident details in: <diagnostic_dest>/diag/rdbms/<instance_name>/<instance_name>/incident/incdir_25809/<instance_name>_ora_7143_i25809.trc
...
Mon May 12 14:47:14 2014
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x92B536D, evaopn3()+125] [flags: 0x0, count: 1]
Errors in file <diagnostic_dest>/diag/rdbms/<instance_name>/<instance_name>/trace/<instance_name>_ora_7143.trc (incident=25809):
ORA-07445: exception encountered: core dump [evaopn3()+125] [SIGSEGV] [ADDR:0x4] [PC:0x92B536D] [Address not mapped to object] []
Incident details in: <diagnostic_dest>/diag/rdbms/<instance_name>/<instance_name>/incident/incdir_25809/<instance_name>_ora_7143_i25809.trc
...
The error is reported while running a SQL select statement against the database.
The Tables participating in the SQL statement have been analyzed without reporting issues but the error is still raised.
This Query is has window functions with PARTITION BY clause and functional index
The call stack trace will have the functions like below:
Problem Key: ORA 7445 [evaopn3()+135]
Error: ORA-7445 [evaopn3()+135] [SIGSEGV] [ADDR:0x4] [PC:0x9676613] [Address
not mapped to object] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: dbgeEndDDEInvocation [diag_dde]
[03]: ssexhd []
[04]: __sighandler []
[05]: evaopn3 []<-- Signaling
[06]: qerpx_start [Parallel_Execution]
[07]: qerpxFetch [Parallel_Execution]
[08]: opifch2 []
[09]: kpoal8 []
[10]: opiodr []
[11]: ttcpip []
[12]: opitsk []
[13]: opiino []
[14]: opiodr []
[15]: opidrv []
[16]: sou2o []
[17]: opimai_real []
[18]: ssthrdmain []
[19]: main []
[20]: __libc_start_main []
Error: ORA-7445 [evaopn3()+135] [SIGSEGV] [ADDR:0x4] [PC:0x9676613] [Address
not mapped to object] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: dbgeEndDDEInvocation [diag_dde]
[03]: ssexhd []
[04]: __sighandler []
[05]: evaopn3 []<-- Signaling
[06]: qerpx_start [Parallel_Execution]
[07]: qerpxFetch [Parallel_Execution]
[08]: opifch2 []
[09]: kpoal8 []
[10]: opiodr []
[11]: ttcpip []
[12]: opitsk []
[13]: opiino []
[14]: opiodr []
[15]: opidrv []
[16]: sou2o []
[17]: opimai_real []
[18]: ssthrdmain []
[19]: main []
[20]: __libc_start_main []
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |