XMLType View Creation Fails With ORA-7445[qmxtr2isoptinorderby()+35] (Doc ID 1316116.1)

Last updated on APRIL 22, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

XMLType view creation fails with the following error in SQL*Plus:

SQL> CREATE OR REPLACE VIEW DETAILED_METADATA OF SYS.XMLTYPE
...
156 /
CREATE OR REPLACE VIEW DETAILED_METADATA OF SYS.XMLTYPE
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 305
Session ID: 9 Serial number: 489


SQL>

The associated error in the alert log is:

     ORA-07445: exception encountered: core dump [qmxtr2IsOptInOrderBy()+34] [SIGSEGV]
      [ADDR:0x94] [PC:0xC3447FE] [Address not mapped to object] []

The Call Stack Trace in the associated trace file may be similar to the following:

     skdstdst ksedst1 ksedst dbkedDefDump ksedmp ssexhd __sighandler qmxtr2IsOptInOrderBy
      qmxtr2oxpthatgRootOverXE qmxtr2oxpthatg kokqbpt kokqbpt kokqbpt kokqbpt kokqbpt
      kokqae kokvccts kokvctp cvwdrv

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