Oracle EBS ( E-Business Suite 12.2.6 ) Step by Step Installation -3

We will patch the components of EBS 12.2.0 installation to be ready for upgrading it to 12.2.6, We will prepare our EBS and upgrade it in the last post. Let’s continue Oracle EBS ( E-Business Suite 12.2.6 ) Installation


Oracle EBS ( E-Business Suite 12.2.6 ) Installation


You should read the previous post of EBS Installation using the following link.

Oracle EBS ( E-Business Suite 12.2.6 ) Step by Step Installation -2


EBS Installation

Note : In this step you may backup your system ( 12.2.0 installation ), Create restore point in your database and tar application files.




E-Business Suite 12.2.6 Installation

Note : In my post I will also share Oracle Doc Numbers too, Reason I share this is to find the latest updated documents if you want to install with the latest TXK Delta patches or you can also find the latest release notes of EBS 12.2.8 with this docs


Oracle E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)

1.EBS Technology Codelevel Checker (ETCC) (Doc ID 1594274.1)

Note: This patch verifies the missing bugfixes which is not applied for db and middle tiers. You can apply the patches directly to the related component but I recommend you go for the next steps and crosscheck the output of the log with the table you will see in section 3.2

Download patch 17537119

Upload patch to DB and APP node



For DB Node :

mkdir –p $ORACLE_HOME/appsutil/etcc

copy all files in the patch to the directory “mkdir –p $ORACLE_HOME/appsutil/etcc”

cd $ORACLE_HOME/appsutil/etcc


For APP Node :

cd <patchdirectory>




2.Apply RDBMS ( Patches



Note: Shutdown application and database before apply patches


opatch lsinventory


Not included in any startCD

Linux x86-64

17 Patches

21286665 Replacement(24560906 )OK
21967332 Footnote 2opatch rollback -id 18893947
22338374 Footnote 3opatch rollback -id 21188532
Footnote 2If a conflict is reported with Patch 18893947 roll back the conflicting patch before applying Patch 21967332.
Footnote 3If a conflict is reported with Patch 21188532  roll back the conflicting patch before applying Patch 22338374.



3.After applying database patches, ensure the following additional tasks are performed:

Startup database

copy $APPL_TOP/admin/adgrants.sql to db node

sqlplus "/ as sysdba" @adgrants.sql apps

sqlplus "/ as sysdba" @$ORACLE_HOME/rdbms/admin/utlrp.sql



Apply Consolidated Seed Table Upgrade Patch (Required)

4.Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD (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.






Set environment “ . /app/TEST45/fs1/EBSapps/appl/APPSTEST45_erp12tapp.env “

sh $ADMIN_SCRIPTS_HOME/ “ kill -9 `ps -ef|grep app45 | awk '{print $2}'` “



Note : copy patches to the patch_top directory “/app/TEST45/fs_ne/EBSapps/patch “


adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes


5. 3.1 Path A — Upgrade and New Installation Customers. Run ETCC (1617461.1 )

Note: Applying the AD and TXK Delta 7 release update packs checks for the existence of the ETCC tables. Even if you already have all the required database patches installed, you must execute the latest version of ETCC on your database before proceeding to Section 3.



6. Technology Inventory Utility (Optional )

The Technology Inventory Utility generates a report that lists the installed technology stack components, as well as patches that have been applied. Any patches listed in this section that are not shown in the generated report must be installed. Refer to Oracle E-Business Suite Maintenance Guide for instructions on generating the technology report.

perl $FND_TOP/patch/115/bin/ -script=$FND_TOP/patch/115/bin/ -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps321 -outfile=$APPLTMP/Report_Inventory.html



7. Apply Oracle Reports and Forms Pathes ( )

Note : Any configuration file changes suggested in post-install steps can be skipped, as those changes are controlled through technology stack templates initialized by AutoConfig. Any recommendation in any Forms patch readme to redeploy Forms ear file can be skipped as it is automatically deployed by Oracle E-Business Suite service control scripts before starting services. Please regenerate jars from adadmin after applying any of the forms patch, do not opt to force the regeneration of all JAR files. If the patch is being applied in the patch file system then ensure Online Patching prepare phase (adop phase=prepare) has completed successfully first before running adadmin. If the patch is being applied in the run file system, run adadmin after applying the patch


Note: The distribution is 32-bit, even on 64-bit platforms. Download the available patch for your platform.

Linux x86-64
Not included in any startCD22698265



Default Oracle Home path is already set to 10.1.2 directory but if you need to set or to be make sure use below command

export ORACLE_HOME=/app/TEST45/fs1/EBSapps/10.1.2


opatch lsinventory

[app45@erp12tdb ~]$ opatch lsinventory

Oracle Home : /app/TEST45/fs1/EBSapps/10.1.2

Oracle Home Inventory : /app/TEST45/fs1/EBSapps/10.1.2/inventory

Central Inventory : /app/TEST45/oraInventory

from : /etc/oraInst.loc

OUI location : /app/TEST45/fs1/EBSapps/10.1.2/oui

OUI shared library : /app/TEST45/fs1/EBSapps/10.1.2/oui/lib/linux/

Java location : /app/TEST45/fs1/EBSapps/10.1.2/jdk/jre/bin/java

opatch apply

After apply patch



Run adadmin

Generate jar files ( dont use force )


8. Apply Oracle Home Patch (Version

There is no patch to apply if you installed EBS with the latest startCD. Check “Table 3 – Patches and bug numbers for” in the document


9. Apply patch for Oracle Fusion Middleware (FMW) webtier

Note: When obtaining patches listed in these tables, download and install the 64-bit version of the patches.

Linux x86-64
Not included in any startCD22288381



Set the ORACLE_HOME environment variable to Webtier home and Opatch version should be or higher

export ORACLE_HOME=/app/TEST45/fs1/FMW_Home/webtier


opatch lsinventory

Oracle Interim Patch Installer version

Copyright (c) 2016, Oracle Corporation. All rights reserved.

Oracle Home : /app/TEST45/fs1/FMW_Home/webtier

Central Inventory : /app/TEST45/oraInventory

from : /app/TEST45/fs1/FMW_Home/webtier/oraInst.loc


OPatch version :

OUI version :

OPatch detects the Middleware Home as “/app/TEST45/fs1/FMW_Home”

Installed Top-level TEST45ucts (1):



Oracle WebTier and Utilities CD

cd 22288381/

opatch apply -jre $ORACLE_HOME/jdk/jre



10. Apply patch for Oracle Fusion Middleware (FMW) oracle_common

Not included in any startCDLinux x86-64
9905685See How to Apply



Set the ORACLE_HOME environment variable to oracle_common home and Opatch version should be or higher

export ORACLE_HOME=/app/TEST45/fs1/FMW_Home/oracle_common


opatch lsinventory




How to Apply Patch 9905685;

cd /tmp45/9905685/oui

opatch apply







Patch 21366277;

cd /tmp45/21366277

opatch apply



Patch 21628307;

cd /tmp45/21628307

opatch apply






11. Apply patch for Oracle Weblogic Server

Note : There are details here in footnotes, you can skip this part and take action directly.

Footnote 1 – This is the PSU. When applying a PSU all conflicting patches (including overlays and previous PSUs) would need to be removed. For a list of bug fixes included in this PSU, refer to My Oracle Support Knowledge Document 2030251.1, Oracle WebLogic Server Patch Set Update Fixed Bugs List.

The PSU is the current minimum level recommendation, you may apply any later version. The Middle Tier EBS Technology Codelevel Checker (ETCC) will report required overlays for later PSU releases.

WebLogic PSU conflict examples:

If you encounter conflicts with 14597598 (VFS8), 13572948 (LL4G), or 16083651 (D33T) uninstall the conflicting patch(es) and then install the WLS PSU (which will include them).

If you encounter a conflict with 14049348 (3ZY8) or 13729611 (YIJF), uninstall the conflicting patch and then install the overlay patch 13729611 (L34G) on top of WLS

If you encounter conflicts with any other patches refer to My Oracle Support Knowledge Document 1306505.1, Announcing Oracle WebLogic Server PSUs (Patch Set Updates) : Patching Scenarios: Scenario 2



Footnote 2 – This overlay patch is specific to PSU; apply the PSU Patch 20780171 then this overlay patch.

Footnote 3 – This patch is specific to the Windows Platform.

Footnote 4 – This Oracle WebLogic Server patch is required for Oracle Fusion Middleware

Ensure you have applied R12.TXK.C.Delta.7 Patch 20784380 and Patch 21846184.

Refer to My Oracle Support Knowledge Document 1617461.1, Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release.

Patch 21846184 includes TXK code that will enable Java Secure Socket Extension (JSSE) within Oracle E-Business Suite Release 12.2 when Oracle Fusion Middleware version is

Follow the instructions in the patch readme, except for the last step (Step 6) in the post-install instructions.

Footnote 5 – Applying this patch will not resolve existing artifacts in patch-backup.xml.



Weblogic Patch Installation Prerequisite

1.Set environment

. /app/TEST45/fs1/EBSapps/appl/APPSTEST45_erp12tapp.env

2. Copy patch files to the Weblogic patch directory

cp /tmp45/*1036* $FMW_HOME/utils/bsu/cache_dir



3.Unzip patch files and Delete zip files

cd $FMW_HOME/utils/bsu/cache_dir

unzip "*.zip"

rm -rf *.zip




Weblogic Patch Installation Step

1.Remove Patches

Note : Here we delete many patches in one shot to gain too much time. BSU patches takes really too much effort, you can do something modify java parameter ( XmaxPerms … ) but it didn’t work for me good enough. -remove -patchlist=Y5AP,BLTG,1LRI,VKXF,2GYW,CW9T -prod_dir=/app/TEST45/fs1/FMW_Home/wlserver_10.3 -verbose

2.Remove Patch -remove -patchlist=FCX7 -prod_dir=/app/TEST45/fs1/FMW_Home/wlserver_10.3 -verbose



3.Install Patch -prod_dir=/app/TEST45/fs1/FMW_Home/wlserver_10.3 -patchlist=EJUW -verbose -install





4.Install Patches -prod_dir=/app/TEST45/fs1/FMW_Home/wlserver_10.3 -patchlist=L34G,N5FK,XECL,TYHS,8FBW,GK5N,DI8E -verbose -install

Not included in any startCD13729611 (see Footnote 2)
17319481 (see Footnote 2)
17938462 (see Footnote 3)NA
19259028 (see Footnote 2)
19687084 (see Footnote 2)
20780171 (see Footnote 1)
22128205 (see Footnote 2)



12. Apply R12.TXK.C.Delta.8 patches

Oracle E-Business Suite Release 12.2.6 Readme (Doc ID 2114016.1)

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

  • Run ETCC according to the section “3.1.1 Prerequisite.
  • Source the run edition environment file and Start up only Weblogic AdminServer service on the run edition application tier file system
. /app/TEST45/fs1/EBSapps/appl/APPSTEST45_erp12tapp.env
sh $ADMIN_SCRIPTS_HOME/ start ( It is already started for upgrade patch )




1.Download all patches below and copy all into patch directory (/app/TEST45/fs_ne/EBSapps/patch )

R12.TXK.C.Delta.8 patches

Critical AD Patches

Critical TXK Patches
Patch 21841299 R12.AD.C.Delta.8)2457845518525466
Patch 21830810 R12.TXK.C.Delta.8)2449455123569114



2.How To Apply R12.AD.C.Delta.8 and Critical AD Patches

  • Compare adgrants.sql versions between $APPL_TOP/admin and 21841299/admin/adgrants.sql
  • Copy adgrants.sql file from patch directory to db server “ $ORACLE_HOME/appsutil/admin/ “ if it is higher than
scp /app/TEST45/fs_ne/EBSapps/patch/21841299/admin/adgrants.sql [email protected]:/db/TEST45/12.1.0/appsutil/admin/



  • Run adgrants.sql on db server


sqlplus /nolog

@$ORACLE_HOME/appsutil/admin/adgrants.sql apps

adop phase=apply patches=21841299 hotpatch=yes




3.How To Apply Critical AD Patches

scp /app/TEST45/fs_ne/EBSapps/patch/24494551/admin/adgrants.sql [email protected]:/db/TEST45/12.1.0/appsutil/admin/



  • Run adgrants.sql on db server
sqlplus /nolog

@$ORACLE_HOME/appsutil/admin/adgrants.sql apps

adop phase=apply patches=24578455,24494551,25025325 hotpatch=yes merge=yes



4.How To Apply R12.TXK.C and Critical TXK Patches

adop phase=apply patches=21830810,18525466,23569114,23705992 hotpatch=yes merge=yes



5. Migrate Latest Code to Database Tier

  • Backup and appsutil folder on db tier
  • On the Application Tier (as the APPLMGR user),Source the environment variables for Oracle E-Business Suite.
. /app/TEST45/EBSapps.env run

perl $AD_TOP/bin/

scp –pr cp $INS_TOP/admin/out/ [email protected]:$ORACLE_HOME/



On the Database Tier (as the ORACLE user):


unzip -o

cd $ORACLE_HOME/appsutil/bin

perl ( there is no Context File in new appsutil directory so regenerate it )

sh $ORACLE_HOME/appsutil/bin/



On the Application Tier (as the APP45 user):

. /app/TEST45/EBSapps.env run







6. Restart APP and DB

adop phase=apply patches=25290922_TR:u25290922.drv workers=16

adop phase=finalize,cutover,cleanup


Lets go to Final Step , “Oracle EBS ( E-Business Suite 12.2.6 ) Step by Step Installation -4 Final”

Oracle EBS ( E-Business Suite 12.2.6 ) Step by Step Installation -4 Final



Do you want to learn Oracle E-Business Suite ( EBS ) for Junior Apps DBA, then read the following articles.

Oracle EBS ( E-Business Suite ) Tutorials for Junior Oracle Apps DBA

About Cihan Gedik

I am currently working as Senior Oracle Application Database Administrator. I have experienced many EBS database upgrade, migrations, Fresh EBS installations, Solaris to Linux, Windows to Linux replatform migration projects in medium and large companies and also experienced core database migration projects for one of the biggest bank of Katar.With my colleagues we decided to run this platform to share our knowledge


  1. There are some interesting time limits in this article but I don’t know if I see all of them middle to heart. There’s some validity but I’ll take hold opinion until I look into it further. Good article , thanks and we want extra! Added to FeedBurner as well

Leave a Reply

Your email address will not be published. Required fields are marked *