【补丁报错】ORA-20001: Latest xml inventory is not loaded into table

Inkcup

实验环境：
windows10  Oracle database 19.30
补丁版本及工具版本：
db19.19 ：p35046439_191900_MSWIN-x86-64
opatch: p6880880_122010_MSWIN-x86-64, OPatch 版本：12.2.0.1.42

---

帖主在Windows10上打1919的补丁，在最后datapatch -verbose的步骤上出现报错：

C:\Users\zw\Desktop\data\V982656-01\OPatch>datapatch -verbose

SQL Patching tool version 19.19.0.0.0 Production on Thu Mar  6 23:42:34 2025

Copyright (c) 2012, 2023, Oracle.  All rights reserved.

Log file for this invocation: C:\Users\app\oracle\cfgtoollogs\sqlpatch\sqlpatch_3040_2025_03_06_23_42_34\sqlpatch_invocation.log

Connecting to database...OK

Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs

       that are in an open state, no patches will be applied to closed PDBs.

       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done

Error: prereq checks failed!

verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log

C:\Users\app\oracle\cfgtoollogs\sqlpatch\sqlpatch_3040_2025_03_06_23_42_34\sqlpatch_invocation.log

for information on how to resolve the above errors.

SQL Patching tool complete on Thu Mar  6 23:42:41 2025

详细报错如下：

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY

--------------------------------------------------------------------------------

ORA-20001: Latest xml inventory is not loaded into table

---

# 然后通过手动创建XML文件解决了报错：

C:\Users\zw>set ORACLE_HOME=C:\Users\zw\Desktop\data\V982656-01

C:\Users\zw>cd %ORACLE_HOME%

C:\Users\zw\Desktop\data\V982656-01>cd OPatch

C:\Users\zw\Desktop\data\V982656-01\OPatch>opatch lsinv -xml C:\new1\test01.xml

Oracle 临时补丁程序安装程序版本 12.2.0.1.42

版权所有 (c) 2025, Oracle Corporation。保留所有权利。

Oracle 主目录       ：C:\Users\zw\Desktop\data\V982656-01

主产品清单：C:\Program Files\Oracle\Inventory

   来自           ：

OPatch 版本    ：12.2.0.1.42

OUI 版本       ：12.2.0.7.0

日志文件位置：C:\Users\zw\Desktop\data\V982656-01\cfgtoollogs\opatch\opatch2025-03-06_23-58-01下午_1.log

Lsinventory Output file location : C:\Users\zw\Desktop\data\V982656-01\cfgtoollogs\opatch\lsinv\lsinventory2025-03-06_23-58-01下午.txt

--------------------------------------------------------------------------------

Generated xml file C:\new1\test01.xml from Oracle Home inventory shown above.

OPatch succeeded.

C:\Users\zw\Desktop\data\V982656-01\OPatch>datapatch -verbose C:\new1\test01.xml