I was applying
DATAPUMP EXPORT EXTREMELY SLOW FETCHING COMMENT OBJECTS. (Patch)
p27277810_122010_Generic.zip
Thanks
Nilesh
On Wed, Sep 23, 2020 at 6:20 AM <dimensional.dba@xxxxxxxxxxx> wrote:
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 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
