Oracle E-Business Suite Upgrade High Level Steps From 12.2.0 to 12.2.5

Oracle E-Business Suite Upgrade High Level Steps From 12.2.0 to 12.2.5

All Oracle EBS Fresh installations will configure base release 12.2.0, which has to be upgraded separately after the successful completion of the installation.

Source version: 12.2.0
Target version: 12.2.5

1) Run the EBS Technology Codelevel Checker (ETCC), which will provide output of all the latest available patches that are missing on the current instance.
-available via patch 17537119.

2) Run the two scripts on database as well as application tier.
-source the ENV run checkDBpatch.sh
-it will show below homes patches.
*Oracle Forms and Reports 10.1.2.3.0
*Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
*Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
*Oracle WebLogic Server (WLS) 10.3.6.0.7
-source the ENV run sh checkDBpatch.sh
*Oracle Database Release 12.1.0.2  (No PSU applied)

3) Apply Oracle Database Release 12.1.0.2 Patches:
-Bring down Application, Database and listener.
-Apply all Database patches recommended by ETCC
-set path.
-opatch apply.

4) Apply Oracle Application Home 10.1.2.3.0 Patches:
-set path
-opatch apply

5) Apply Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0 Patches:
-set path.
-opatch apply.

6) Apply Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0 Patches.
-set path.
-opatch apply.

7) Apply Oracle WebLogic Server (WLS) 10.3.6.0.7 Patches.
-patch must be installed on WebLogic Server before proceeding with the upgrade.

8) Applying AD and TKX Patches.
e.g:
p20745242_R12.AD.C_R12_LINUX.zip
p20784380_R12.TXK.C_R12_GENERIC.zip
p22123818_R12.AD.C_R12_LINUX.zip
p22363475_R12.TXK.C_R12_GENERIC.zip
p22495069_R12.TXK.C_R12_GENERIC.zip
-make sure we have taken before applying these patches.
-mtart the WebLogic admin server from the RUN file system.
-run adgrants.sql from the respective patch directories before applying the patch.
-The patch 20745242 (R12.AD.C.Delta.7) contains a newer version of the adgrants.sql script, so it’s mandatory to execute this script from the database tier.
-adop phase=apply patches=20745242 hotpatch=yes
-Similarly, the patch 22123818:R12.AD.C also contains the adgrants.sql script. Execute the script before applying this patch.
-adop phase=apply patches=22123818 hotpatch=yes
-After installing these patches, you can merge patches 20784380, 22363475, and 22495069 and install it.
-adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes

9) Execute AutoConfig on the database tier.

10) Migrate the latest code on the database tier using $AD_TOP/bin /admkappsutil.pl.

11) Restart the database and application tiers.
-Once after applying all the patches, run again ETCC (EBS Technology Codelevel Checker) and get the confirmation that all the required pathces has been applied on all the technology stacks.
-sh checkDBpatch.sh
-sh checkMTpatch.sh

12) Installation of 12.2.5 Upgrade Patch.
-The preparation of the EBS 12.2.5 patch upgrade is complete. Now the system is almost ready for installing an upgrade patch. Follow these steps
-Set optimizer_adaptive_features to FALSE. It’s recommended that you set this to FALSE because of performance issues during upgrade.
-Source the RUN file system and stop all the application services.
- Ensure there is no active patching cycle using "adop -status"
- Install 12.2.5 Upgrade patch 19676458 in downtime mode.
-adop phase=apply apply_mode=downtime patches=19676458

13) Verify the logs and execute the cleanup phase.
- adop phase=cleanup
- After cleanup, run the fs_clone to sync the another file system with first one.
- adop phase=fs_clone
- Revert the DB parameter changes: optimizer_adaptive_features to TRUE.

The upgrade of Oracle EBS 12.2.0 to 12.2.5 has completed successfully.