• Arpit Narula

Cut the Clutter: SOA Upgrade from 12.2.1.x to 12.2.1.4

Updated: Jan 4

Introduction: Oracle SOA Suite 12.2.1.4 was released on Sep 27, 2019, and is the latest SOA release in the market. The complete upgrade process is listed in Oracle SOA Upgrade Documentation, however, it is too exhaustive and a bit hard to follow. https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/fupss/preface.html#GUID-97108791-B395-4339-824C-2E8404C54DAD

Hence, to simplify the upgrade exercise, I have divided it into several activities that are explained in detail below. And have also listed several issues that you might encounter during the upgrade and their corresponding action plans.


Here is the list of activities we need to complete for the upgrade task.

1. Obtain the 12.2.1.4 Installer

2. Capture the Current Versions

3. Capture key configurations

4. Domain Shutdown and Backup

5. Infrastructure 12.2.1.4 Install

6. SOA 12.2.1.4 Install

7. Upgrade Readiness Check

8. Schema Upgrade

9. Domain Reconfiguration

10. Component Upgrade

11. Reconfigure Plan XMLs

12. Re-import SSL Certificates

13. Necessary Patching/Other fixes

14. Domain Startup

15. Capture the New Versions

Now let's start the upgrade activity and follow the above sections in given order:


Obtain the 12.2.1.4 Installer

For SOA Upgrade you would need 2 installers and a bundle patch

V983368-01.zip - Infrastructure 12.2.1.4 Installer

V983383-01.zip - SOA 12.2.1.4 Installer

Patch 31396632 - 12.2.1.4 Bundle Patch 200524 (12.2.1.4.200524)


Installers can be obtained from Oracle Edelivery and Patch can be downloaded from Oracle Support Portal.


Capture the current versions

OS

JAVA

DB Schema

SOA

WebLogic

Capture Key Configurations

Oracle Homes: These values will be referred in various GUI screens to follow during the upgrade process.

  • SOA HOME: /oracle/wls/12c/soa

  • WLS HOME: /oracle/wls/12c/wlserver

  • JAVA HOME: /usr/java8_64/jre/

  • DOMAIN HOME: /oracle/wls/12c/user_projects/domains/soa

  • FMW HOME: /oracle/wls/12c

Domain Shutdown and Backup

Shutdown the SOA domain and take the following backups:

  • Orainventory file: mv oraInventory oraInventory_backup12212

  • Product/Binaries: mv 12c 12c_backup12212_new

  • Domain: I had the domain in 12c folder only so no separate backup required. However it is good practice to have Binary and Domain in separate folder structures. I have created a new 12c folder that will hold the new binaries and also copied over the domain from the backed up folders.

cd /oracle/wls/

mkdir 12c

cd /oracle/wls/12c_backup12212_new

tar -cvz user.tar user_projects/

mv user.tar ../12c/

tar -xvf user.tar

  • SOA Database: You can use RMAN or FLASHBACK to take the SOA Database Backup

Infrastructure 12.2.1.4 Install

Now all backups are done and domain is shutdown. We are good to proceed with the installation activities.

Important Note: Do not install weblogic from fmw_12.2.1.4.0_wls.jar as it will result in error while installing SOA on top of it. WLS jar does not have required components to support SOA. You need to install weblogic and other components from fmw_12.2.1.4.0_infrastructure.jar (Doc ID 1904280.1)


Unzip the Installer:

Execute the Installer:

Screenshots: I have added the key screenshots below.

SOA 12.2.1.4 Install

After Infrastructure Installation we need to install SOA 12.2.1.4. We will install it in the new FMW home that we created during backup stage.

Unzip the installer:

Execute the installer:

Screenshots: In 3rd screenshot, BPM will include SOA and BPM both for upgrade

Upgrade Readiness Check

This step is executed to make sure that all components are in proper to be upgraded. In case some schemas having custom objects and locked objects, you will see warning/errors in this step.

Execute Readiness Check:

Key Screenshots:

Schema Upgrade

Now the readiness check is successfully done and we are good to execute the Database schema upgrade. Here you will notice that not all schemas are getting upgraded to 12.2.1.4, some of those will remain in their existing version as there are no changes introduced in those for this upgrade.


Schema Upgrade Execution:

Key Screenshot:

*Below warning can be ignored


Domain Reconfiguration

Execute Domain Reconfiguration:

Key Screenshots:

Any Schema connection error should be resolved before proceeding further. We had faced issues with account locked and incorrect port details in the environment that were resolved during the upgrade.

Component Upgrade

In this section, we are required to upgrade the WebLogic domain components such as JRF, WSM etc.


Execute Component Upgrade:

Key Screenshots:

Reconfigure Plan XMLs

If the plan XMLs are located inside the product home directories, we need to move them to new oracle home directories that are created in new Product home.

Copy the following to new Product home:

/oracle/wls/12c_backup12214/ soa/soa/Plan.xml /oracle/wls/12c_backup12214/ soa/soa/Plan1.xml /oracle/wls/12c_backup12214/ soa/soa/Plan_AQ.xml /oracle/wls/12c_backup12214/ soa/soa/applications/Plan.xml /oracle/wls/12c_backup12214/ soa/soa/connectors/Plan.xml

To

/oracle/wls/12c/soa/soa/Plan.xml /oracle/wls/12c/soa/soa/Plan1.xml /oracle/wls/12c/soa/soa/Plan_AQ.xml /oracle/wls/12c/soa/soa/applications/Plan.xml /oracle/wls/12c/soa/soa/connectors/Plan.xml


Best Practice:

For Clusters: Keep Plan XMLs in a shared location

For Standalone: Keep Plan XMLs outside the Product home


Re-import SSL certificates

As the Demotrust keystore resides in weblogic home, we need to move the old keystore to new oracle home.

mv $WLS_HOME/server/lib/DemoTrust.jks $WLS_HOME/server/lib/DemoTrust.jks_bkup

cp $OLD_WLS_HOME/server/lib/DemoTrust.jks $WLS_HOME/server/lib/


Necessary Patching and other fixes


Issue 1:

ORABPEL-15235 - Failed To Translate JSON To XML. Cannot Normalize!

Resolution:

Patch 31396632: 12.2.1.4 Bundle Patch 200524 (12.2.1.4.200524) in your 12.2.1.4

Please Note: This patch is mandatory after the upgrade as many features were not working after the upgrade and some of the components were still showing the previous version despite the successful upgrade.


Issue 2:

Deployment failed with ANT not found error

Resolution:

Copied over ANT related modules from old binary backup

ANT Copy

cd /oracle/wls/12c_backup12212_new/oracle_common/modules/

tar cvf ant.jar org.apache.ant_1.9.2/

mv ant.jar /oracle/wls/12c/oracle_common/modules

cd /oracle/wls/12c/oracle_common/modules

tar xvf ant.jar

rm ant.jar


ANTCONTRIB Copy

cd /oracle/wls/12c_backup12212_new/oracle_common/modules/

tar cvf sf.jar net.sf.antcontrib_1.1.0.0_1-0b3/

mv sf.jar /oracle/wls/12c/oracle_common/modules/

cd /oracle/wls/12c/oracle_common/modules

tar xvf sf.jar

rm sf.jar


Issue 3:

Custom XA Data Sources were reverted to Non XA Driver after the upgrade

Resolution:

Verify the drivers for XA Datasources post upgrade. If its non-XA driver (oracle.jdbc.OracleDriver), update to XA driver (oracle.jdbc.xa.client.OracleXADataSource) from Admin console.


Restart Domain and verify the versions

Schema Version:

WebLogic Version:

SOA Version:

Conclusion:

However it is a minor version upgrade but from 12c onwards we need to do a complete installation and re-configuration of existing domain to upgrade SOA. A thorough testing of all critical composites, Data Sources (especially using XA drivers), SSL outbound calls and JSON based REST services is advised.

179 views