Friday, September 18, 2015

Oracle SOA upgrade from to

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

Pre Upgrade Steps:

Step 1) Download patch and 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 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                               VALID       Y
XXX_MDS                                         VALID       Y
XXX_SOAINFRA                              VALID       Y

No comments:

Post a Comment

Other Posts