Upgrade EBS 12.2.4 to EBS 12.2.12 Oracle Application
In this post I am going how to upgrade the EBS 12.2.4 version to 12.2.12.
System Details:
One node Database: DB 19.15 Version
One node Application: Apps 12.2.4
1) Check current version for database and application
2) Check database Character Set
3) The following products are obsolete in Release 12.2.12. Please check with Oracle contact before upgrading if you are using any of below products
Oracle Demand Planning (obsolete in Release 12.2.5 and above)
Oracle Manufacturing Scheduling (obsolete in Release 12.2.5 and above)
4) Check the AD and TXK version
5) Apply Required Database Patches
Run the latest version (available via Patch 17537119) of the EBS Technology Codelevel Checker (ETCC).
Use the command checkDBpatch.sh (on UNIX)
Download the patch and copy to the database server.
Source the PDB environment file as it is 19c database with multitenancy. No recommendation were presented by the script for the current DB version. Proceeding further with next steps.
6) If you are using Oracle Database 19c or later, optimizer adaptive features are no longer controlled by the database initialization parameter optimizer_adaptive_features. Instead, these features are controlled by two new parameters: optimizer_adaptive_plans, which defaults to TRUE, and optimizer_adaptive_statistics, which defaults to FALSE.
No changes needed as it is set to correct value
7) Disable Actualization for Grant
This parameter is applicable if you are using Oracle Database 23ai, 19c, 12.1.0.2, or 11.2.0.4.
Set the parameter _disable_actualization_for_grant to true at CDB level.
_disable_actualization_for_grant=true
You can verify the parameter was set correctly by running the following command, which should return the value TRUE:
SQL> show parameter "_disable_actualization_for_grant"
8) Apply Delta 14 AD and TXK patches
Download and unzip patches into the $PATCH_TOP directory, which is the directory pointed to by $APPL_TOP_NE/../patch (UNIX)
Patch 33600809 (R12.AD.C.Delta.14)
Patch 33602997 (R12.TXK.C.Delta.14)
Patch 34669333:R12.AD.C (BUNDLE PATCH ON TOP OF R12.AD.C.DELTA.14)
Critical AD Patches
You should apply the following additional critical AD patches
Patch 34668508:R12.AD.C
Patch 34669333:R12.AD.C - BUNDLE PATCH ON TOP OF R12.AD.C.DELTA.14
Patch 34681299:R12.AD.C
Patch 35280947:R12.AD.C
Critical TXK Patches
Patch 34708635:R12.TXK.C - If you are a customer using Oracle Web Applications Desktop Integrator (BNE) or Oracle Report Manager (FRM),
Patch 34654260:R12.TXK.C
Download all above patches and copy to Application Server. Unzip all patches.
Run the latest version of the adgrants.sql script, which will grant the required privileges and also create the EBS_SYSTEM schema if it does not already exist
Copy the adgrants.sql script from Patch 34669333 to the database tier server (if the adgrants.sql from the patch dir is higher)
$ cp $PATCH_TOP/34669333/admin/adgrants.sql $ORACLE_HOME/appsutil/admin/
On the database tier server as “oracle” user
source $ORACLE_HOME/<CDB_NAME>_<HOSTNAME>.env
$ export ORACLE_PDB_SID=UAT
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps
Please note after this adgrant.sql EBS_SYSTEM schema is created in database. it creates the EBS_SYSTEM user in a locked state.
source $ORACLE_HOME/<CDB_NAME>_<HOSTNAME>.env
$ export ORACLE_PDB_SID=UAT
sqlplus '/as sysdba'
ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;
ALTER USER EBS_SYSTEM IDENTIFIED BY <keep same as system password of DB>
Validate that the EBS_SYSTEM and SYSTEM passwords are the same by running the adValidateEbssystemSchema.pl script from from the run edition file system, with the appropriate command for your system:
$ perl $PATCH_TOP/33600809/ad/bin/adValidateEbssystemSchema.pl
Connect to Application Server and start the patching cycle. We will be applying patches on patch file system in this activity.
Source the run edition applications environment.
$ . <INSTALL_BASE>/EBSapps.env run
Start an online patching cycle.
$ adop phase=prepare
cd $PATCH_TOP
adop phase=apply patches=33600809,34668508,34669333,34681299,35280947 merge=yes
cd $PATCH_TOP
adop phase=apply patches=33602997,34654260,34708635 merge=yes
Make sure all patch application is successful.
Connect as apps user and check
select bug_number,creation_date from ad_bugs where bug_number in ('33600809','34668508','34669333','34681299','35280947','33602997','34654260','34708635');
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=finalize
$ adop phase=cutover
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=cleanup
Validate new AD and TXK version
9) Make Appsutil directory
Source the run edition file system environment file.
$ . <EBS_ROOT>/EBSapps.env run
perl $AD_TOP/bin/admkappsutil.pl
And copy to db tier Oracle Home and Unzip
Run autoconfig on DB and APPS node. Make sure its successful.
10) Sync the class files in run and patch file system
Make sure that the s_apps_jdbc_patch_connect entry in control file have the instance name as the container name and correct service name.
Source the run edition file system environment file.
$ . <EBS_ROOT>/EBSapps.env run
adjava -mx512m oracle.apps.ad.jri.adjcopy -masterArchive $JAVA_TOP -sync -mode APPLY
Source the patch edition file system environment file.
$ . <EBS_ROOT>/EBSapps.env patch
adjava -mx512m oracle.apps.ad.jri.adjcopy -masterArchive $JAVA_TOP -sync -mode APPLY
11) Apply Oracle E-Business Suite Release 12.2.12 Patch 33527700.
Merge Release 12.2.12 Patch 33527700 and Critical Patch 36842768:R12.FND.C.
$ . <INSTALL_BASE>/EBSapps.env run
Start an online patching cycle and apply patches as below
$ adop phase=prepare
$ adop phase=apply patches=33527700,36842768 merge=yes wait_on_failed_job=yes
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=finalize
$ adop phase=cutover
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=cleanup
$ adop phase=fs_clone
12)Apply Oracle E-Business Suite Release 12.2.12 Online Help
Using adop hotpatch mode on the run file system, apply Oracle E-Business Suite Release 12.2.12 Online Help Patch 33527707.
$ adop phase=apply patches=33527707 hotpatch=yes
$adop phase=fs_clone
Now Validate the EBS Version and test the environment.
Post a Comment
Post a Comment