Windows Server 2019 Standard Edition
Oracle Database 19.9.0.0.201020WINDBBP Enterprise Edition
Oracle Grid Infrastructure for Standalone Server 19.9.0.0.201020WINDBBP (No-RAC / ONLY ORACLE Restart - HAS and ASM )
-------------------------------------------------------------------------------------------------
ORA>%ORACLE_HOME%/Opatch/datapatch.bat -db rcat -verbose
SQL Patching tool version 19.3.0.0.0 Production on Tue Dec 22 18:20:34 2020
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: F:\orahome1\dbbase1\cfgtoollogs\sqlpatch\sqlpatch_7504_2020_12_22_18_20_34\sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
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
F:\orahome1\dbbase1\cfgtoollogs\sqlpatch\sqlpatch_7504_2020_12_22_18_20_34\sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Tue Dec 22 18:20:41 2020
ORA>
---
select dbms_sqlpatch.verify_queryable_inventory from dual;
--ORA-20001: Latest xml inventory is not loaded into table
---
select * from OPATCH_XML_INV;
/*
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command F:\orahome1\dbhome1\product\19c\db1\QOpatch\qopiprep.bat encountered error "LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file spec"
29913. 00000 - "error in executing %s callout"
*Cause: The execution of the specified callout caused an error.
*Action: Examine the error messages take appropriate action.
*/
ORA>%ORACLE_HOME%/Opatch/opatch lsinventory
--works fine!!!