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
APPLYING TECHNOLOGY PATCHES FOR 12.2.0
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 ./checkDBpatch.sh
For APP Node :
cd <patchdirectory> ./checkMTpatch.sh
2.Apply RDBMS (12.1.0.2) Patches
Note: Shutdown application and database before apply patches
export PATH=$ORACLE_HOME/OPatch:$PATH opatch lsinventory
| Not included in any startCD
Linux x86-64 17 Patches |
18793246 | OK |
| 19591608 | OK | |
| 19908836 | OK | |
| 21286665 Replacement(24560906 ) | OK | |
| 21321429 | OK | |
| 21387964 | OK | |
| 21864513 | OK | |
| 21904072 | OK | |
| 21967332 Footnote 2 | opatch rollback -id 18893947 | |
| 22098146 | OK | |
| 22338374 Footnote 3 | opatch rollback -id 21188532 | |
| 22496904 | OK | |
| 22731026 | OK | |
| 23089357 | OK | |
| 23595848 | OK | |
| 23745950 | OK | |
| 24481723 | OK | |
| Footnote 2 | If a conflict is reported with Patch 18893947 roll back the conflicting patch before applying Patch 21967332. | |
| Footnote 3 | If 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 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.
Set environment “ . /app/TEST45/fs1/EBSapps/appl/APPSTEST45_erp12tapp.env “
sh $ADMIN_SCRIPTS_HOME/adstpall.sh “ kill -9 `ps -ef|grep app45 | awk '{print $2}'` “
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
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/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps321 -outfile=$APPLTMP/Report_Inventory.html
7. Apply Oracle Reports and Forms Pathes ( 10.1.2.3.0 )
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 10.1.2.3 distribution is 32-bit, even on 64-bit platforms. Download the available patch for your platform.
| Linux x86-64 | |
| Not included in any startCD | 22698265 |
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 export PATH=$ORACLE_HOME/OPatch:$PATH 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/liboraInstaller.so 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 10.1.0.5.0)
There is no patch to apply if you installed EBS with the latest startCD. Check “Table 3 – Patches and bug numbers for 10.1.0.5.0” in the document
9. Apply patch for Oracle Fusion Middleware (FMW) webtier 11.1.1.9
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 startCD | 22288381 |
Set the ORACLE_HOME environment variable to Webtier home and Opatch version should be 11.1.0.9.0 or higher
export ORACLE_HOME=/app/TEST45/fs1/FMW_Home/webtier export PATH=$ORACLE_HOME/OPatch:$PATH opatch lsinventory Oracle Interim Patch Installer version 11.1.0.12.9 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 : 11.1.0.12.9
OUI version : 11.1.0.11.0
OPatch detects the Middleware Home as “/app/TEST45/fs1/FMW_Home”
Installed Top-level TEST45ucts (1):
Oracle WebTier and Utilities CD 11.1.1.9.0
cd 22288381/ opatch apply -jre $ORACLE_HOME/jdk/jre
10. Apply patch for Oracle Fusion Middleware (FMW) oracle_common 11.1.1.9
| Not included in any startCD | Linux x86-64 | |
| 9905685 | See How to Apply | |
| 21366277 | ||
| 21628307 |
Set the ORACLE_HOME environment variable to oracle_common home and Opatch version should be 11.1.0.9.0 or higher
export ORACLE_HOME=/app/TEST45/fs1/FMW_Home/oracle_common export PATH=$ORACLE_HOME/OPatch:$PATH 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 sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
11. Apply patch for Oracle Weblogic Server 10.3.6.0
Note : There are details here in footnotes, you can skip this part and take action directly.
Footnote 1 – This is the 10.3.6.0.12 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 10.3.6.0.12 Fixed Bugs List.
The 10.3.6.0.12 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 10.3.6.0.12 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 10.3.6.0.12.
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 10.3.6.0.12 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 11.1.1.9.
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 11.1.1.9.
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.
bsu.sh -remove -patchlist=Y5AP,BLTG,1LRI,VKXF,2GYW,CW9T -prod_dir=/app/TEST45/fs1/FMW_Home/wlserver_10.3 -verbose
2.Remove Patch
bsu.sh -remove -patchlist=FCX7 -prod_dir=/app/TEST45/fs1/FMW_Home/wlserver_10.3 -verbose
3.Install Patch
bsu.sh -prod_dir=/app/TEST45/fs1/FMW_Home/wlserver_10.3 -patchlist=EJUW -verbose -install
4.Install Patches
bsu.sh -prod_dir=/app/TEST45/fs1/FMW_Home/wlserver_10.3 -patchlist=L34G,N5FK,XECL,TYHS,8FBW,GK5N,DI8E -verbose -install
| Not included in any startCD | 13729611 (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) | ||
| 22323006 |
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/adadminsrvctl.sh 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) | 24578455 | 18525466 |
| Patch 21830810 R12.TXK.C.Delta.8) | 24494551 | 23569114 |
| 25025325 | 23705992 |
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 ora45@172.27.82.72:/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 ora45@172.27.82.72:/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 appsutil.zip 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/admkappsutil.pl scp –pr cp $INS_TOP/admin/out/appsutil.zip ora45@172.27.82.72:$ORACLE_HOME/
On the Database Tier (as the ORACLE user):
cd $ORACLE_HOME unzip -o appsutil.zip cd $ORACLE_HOME/appsutil/bin perl adbldxml.pl ( there is no Context File in new appsutil directory so regenerate it ) sh $ORACLE_HOME/appsutil/bin/adconfig.sh
On the Application Tier (as the APP45 user):
. /app/TEST45/EBSapps.env run cd $ADMIN_SCRIPTS_HOME adautocfg.sh
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