SAP Knowledge Base Article - Preview

2708154 - Package body XDB.DBMS_XMLSTORAGE_MANAGE is Invalid

Symptom

While preparing to upgrade from Oracle 12.1 to Oracle 12.2, there were no invalid objects before running the dbua.sap.sh  script. At the Prerequisite Checks screen (Step 2 of 9), it identified that there were invalid objects.  Specifically, only XDB.DBMS_XMLSTORAGE_MANAGE package body is invalid. Attempting to compile the package body results in these errors:

SQL> alter package XDB.DBMS_XMLSTORAGE_MANAGE compile body;   Warning: Package Body altered with compilation errors.  SQL> show errors Errors for PACKAGE BODY XDB.DBMS_XMLSTORAGE_MANAGE:

LINE/COL ERROR -------- -----------------------------------------------------------------

668/4    PL/SQL: SQL Statement ignored

668/59   PL/SQL: ORA-00942: table or view does not exist

682/4    PL/SQL: SQL Statement ignored

682/38   PL/SQL: ORA-00942: table or view does not exist

928/4    PL/SQL: SQL Statement ignored

928/59   PL/SQL: ORA-00942: table or view does not exist

941/4    PL/SQL: SQL Statement ignored

941/38   PL/SQL: ORA-00942: table or view does not exist


Read more...

Keywords

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.