ORA-31114 XDB configuration has been deleted or is corrupted during upgrade to 11.2
(Doc ID 1091252.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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 22.214.171.124 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!