Objective:

In the previous article Oracle E-Business Suite Architecture we learned about the basic architecture of E-Business Suite. In this article we will learn how to upgrade oracle EBS R12.2.0 to R12.2.4

Upgrade Oracle EBS R12.2.0 to R12.2.4:

Install Oracle RDBMS Opatches

Step 1:Install following patches

Shutdown application & database services.

a) 16989137

Go to patch Patch_top

[oracle@icm 16989137]$ /u01/oracle/PROD/11.2.0/OPatch/opatch apply

b) 17875948

c) 17912217

d) 18419770

e) 18614015

f) 18685209

g) 19078951(rool back patch 18259911)

[oracle@icm OPatch]$ opatch lsinventory | grep 18259911

[oracle@icm OPatch]$ opatch rollback -id 18259911

h) 19393542

Now run the following patches sql scripts

a) 16989137

b) 17875948

c) 18614015

i) 17537119 apply this patch for check db

Now Install Oracle Fusion Middleware 11.1.1.6 patches

First set Oracle home for middleware

export ORACLE_HOME=/u01/oracle/PROD/fs1/FMW_Home/webtier

export PATH=/u01/oracle/PROD/fs1/FMW_Home/webtier/OPatch:$PATH

#opatch lsinventory

opatch apply –jre $ORACLE_HOME/jdk/jre

17639414

[oracle@icm ]$ export ORACLE_HOME=/u01/oracle/PROD/fs1/FMW_Home/oracle_common/

export PATH=/u01/oracle/PROD/fs1/FMW_Home/oracle_comn/OPatch:$PATH

[oracle@icm 18989444]$ opatch apply

Also apply patch 19462638 with same way.

Install Oracle 10.1.2.3 Forms & Reports Patches:

Set environmental variable

18186693

opatch apply

Install Oracle Weblogic server (10.3.6) Patches:

And unzip in this directory /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir

Cd /u01/oracle/PROD/fs1/FMW_Home/utils/bsu

#./bsu.sh

Installation Of EBS Application patches:

The Online Patching Cycle

The online patching cycle is divided into five phases:

Patching Cycle Overview:

1. Prepare

• Synchronizes patch edition and run edition on the file system.

• Creates a new patch edition in the database.

2 Apply

• Executes patch drivers to update patch edition.

• Patches applied: can be one or many, including customizations.

3. Finalize

• Compiles invalid objects.

• Generates derived objects.

4. Cutover

• Configures patch edition file system to be the new run edition file system.

• Configures patch edition of database to be the new run edition.

• Restarts application tier services.

5. Cleanup

• Delete obsolete code and seed data to recover space.

Oracle Applications DBA (AD) Utility

The Oracle Applications DBA product provides a set of tools for administration of the Oracle E-Business

Suite file system and database. AD tools are used for installing, upgrading, maintaining, and patching the

Oracle E-Business Suite system.

The AD utilities include:

AD Administration - Performs general maintenance tasks for Oracle E-Business Suite.

AD Merge Patch - Merges multiple patches into a single, integrated patch.

AutoConfig - Manages configuration changes to components that are specific to an Oracle

E-Business Suite system. Configuration changes to technology components that are not specific

to Oracle E-Business Suite are managed via the native tools for those components.

AutoPatch - Applies patches and adds new languages and products to an Oracle E-Business

Suite system. In Oracle E-Business Suite Release 12.2, adop (AD online patching) is used, rather

than adpatch which is used in previous releases.

To install Application Patches we need to start all services

Below all patches apply with hot patch option

Copy the patches in following location

/u01/oracle/PROD/fs_ne/EBSapps/patch

17204589

adop phase=apply patches=17204589 hotpatch=yes

18283295 also run adgrants sql script

19581770

18288881

19445058

19259764

Now run bellow command

[oracle@icm]$ cd /u01/oracle/PROD/

[oracle@icm]$ . EBSapps.env

[oracle@icm]$ adop phase=fs_clone

Now Apply update patch with adop command as above.

17919161

[oracle@icm]$ adop phase=apply patches=17919161 hotpatch=yes

17919162 on same way

The upgrade form 12.2.0 to 12.2.4 completed.

Varun Kapila

Add comment