Upgrade OracleAS 10g Release 2 (10.1.2.2.0) for Forms and Reports to Patchset 3 (10.1.2.3.0)

Upgrade OracleAS 10g Release 2 (10.1.2.2.0) for Forms and Reports to Patchset 3 (10.1.2.3.0)

Metalink Note ID Refered : ID 437878.1

1) Download latest certified OracleAS patchset and Oracle E-Business Suite Interoperability Patch

Download the latest certified OracleAS 10g patchset. In addition, you will need the E-Business Suite/Forms Interoperability patch corresponding to the OracleAS 10g patchset you are installing. The number for the interoperability patch is given in the right-hand column.


Oracle Application Server 10g Oracle Application Server 10g Patchset Oracle Forms Oracle Reports Oracle E-Business Suite Interoperability Patch
OracleAS Patchset 10.1.2.3.0 5983622 10.1.2.3.0 10.1.2.3.0 7120543

2) Download Additional Patches

Platform Nature of Patch Patch
Linux Forms - Java Patch 9044638
Linux Forms - Platform-Specific 7121788
Linux Forms - C Patch 6857221
Linux 4407272
Linux 4526825
Linux 7329300
Linux 8557019
Linux Reports - Platform-Specific 5705981
Linux 7230832
Linux Reports - C Patch 7016961
Linux 5917053
Linux 6371228
Linux Reports - Java Patch 7140392
Linux Reports - Generic Patch 8300196

3) Stop All Services

$INST_TOP/admin/scripts/adstpall.sh apps/apps

4) Back Up OracleAS 10.1.2 ORACLE_HOME and Inventory folder

Oracle recommends that you make a backup of your existing environment before you install Oracle Application Server 10g Release 2 patchset 3 (10.1.2.3.0).This will enable you to restore your original environment if you encounter a problem with application of the patch, or need to remove the patch for some reason.

You are also advised to take a complete backup of the Inventory folder (either global or local) that contains the OracleAS 10.1.2 ORACLE_HOME inventory details.

5) Install the Application Server Latest Certified Patchset (10.1.2.3.0)

The steps in this section will install the OracleAS 10g 10.1.2.3.0 patchset on all application tier nodes hosting Forms and Reports services.

Note: All references to "ORACLE_HOME" refer to the OracleAS 10.1.2 Oracle Home that contains the Forms and Reports 10g installation. Ensure that you are using same oraInventory that was created during Oracle E-Business Suite Release 12 installation.

Unzip the Patchset
Unzip patch 5983622 into a temporary directory.

Apply OracleAS 10g Release 2 Patchset 3 (10.1.2.3.0)
The following steps will apply the patchset.
Execute runInstaller
Execute runInstaller (UNIX) and choose "Oracle Application Server and Developer Suite 10g R2 Software Update 10.1.2.3.0" as the install option.

On Linux and UNIX:
If you have a Global Inventory, invoke the Installer by changing to the appropriate directory and running the command:
$ ./runInstaller
If you have a Local Inventory, invoke the Installer by changing to the appropriate directory running the command:
$ ./runInstaller -invPtrLoc <1012_ORACLE_HOME>/oraInst.loc

Supply the ias_admin default password

Supply the ias_admin default password 'secret' when prompted.

Note: You may see failures while executing OC4J configuration assistant as part of post install configuration steps. Please select Next to skip the configuration assistant. This action will skip the remaining configuration assistants, which is expected for Oracle E-Business Suite customers.

Shut Down Services Started by OUI during 10.1.2.3 Patchset Installation

During OracleAS 10g patchset 10.1.2.3 installation, Oracle Universal Installer may have started some processes from the OracleAS 10.1.2 Oracle Home. Before proceeding further, ensure you shut down any processes started by the Installer.

Export ORACLE_HOME=<10.1.2 Oracle Home>
$ORACLE_HOME/opmn/bin/opmnctl stopall
$ORACLE_HOME/bin/emctl stop iasconsole

Do not source the environment using any of the Applications environment files.

6) Install the Additional Patches

Use opatch to install each of the additional patches you downloaded earlier, in the same order as in the table, and following the instructions in the accompanying README. Use opatch version 1.0.0.0.57 or higher. You can download the latest version of opatch via patch 6880880.

7) Download and apply 10.1.0.5 RSF fixes

Note: You must select 10.1.0.5 from the Release dropdown list before downloading.

Download patch 3559326 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
Download patch 5394728 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.
Download patch 5261796 from OracleMetaLink and apply to the OracleAS 10.1.2 Oracle Home.

8) Apply the Oracle E-Business Suite Release 12 Interoperability Patch

Before applying the patch, you must enable Maintenance Mode:

1. Run adadmin
2. Select menu option 5 (Change Maintenance Mode)
3. Select menu option 1 (Enable Maintenance Mode)

Step 3.7.2: Apply the Oracle E-Business Suite/Forms Interoperability Patch

Apply the patch driver from the Interoperability patch using AutoPatch.

Step 3.7.3: Disable Maintenance Mode from adadmin

After applying the patch, disable Maintenance Mode:

1. Run adadmin
2. Select menu option 5 (Change Maintenance Mode)
3. Select menu option 2 (Disable Maintenance Mode)

9) Redeploy the new Forms EAR file

Redeploy the formsapp.ear file by following the instructions given in OracleMetaLink Note 397174.1, "Deploying a New Forms EAR File in Oracle Applications Release 12".

10) Post-Installation Steps

Rebuild Forms and Reports executables

cd $ORACLE_HOME/forms/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk install

cd $ORACLE_HOME/reports/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk install

Regenerate JAR files

Verify the JAR files have been rebuilt

Verify that the fndforms.jar & fndewt.jar JAR files have been rebuilt by checking the timestamp for both files in $OA_JAVA/oracle/apps/fnd/jar directory.

Regenerate the JAR Files (if required)

If the timestamp is not current but the installation steps completed successfully, run the AD Administration Utility to regenerate the JAR files:

1. Run the AD Administration Utility (adadmin)
2. Select Generate Applications Files
3. Generate Product JAR Files

Note: Do not opt to force the regeneration of all JAR files.

Verify that the fndforms.jar and fndewt.jar JAR files have been rebuilt by checking their timestamps again.


11) Start All Services

$INST_TOP/admin/scripts/adstrtal.sh apps/apps

Verify the Upgrade

Log on to E-Business Suite as any user, launch any form, select "About Applications" from the Help menu, and confirm that the Forms version (under Forms Server) shows as 10.1.2.3.0.

Run Forms compiler

Run the following command to display various component versions, and confirm that the Forms version shows as 10.1.2.3.0. This command requires the DISPLAY environment variable to be set correctly.

$ORACLE_HOME/bin/frmcmp help=y