Upgrading R12 OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)

Upgrading R12 OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)

Reference:

Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12 (Doc ID 454811.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/

Note: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

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:

SQL> select release_name from apps.fnd_product_groups;

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

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 are different ways to check the version.

a) cat $IAS_ORACLE_HOME/config/ias.properties

Version=10.1.3.5.0

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.

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(for patch 8626084)
Execute runInstaller (UNIX) or setup.exe (Windows)

On UNIX and Linux (32bit and 64bit) :

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

$ ./runInstaller

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

$ ./runInstaller -invPtrLoc <1013_ORACLE_HOME>/oraInst.loc

On Windows, invoke the setup.exe program by running the command:

/Disk1/setup.exe

Note:

Installation of AS 10.1.3.5 on more recent operating systems:
For installations of AS 10.1.3.5 on more recent operating systems such as AIX 7, Solaris 11, Red Hat/Oracle Linux 6, and SLES 11, the OU Installer may fail when checking the operating system version. On these newer operating systems, it is necessary to invoke 'runInstaller' with the 'ignoreSysPrereqs' flag, as follows:

$ ./runInstaller -ignoreSysPrereqs

Note: During the Installation, OUI may display the following warning messages.

1) Ensure that all OC4J instances are up and running prior to applying this patch.
2) At this time, Oracle Application Tier will be shut down. There will be a brief pause in the installer when the application tier processes are stopped.

Click the 'OK' button to proceed with the installation.

Enter the <oc4jadmin> user password for the OracleAS 10g 10.1.3 instance that is being patched. If you are upgrading from OracleAS 10g 10.1.3.0, the default password is 'secret'. Otherwise the default password is 'oafm', if it was not changed after Release 12 installation. Proceed to the end of the installation.

Shut Down Any Services Started by OUI during 10.1.3.5 Patch Set Installation

During 10.1.3.5 patchset installation, Oracle Universal Installer may have started some process from the OracleAS Oracle Home. Before proceeding further, shut down any processes started by the installer.

Run AutoConfig

Apply Any Additional OracleAS 10g Patches

Regenerate appsborg.zip and appsborg2.zip files

Run adadmin, and choose Generate product JAR files (with the no force option) to generate the appsborg.zip and appsborg2.zip files.

Restart application tier services