Nov 14, 2012

How to Upgrade Oracle Application Server to 10.1.3.5 (10g R3 patchset 5)

Recently I have upgraded my R12.1.2 with OracleAS 10g Release 3 Patch Set 5 (10.1.3.5.0)
OS: Windows XP
Apps Version 12.1.2

These are the points for Oracle Application Server 10.1.3 Upgrade in R12
1. There are two Oracle Homes under application tier in R12  and other one is in Database Tier
a) 10.1.2 for forms & reports
b) 10.1.3 for Web (Apache) and J2EE (OC4J for oacore, oafm and forms)
Two Oracle Home (10.1.2 and 10.1.3) are under R12_BASE_INSTALL_DIR/apps/tech_st/

2. OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) is not a complete software distribution, and the patch set can only be applied to an existing Oracle E-Business Suite Release 12 10.1.3 Oracle Home via patch 8626084

3. You should be on minimum 12.0.3 (version of R12/12i) to upgrade 10.1.3 Oracle Home. To check your apps R12 version use
SQL> select release_name from apps.fnd_product_groups;

4. During upgrade, installer will prompt for OC4JADMIN password. If your source oracle home version is 10.1.3.0 then password for oc4jadmin is secret else (for 10.1.3.1/2/3) password is oafm
If you don’t remember oc4jadmin password you can reset oc4jadmin password

5. To check current Oracle Application Server Patchset version i.e. if 10.1.3.0 or 10.1.3.1 or 10.1.3.2
There different ways:
a)cd %IAS_ORACLE_HOME%\config
you can look into file ias.properties, there is an entry for version
b) Using runInstaller
–Invoke runInstaller from 1013_ORACLE_HOME/oui/bin
–Click on Installed Products.
–Select the 10.1.3 Oracle Home and expand the tree. You should see Oracle Application Server Patchset 10.1.3.X patch in the list.
c) Using Opatch
Run the command ‘opatch lsinventory -detail‘
Look for ‘Oracle Application Server PatchSet‘ in the ‘Product‘ column.

Main Upgrade Steps:-
1. Set your environment
Log in to the application tier as the OS user who owns the application tier file system. Navigate to the INST_TOP/ora/10.1.3 and source the [SID_machine].env/.cmd file to set your 10.1.3 ORACLE_HOME. Source [SID_Hostname].cmd

2. Apply OracleAS 10.1.3.5 Patch Set
Unzip patch 8626084 (OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)) into a temporary directory ()

Change directory to /Disk1
Execute runInstaller (UNIX) or setup.exe (Windows)

On UNIX and Linux:

If you have a Global Inventory, invoke the runInstaller program by running the command:

$ ./runInstaller

On Windows, invoke the setup.exe program by running the command:
/Disk1/setup.exe -installAdditionalComponents "oracle.swd.oui.core:ALWAYS_IF_NEW_OR_VERSION_GTE,oracle.swd.oui:ALWAYS_IF_NEW_OR_VERSION_GTE"
Shut down any services started by OracleAS 10.1.3.5 Patch Set

3. Run AutoConfig 

4. Apply additional patches to 10.1.3 oracle home (using opatch and not adpatch)

5. Regenerate appsborg.zip and appsborg2.zip files using adadmin

6. Restart application tier services for r12 , click here for how to start/stop services on R12

For step by step OAS upgrade steps for R12 check metalink note 454811.1

References
454811.1  Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12

No comments: