My Oracle Support Banner

ORA-7445 [KGHISPIR] Reported While Compiling View Using UTLRP.SQL (Doc ID 2036735.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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.


Running utlrp.sql, this fails with an ORA-7445 [KGHISPIR] in the alert.log:

SERVER COMPONENT id=UTLRP_BGN: timestamp=2015-07-01 19:38:59
Wed Jul 01 19:39:21 2015
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFFFFFFFFFE] [PC:0xCD91D06, KGHISPIR()+6] [flags: 0x0, count: 1]
Errors in file <diagnostic_dest>/diag/<dbname>/<instname>/trace/<instname>_j037_24112.trc  (incident=70337):
ORA-07445: exception encountered: core dump [KGHISPIR()+6] [SIGSEGV] [ADDR:0xFFFFFFFFFFFFFFFE] [PC:0xCD91D06] [Address not mapped to object] []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_70337/<instname>_j037_24112_i70337.trc

The trace file shows characteristics like:

----- Current SQL Statement for this session (sql_id=4da1g1vtw3wa8) -----
ALTER VIEW "<owner>"."<view>" COMPILE

----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x34163b620      1294  package body SYS.DBMS_UTILITY
0x337148c68         1  anonymous block
0x3374438c0       413  package body SYS.UTL_RECOMP
0x3374438c0       559  package body SYS.UTL_RECOMP
0x33af63190         1  anonymous block

----- Call Stack Trace ----

... KGHISPIR kglpin qcsResolveSqnRef qcsRslvName qcsoppls qcsoProcessOpt qcsAnalyzeExpr_Dflt qcsoAnalyzeTableExp r_Cbk qcsAnalyzeExpr r_Cbk qcsosfpo qcsoptf qcsprfro qcsprfro_tree qcsprfro_tree qcsprfro_tree...

Furthermore, the base tables for the view mentioned in current SQL contain XMLTABLEs.




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

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