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 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