版本:12.2.0.1.0
操作系统:Linux oradb 5.10.134-13.an8.x86_64
故障:datapatch -verbose 执行报错
[oracle@oradb 33583921]$ /u01/SOFT/p6880880/OPatch/datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Sun Apr 7 18:24:11 2024
Copyright (c) 2012, 2021, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29104_2024_04_07_18_24_11/sqlpatch_invocation.log
Connecting to database...OK
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
Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'
and/or check the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29104_2024_04_07_18_24_11/sqlpatch_invocation.log
for the complete error.
Prereq check failed, exiting without installing any patches.
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29104_2024_04_07_18_24_11/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Sun Apr 7 18:24:23 2024
[oracle@oradb 33583921]$
SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;
VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-20001: Latest xml inventory is not loaded into table
SQL> select * from opatch_xml_inv;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command
/u01/app/oracle/product/12.2.0/db_1/QOpatch/qopiprep.bat encountered error
"Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
LsInventorySession failed: Unable to create patchObject Possible causes are:"
no rows selected
SQL>
墨值悬赏

评论

