【Oracle点滴积累】解决ORA-20001: Latest xml inventory is not loaded into table故障的方法

广告位招租！
知识无价，人有情，无偿分享知识，希望本条信息对你有用！

今天和大家分享在安装Oracle Critical Patch Update (Patch Number:33806138) 遇到ORA-20001: Latest xml inventory is not loaded into table故障时的解决方法。本博文仅供参考，谢谢！

本博文提供Oracle官方文档MOS Note 1609718.1

sqlplus /nolog
conn / as sysdba

select dbms_sqlpatch.verify_queryable_inventory from dual;

select * from OPATCH_XML_INV;


select xmltransform(dbms_qopatch.get_opatch_lsinventory(), dbms_qopatch.GET_OPATCH_XSLT()) from dual;

Solution:

select tables