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

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_at_comcast.net> 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_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 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
>

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

--
http://www.freelists.org/webpage/oracle-l