My Oracle Support Banner

ORA-3113 / ORA-7445[memcpy()+932] From Epgstat.sql / XQuery (Doc ID 1558011.1)

Last updated on JULY 16, 2019

Applies to:

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

Symptoms

Running epgstat.sql via SQL*Plus connected to the database as AS SYSDBA fails as follows:

     SQL> @?/rdbms/admin/epgstat.sql
     ...
     +---------------------------+
     | DAD virtual-path mappings |
     +---------------------------+
     select extractValue(value(map), '/servlet-mapping/servlet-pattern',
     *
     ERROR at line 1:
     ORA-03113: end-of-file on communication channel
     Process ID: 7555
     Session ID: 33 Serial number: 1055


     Elapsed: 00:00:45.55
     ...

The full failing statement from epgstat.sql is:

    COLUMN vpath    FORMAT a32 HEADING 'Virtual Path'
    COLUMN dad_name FORMAT a32 HEADING 'DAD Name'
    select extractValue(value(map), '/servlet-mapping/servlet-pattern',
            'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"') vpath,
          extractValue(value(map), '/servlet-mapping/servlet-name',
            'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"') dad_name
     from xdb.xdb$config cfg,
          table(XMLSequence(extract(cfg.object_value,
                '/xdbconfig/sysconfig/protocolconfig/httpconfig'||
                  '/webappconfig/servletconfig/servlet-mappings'||
                  '/servlet-mapping'))) map,
          table(XMLSequence(extract(cfg.object_value,
                '/xdbconfig/sysconfig/protocolconfig/httpconfig'||
                  '/webappconfig/servletconfig/servlet-list'||
                  '/servlet[servlet-language="PL/SQL"]',
                'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"'))) dad
    where extractValue(value(map), '/servlet-mapping/servlet-name',
                       'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"') =
          extractValue(value(dad), '/servlet/servlet-name',
                       'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"')


The associated error in the alert log is:

     ORA-07445: exception encountered: core dump [memcpy()+932] [SIGSEGV] [ADDR:0x0] [PC:0xFFFFFFFF7BB00EC0] [Address not mapped to object] []

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.