【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 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;最后，恭祝各位使用愉快！