SAP Knowledge Base Article - Preview

2978249 - Internal 19c Preupgrade Error-check "xdb_resource_type" raised the exception

Symptom

Error reported when trying to run the Pre-Upgrade Information Tool to upgrade from Oracle 12.2 to Oracle 19c

The initial description of the error is as below:

[oracle@abcdef oraupgradel9c_work]$ $ORACLE_HOME/jdk/bin/java -jar$ORACLE_HOME_NEW/sap/ora_upgrade/pre_upgrade_utility/preupgrade.jar TERMINAL TEXT DIR $ORA_UPGRADE_WORK_DIR
ERROR - Unable to run the preupgrade due to:ERROR - Unable to run preupgrade due to:
check "xdb_resource_type" raised the following exception and did not complete.
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_PREUP", line 8026
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 5257

preupgrade will attempt to continue from that error
ORA-06512: at "SYS.DBMS_PREUP", line 2150
ORA-06512: at "SYS.DBMS_PREUP", line 5155
ORA-06512: at "SYS.DBMS_PREUP", line 5002


INTERNAL ERROR: An internal preupgrade error occurred that prevents further execution. This is unexpected and usually caused by some sort of internal inconsistency. You may want to contact Oracle Support. The internal error message is:
ORA-96562: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 293
ORA-06512: at "SYS.DBMS_PREUP", line 5059
ORA-06512: at "SYS.DBMS_PREUP", line 2150
ORA-06512: at "SYS.DBMS_PREUP", line 5155
ORA-06512: at "SYS.DBMS_PREUP", line 5002
ORA-06512: at line 39


Read more...

Environment

SAP independent

Oracle 12c

Keywords

Upgrade,Oracle 19c,Oracle 19c upgrade,XDB database , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.