Getting ORA-31159 on the XMLTYPE Call, When XDB is Not Installed (Doc ID 1622373.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When attempting to run the below pl/sql statement -

the following error occurs.

ORA-31159: XML DB is in an invalid state
ORA-06512: at "SYS.XMLTYPE", line 272.

The XML document starts with

'<ProductConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="file://...../xmlschema.xsd">
    <Customer>
        <CustomerType>SERVICE_AGENT</CustomerType>
        <StatusCustomer>ACTIVE</StatusCustomer>
        <StatusConfiguration>NEW</StatusConfiguration>
...'


XDB is not installed in this database, and this is the only XML documents which is raising this error

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