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