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 for Me (Login required).

Search for additional results

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