ORA-7445 [evaopn3] While running XML query

(Doc ID 2356070.1)

Last updated on FEBRUARY 07, 2018

Applies to:

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

Symptoms

DB Version: 12.1.0.2

OS Version: Microsoft Windows x64 (64-bit)

An XML query fails with the following errors:

SQL> SELECT <columns> , EXTRACTVALUE (VALUE (inv), '<path1>') sku_no, EXTRACTVALUE (VALUE (inv), '<path2>') qty
         FROM (SELECT xml_message data, xml_id, .... FROM .....) t, TABLE(XMLSEQUENCE (EXTRACT (data, '<path>'))) inv) <alias>,

                  (SELECT ... FROM ... WHERE ... GROUP BY ... ) <alias>
       WHERE .... GROUP BY ....

SELECT ....
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 20984
Session ID: 17 Serial number: 38379

ORA-07445: exception encountered: core dump [evaopn3()+107] [SIGSEGV] [ADDR:0x0] [PC:0xCEA994B] [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