How To Appy Fmw And Webtier Patches In R12.2 Blogs

Upgrade EBS 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.

We will cover the upgrade process of a freshly installed Oracle EBS system from release 12.2.0 to 12.2.5.

You may checkout below link for fresh EBS installation using below link:

Oracle EBS 12.2.5 installation

As the first step, you should install patch 17537119 (EBS Technology Codelevel Checker (ETCC)), which will provide output of all the latest available patches that are missing on the current instance. You should ensure that you have downloaded the latest version of this patch from Oracle Support.

This patch will have two scripts:

checkDBpatch.sh
checkMTpatch.sh

Execution of checkMTpatch.sh: Set the env and run below.

[applmgr@ol5-r122-ebs1 ~]$ sh checkMTpatch.sh

we get the list of below patches that need's to be applied on application techstacks.

========================================================================
PATCH RECOMMENDATION SUMMARY
========================================================================
One or more products have bugfixes missing.
The default patch recommendations to install these missing bugfixes are:

-------------------------------------------------------------------------------
Oracle Forms and Reports 10.1.2.3.0
-------------------------------------------------------------------------------
Patch 24946444 - Filename: p24946444_101232_LINUX.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
-------------------------------------------------------------------------------
Patch 22288381 - Filename: p22288381_111190_Generic.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
-------------------------------------------------------------------------------
Patch 9905685 - Filename: p9905685_111190_Generic.zip
Patch 21366277 - Filename: p21366277_111190_Generic.zip
Patch 21628307 - Filename: p21628307_111190_Generic.zip
Patch 24606362 - Filename: p24606362_111190_Generic.zip
-------------------------------------------------------------------------------
Oracle WebLogic Server (WLS) 10.3.6.0.7
-------------------------------------------------------------------------------
Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018]
- Filename: p23743997_1036_Generic.zip
========================================================================

Execution of checkDBpatch.sh:Set the env and run below.

[oracle@ol5-r122-ebs1 ~]$ sh checkDBpatch.sh

========================================================================

PATCH RECOMMENDATION SUMMARY

========================================================================

The default patch recommendations to install these missing bugfixes are:

-------------------------------------------------------------------------------

Oracle Database Release 12.1.0.2 (No PSU applied)

-------------------------------------------------------------------------------

Patch 23595848 - Filename: p23595848_121020_Linux-x86-64.zip

Patch 18793246 - Filename: p18793246_121020_Generic.zip

Patch 24911308 - Filename: p24911308_121020_Linux-x86-64.zip

Patch 19591608 - Filename: p19591608_121020_Linux-x86-64.zip

Patch 19908836 - Filename: p19908836_121020_Linux-x86-64.zip

Patch 20766180 - Filename: p20766180_121020_Generic.zip

Patch 24481723 - Filename: p24481723_121020_Linux-x86-64.zip

Patch 22098146 - Filename: p22098146_121020_Linux-x86-64.zip

Patch 21321429 - Filename: p21321429_121020_Generic.zip

Patch 21864513 - Filename: p21864513_121020_Linux-x86-64.zip

Patch 21904072 - Filename: p21904072_121020_Linux-x86-64.zip

Patch 21967332 - Filename: p21967332_121020_Linux-x86-64.zip

Patch 22338374 - Filename: p22338374_121020_Linux-x86-64.zip

Patch 22496904 - Filename: p22496904_121020_Linux-x86-64.zip

Patch 22731026 - Filename: p22731026_121020_Generic.zip

Patch 23089357 - Filename: p23089357_121020_Linux-x86-64.zip

Patch 24560906 - Filename: p24560906_121020_Linux-x86-64.zip

+-----------------------------------------------------------------------------+

Apply : Oracle Database Release 12.1.0.2 Patches:

Bring down Application, Database and listener.

Apply all Database patches recommended by ETCC

[oracle@ol5-r122-ebs1 ~]$ which opatch

/u01/app/oracle/r12ebs/12.1.0/OPatch/opatch

[oracle@ol5-r122-ebs1 ~]$ cd 23595848

[oracle@ol5-r122-ebs1 23595848]$ opatch apply

Sometimes you may see patch conflicts with critical patch updates (CPUs)/patchset upates (PSUs) installed, in that case, you may need to roll back certain patches and install certain patches with patch

I have demonstrated installation of only one patch on RDBMS home. We should follow the same process for Installing other RDBMS patches as recommended by ETCC.

After installing the patches start the database and listener, copy the adgrants.sql script from $APPL_TOP/admin/ to the database tierb and execute the script from the database tier.

Run utlrp.sql and validate we don't have any invalids.

Apply: Oracle Application Home 10.1.2.3.0 Patches:

[applmgr@ol5-r122-ebs1 ~]$ cd 24946444

[applmgr@ol5-r122-ebs1 24946444]$ which opatch

/u01/app/EBSR12/fs1/EBSapps/10.1.2/OPatch/opatch

[applmgr@ol5-r122-ebs1 24946444]$ echo $ORACLE_HOME

/u01/app/EBSR12/fs1/EBSapps/10.1.2

[applmgr@ol5-r122-ebs1 24946444]$ opatch apply

Apply: Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0 Patches:

[applmgr@ol5-r122-ebs1 ~]$ cd 22288381

[applmgr@ol5-r122-ebs1 22288381]$ export ORACLE_HOME=/u01/app/EBSR12/fs1/FMW_Home/webtier

[applmgr@ol5-r122-ebs1 22288381]$ opatch apply

Apply :Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0 Patches:

[applmgr@ol5-r122-ebs1 ~]$ cd9905685

[applmgr@ol5-r122-ebs1 9905685]$ export ORACLE_HOME=/u01/app/EBSR12/fs1/FMW_Home/oracle_common

[applmgr@ol5-r122-ebs1 9905685]$ opatch apply

apply other patches 21366277, 21628307, 24606362 similarily.

Apply: Oracle WebLogic Server (WLS) 10.3.6.0.7 Patches:

The following patch must be installed on WebLogic Server before proceeding with the upgrade.

Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018]

This patch gets conflicts with below existing patches:

you must remove all conflicts and apply

patch

23743997 using the bsu.sh utility.

CW9T, VKXF, FCX7, Y5AP, 1LRI, 2GYW, BLTG

Patch23743997 ( K25M ) requires below prerequisite patches:

13729611 Z9PC

17319481 9KCT

19259028 KRDE

19687084 NJVF

22323006 DI8E

24608998 QMJP

Install all above patches using BSU and apply Patch23743997.

[applmgr@ol5-r122-ebs1 bsu]$ cd /u01/app/EBSR12/fs1/FMW_Home/utils/bsu

[applmgr@ol5-r122-ebs1 bsu]$ ./bsu.sh

Below is the screenshot of BSU utility.

Applying AD and TKX Patches:

The patch sequence, patch numbers, and options may change, so it's recommended that you refer to MOS tech note "Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12" (Doc ID 1617461.1) before applying these patches. The patching sequence and options provided should be used as mentioned or the patching cycle may encounter issues.

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

Copy all above patches to PATCH TOP dir:

[applmgr@ol5-r122-ebs1 ~]$ cd /u01/app/EBSR12/fs_ne/EBSapps/patch

- Make sure we have taken before applying these patches.
- Start 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 as

[applmgr@ol5-r122-ebs1 ~]$ 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.

[applmgr@ol5-r122-ebs1 ~]$ adop phase=apply patches=22123818 hotpatch=yes

After installing these patches, you can merge patches 20784380, 22363475, and 22495069 and install it

[applmgr@ol5-r122-ebs1 ~]$ adop phase=apply patches=20784380,22363475,22495069

hotpatch=yes merge=yes

-Execute AutoConfig on the database tier.
-Migrate the latest code on the database tier using $AD_TOP/bin /admkappsutil.pl.
-Restart the database and application tiers.

Once after applying all the patches, lets run ETCC (EBS Technology Codelevel Checker) and get the confirmation that all the required pathces has been applied on all the technology stacks.

[applmgr@ol5-r122-ebs1 ~]$ shcheckDBpatch.sh
[applmgr@ol5-r122-ebs1 ~]$ shcheckMTpatch.sh

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.

[applmgr@ol5-r122-ebs1 ~]$ adop phase=apply apply_mode=downtime patches=19676458
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

-- Verify the logs and execute the cleanup phase.

[applmgr@ol5-r122-ebs1 ~]$ adop phase=cleanup
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

-- After cleanup, run the fs_clone to sync the another file system with first one.

[applmgr@ol5-r122-ebs1 ~]$ 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.

Post Upgrade:

Please ensure all the services came up normally and you are able to access the front end page.