Upgrading Fusion Middleware 11.1.1.x to 18.104.22.168
By James Taylor on Feb 23, 2011
This is a follow on from my previous post where we upgraded 22.214.171.124 to 126.96.36.199. The instructions I provide here will work for Fusion Middleware 188.8.131.52 and 184.108.40.206 wanting to upgrade to 220.127.116.11.
In this example I’m just upgrading SOA Suite on OEL 64bit but the steps will be the same, some of the downloads may be different based on your environment.
To upgrade to 18.104.22.168 you need to have access to http://support.oracle.com as this is where the downloads reside. Oracle provides 22.214.171.124 as a standalone download so you can do a fresh install if required using OTN downloads (http://www.oracle.com/technetwork/indexes/downloads/index.html).
The high level steps to upgrade are as follows:
- Download software
- Shutdown your SOA Environment
- Upgrade WLS to 126.96.36.199
- Upgrade SOA Suite to 188.8.131.52
- Upgrade OSB to 184.108.40.206
- Upgrade MSD Schemas
- Identify the downloads you require for your install. You will need the WebLogic Server Upgrade and the additional product downloads. If you are using 64bit then use the generic version. The downloads are found from the following location - http://download.oracle.com/docs/html/E18749_01/download_readme.htm#BABDDIIC
For the purpose of this post I downloaded the following patches
11060985 – WLS Server Generic
11060960 – SOA Suite
11061005 – OSB Suite
- Make sure you have set the Java executable in your PATH e.g.
- Make sure all your WebLogic environment has been shut down before performing the upgrade.
- Extract the WLS patch 11060985 to a temporary directory and start the installer
java –jar wls1034_upgrade_generic.jar
Please note if you are not running 64BIT then the upgrade executable will be just a bin file which you can execute directly.
- Chose the right Oracle home for your WebLogic Server install.
- In the Register for Security Updates you can enter your details or just click Next. If you do not enter details confirm that you don’t want to receive these updates
- Select the products you want to upgrade and select next. It is recommended that you accept the defaults.
- Confirm the directories that will be upgraded
- Upgrade of WLS ahs been completed
- Extract your both SOA downloads to a temporary directory and run the installer found in Disk1
./runInstaller -jreLoc /java/jdk1.6.0_20/jre
Please note that the java location and version may be different for your environment
- Skip the Software Updates
- Ensure your system meets the prerequisites
- Set the Oracle home for your SOA install.
You will be asked to confirm that you want to upgrade, click Yes
- Choose your application server. Since you are upgrading from 11.1.1.x you will be on WebLogic
- Start the Install
- Installation Upgrade of SOA Suite completed accept the default to finish.
- In my environment I have OSB installed so I need to upgrade this next. If you don’t have SOA Suite you can go straight to completing the DB Schema updates at Step 24.
- Extract the OSB upgrade files to a temporary directory and execute the installer found in the Disk1 folder.
./runInstaller -jreLoc /java/jdk1.6.0_20/jre
- Skip the software updates
- Select the Oracle home for your environment
Accept the warning to continue the upgrade
- Point to the location of your WebLogic Server installation
- Install the OSB upgrade
- Upgrade has been completed accept the defaults
- Change directory to $MW_HOME/oracle_common/bin where the Patch Set Assistant is installed
- Execute the following command to update the MDS schema. Please not for my examples I have the context set to DEV. your may be different. This means that all my schemas are prefixed by DEV.
./psa -dbType Oracle -dbConnectString 'localhost:1521:xe' -dbaUserName sys -schemaUserName DEV_MDS
You will be asked you passwords for sys and the schema
Enter the database administrator password for "sys":
Enter the schema password for schema user "DEV_MDS":
- Change directory to $MW_HOME/Oracle_SOA1/bin to where the Patch Set Assistant is installed for SOA Suite.
Execute the following command to update the SOA and BAM schemas
./psa -dbType Oracle -dbConnectString 'localhost:1521:xe' -dbaUserName sys -schemaUserName DEV_SOAINFRA
- To check that you have the installed correctly run the following SQL as sysdba.
SELECT owner, version, status FROM schema_version_registry;
OWNER VERSION STATUS
------------------------------ ------------------------------ -----------
DEV_MDS 220.127.116.11.0 VALID
DEV_SOAINFRA 18.104.22.168.0 VALID
Don’t stress if the versions are not all sitting at version 22.214.171.124 as not all schemas need to be updated. The key ones are MDS and SOAINFRA