Pages

Tuesday, July 28, 2015

Finding latest Patchset for OFMW SOA components !!!

Oracle recommend to patch SOA environments with latest patch set whenever it’s available. Its SOA administrator responsibility to apply latest patch set in all SOA environments time to time in order to make sure Oracle product remain to latest patch set levels. 

In each patch set there is list of bug which Oracle fixes, often I have seen if we raise a service ticket in Oracle for any specific bug, they will ask straight away what version of product component getting used.

They also ask to provide inventory logs for each Oracle product components e.g. SCA, OSB, WLS and Oracle_COMMON. 

In below blog I will show very simple example how to check current product level version of SOA bundle and find latest patchset available for same component.

1.1. SCA aks BPEL Component Current Patch set version Verification


Step1: 


Run the lsinventory command for Oracle_SOA1 home and get the installed Patch Number.

-bash-3.2$ export ORACLE_HOME=/u01/app/oracle/product/fmw/Oracle_SOA1
-bash-3.2$ cd /u01/app/oracle/product/fmw/Oracle_SOA1/OPatch
-bash-3.2$ ./opatch lsinventory -InvPtrLoc /u01/app/oracle/product/fmw/Oracle_SOA1/oraInst.loc -details



Step2: 


Now, login into support.oracle.com >> under patch & Update tab page >> provide patch number which we have got from above steps and click on search button.  


Step3: 


The below result will show us which particular patch set number this patch 19953598 is. It this case its SOA Bundle Patch 11.1.1.7.6


1.2. SOA Suite Latest Patch Set Search


In above steps we have confirmed which particular SOA Bundle PATCH set been already installed, now next steps to find out if there is any new patch set released after the one which is already installed. 

Step1: 


Login into support.oracle.com >> Patches & Update >> Product = Oracle SOA Suite >> Release = FMW 11.1.1.7.0 >> Platform = <As per your environment>
Click on search button-


Step2: 


The result which will appear will show what are all the patchset has been released. In below snap you could notice that next SOA Bundle has been release whose version is ‘SOA Bundle PATCH 11.1.1.7.8


Step3: 


Download the patch and apply in test environment, do regression test to verify all key business transactions, if it works apply into Production environment. Refer the patch readme file for detailed instructions. 

Likewise, above steps we can verify existing patch version of Oracle Service Bus (OSB) Component,  Weblogic Server component and find latest patch set released (if any) and apply into SOA environments.

1.3. Finding Weblogic Component Installed Patch Set Version 


There are two ways we can check the WLS installed product version-

Option1:


cd /u01/app/oracle/product/fmw/utils/bsu
./bsu.sh -prod_dir=/u01/app/oracle/product/fmw/wlserver_10.3 -status=applied -verbose –view



Option2: 


-bash-3.2$ export WL_HOME=/u01/app/oracle/product/fmw/wlserver_10.3
-bash-3.2$ . $WL_HOME/server/bin/setWLSEnv.sh
-bash-3.2$ java weblogic.version



 
Find the WLS latest Patch set in similar ways as we have found for OSB and SCA components.