ORA-31114 XDB configuration has been deleted or is corrupted during upgrade to 11.2
(Doc ID 1091252.1)
Last updated on FEBRUARY 18, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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
Upgrade from 10.2.0.4 to 184.108.40.206 generated errors during XDBCONFIG upgrade:
SQL> Rem $Header: catupgrd.sql 29-mar-2007.12:50:24 cdilling Exp $
SQL> Rem catupgrd.sql
SQL> Rem $Header: xdbuud.sql 12-nov-2007.16:03:02 yifeng Exp $
SQL> Rem xdbuud.sql
SQL> Rem TODO - We should do the XDBCONFIG Upgrade here
SQL> Rem Add new servlets
2 cfg_data XMLTYPE;
4 cfg_data := dbms_xdb.cfg_get();
52 INTO cfg_data
53 FROM dual;
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>.
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