Oracle EBS R12.2.7 Full Installation Step by Step

High level Steps Involved to do the R12.2.7 upgrade steps are:
1.Checked Pre requestions for R12.2.7
2.Run ETCC in both database tier and Application tier to get the list of required patches and apply.
3.Upgrade to  AD and TXK Delta 10
4.Apply the R12.2.7 upgrade patch
5.FS_CLONE for filesystem cloning
6.Apply the Help patch.

1.Checked Pre requestions for R12.2.7

In Release 12.2.0 and higher, patching is performed by running the new adop (AD Online Patching) utility. You must use adop instead of the adpatch utility that was provided in previous releases

Download and unzip all the patches to the default Patch Top location for R12.2 ($APPL_TOP_NE/../patch)

If your Oracle E-Business Suite instance is currently on Database version 11.2.0.3, then you should now upgrade to Database 11.2.0.4 or 12.1.0.2 before proceeding with next steps, by following process documented in the oracle


Note: Database desupport schedules have important operational and planning implications for Oracle E-Business Suite environments. Oracle recommends that you review the following document that details the latest database support policies and desupport schedules: My Oracle Support Knowledge Document 742060.1, Release Schedule of Current Database Patch Sets

2.Run ETCC in both database tier and Application tier to get the list of required patches and apply.

EBS Technology Codelevel Checker (ETCC)

ETCC can be downloaded via Patch 17537119 from My Oracle Support

Download the Patch 17537119
p17537119_R12_GENERIC.zip

Unzip p17537119_R12_GENERIC.zip

The two scripts that make up ETCC are:

checkDBpatch.sh

This is the Database EBS Technology Codelevel Checker (DB-ETCC), which determines if all the needed bugfixes exist in the specified database ORACLE_HOME.

./checkDBpatch.sh

checkMTpatch.sh 

 This is the Application Tier EBS Technology Codelevel Checker (MT-ETCC), which determines if all the needed bugfixes exist in the application tier file system.

./checkMTpatch.sh


Note: This patch verifies the missing bugfixes which is not applied for db and middle tiers

For DB Node :

copy all files in the patch directory
cd $PATCH_TOP/17537119

./checkDBpatch.sh

Apply the patches using opatch


Example:

export PATH=$PATH:$ORACLE_HOME/OPatch

To Check the patch:
opatch lsinventory | grep 19908836

cd 18793246

opatch apply

For APP Node :
./checkMTpatch.sh


=================================
PATCH RECOMMENDATION SUMMARY
=================================

Oracle Forms and Reports 10.1.2.3.0
---------------------------------------------
  Patch 25768948
    - Filename: p25768948_101232_LINUX.zip


Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
------------------------------------------------------------------------------
  Patch 17428617
    - Filename: p17428617_111190_Generic.zip

  Patch 24606362
    - Filename: p24606362_111190_Generic.zip

  Patch 24843064
    - Filename: p24843064_111190_Generic.zip

Oracle WebLogic Server (WLS) 10.3.6.0.12
---------------------------------------------------------
  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018]
    - Filename: p23743997_1036_Generic.zip

  Patch 25333306 [SU Patch [SUY4]]
    - Filename: p25333306_1036_Generic.zip


Apply the required patches and rerun this script.

+--------------------------------------------------------------------------------------------------------+
A consolidated zip file with the required application tier patches is
available on My Oracle Support via:

  Patch 26328262
    - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2017

+--------------------------------------------------------------------------------------------------------+
[WARNING]  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] is missing.
This is the recommended minimum WLS patch set.
You should install it now, and then rerun this script to check for any
further fixes available.
+--------------------------------------------------------------------------------------------------------+

For APPS Tier Node :

Connecting to database.
Database connection successful.


Oracle Forms and Reports
-------------------------

1.unzip Patch file
2.set Oracle home
  export ORACLE_HOME=/u02/oracle/TST/fs1/EBSapps/10.1.2.
3.set path
  export PATH=$ORACLE_HOME/OPatch:$PATH
4.opatch lsinventory|grep 25768948
5.cd 25768948
6.opatch apply


Oracle Fusion Middleware (FMW) - oracle_common
------------------------------------------------

1.unzip Patch file
2.set Oracle home
  export ORACLE_HOME=/u02/oracle/TST/fs1/FMW_Home/oracle_common
3.set path
  export PATH=$ORACLE_HOME/OPatch:$PATH
4.opatch lsinventory|grep 17428617
5.cd 17428617
6.cd oui
7.opatch apply

Oracle WebLogic Server (WLS)
------------------------------------
1. copy file 23743997 to /u02/oracle/TST/fs1/FMW_Home/util/bsu/cache_dir
2. unzip file (23743997)
3. check the .jar file
    ls -ltr *.jar
4. cd  /u02/oracle/TST/fs1/FMW_Home/util/bsu

5. check the Display
    echo$DISPLAY
    echo$DISPLAY=:1:0

6 To apply the Patch
   . ./bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/
   cache_dir -patchlist=EJUW - prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

7.  To apply patches, first you have to apply patch number 23743997 but you may have conflict warning with the previous patches which has older PSU patches because 23743997 patch number is PSU 10.3.6.0.12 patch

we removed the below patches using following commands
 Delete the files - YSAP,BLTC,1LRI,VKXF,2GYW,CWGT,FCX7
   ./bsu.sh -remove -patchlist=Y5AP -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=BLTC -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=1LRI -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=VKXF -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=2GYW -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=CWGT -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=FCX7 -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

8. Once again apply
  ./bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=EJUW -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3

9. Run ETCC again to get the patch list

    24608998 [QMJP]
    13729611 [Z9PC]
    17319481 [9KCT]
    19259028 [KRDE]
    25804598 [EQDE]

9. Download the above patch list

10.Unzip patches.

11.To install the the patches using following commands

    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=QMJP -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3
    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=Z9PC -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3
    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=9KCT -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3
    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=KRDE -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3
    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=EQDE -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3


12. To check  the MTpatchlist again run the following

      ./checkMTpatch.sh

   Now you should get the message as "All required patches are present"

Set Database Parameter (Conditional) 

Oracle Database 12c Release 1 uses cost based optimization. If you are using Oracle Database 12.1.0.2, the following optimizer parameter should always be set to 'false'. This setting should be completed before proceeding with the next steps and should not be changed thereafter.

[appltst@qb]$ #optimizer_adaptive_features=false

You can verify the parameter was set correctly by running the following command, which should return the value FALSE:
SQL>show parameter optimizer_adaptive_features

3.Upgrade to  AD and TXK Delta 10

Note: This step is applicable only for new installation customers and customers upgrading from Oracle E-Business Suite Release 12.2.2 to Release 12.2.7

If you haven't already applied Consolidated Seed Table Upgrade Patch 17204589:12.2.0, then you must first apply Patch 17204589:12.2.0 on the run file system.

Note: If you have upgraded to Release 12.2.0 using Consolidated Upgrade Patch 24690520:12.2.0 (CUP8) or Patch 22742071:12.2.0 (CUP7) or
Patch 19796566:12.2.0 (CUP6) or Patch 18007406:12.2.0 (CUP5) or Patch 17197281:12.2.0 (CUP4), then you can skip this step.

1. Stop all application tier services on the run file system.

sh $ADMIN_SCRIPTS_HOME/adstpall.sh


2. Start up only the Oracle Weblogic Admin Server on the run file system

$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

3. Apply the consolidated seed table upgrade Patch 17204589:12.2.0 on the run file system using adop hotpatch mode.
$ adop phase=apply patches=17204589 hotpatch=yes

Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch 22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch 21900871:12.2.0 on the run file system using adop hotpatch mode.
 $ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes


4. Start up all application tier services.

$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh


Section 6: Apply the Latest AD and TXK Delta Release Update Packs

Note: Follow this Oracle Document 1617461.1


Download and unzip the following patches:
Patch 25820806 (R12.AD.C.Delta.10)
Patch 25828573 (R12.TXK.C.Delta.10)
Patch 26720905:R12.AD.C
Patch 19259764:R12.FND.C.

All Downloaded files are moved to /u01/oracle/CRP/fs_ne/EBSapps/Patch
Unzip the patch files.
online patches apply

$ adop phase=prepare
$ adop phase=apply patches=25820806,26720905 merge=yes
$ adop phase=apply patches=25828573
$ adop phase=apply patches=19259764
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=finalize
$ adop phase=cutover
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=cleanup
$ adop phase=fs_clone

Critical AD Patches

Patch 24591000:R12.AD.C
Patch 26482811:R12.AD.C

Critical TXK Patches

Patch 26400116:R12.TXK.C
Patch 26720231:R12.TXK.C
Patch 25994411:R12.TXK.C

online patches apply

$ adop phase=prepare
$ adop phase=apply patches=24591000
$ adop phase=apply patches=26482811
$ adop phase=apply patches=26400116
$ adop phase=apply patches=26720231
$ adop phase=apply patches=25994411
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=finalize
$ adop phase=cutover
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=cleanup
$ adop phase=fs_clone

4.Apply the R12.2.7 upgrade patch

1. Source the run edition applications environment

UNIX:
$ . <INSTALL_BASE>/EBSapps.env run

2. Start an online patching cycle.
$ adop phase=prepare

3. Apply Oracle E-Business Suite Release 12.2.7 Patch 24690690. UNIX:
$ adop phase=apply patches=24690690

4. Complete the online patching cycle by running the following commands in the order shown.

 UNIX:
$ adop phase=finalize 
$ adop phase=cutover 
$ . <INSTALL_BASE>/EBSapps.env run 
$ adop phase=cleanup

5.FS_CLONE for filesystem cloning

Synchronize file systems Synchronize the file systems using the command shown below.
This action will copy the new run edition code and configuration to the other file system,
to help the next online patching cycle complete faster.


$ adop phase=fs_clone

6.Post-Update Steps

Note: If you are upgrading from Release 11i, 12.0.x or 12.1.x to Release 12.2.7, then you must continue with 12.2.0 post upgrade steps mentioned in the Upgrade guides before performing the below steps

$ adop phase=apply patches=24690800 hotpatch=yes

Health checking application

http://<hostname>:port/OA_HTML/OA.jsp


**All the Best**