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

Last updated on JULY 29, 2015

Applies to:

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

Symptoms

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 /u01/app/oracle/diag/rdbms/dwhp12c/DWHP12C1/trace/DWHP12C1_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: /u01/app/oracle/diag/rdbms/dwhp12c/DWHP12C1/incident/incdir_70337/DWHP12C1_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.

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