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

刘泽宇

ERROR:
ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 1448
ORA-06512: at "SYS.DBMS_QOPATCH", line 122


select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04027: file name check failed: <$ORACLE_HOME>/QOpatch/qopiprep.bat

qopatch_log.log 显示：

KUP-04027: file name check failed: qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: Oracle Directory object contains 1 symbolic links at path component /u01
KUP-04118: operation "lstat64", location "skudmicdl:1"

解决方案：
ORACLE_HOME是一个符号链接，其下的目录实际上是符号链接（不指向完整的路径名）。因此我们需要更改OPATCH_SCRIPT_DIR，OPATCH_LOG_DIR的值，以便它指向完整路径

SQL> create or replace directory OPATCH_LOG_DIR as '<complete path to QOpatch>';
Directory created.

SQL> create or replace directory OPATCH_SCRIPT_DIR as '<complete path to QOpatch>';
Directory created.
或者通过重新创建的目录结构中删除软链接。

重新执行安装后步骤

cd $ORACLE_HOME/OPatch [cd $ORACLE_HOME/sqlpatch (older version)]

./datapatch -verbose