RE: Datapatch failed on 12.2 (verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table)
Date: Wed, 23 Sep 2020 06:20:36 -0700
Message-ID: <3ad801d691ac$56e021a0$04a064e0$_at_comcast.net>
What patch number were you applying?
I have had some cases where datapatch fails on simply updating the tables in the database and have had to run the direct command that datapatch would run against the database to get it to work.
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of nilesh kumar
Sent: Wednesday, September 23, 2020 6:12 AM
To: ORACLE-L <Oracle-L_at_freelists.org>
Subject: Datapatch failed on 12.2 (verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table)
Hello Gurus,
I was applying a bug patch on the 12.2.0.1 database on windows.
Opatch successfully applied, but the post installation step "datapatch"
faced error.
The sqlpatch_invocation.log has below
QL Patching tool version 12.2.0.1.0 Production on Wed Sep 23 06:16:57 2020
Copyright (c) 2012, 2017, Oracle. All rights reserved.
Build label: RDBMS_12.2.0.1.0_WINDOWS.X64_170210.4
Log file for this invocation: D:\Oracle\Database12cR2\cfgtoollogs\sqlpatch\sqlpatch_2144_2020_09_23_06_16_57\sqlpatch_invocation.log
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/catcon.pm <http://catcon.pm> 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 Nilesh Oracle DBA (sqlplus "/as sysdba" is my world)Received on Wed Sep 23 2020 - 15:20:36 CEST
"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
-- http://www.freelists.org/webpage/oracle-l