My Oracle Support Banner

ORA-07445: [kxhrInit] reported in database alert log (Doc ID 2775613.1)

Last updated on JULY 09, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.