ORA-07445: [kxhrInit] reported in database alert log
(Doc ID 2775613.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
Oracle ver -->12.1.0.2
OS ver -->Linux x86-64
===================
After restart of database, below ORA-07445 errors reported in database alert log at the time of below mentioned SQL
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xC] [PC:0x30FD2D8, kxhrInit()+72] [flags: 0x0, count: 1]
ORA-07445: exception encountered: core dump [kxhrInit()+72] [SIGSEGV] [ADDR:0xC] [PC:0x30FD2D8] [Address not mapped to object] []
----- Current SQL Statement for this session (sql_id=0nwhbsgsp9ym5) -----
SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel ...
0x14a59d780 12825 package body SYS.DBMS_SQLTUNE_INTERNAL
0x148dbae40 7 SYS.WRI$_ADV_SQLTUNE
0x14a5ce788 602 package body SYS.PRVT_ADVISOR
0x14a5ce788 2678 package body SYS.PRVT_ADVISOR
0x14a6f9ec0 241 package body SYS.DBMS_ADVISOR
0x14a627fa8 937 package body SYS.DBMS_SQLTUNE
Call stack
=========
<- kxhrInit <- qerhjInitializeMana <- gementComponentsPos
<- tLeft <- qerhjInitializeMana <- gementComponents <- qerhjFetch <- gementComponents
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 |
| Cause |
| Solution |
| References |