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

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

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.

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.

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

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

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 )

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 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 [email protected]:$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