Upgrading Oracle SOA Suite 10.3.1 to 10.3.4

In our last blog entry we went through the process of installing Oracle's SOA Suite 10.3.1, which is the base install for the SOA Suite product. In this entry we'll perform the upgrade from 10.3.1 to 10.3.4 which is the latest version of the SOA Suite product in the 10 series.

• To begin download the desired 10.3.4 patch from the following location ().

• Once downloaded unzip it to a temporary folder on your local hard disk.

The first thing that is required before running the upgrade is to perform the Database schema upgrade. In the 10.3.4 patch there is no nice program to do this like there is in the base installer (irca). To do this follow these steps.

Note: Ensure the following environment variables are set

• ORACLE_HOME=

• ORACLE_SID=XE

Lets start off with the ESB Upgrade:

• Using a command prompt navigate to the following folder (/OracleInstall/Oracle10.3.4_Patch/Disk1/install/soa_schema_upgrade/esb/sql/other).

• Connect using sqlplus as your system user

• Once connected type @upgrade_10131_10134_oracle.sql

Now lets do the BPEL Upgrade:

• Using a command prompt navigate to the following folder (/OracleInstall/Oracle10.3.4_Patch/Disk1/install/soa_schema_upgrade/bpel/scripts).

• Connect using sqlplus as your system user

• Once connected type @upgrade_10131_10134_oracle.sql

Now that both the BPEL & ESB Schemas have been upgraded its now time to run the binary upgrade.

• Navigate to the following folder (/OracleInstall/Oracle10.3.4_Patch/Disk1/install).

• Execute the ./runinstaller (Program File) and follow the GUI prompts. This process will take you through the same process as the base installer did. Once the install and configuration has completed your system will now be upgraded to 10.3.4.

How do I know my SOA Suite has been upgraded?

• Using a browser, navigate to (http://localhost:8888/em) connect using oc4jadmin user and whichever password was used during the base install.
• Click on About and you should see a window pop up which reads Oracle ESB Control 10G Version 10.1.3.4.0.