My Oracle Support Banner

Script with XMLForest Query Fails with Core Dump, ORA-7445 qmsqxStreamEvalXMLOp, on 11.1.0.7 (Doc ID 975505.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On 11.1.0.7 version, when attempting to run scripts with XMLForest the following error occurs:

ORA-07445: exception encountered: core dump [PC:0x0] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x0] [UNABLE_TO_WRITE] []
...
----- Current SQL Statement for this session (sql_id=c1bncuzgsbmya) -----
SELECT XMLELEMENT( "ROWSET", XMLATTRIBUTES('http://www.w3.org/2001/XMLSchema-instance' AS "xmlns:xsi", 'http://health.version1.com/xsd/health.xsd' AS "xsi:noNamespaceSchemaLocation"), XMLELEMENT(INS, (SELECT XMLAGG(XMLELEMENT(TD_INSTANCE, XMLFOREST(INSTANCE_NAME AS INS_SID, TO_CHAR(TRUNC(STARTUP_TIME),'DD-MM-YYYY') AS INS_STARTUP_TIME, DATABASE_STATUS AS INS_DB_STATUS, ACTIVE_STATE AS INS_ACTIVE_STATE, VERSION AS INS_VERSION, HOST_NAME AS INS_HOSTNAME, TO_CHAR(TRUNC(SYSDATE),'DD-MM-YYYY') AS INS_SYSTIME)))

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.