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

今天和大家分享在安装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 sysdbaselect 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 tablespace_name,file_name,bytes/1024/1024/1024 from dba_data_files;select tablespace_name,file_name from dba_data_files where tablespace_name='SYSAUX';alter tablespace SYSAUX add datafile '/data/oradata/ORCL/sysaux02.dbf' size 1G autoextend on next 100M;

最后，恭祝各位使用愉快！