Ora-07445: Exception Encountered: Core Dump [Kgghstfel()+4] Trying To Recreate KU$_XMLSCHEMA_VIEW (Doc ID 1438080.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On a 10.2.0.4 database there are SYS objects invalids that belong to XDB installation
It seems XDB was deinstalled and reinstalled but we are not sure. Utlrp does not fix the invalids
Among other invalids we see:

...
SYS KU$_10_1_FHTABLE_VIEW VIEW INVALID
SYS KU$_10_1_IOTABLE_VIEW VIEW INVALID
SYS KU$_10_1_PFHTABLE_VIEW VIEW INVALID
SYS KU$_10_1_PIOTABLE_VIEW VIEW INVALID
SYS KU$_CLUSTER_VIEW VIEW INVALID
SYS KU$_FHTABLE_VIEW VIEW INVALID
SYS KU$_IOTABLE_VIEW VIEW INVALID
SYS KU$_M_VIEW_FH_VIEW VIEW INVALID
SYS KU$_M_VIEW_IOT_VIEW VIEW INVALID
SYS KU$_M_VIEW_LOG_FH_VIEW VIEW INVALID
SYS KU$_M_VIEW_LOG_PFH_VIEW VIEW INVALID
SYS KU$_M_VIEW_PFH_VIEW VIEW INVALID
SYS KU$_M_VIEW_PIOT_VIEW VIEW INVALID
SYS KU$_XMLSCHEMA_VIEW VIEW INVALID
...


The utlrp generated a core dump showing this info in the trace file:

ORA-07445: exception encountered: core dump [kgghstfel()+4] [SIGSEGV] [Address not mapped to object] [0x000000018] [] []
Current SQL statement for this session:
ALTER VIEW "SYS"."KU$_XMLSCHEMA_VIEW" COMPILE

*** 2011-09-25 19:25:09.745
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgghstfel()+4] [SIGSEGV] [Address not mapped to object] [0x000000018] [] []
Current SQL statement for this session:
ALTER VIEW "SYS"."KU$_XMLSCHEMA_VIEW" COMPILE
----- PL/SQL Call Stack -----
object line object
handle number name
73cfb1538 946 package body SYS.DBMS_UTILITY
738950e70 1 anonymous block
73da3b9e0 316 package body SYS.UTL_RECOMP
73da3b9e0 644 package body SYS.UTL_RECOMP
73da3b9e0 595 package body SYS.UTL_RECOMP
73e7ba910 4 anonymous block



Using catmetx.sql trying to create sys.ku$_xmlschema_view

SQL> create or replace force view sys.ku$_xmlschema_view of sys.ku$_xmlschema_t
2 with object identifier (schemaoid) as
3 select '1','0',
4 u.user#, u.name, extractvalue(VALUE(s), '/schema/@x:schemaURL',
5 'xmlns="http://www.w3.org/2001/XMLSchema" xmlns:x="http://xmlns.oracle.com/xdb"'),
6 s.sys_nc_oid$,
7 case when under_path(value(r), '/sys/schemas/PUBLIC') = 1
8 then 0 else 1 end,
9 s.getclobval(), -- unstripped
10 xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()),
11 u.name) -- stripped
12 from sys.user$ u, xdb.xdb$schema s, xdb.xdb$resource r
13 where extractvalue(VALUE(r), '/Resource/XMLRef') = ref(s)
14 and u.user# = sys_op_rawtonum(extractvalue(VALUE(r),'/Resource/OwnerID'))
15 AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0) OR
16 EXISTS ( SELECT * FROM session_roles
17 WHERE role='SELECT_CATALOG_ROLE' ))
18 /
create or replace force view sys.ku$_xmlschema_view of sys.ku$_xmlschema_t
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Same ORA-07445: exception encountered: core dump [kgghstfel()+4]

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