SAP Knowledge Base Article - Preview

2530308 - ORA-20001 shown by DBMS_QOPATCH

Symptom

IMPORTANT NOTE: This article does not deal issues during a database upgrade! Like below visible, this document addresses a problem with a manual execution of DBMS_QOPATCH.

Executing any Subprogram of DBMS_QOPATCH produces errors like below:

SQL> select xmltransform(dbms_qopatch.get_opatch_list, dbms_qopatch.get_opatch_xslt) from dual;
ERROR:
ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 704
ORA-06512: at "SYS.DBMS_QOPATCH", line 839

no rows selected

SQL> select xmltransform(dbms_qopatch.get_opatch_bugs, dbms_qopatch.get_opatch_xslt) from dual;
ERROR:
ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 704
ORA-06512: at "SYS.DBMS_QOPATCH", line 1002
ORA-06512: at line 1

no rows selected


Read more...

Environment

  • UNIX / Linux
  • SAP Release Independent
  • As of Oracle RDBMS 12c

Keywords

DBMS_QOPATCH, oracle, 12.1, ORA-20001, ORA-06512, datapatch, SBP, SAP Bundle Patch, package, error, fail, select, dual, exec , 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.