19c 升级后需要执行./datapatch -verbose命令，但是报错如下：http://www.cndba.cn/dave/article/131628

[oracle@19ctest 35643107]$ cd /data/app/oracle/product/19.3.0/dbhome_1/OPatch/
[oracle@19ctest OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.21.0.0.0 Production on Wed Apr 23 19:44:41 2025
Copyright (c) 2012, 2023, Oracle.  All rights reserved.

Log file for this invocation: /data/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3405_2025_04_23_19_44_41/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.

这里和JAVA_HOME设置有问题，一般建议设置为$ORACLE_HOME/jdk，设置完毕后检查一下$ORACLE_HOME/jdk/bin/java是否可执行。

然后修改OPatch目录下的opatch改名为opatch.org，在新建opatch文件，包含如下内容，添加如下内容：

$ORACLE_HOME/OPatch/opatch.org $* -jdk $ORACLE_HOME/jdk

http://www.cndba.cn/dave/article/131628

在执行就不会报错了。http://www.cndba.cn/dave/article/131628http://www.cndba.cn/dave/article/131628http://www.cndba.cn/dave/article/131628

版权声明：本文为博主原创文章，未经博主允许不得转载。