重庆思庄Oracle、Redhat认证学习论坛

标题: 【补丁报错】ORA-20001: Latest xml inventory is not loaded into table [打印本页]

作者: Inkcup 时间: 6 天前
标题: 【补丁报错】ORA-20001: Latest xml inventory is not loaded into table
实验环境：
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

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

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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)