Please provide the following output -
show parameter _disable_actualization_for_grant
sql> show parameter _disable_actualization_for_grant
Ok, Can you try to apply one by one or hotpatch ?
Please confirm if you ran the following as a pre-req for this patch -
Execute adgrants script by following the instructions in the readme of Patch 26834480:
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.
$ grep ‘$Header’ $ORACLE_HOME/appsutil/admin/adgrants.sql
REM $Header: adgrants.sql 120.67.12020000.60 2018/04/26 02:32:13 jwsmith ship $
$ grep ‘$Header’ /backup/patches/EBS12.2/ADTKX/26834480/admin/adgrants.sql
REM $Header: adgrants.sql 120.67.12020000.65 2019/04/02 22:47:38 jwsmith ship $
3. Copy the higher version of adgrants.sql (UNIX) to $ORACLE_HOME/appsutil/admin.
$ cp -iv /backup/patches/EBS12.2/ADTKX/26834480/admin/adgrants.sql /u01/install/APPS/12.1.0/appsutil/admin
4. Set the environment to point to ORACLE_HOME on the database server.
$ . ~/EBSDB_database.env
5. Use SQL*Plus to run the script:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS
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
The parameter you are trying to set is a hidden parameter, please try it like below,
alter system set "_disable_actualization_for_grant"=true;
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 220.127.116.11 ProactiveBP
Some required one-off bugfixes are missing from the Database ORACLE_HOME.
The missing bugfixes are:
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"
Strange, I just ran same command in my environment ebs r12.2.8 just to test it and it went fine.
hope you are running it with sysdba user
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 -
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 18.104.22.168.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
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 : 22.214.171.124.17
OUI version : 126.96.36.199.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)  which are not present in the Oracle Home.
Apply prerequisite patch(es)  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
Please help how to apply this patch.
The support is very long time to reply.
Thanks Prasant, I will try it....brb