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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of nilesh kumar
Sent: Wednesday, September 23, 2020 6:12 AM
To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
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)
"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