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.