Datapatch failed on 12.2 (verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table)

From: nilesh kumar <>
Date: Wed, 23 Sep 2020 06:12:17 -0700
Message-ID: <>

Hello Gurus,

I was applying a bug patch on the database on windows. Opatch successfully applied, but the post installation step "datapatch" faced error.

The sqlpatch_invocation.log has below

QL Patching tool version Production on Wed Sep 23 06:16:57 2020 Copyright (c) 2012, 2017, Oracle. All rights reserved.

Build label: RDBMS_12. Log file for this invocation:

Connecting to database...OK
catcon: ALL catcon-related output will be written to [D:\Oracle\Database12cR2\cfgtoollogs\sqlpatch\sqlpatch_2144_2020_09_23_06_16_57/sqlpatch_catcon__catcon_2144.lst] catcon: See
[D:\Oracle\Database12cR2\cfgtoollogs\sqlpatch\sqlpatch_2144_2020_09_23_06_16_57/sqlpatch_catcon_*.log] files for output generated by scripts
catcon: See
[D:\Oracle\Database12cR2\cfgtoollogs\sqlpatch\sqlpatch_2144_2020_09_23_06_16_57/sqlpatch_catcon__*.lst] files for spool files, if any
Use of uninitialized value $ENV{"ORACLE_HOME"} in concatenation (.) or string at D:\Oracle\Database12cR2\\rdbms\admin/ line 8126. catconInit: catcon_kill_sess_gen.sql not found at ORACLE_HOME, will instead use D:\Oracle\Database12cR2\rdbms\admin/catcon_kill_sess_gen.sql *verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table*

Please refer to MOS Note 1609718.1 and/or the invocation log D:\Oracle\Database12cR2\cfgtoollogs\sqlpatch\sqlpatch_2144_2020_09_23_06_16_57\sqlpatch_invocation.log

I re-created the directories "OPATCH_SCRIPT_DIR,OPATCH_LOG_DIR" with the same path as mentioned in MOS Note 1609718.1 and also I rolled backed the patch and updated opatch with latest version but still same issue.

Could you please advise.

Thanks & Regards
Oracle DBA (sqlplus "/as sysdba" is my world)

"As our circle of knowledge expands, so does the circumference of darkness
surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot
by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do
and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may
not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat
you with experience." - Unknown --
Received on Wed Sep 23 2020 - 15:12:17 CEST

Original text of this message