Oracle SOA upgrade from 11.1.1.5 to 11.1.1.7

As we know that Oracle SOA Suite 11.1.1.5 is now out of support by Oracle. So in this post we shall see up gradation of Oracle SOA Suite from 11.1.1.5 to 11.1.1.7.

Pre Upgrade Steps:

Step 1) Download patch p16471502_111170_Generic_1of2.zip and p16471502_111170_Generic_2of2.zip from metalink.

Step 2) Upgrade Oracle Weblogic server to 10.3.6 

Step 3) Backup Oracle SOA home folder , Middleware home ,  Inventory directory and database.

Step 4) Shutdown below services:

Admin Server , All Manage server and Node Manager.

Step 5) Unzip the patch.

Upgrade Oracle SOA Home:

Step 1) Execute below command from Disk1

 

Step 2) On Welcome screen click Next

 

Step 3) Select  radio button Skip Software Updates and click Next.

 

Step 4) Make sure it passes all per-requisites check. Once done click Next.

 

Step 5) Specify middleware location and oracle soa home  name that you wish to upgrade and click Next

Oracle Middleware Home= $MW_HOME

Oracle Home Directory= Oracle_SOA1(by default)

 

Step 6) Click Yes to confirm with upgrade.

 

Step 7) Select appropriate  application server as per your environment.

 

Step 8) Confirm everything and click Install

 

Step 9) Click Finish once up gradation completes 100%.

 

Step 10) Confirm soa version by executing  soaversion.sh from $ORACLE_SOA_HOME/bin

 

Upgrade SOA INFRA schema:

Step 1) Execute ./psa from $ORACLE_SOA_HOME/bin in GUI mode.

Step 2) Click Next

 

Step 3)  Select Oracle SOA schema  to upgrade and click Next

 

Step 4) Click Next.

 

Step 5)Enter schema details for ORASDPM / MDS  / SOAINFRA  user

Connect string : hostname:port/DBName
DBA user name : sys as sysdba
DBA Password : ******
Schema Username: Dropdown and select user name 'XXX_ORASDPM'
Schema Password : Password for user 'XXX_ORASDPM'

Step 6) Repeat above step 5  for 'XXX_MDS' schema and 'XXX_SOAINFRA' schema

Step 7) Make sure it passes all checks



Step 8) Confirm everything and click Upgrade

Step 9) Check Status.

Step 10) Login to database and confirm schemas have been upgraded with below command.

"Select owner,version,status,upgraded from schema_version_registry"

Expected Output:

XXX_ORASDPM                    11.1.1.7.0                     VALID       Y
XXX_MDS                              11.1.1.7.0                     VALID       Y
XXX_SOAINFRA                   11.1.1.7.0                     VALID       Y