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

Hi Amit,

I had recreated directories OPATCH_LOG_DIR and OPATCH_SCRIPT_DIR, need to check with OPATCH_INST_DIR.
I had also tried by setting the below parameter to true but it didn't work. *alter system set "_disable_directory_link_check"=TRUE scope=spfile;*

I am not sure if Java is creating an issue, as few blogs have stated that I need to unset the JAVA. But not sure on that.

Thanks
Nilesh

On Wed, Sep 23, 2020 at 9:34 AM Amit Grover <amitgrover27_at_gmail.com> wrote:

> Check the location for the OPATCH* directories are they pointing to a
> softlink or actual path, Oracle made the change supposedly in 12.1 but
> didn't kind of enforce it, the paths from 12.2 need to be actual locations
> and soft links don't work..
>
> create or replace directory OPATCH_LOG_DIR as '<$ORACLE_HOME>/QOpatch';
> create or replace directory OPATCH_SCRIPT_DIR as '<$ORACLE_HOME>/QOpatch';
> create or replace directory OPATCH_INST_DIR as '<$ORACLE_HOME>/OPatch';
>
> Check the DOC ID 1602089.1 on MOS if that doesn't help.
>
> Best Regards
> Amit Grover
> 2065966629
>
>
> On Wed, Sep 23, 2020 at 8:52 AM nilesh kumar <nileshkum_at_gmail.com> wrote:
>
>> 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
>>
>

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