Tag: datapatch

Another reason for verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

In another post I wrote some time ago, I ran into the error ORA-20001 during the datapatch of a 19c upgrade. I got the same error but with a different reason this time: temp data files missing due to OS changes. So we moved a 12c datatabase from Oracle Linux 6 to Oracle Linux 8 … Continue reading Another reason for verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table →

Advertisement

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

Ran into a different issue with Oracle 19c datapatch again. The error was: [oracle@joedb OPatch]$ ./datapatch -verbose SQL Patching tool version 19.14.0.0.0 Production on Thu Jun 2 19:35:49 2022 Copyright (c) 2012, 2021, Oracle. All rights reserved. Log file for this invocation: /opt/oracle/cfgtoollogs/sqlpatch/sqlpatch_74090_2022_06_02_19_35_49/sqlpatch_invocation.log Connecting to database...OK Gathering database info...done Bootstrapping registry and package to current … Continue reading verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table →

SQL Patch fails — Archived Patch Directory Is Empty — sqlpatch_invocation.log

When patching Oracle database, some patches need to update database objects. A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. In Oracle 12c, Oracle has introduced a new tool named "datapatch" which enables automation of post-patch SQL actions for RDBMS patches. It's called by OPatchAuto usually. … Continue reading SQL Patch fails — Archived Patch Directory Is Empty — sqlpatch_invocation.log →