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.