Error - Applying Latest AD, TXK Patches to our EBS 12.2.8

Hi Prashant,

sql> show parameter _disable_actualization_for_grant

Returns blank 

Kind regards,

Hi Prashant,

Yes that was my first step, running adgrants.sql, although I got warning error at end part saying some views are do not exist?

I will try it again, and show the output here....brb

Regards,

Hi Maaz,

SQL> alter system set "_disable_actualization_for_grant"=true;
alter system set "_disable_actualization_for_grant"=true
                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

I think I missed some ETCC patches that is why I got this error.

When I run ETCC for database I got list below:

Patch mapping not available.

Patch mapping data is not available for 12.1.0.2 ProactiveBP

Some required one-off bugfixes are missing from the Database ORACLE_HOME.

The missing bugfixes are:

8975044

26742604

28507324

28542455

29125374

29496791

I tried to opatch apply  29496791 > but it has conflicts

I think this patch has the solution for the parameter setting "_disable_actualization_for_grant"

Kind regards,

Thanks Hal and Maaz,

Our EBS 12.2.8 maybe has not really cleared the ETCC checker, hence I got the consequence error now

This may cleared up my error with > alter system set "_disable_actualization_for_grant"=true;

I raised an SR to Oracle Support re: my conflict error when applying db patch > 29496791

And below is the answer:

DB BP 29496791 showed conflict with many patches. Merge patches are released for these conflicts and patching may be performed in following manner -

1. Rollback the conflicting patches - 27322338, 27322748 and 27333394.

2. Apply DB BP 29496791

3. Now, download and apply these merge patches -

Patch 25139545 released for version 'Oracle 12.1.0.2.190416 Proactive BP' - http://updates.oracle.com/download/25139545.html

Patch 28235934 released for version 'Oracle 12.1.0.2.180717 Proactive BP' - http://updates.oracle.com/download/28235934.html

Patch 29943147 released for version 'Oracle 12.1.0.2.190716 Proactive BP' - http://updates.oracle.com/download/29943147.html

Patch 19239846 released for version 'Oracle 12.1.0.2.190716 Proactive BP' - http://updates.oracle.com/download/19239846.html

Patch 25099339 released for version 'Oracle 12.1.0.2.190716 Proactive BP' - http://updates.oracle.com/download/25099339.html

Patch 23604553 released for version 'Oracle 12.1.0.2.190716 Proactive BP' - http://updates.oracle.com/download/23604553.html

Kind regards,

Hi ALL.

I was able to do steps  1 and 2,

But for additional patch, I got conflict error again

25139545]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2019, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u04/orap1228/P1228/12.1.0

Central Inventory : /u04/orap1228/P1228/12.1.0/admin/oui/P1228_trnsrvr/oraInventory

from : /u04/orap1228/P1228/12.1.0/oraInst.loc

OPatch version : 12.2.0.1.17

OUI version : 12.1.0.2.0

Log file location : /u04/orap1228/P1228/12.1.0/cfgtoollogs/opatch/opatch2019-10-14_19-37-40PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" failed.

The details are:

Interim patch 25139545 requires prerequisite patch(es) [29141015] which are not present in the Oracle Home.

Apply prerequisite patch(es) [29141015] before applying interim patch 25139545.

Summary of Conflict Analysis:

There are no patches that can be applied now.

Whole composite patch Conflicts/Supersets are:

Patch : 25139545

Conflict with Composite Patch 29496791

Detail Conflicts/Supersets for each patch are:

Patch : 25139545

Conflict with Sub-Patch 29141038

Conflict details:

/u04/orap1228/P1228/12.1.0/rdbms/admin/dpload.sql

OPatch succeeded.

Please help how to apply this patch.  

The support is very long time to reply.

Kind regards,

Thanks Prasant, I will try it....brb