EM 13c: Database Cloning on Windows Failing with: Queryable Inventory Could not Determine the Current Opatch Status.
(Doc ID 2757719.1)
Last updated on MAY 03, 2021
Applies to:Enterprise Manager for Oracle Database - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Trying to close a 12.2 DB on the same Windows server (different home), will fail with this error in the Deployment Procedure step output:
Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'
and/or check the invocation log
for the complete error.
Prereq check failed, exiting without installing any patches.
The same error can be seen by running this command in the new (cloned) database:
Checking the alert log file on the cloned database, this error will be seen:
Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 777
ORA-06512: at "SYS.DBMS_QOPATCH", line 864
ORA-06512: at "SYS.DBMS_QOPATCH", line 2222
ORA-06512: at "SYS.DBMS_QOPATCH", line 740
ORA-06512: at "SYS.DBMS_QOPATCH", line 2247
Dumping current patch information
Unable to obtain current patch information due to error: 20001
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document