This is a follow on from my previous post where we upgraded 11.1.1.2 to 11.1.1.3. The instructions I provide here will work for Fusion Middleware 11.1.1.2 and 11.1.1.3 wanting to upgrade to 11.1.1.4.

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 11.1.1.4 you need to have access to http://support.oracle.com as this is where the downloads reside. Oracle provides 11.1.1.4 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 you SOA Environment
• Upgrade WLS to 11.1.1.4
• Upgrade SOA Suite to 11.1.1.4
• Upgrade OSB to 11.1.1.4
• Upgrade MSD Schemas

1. 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
   
   You must also download the 11.1.1.4 RCU tool to upgrade the DB schemas. It is available via OTN, or, Oracle Support, I have provided the link from Oracle Support. 
   11060956 – RCU
   
2. Make sure you have set the Java executable in your PATH e.g.
   
   export PATH=$JAVA_HOME/bin:$PATH 
   
3. Make sure all your WebLogic environment has been shut down before performing the upgrade.
   
4. 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.
   
   
   
5. Chose the right Oracle home for your WebLogic Server install.
   
   
   
6. 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
   
   
   
   
   
7. Select the products you want to upgrade and select next. It is recommended that you accept the defaults.
   
   
   
8. Confirm the directories that will be upgraded
   
   
   
9. Upgrade of WLS ahs been completed
   
    
   
10. 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
    
    
    
11. Skip the Software Updates
    
    
    
12. Ensure your system meets the prerequisites
    
    
    
13. Set the Oracle home for your SOA install.
    
    
    
    You will be asked to confirm that you want to upgrade, click Yes
    
    
    
14. Choose your application server. Since you are upgrading from 11.1.1.x you will be on WebLogic
    
    
    
15. Start the Install
    
    
    
16. Installation Upgrade of SOA Suite completed accept the default to finish.
    
     
    
    
    
    
17. 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. 
    
18. 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




19. Skip the software updates
    
    
    
20. Select the Oracle home for your environment
    
    
    
    Accept the warning to continue the upgrade
    
    
    
21. Point to the location of your WebLogic Server installation
    
    
    
22. Install the OSB upgrade
    
    
    
23. Upgrade has been completed accept the defaults
    
    
    
    
    
24. Change directory to $MW_HOME/oracle_common/bin where the Patch Set Assistant is installed
    
25. 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
 
27. 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                        11.1.1.4.0                     VALID
DEV_SOAINFRA                   11.1.1.4.0                     VALID

Don’t stress if the versions are not all sitting at version 11.1.1.4 as not all schemas need to be updated. The key ones are MDS and SOAINFRA