Applying patches to OBIEE : 11.1.1.6.2 BP1

July 10th, 2012 by

The recent release of OBIEE 11.1.1.6.2 BP1 weighs in with a hefty eight individual patches to apply. They use the standard Oracle opatch mechanism. Here we see how to apply the patches, and note any “gotchas”. 

Starting point

To install 11.1.1.6.2 BP1, you must be on 11.1.1.6.0 first.

This article is based on an installation on Linux (OL6), but the process should be the same across OSs. It is also based on a single-node OBIEE install. For clustered deployments, you will need to do this on each node – see the patch README for more information.

Obtain the patches

The first step is to download the patches from Oracle Support. See my previous post on how to locate them and optionally download them from the command-line using wget. Don’t forget the JDeveloper patch, 13952743, which doesn’t show up in the standard search for 11.1.1.6.2 BP1.

Unzip the patches

You can unzip them using the commandline statement

unzip \*.zip

This will give you a list of folders, each containing a set of patch files. You should have the following:

drwxrwxr-x  4 oracle oinstall 4096 Jul 10 17:10 13867143
drwxr-xr-x  4 oracle oinstall 4096 Apr 12 07:10 13952743
drwxrwxr-x  4 oracle oinstall 4096 Jun  2 03:25 13960955
drwxr-xr-x  4 oracle oinstall 4096 Jun 14 00:53 14142868
drwxr-xr-x  4 oracle oinstall 4096 Jul 10 17:20 14223977
drwxrwxr-x  4 oracle oinstall 4096 Jun 22 11:06 14226980
drwxrwxr-x  4 oracle oinstall 4096 Mar 29 03:09 14226993
drwxrwxr-x  4 oracle oinstall 4096 Apr 19 07:22 14228505

Read the README

The patches come with a master README file, in 14223977/README.txt. Make sure you read through this and understand it. What I detail below are my notes based on it, but always check the README.

Determine FMW_HOME

All OBI 11g installations follow the same directory structure, but the root of this structure varies depending on where it was installed. The root is known as FMW_HOME (Fusion MiddleWare Home), and is commonly found in locations such as

  • /u01/app/oracle/product/fmw
  • /home/oracle/obiee
  • c:\oracle\middleware

Before continuing, make sure you know where your FMW_HOME is. When you’ve found it, you should see the following structure within it:

-rw-rw----  1 oracle oinstall   225 Jul  6 13:49 domain-registry.xml
drwxr-x---  3 oracle oinstall  4096 Jul  6 13:44 instances
drwxr-x---  2 oracle oinstall  4096 Jul  6 16:41 logs
drwxr-x---  7 oracle oinstall 36864 Jul  6 13:26 modules
-rw-r-----  1 oracle oinstall   623 Jul  6 13:26 ocm.rsp
drwxr-x--- 65 oracle oinstall  4096 Jul 10 20:25 Oracle_BI1
drwxr-x--- 33 oracle oinstall  4096 Jul 10 21:38 oracle_common
-rw-r-----  1 oracle oinstall 86921 Jul  6 13:26 registry.dat
-rw-r-----  1 oracle oinstall  1750 Jul  6 13:26 registry.xml
drwxr-x---  4 oracle oinstall  4096 Jul  6 13:37 user_projects
drwxr-x---  8 oracle oinstall  4096 Jul  6 13:26 utils
drwxr-x---  9 oracle oinstall  4096 Jul  6 13:26 wlserver_10.3

For the rest of this article, I’m assuming you’ve set the environment variable FMW_HOME, for example using export FMW_HOME=/u01/app/oracle/product/fmw (on a bash shell – other shells & OSs will differ)

Put patch files in place

Move your unzipped patch files into the $FMW_HOME/Oracle_BI1 folder. It should look like this:

oracle@rnm-ol6 fmw]$ ls -l /u01/app/oracle/product/fmw/Oracle_BI1/
total 272
drwxrwxr-x  4 oracle oinstall 4096 Jul 10 17:10 13867143
drwxr-xr-x  4 oracle oinstall 4096 Apr 12 07:10 13952743
drwxrwxr-x  4 oracle oinstall 4096 Jun  2 03:25 13960955
drwxr-xr-x  4 oracle oinstall 4096 Jun 14 00:53 14142868
drwxr-xr-x  4 oracle oinstall 4096 Jul 10 17:20 14223977
drwxrwxr-x  4 oracle oinstall 4096 Jun 22 11:06 14226980
drwxrwxr-x  4 oracle oinstall 4096 Mar 29 03:09 14226993
drwxrwxr-x  4 oracle oinstall 4096 Apr 19 07:22 14228505
drwxr-x---  3 oracle oinstall 4096 Jul  6 12:53 admin
drwxr-x---  3 oracle oinstall 4096 Jul  6 12:53 asoneofftool
drwxr-x---  3 oracle oinstall 4096 Jul  6 13:08 assistants
drwxr-x---  3 oracle oinstall 4096 Jul  6 12:53 atgpf
drwxr-xr-x  3 oracle oinstall 4096 Jul 10 20:25 bicomposer
drwxr-x--- 16 oracle oinstall 4096 Jul  6 13:15 bifoundation
[…]

Check disk space

The patches copy files and take copies of files they are replacing, so you will need free disk space – from experience, around 10GB can be necessary

Backup, backup, backup

You already take backups of your OBIEE installation, right? Well, now is definitely the time to start if you don’t. Patching is a complex process, and if something goes wrong then you are at the mercy of oPatch and oraInventory.

And don’t forget, untested backups are as good as no backups.

See the Oracle® Fusion Middleware Administrator’s Guide – Introducing Backup and Recovery for more information, and specifically Backup and Recovery Recommendations for Oracle Business Intelligence

Shutdown the OBIEE processes, including WebLogic

Shutdown OPMN, the Weblogic managed server (bi_server1), and the Weblogic Admin Server.

Delete catalog manager cache directories

These may or may not exist – if they do, delete them

rm -rv $FMW_HOME/Oracle_BI1/bifoundation/web/catalogmanager/configuration/org.eclipse.osgi
rm -rv $FMW_HOME/Oracle_BI1/bifoundation/web/catalogmanager/configuration/org.eclipse.equinox.app

Set the environment variables

The patch README explains how to do this on Windows and a *nix C shell, here is how to do it on Bash shell:

cd $FMW_HOME/Oracle_BI1
export ORACLE_HOME=$PWD
export PATH=$ORACLE_HOME/bin:$PATH
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$JAVA_HOME/bin:$PATH
export PATH=$ORACLE_HOME/OPatch:$PATH

Apply the OBI patches

Making sure that you’ve set the environment variables as shown above, apply the seven OBI patches as follows:
14223977 (1 of 7) Oracle Business Intelligence Installer

cd $FMW_HOME/Oracle_BI1/14223977
opatch apply

14226980 (2 of 7) Oracle Real Time Decisions

cd $FMW_HOME/Oracle_BI1/14226980
opatch apply

13960955 (3 of 7) Oracle Business Intelligence Publisher

cd $FMW_HOME/Oracle_BI1/13960955
opatch apply

14226993 (4 of 7) Oracle Business Intelligence ADF Components

cd $FMW_HOME/Oracle_BI1/14226993
opatch apply

14228505 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x

cd $FMW_HOME/Oracle_BI1/14228505
opatch apply

13867143 (6 of 7) Oracle Business Intelligence

cd $FMW_HOME/Oracle_BI1/13867143
opatch apply

14142868 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer

cd $FMW_HOME/Oracle_BI1/14142868
opatch apply

Check the OBI patches have been applied

cd $FMW_HOME/Oracle_BI1
opatch lsinventory|grep applied

You should see the seven patches just applied, plus a bunch of others from installing 11.1.1.6.0

Patch  14142868     : applied on Tue Jul 10 21:31:11 BST 2012
Patch  13867143     : applied on Tue Jul 10 20:58:29 BST 2012
Patch  14228505     : applied on Tue Jul 10 20:33:59 BST 2012
Patch  14226993     : applied on Tue Jul 10 20:25:58 BST 2012
Patch  13960955     : applied on Tue Jul 10 20:19:46 BST 2012
Patch  14226980     : applied on Tue Jul 10 20:02:40 BST 2012
Patch  14223977     : applied on Tue Jul 10 20:00:35 BST 2012
Patch  6845838      : applied on Fri Jul 06 13:33:14 BST 2012
Patch  7393921      : applied on Fri Jul 06 13:32:58 BST 2012
Patch  7707476      : applied on Fri Jul 06 13:32:46 BST 2012
Patch  7663342      : applied on Fri Jul 06 13:32:21 BST 2012
Patch  6599470      : applied on Fri Jul 06 13:32:10 BST 2012
Patch  6750400      : applied on Fri Jul 06 13:31:58 BST 2012
Patch  7427144      : applied on Fri Jul 06 13:31:23 BST 2012

Copy the client tool installers

cd $FMW_HOME/Oracle_BI1/clients/bipublisher/repository/Tools
cp BIPublisherDesktop*.exe $FMW_HOME/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools/

Apply the JDeveloper patch

This requires a different ORACLE_HOME to be set, so make sure you don’t skip setting the environment variables here:

cd $FMW_HOME/oracle_common
export ORACLE_HOME=$PWD
export PATH=$ORACLE_HOME/bin:$PATH
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$JAVA_HOME/bin:$PATH
export PATH=$ORACLE_HOME/OPatch:$PATH
cd $FMW_HOME/Oracle_BI1/13952743
opatch apply

Check the JDeveloper patch has been applied

cd $FMW_HOME/Oracle_BI1
opatch lsinventory|grep applied

You should see the patch just applied listed:

Patch  13952743     : applied on Tue Jul 10 21:44:19 BST 2012

Startup the OBIEE processes, including WebLogic

Start up the Weblogic Admin Server, Managed Server (bi_server1), and then OPMN.

Validate the patching has been successful

If all has gone well, you should now be able to login to OBIEE and from the Administration link see the new version listed:
11.1.1.6.2 (Build 120605.2000 BP1 64-bit)

Untitled 4
Untitled 5

Client tools

Don’t forget to update your Client Tools (Adminstration Tool, Catalog Manager, Job Manager). To do this, login to OBIEE and from the Home page go to Get Started… -> Download BI Desktop Tools -> Oracle BI Client Installer. This will download the client installer, which you should then run to install the tools.

The Admin Tool lists its version in C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\version.txt

Build: 11.1.1.6.0.BIFNDN_11.1.1.6.2BP1_NT_120604.0813
Release Version: Oracle Business Intelligence 11.1.1.6.0
Package: 120604.0136.000

Tidy up patch files

If you want to save disk space, you can delete the patch folders:

cd $FMW_HOME/Oracle_BI1/
rm -rf 13867143
rm -rf 13952743
rm -rf 13960955
rm -rf 14142868
rm -rf 14223977
rm -rf 14226980
rm -rf 14226993
rm -rf 14228505

Browser Cache

In the README for the patches, there is the following note that is worth being aware of:


NB: When the patchset installation is complete and the BI System is running again, end-users might experience unexpected behavior due to pre-existing browser sessions caching javascript from the earlier Oracle BI release. To avoid unnecessary support requests, ask all end-users to clear their browser cache.

This unexpected behaviour can include the display not rendering correctly – when creating a new Analysis, only the main toolbar is shown:
Untitled 6
The resolution is simple, just purge the browser cache and logout/login to OBIEE.

Another problem observed has been the dashboard tabs not displaying.

For an enterprise deployment, I would imagine this might cause a few problems as not all users will necessarily be familar with clearing browser caches, or pay attention to instructions telling them to do so.

Tags: , , ,

Comments

  1. Tom Says:

    After our upgrade we were not seeing any graphs anymore. This was because we are using Custom Styles, Skins & Custom XML Messages. After Upgrade you need to reapply,reconfigure this.

  2. Steve Says:

    Hi Robin,
    Great post. As an fyi, you may want to alert your readers that the patch readme has just been updated for the graph issue.

    ========================================
    Section 6: Post-Installation Instructions
    —————————————–

    Section 6.1: Copying BIChart.swf To Custom Directories

    The Oracle white paper “Customizing Oracle Business Intelligence Enterprise Edition 11g” describes how to customize BI Presentation Services by storing custom skins, styles, and messages in a custom directory.

    If the BI System has been customized as described in the white paper and custom skins are stored in one or more custom directories, follow the additional instructions below to complete the 11.1.1.6.2 BP1 patchset installation:

    1. Go to the following directory:
    \bifoundation\web\app\res\sk_blafp\dvt

    2. Verify that the BIChart.swf file in that directory:
    – has a size of 457KB (466,944 bytes)
    – has a date of 6/4/2012

    3. Copy the BIChart.swf file to each custom directory in the BI System, replacing the existing file of that name:
    For example, on Windows, you might copy the BIChart.swf into the following custom directory:
    c:\prod_mwhome\Oracle_BI1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\sk_mylookandfeel\dvt

    4. Stop and restart the BI Presentation Services system component as follows:
    a. Stop BI Presentation Services, by typing the following at the command prompt:
    opmnctl stopproc ias-component=coreapplication_obips1
    b. Restart BI Presentation Services, by typing the following at the command prompt:
    opmnctl startproc ias-component=coreapplication_obips1

    5. Clear the browser cache.

    ======================================

    An Oracle tech note was also published for those that miss the readme update

    OBIEE 11g: Problems Displaying Charts / Graphs after Application of 11.1.1.6.2 BP1 when Using Customized Skins or Folders (Doc ID 1474605.1)

  3. Mahesh Vallampati Says:

    A couple of things.
    1.) After installing 11.1.1.6.0 on Windows, we could not find the orainst.loc. So we had to follow. http://docs.oracle.com/cd/E17236_01/epm.1112/ofma_admin.pdf to fix this issue. We had to copy orainst-template.loc from
    %BI_ORACLE_HOME%\bifoundation\provision\scripts\bidomain\inst to the %BI_ORACLE_HOME% location and rename it to oraInst.Loc. We also copied it to c:\program files\Oracle\Inventory.
    2.) In Windows when you run the command shell, you have to start is as “Run as Administrator” so I can get a lock on the orainst.loc file.
    3.) In the unbundled patch, there were some specific intsruction in the upgrade about some of the Java components. You had to rename the AdminServer, update RTD, BI Publisher etc. etc. Has this been addressed? The BP1 patch seems to be too simple to be true!! Can we apply this directly on top of 11.1.1.6.0? We created our test enviroments with the unbundled patch. So we are replicating the process of applying the 11.1.1.6.2 unbundled on top of the 11.1.1.6.0 home and then applying BP1 patch.

    Very good blog. Thanks!! We checked our install steps against yours and it matches.
    Mahesh

  4. Robin Moffatt Says:

    Hi,
    11.1.1.6.2 was a very protracted install, like you say, and BP1 is a lot simpler.
    You should apply 11.1.1.6.2 BP1 directly to 11.1.1.6.0, you do not need 11.1.1.6.2 first.

  5. Mahesh Vallampati Says:

    Robin
    A quick followup on the Tools. Does the installer automatically install the client tools (Admin Tool, Catalog Manager/Job Manager) on The windows server when you apply opatch? The tools patch is 14142868 and the biee_client_install*.exe files are in the files\clients\biserver directory. Or should we install it seperately on the server and use that one instead of the tool in the BI Server home? It is confusing.

    Mahesh

  6. Dustin Says:

    We saw three big issues after our 6.2 BP1 upgrade from 6.0. The first one was effectively communicating to users (and getting them to do it correctly) that they would need to clear their browser cache.

    The second is the pie chart for pivot charts has reverted back to 10g functionality. Now the measure labels must go in the ROWS instead of the columns. This one really hurt as we just upgraded to 11g 2 months ago and all of our users had to update their pivot charts…now they had to go back and revert just two months later and they were not happy.

    The third is chart labels are unreadable in Google Chrome. Big bummer as IE8 is so incredible buggy in 11g.

  7. Julia Says:

    After upgrading to 6.2 from 6.0 we got another logic of SQL-queries in Answers, which gives incorrect results in aggregated measures. Here are the examples of queries before and after patching:
    11.1.1.6.0 – correct aggregation:

    /* a7aee635 */WITH 
    SAWITH0 AS (select sum(T574.SUM_SHIPPING_VAT) as c1,
         sum(T574.SUM_RET_VAT) as c2,
         T511.REPORT_DATE as c3,
         T1256.PRODUCT_CODE as c4,
         T511.ID_CALENDAR as c5
    from 
         D_PRODUCT T1256 /* AD.100_PRODUCT */ ,
         D_CALENDAR T511 /* AD.010_CALENDAR_DETAIL */ ,
         F_SHIP_FACT T574 /* AF.010_SHIP_FACT */  left outer join D_AVG_STOCK_PRICE T9355 /* AD.320_AVG_STOCK_PRICE */  On T574.ID_PRODUCT = T9355.ID_PRODUCT and T574.ID_WHS = T9355.ID_WHS
    where  ( T511.ID_CALENDAR = T574.ID_CALENDAR and T511.ID_MONTH = T9355.ID_CALENDAR and T574.ID_PRODUCT = T1256.ID_PRODUCT and T574.ID_WHS = T1256.ID_WHS and T511.REPORT_DATE between TO_DATE('2012-07-01 00:00:00' , 'YYYY-MM-DD HH24:MI:SS') and TO_DATE('2012-08-03 00:00:00' , 'YYYY-MM-DD HH24:MI:SS') ) 
    group by T511.ID_CALENDAR, T511.REPORT_DATE, T1256.PRODUCT_CODE),
    SAWITH1 AS (select distinct 0 as c1,
         D1.c3 as c2,
         D1.c4 as c3,
         D1.c2 as c4,
         D1.c1 as c5,
         D1.c5 as c6
    from 
         SAWITH0 D1)
    select D1.c1 as c1,
         D1.c2 as c2,
         D1.c3 as c3,
         D1.c4 as c4,
         D1.c5 as c5
    from 
         SAWITH1 D1
    order by c1, c3, c2
    

    11.1.1.6.2 – incorrect aggregation:

    select 0 as c1,
         D1.c2 as c2, 
         D1.c3 as c3,
         case  when D1.c1 is not null then D1.c1 when D2.c2 is not null then D2.c2 end  as c4,
         D2.c1 as c5
    from 
         (select distinct sum(T574.SUM_RET_VAT) as c1,
                   T511.REPORT_DATE as c2,
                   T1256.PRODUCT_CODE as c3
              from 
                   D_PRODUCT T1256 /* AD.100_PRODUCT */ ,
                   D_CALENDAR T511 /* AD.010_CALENDAR_DETAIL */ ,
                   F_SHIP_FACT T574 /* AF.010_SHIP_FACT */  left outer join D_AVG_STOCK_PRICE T9355 /* AD.320_AVG_STOCK_PRICE */  On T574.ID_PRODUCT = T9355.ID_PRODUCT and T574.ID_WHS = T9355.ID_WHS
              where  ( T511.ID_CALENDAR = T574.ID_CALENDAR and T511.ID_MONTH = T9355.ID_CALENDAR and T574.ID_PRODUCT = T1256.ID_PRODUCT and T574.ID_WHS = T1256.ID_WHS and T511.REPORT_DATE between TO_DATE('2012-08-01 00:00:00' , 'YYYY-MM-DD HH24:MI:SS') and TO_DATE('2012-08-03 00:00:00' , 'YYYY-MM-DD HH24:MI:SS') ) 
              group by T511.ID_CALENDAR, T511.REPORT_DATE, T1256.PRODUCT_CODE
         ) D1,
         (select sum(T574.SUM_SHIPPING_VAT) as c1,
                   sum(T574.SUM_RET_VAT) as c2
              from 
                   D_CALENDAR T511 /* AD.010_CALENDAR_DETAIL */ ,
                   F_SHIP_FACT T574 /* AF.010_SHIP_FACT */  left outer join D_AVG_STOCK_PRICE T9355 /* AD.320_AVG_STOCK_PRICE */  On T574.ID_PRODUCT = T9355.ID_PRODUCT and T574.ID_WHS = T9355.ID_WHS
              where  ( T511.ID_CALENDAR = T574.ID_CALENDAR and T511.ID_MONTH = T9355.ID_CALENDAR and T511.REPORT_DATE between TO_DATE('2012-08-01 00:00:00' , 'YYYY-MM-DD HH24:MI:SS') and TO_DATE('2012-08-03 00:00:00' , 'YYYY-MM-DD HH24:MI:SS') ) 
         ) D2
    order by c3, c2
    

    It looks like some parameters were changed after upgrade, but we can’t find which ones so far…
    Regards, Julia

  8. Julia Says:

    We re-deployed the RPD file, RPD version was updated – now the SQL-query works correctly.
    Regards,

  9. Dhanaraj R Says:

    Hi All,
    I have a unix script which will apply the patch one by one automatically. I have given the commands like go into the directory and do “opatch apply”.
    But the opatch is is failing waiting for the user input.

    [Aug 23, 2012 4:28:43 PM] To continue, OPatch will do the following:
    [Back up for restore] : Back up 53 files for Oracle Home restore in case of patching error.
    [Back up for rollback] : Back up 24 files for future patch rollback.
    [Patch Oracle Home for apply] : Copy 24 file(s) to Oracle Home.
    [Update inventory for apply] : Modify the inventory to record patch [14223977].
    [Aug 23, 2012 4:28:43 PM] Do you want to proceed? [y|n]
    [Aug 23, 2012 4:28:43 PM] Start to wait for user-input at Thu Aug 23 16:28:43 EDT 2012
    [Aug 23, 2012 4:28:43 PM] Finish waiting for user-input at Thu Aug 23 16:28:43 EDT 2012
    [Aug 23, 2012 4:28:43 PM] [ Error during Patch conflict detection for apply patch phase ] Detail: OUI-67073:OPatch failed: ApplySession failed to prepare the system. No detail available.
    [Aug 23, 2012 4:28:43 PM] System is intact, OPatch will not restore the system
    [Aug 23, 2012 4:28:43 PM] Finishing ApplySession at Thu Aug 23 16:28:43 EDT 2012

    Could anyone help me how to apply the patch in silent mode i.e make opatch run without waiting for user input to be given.

    Thanks,
    Dhanaraj R

  10. Robin Moffatt Says:

    Hi,

    Try this:

    echo Y|opatch apply
  11. Dhanaraj R Says:

    Hi Robin,
    opatch apply -silent
    This one worked perfectly for me. Oracle recommended this.
    Thanks for your reply on this.

  12. Keith Says:

    After applying BP1, charts in general are working, but the Dial view of a Gauge chart is not working.

    We are not using custom skins or styles, and I have verified that the BIChart.swf file in both locations is the correct size and showing the correct modified date.

    This is a Solaris 64 bit instance.

    Any ideas what might be the problem? I have purged client cache, tried accessing from multiple clients, etc. Oddly enough a Windows instance is working fine.

  13. Mike Brookes Says:

    We have some corruption with Graphs using Chrome in the BP1 release.
    The .swf file date stamps and sizings all checked out, and after raising an SR with oracle, it turns out that the version of flash bundled with the latest version of Chrome is not up to date.
    The version bundled with chrome is 11.3.x and the latest version is 11.4.x.
    To fix our issue, we disabled Flash in Chrome, and then installed the latest Version.
    The problem with this solution is that by disabling Flash in Chrome, you also disable the auto-update of flash, so you have to manually do it yourself from that point on.
    Another issue is that all users using Chrome will also have to do this, which is not really practicable for a large user base – esapecially as you will have to undo your changes when the next release of Chrome comes out!
    regards
    Mike

  14. Mike Brookes Says:

    Quick fix for unreadable chart labels using Chrome:
    By the way, if you do see a malformed chart using chrome, then just zoom one step in, or out, in your browser (ctrl-”+”, or ctrl-”-”) this seems to kick start flash to display what it should…it worked for us…
    hope this helps
    Mike

  15. M Rao Says:

    Hi,
    I am applying patches on Windows 7. When running opatch apply command, I am getting error “OPatch failed with error code = 22″. Pls help me resovle it.
    TX

  16. Krishna Prasad Says:

    Hi Mark,

    We have recently applied the obiee 11.1.6.2 BP1 patch. Currently we are facing the same issue as mentioned by Julia in the posts ( 11.1.1.6.2 – incorrect aggregation ) we tried to redeploy the RPD, also restarted the weblogic + whole services.. but stil the issue remains the same.

    How can we resolve the same.

  17. Ruchi Says:

    I applied the said patches, but after the upgrade, I was unable to see my Dashboard pages/tabs.
    I cleared the browser cache, even restarted the server, still no help. Please suggest

  18. Mabel Lee Says:

    I installed OBIEE 11g by myname user(no administrator). Can I use root (administrator ) to install the patch?

  19. Michal Novy Says:

    I solved the issue of illegible flash charts in Chrome. I checked the installed plugins and found out I had two sub-plugins under the Adobe Flash Player – the first one was built-in in version 11.5.31.2, the second one was standalone in version 11.5.502.110. So I deactivated the older one (Chrome built-in).
    Now charts are shown correctly.

    You can see plugin setup screen in Chrome: https://docs.google.com/open?id=0B9EGCSsYeJdeeThIX1BSNTR6bmM
    Unfortunately, it is in Czech. However you can understand the basic idea.

  20. PL Says:

    @M. Rao – October 16th, 2012 at 10:06 pm:

    You have to run opatch as as Administrator. Go to Start > Run > type ‘cmd’. Instead of pressing enter key, press CTRL+SHIFT+Enter, then you’re running command prompt as an Administrator and you can run command ‘opatch apply’ succesfully!

    Cheers,
    PL

  21. PL Says:

    BTW, Mark thanks for your good post!

  22. sarah Says:

    Hi

    I have installed 11.1.1.6 and trying to apply 11.1.1.6.2 BP1 patch.

    i followed the guide, set up the enviroment veriables as following

    set ORACLE_HOME=C:\OBIEE_Server\Oracle_BI1
    set PATH=%ORACLE_HOME%\bin;%PATH%
    set JAVA_HOME=%ORACLE_HOME%\jdk
    set PATH=%JAVA_HOME%\bin;%PATH%
    set PATH=%ORACLE_HOME%\OPatch;%PATH%

    but when i tried to apply any of the patch. keep getting error which is indicated that can’t find main class:
    C:\OBIEE_Server\Oracle_BI1\modules\oracle.jrf_11.1.1/jrf_wlstman.jar

    I checked the folder , i can’t find any folder name is oracle.jrf_11.1.1 in modules. is that the reason the apply failed ??

    anybody could help? thanks a lot!!

    Sarah

  23. SKDHyperion Says:

    Hi,

    We have recently applied the patch 11.1.1.6.7 and everything seems to work fine when using the server URL (HTTP), but when using Load Balancer URL (F5) with SSL (HTTPS at the LB layer), the Dashboards with Tabs and Charts are not visible . Any help or inputs on the same.

  24. SKDHyperion Says:

    The issue was resolved by clearing the cache in the DMZ Proxy level .

Website Design & Build: tymedia.co.uk