Saturday, October 26, 2013

Installing OBIEE Patchset 11.1.1.7.131017 on Windows

Please note OBIEE Bundle Patch 11.1.1.7.151020 is available. You might prefer it.

First download the single big patch file of   Patch 17530796 and the small file of  Patch 16569379 (you need 16569379 only if you didn't install it with 11.1.1.7.1) as described in OBIEE BUNDLE PATCH 11.1.1.7.131017 AKA 11.1.1.7.2 or 11.1.1.7.3 is available.

Don't know why, but I had trouble downloading the WIN64 patch with Firefox (all 4 time failed), while Chrome did the job well.
Unzip the patches. You should have 2 directories named by the patch number.
Now in the directory 17530796, you have 8 zip files and a useful readme.htm. You are advised by the readme to move the 17530796 directory to  prod_mwhome\Oracle_BI1. Unzip all 8 zip files. At the moment you should have 8 directories under prod_mwhome\Oracle_BI1\17530796.

PLEASE read carefully section 3.1 if you are upgrading from 11.1.1.6.X.

In section 3.2 we are advised to check conflicts. I promise to do it later, after I set the path and Oracle_Home.

Next we are advised to do is to back up the Oracle BI system, including the following:
  •     The <Oracle BI Home>\bifoundation\server directory.
  •     The <Oracle Instance>\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository directory.
  •     The <Oracle BI Home>\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml file, if you have modified it.
There is a tip: The location of the Oracle BI Home directory and the Oracle Instance directory depend on where Oracle BI was originally installed, and on the platform. For example:
        On UNIX, the Oracle BI Home directory might be prod_mwhome/Oracle_BI1
        On Windows, the Oracle BI Home directory might be c:\prod_mwhome\Oracle_BI1
In my case it's D:\or\MWHOME\Oracle_BI1\bifoundation\server and D:\or\MWHOME\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository.
I prefer to backup D:\or\MWHOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog as well.

In point 3 you are advised to stop the BI System and told how to do it, step by step. It's all very nice but to me it looks simpler just to run "Stop BI Services" from the Start/All Programs/Oracle Business Intelligence menu. I guess wee see the full details due to Linux needs (and anyway, it's very educational).

Point 4 advises to clear cache: from prod_mwhome\Oracle_BI1\bifoundation\web\catalogmanager\configuration\ (in my case D:\or\MWHOME\Oracle_BI1\bifoundation\web\catalogmanager\configuration\) you should delete 2 files (if they exist) org.eclipse.osgi  &  org.eclipse.equinox.app.

As you remember we have directory 17530796 with 8 sub-directories in  prod_mwhome\Oracle_BI1 (in my case D:\or\MWHOME\Oracle_BI1).
make sure the extracted directory 16569379 is under prod_mwhome\Oracle_BI1 as well, only if you didn't install this patch before (you did, if you installed 11.1.1.7.1).

Open CMD prompt as Administrator on  prod_mwhome\Oracle_BI1. (Right Click with Shift pressed on the CMD or Right Click and CMD here as Administrator in the File Browser).

The readme states:

On UNIX: If you are using a command shell derived from the C shell, then set the environment variables by entering the following:
setenv ORACLE_HOME $PWD
setenv PATH $ORACLE_HOME/bin:$PATH
setenv JAVA_HOME $ORACLE_HOME/jdk
setenv PATH $JAVA_HOME/bin:$PATH
setenv PATH $ORACLE_HOME/OPatch:$PATH
 
On Windows: If the Oracle BI Home directory is C:\prod_mwhome\Oracle_BI1, then set the environment variables by entering the following:
set ORACLE_HOME=C:\prod_mwhome\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%
 (in my case the first line is set ORACLE_HOME=D:\or\MWHOME\Oracle_BI1)
DON'T leave empty spaces in the set, such as set ORACLE_HOME=   D:\or\MWHOME\Oracle_BI1. 
Right Click does the paste action in CMD window.

 Now if you remember we need to conflict detection from section 3.2.
Assuming we are in directory 17530796 (cd 17530796), run:

cd 16913445
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17463314
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17300417
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17463395
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17463376
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17300045
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\16997936
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17463403
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

In all cases you should see:
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
 In point 10 we have 2 options: Run Once all 8 patches or do each manually.
Since I don't enjoy tedious manual labor, I preferred the first option.

Be sure you are back to the basic  prod_mwhome\Oracle_BI1\17530796 directory (by running:  cd.. in CMD, if you follow me.)

Enter the following command: 
opatch napply –skip_duplicate



My system is 11.1.1.7.1 so I was asked twice "Do you want proceed?"

And was asked to be sure "the local system is ready for patching" (shut down).

My installation finished with warning:
From what I see in the log, it's all because of previous patches (11.1.1.7.1 ?) components that are replaced by newer ones.



In case you don't trust opatch or simply enjoy unnecessary work you can run each patch separately with opatch apply. Wait for the  "Opatch Succeeded" and repeat in the next directory. (Repeat the Conflict Resolution list, just with opatch apply, instead of  opatch prereq CheckConflictAgainstOHWithDetail -ph ./)
As I said twice before, only if you didn't install 16569379 before,  go to directory 16569379 and Run opatch apply (in both types of installation).


You are advised to check all patches were applied using opatch lsinventory.


The next part has some manual labor (I use the readme numbers starting with 14):

14. Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files from the prod_mwhome\Oracle_BI1\clients\bipublisher\repository\Tools directory to the prod_mwhome\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Tools directory.
In my case, from D:\or\MWHOME\Oracle_BI1\clients\bipublisher\repository\Tools to D:\or\MWHOME\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Tools.
(Should I copy ExcelAnalyzer.exe as well?)

15. Copy the msmdacc64.dll file from the <Oracle BI Home>\clients\bipublisher\repository\Admin\DataSource directory to the prod_mwhome\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Admin\DataSource directory.
There seems to be a problem here since the source does not exist. I don't know if it's a documentation bug or missing file. Had the same thing in 11.1.1.7.1.

16.  Remove the jsp_servlet subdirectory associated with Oracle BI Publisher (if it exists), as follows:

  A.  Go to the directory containing the jsp_servlet subdirectory (using a file manager application or the command line). If it exists, then the jsp_servlet subdirectory is located in one of the directories below the <Middleware Home>/<Domain Home>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1 directory.

    For example:
        On UNIX: If the Middleware Home directory is /prod_mwhome and the Domain Home directory is /user_projects/domains/bifoundation_domain, then go to the following directory:
        /prod_mwhome/user_projects/domains/bifoundation_domainservers/bi_server1/tmp/_WL_user/bipublisher_11.1.1
        On Windows: If the Middleware Home directory is C:\prod_mwhome and the Domain Home directory is \user_projects\domains\bifoundation_domain, then go to the following directory:
        C:\prod_mwhome\user_projects\domains\bifoundation_domainservers\bi_server1\tmp\_WL_user\bipublisher_11.1.1

B.  Look in each directory below <Middleware home>/<Domain home>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1, and remove any jsp_servlet subdirectory that you find.

  17. If you backed up mapViewerConfig.xml because it had been modified, then copy the backed-up file to its original location at <Oracle BI Home>\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\.

Now you should be able to start the server, but before you do, there is one more part not in the readme file.

 You might remember the post of Abhinav Agarwal  Smart View Version to use with OBIEE 11.1.1.7.1
You are advised there to download the new SmartView here. Both zip files seem to be the same. They contain both SmartView files (the 32 and 64 bit).

The readme there states:
"With the availability of Oracle Business Intelligence Enterprise Edition release 11.1.1.7.1, it will no longer be possible to make use of the default Oracle Smart View client installer which is available through the Oracle BI EE Home Page. For this release only, it will be necessary to access an updated version of the Oracle Smart View client installer version 11.1.2.3.000_16909989 (from My Oracle Support), or later.

This updated version can be used to replace the default Oracle Smart View installer in the default Oracle BI EE Home Page location

/<middleware>/Oracle_BI1/clients/epm/SmartView/SmartView.exe
/<middleware>/Oracle_BI1/clients/epm/SmartView/SmartView-x64.exe
2.    Make backup copies of smartview.exe and version.xml before deploying the replacement files.

3.    Download the Smart View zip file from My Oracle Support.

4.    Unzip the file.

5.    Copy smartview.exe and version.xml to the location of the Workspace installation, typically: C:\Oracle\Middleware\EPMSystem11R1\common\epmstatic\wspace\SmartView"

Well you don't have to go to support... you just downloaded the zip file.
Backup  <Oracle BI Home>\clients\epm\SmartView (In my caseD:\or\MWHOME\Oracle_BI1\clients\epm\SmartView),  extract the content of the Zip file to that directory. 

You might want to delete the patch installation files from <Oracle BI Home> and free the 2.5GB of disk space.

Now you can Start up the server. Bon Voyage.




For Oracle Business Intelligence Client Tools only: Having applied the Oracle BI EE Suite Bundle Patch 11.1.1.7.131017, you must also update each desktop installation of the Oracle Business Intelligence Client Tools (Oracle BI Administration Tool, Job Manager, and Catalog Manager) as follows:

Deinstall the Oracle Business Intelligence Client Tools from every computer where the client tools have been installed by following the instructions in Chapter 5 of Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence.

Reinstall the Oracle Business Intelligence Client Tools on every computer where the client tools have been deinstalled by following the instructions in Chapter 5 of Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence.



Section 5.1: Copying BICharts.swf to Custom Directories


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

If the Oracle BI system has been customized as described in the white paper and custom skins are stored in one or more custom directories, then follow these additional instructions to complete the Suite Bundle Patch installation:

1.Copy the BIChart.swf file from the <Oracle BI Home>\bifoundation\web\app\res\sk_blafp\dvt directory 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

 2. Stop and restart the Oracle BI Presentation Services system component

3. Clear the browser cache.




Section 5.2: Editing Settings in OracleBIJavahostComponent


For customers exporting data into Microsoft Excel: To improve the functionality of exporting data from analyses, dashboards, and other Oracle BI Presentation Catalog objects into Microsoft Excel, edit settings in OracleBIJavahostComponent by performing the following steps to complete the Suite Bundle Patch installation:

    1. Navigate to the /instances/instance1/config/OracleBIJavaHostComponent folder.

    2. Perform the following actions:

       a. In the config.xml file, configure the XMLP tag for large data as follows:

        <XMLP> <InputStreamLimitInKB>0</InputStreamLimitInKB>

        <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing></XMLP>

        b . In the xdo.cfg file, change the setting for xlsx-keep-values-in-same-column to True. (See note 1632002.1 at Oracle Support if you don't know what they are talking about).

    3. Restart the WebLogic Administration Server (and Managed Server and BI System).

1 comment:

  1. Remember to upgrade the Admin Clients, otherwise you will get an Error.
    See: http://obieeil.blogspot.co.il/2013/11/obiee-nqserror-46036-in-bi.html

    ReplyDelete