ORA-31114 XDB configuration has been deleted or is corrupted during upgrade to 11.2 (Doc ID 1091252.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
Checked for Relevance on 11-Apr-2013
Checked as Top Hit on 09-NOV-2011


Symptoms

Upgrade from 10.2.0.4 to 11.2.0.1 generated errors during XDBCONFIG upgrade:

SQL> @catupgrd.sql
SQL> Rem
SQL> Rem $Header: catupgrd.sql 29-mar-2007.12:50:24 cdilling Exp $
SQL> Rem
SQL> Rem catupgrd.sql
...
...
SQL>
SQL> @@xdbuud
SQL> Rem
SQL> Rem $Header: xdbuud.sql 12-nov-2007.16:03:02 yifeng Exp $
SQL> Rem
SQL> Rem xdbuud.sql
...
...
SQL> Rem TODO - We should do the XDBCONFIG Upgrade here
SQL>
SQL> Rem Add new servlets
SQL> declare
 2    cfg_data XMLTYPE;
 3 begin
 4   cfg_data := dbms_xdb.cfg_get();
...
...
52   INTO cfg_data
53   FROM dual;
54
55   dbms_xdb.cfg_update(cfg_data);
56 end;
57 /
declare
*
ERROR at line 1:
ORA-31114: XDB configuration has been deleted or is corrupted
ORA-06512: at "SYS.XMLTYPE", line 310
ORA-06512: at line 1
ORA-06512: at line 7


No other errors found in the upgrade log file, and no memory related errors found in OS system log.

ASMM is configured on the database with SHARED_POOL_SIZE = 0, JAVA_POOL_SIZE = 0, and MEMORY_TARGET = <some size>.

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