Weblogic Patching

Weblogic Patching on OBIEE Linux Node:

1) How to check the weblogic version?

To verify or check the weblogic version you need to follow below mention steps:
a) First navigate to the location :<ORACLE_MIDDLEWARE_HOME>/wlserver_10.3/server/bin

b) Run the following script to set Envirnoment Varaible : . ./setWLSEnv.sh

c) Then Navigate to location: <ORACLE_MIDDLEWARE_HOME>/utils/bsu

d) Then there are two ways to check the weblogic version:
    i) You can fire the below command also:
    java weblogic.version
   
    ii) Or you can fire this command also:
    ./bsu.sh -prod_dir=<ORACLE_MIDDLEWARE_HOME>/wlserver_10.3  -status=applied -verbose -view
   
From the above steps you will get the weblogic version and the patches applied to it.


2) How to apply the patch in weblogic:


a)Downlaod the patch and unzip the patch and place in the folder <ORACLE_MIDDLEWARE_HOME>/utils/bsu/cache_dir

b) Rename the patch-catalog_XXX.XML file to patch-catalog.xml

c) First navigate to the location :<ORACLE_MIDDLEWARE_HOME>/wlserver_10.3/server/bin

d) Run the following script to set Envirnoment Varaible : . ./setWLSEnv.sh

e) Then Navigate to location: <ORACLE_MIDDLEWARE_HOME>/utils/bsu

f) Use the below command to apply the patch:
 ./bsu.sh -install -patch_download_dir=<ORACLE_MIDDLEWARE_HOME>/utils/bsu/cache_dir -patchlist=PATCHID -prod_dir=<ORACLE_MIDDLEWARE_HOME>/wlserver_10.3


3) How to Roll Back the patches if it has a conflict with the existing patches?

Weblogic patches are cumulative patches i.e. sometime we need to roll back few patches and apply the new patch.
./bsu.sh -prod_dir=<ORACLE_MIDDLEWARE_HOME>/wlserver_10.3 -patchlist=<PATCHID having conflict> -verbose -remove

Please update the details or any more info that you may need for weblogic patching.

BI Publisher Graph Formatting Part 2

In BI Publisher Graph Formatting Part 1 We made some changes to line graph now to moving ahead.

Now as you can see the below mentioned graph in which the x-axis label are horizontal and are overlapping each other. 

 

In rtf template while creating BI Publisher report it is working dynamically but if we want to show the x-axis label vertically we can do so for the same we will make some changes in the Advanced tab of charts.Please enter the below code after the tag <LegendArea visible="true" />. 

<O1TickLabel textRotation="TR_HORIZ_ROTATE_90" automaticRotation="AR_NO_ROTATE"></O1TickLabel> 

After making the changes mentioned above you will find that the x-axis label are now vertically displayed.

   

Now much of the formatting is done but now if we want to see the y-axis label without the scale factor the need to make some changes with respect to the scale we can do that too. 
For making the changes with respect to the scale of y-axis please use the following code in the advance tab and place it before the <LocalGridData> 
<Y1Axis><ViewFormat numberType="NUMTYPE_GENERAL" numberTypeUsed="true" decimalDigit="0" decimalSeparatorUsed="true" decimalDigitUsed="true" scaleFactor="SCALEFACTOR_NONE" scaleFactorUsed="true" /></Y1Axis> 

So after placing the above code please see below the graph changed as shown below:

 

Now similarly if you want to make the changes with respect to the values on the line graph you can make that change too. 

For the same please use the below mention code in the advance tab. And place it after the <MarkerText visible="true" markerTextPlace="MTP_OUTSIDE"> tag. 

<Y1ViewFormat><ViewFormat numberType="NUMTYPE_GENERAL" numberTypeUsed="true" decimalDigit="0" decimalSeparatorUsed="true" decimalDigitUsed="true" scaleFactor="SCALEFACTOR_NONE" scaleFactorUsed="true" /></Y1ViewFormat> 

After making the above changes the graph will reflect as shown below.

 

For doing the same please use the below mention code in the advance tab and place it before the <LocalGridData>    

Now we will move towards the next step i.e if we want to show the values on the y-axis i.e Revenue using Currency symbol we can do that too also. 

<Y1Axis><ViewFormat numberType="NUMTYPE_CURRENCY" currencySymbol="$"  numberTypeUsed="true" decimalDigit="0" decimalSeparatorUsed="true" decimalDigitUsed="true" scaleFactor="SCALEFACTOR_NONE" scaleFactorUsed="true" /></Y1Axis> 

So after making the changes mentioned above you will find that the currency symbol has been seen in the graph.

   

As you can see we have made some many changes in the graph and this same logic can be used in other graphs also. 

So now in my next blog will be coming up with something more on graphs and at the same walking you through the steps of implementing the bursting in BI Publisher.  

So please wait for the same…………….