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

Last updated on MAY 30, 2013

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

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