Oracle 11->12 Upgrade Error/Warning (Windows 2012R2): XDB.DBMS_XMLSCHEMA

[Former Member]

Hi experts,

we experience an unusual behavior during an upgrade of our existing Oracle 11.2.0.4 production database to Oracle 12.1.0.2.0 (SBP 0516) on Windows 2012R2.

First of all: I have already made several Upgrades to Oracle 12 on Windows platforms which all went (more or less) as expected.

During the upgrade process (at about 27% during catupgrd.sql) we get the following warning:

ORA-00942: table or view does not exist
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136
ORA-06512: at line 5

I can ignore the warning and the Upgrade continues. I can start/stop the upgraded database afterwards without problems. sap_post_upgrade_checks does not output any warning (XDB VALID).

However, the Oracle Post Upgrade Status Tool gives the following output, which of course makes me doubt that it worked:

Oracle Database 12.1 Post-Upgrade Status Tool       
06-26-2016 15:11:59







Component                           
Current     
Version  Elapsed Time


Name                                
Status      
Number   HH:MM:SS







Oracle Server                         
VALID  
12.1.0.2.0  00:08:02



Oracle XML Database




ORA-00942: table or view does not exist



ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136



ORA-06512: at line 5



ORA-00942: table or view does not exist



ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136



ORA-06512: at line 5



ORA-00942: table or view does not exist



ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136



ORA-06512: at line 5



ORA-00942: table or view does not exist



ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136



ORA-06512: at "SYS.REGISTER_DAV_SCHEMA", line 12



ORA-06512: at line 1



ORA-00942: table or view does not exist



ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37



ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65


Oracle XML Database                   
VALID  
12.1.0.2.0  00:00:37


Final Actions                                                
00:05:47


Post Upgrade                                                 
00:00:10


Post Compile                                                 
00:00:41




Total Upgrade Time: 00:21:28

The list of installed components in the source-database does not show up XDB:

SQL> select COMP_ID,VERSION,COMP_NAME,STATUS from dba_registry;

COMP_ID         VERSION                        COMP_NAME                                          STATUS
--------------- ------------------------------ -------------------------------------------------- -------
CATALOG         11.2.0.4.0                     Oracle Database Catalog Views                      VALID
CATPROC         11.2.0.4.0                     Oracle Database Packages and Types                 VALID

SQL> 

I know Oracle Doc ID 1990207.1 which says this error/warning will occur if XDB was installed/uninstalled without a mandatory restart. As far as I know XDB was never installed in the source database (it was always an "SAP standard" Oracle installation with sapserver-scripts and so on).

I made three attempts (with DBUA, manual, with DBUA again) to upgrade this database to Oracle 12c which all led to this warning.

We already opened an incident to SAP (ASFU license)

I still have the DBUA-upgrade log (several tens of MBs) in case somebody needs more specific information.

Do you guys have any hint on that issue?

Regards

Michael

[Former Member]

No idea anyone?

[Former Member]

This message was moderated.