Saturday, April 26, 2014

OBIEE - Installing patch set 11.1.1.7.140415 on Windows

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

The process is very similar to the previous patchset installations. I created it for myself, mostly for comfortable copy/paste of command lines.

As described in OBIEEBUNDLE PATCH 11.1.1.7.140415 AKA 11.1.1.7. (?) is available, first download the single big patch file of   Patch 18283508 and the small file of  Patch 16569379 (you need 16569379 only if you didn't install it with 11.1.1.7.1 ... or later, I’ll refer to it in the description, but you can disregard it if you already installed it).

Unzip the patches. You should have 2 directories named by the patch number.
Now in the directory 18283508, you have 8 zip files and a useful readme.htm. You are advised by the readme to move the 18283508 directory to  prod_mwhome\Oracle_BI1. Unzip all 8 zip files. At the moment you should have 8 directories under prod_mwhome\Oracle_BI1\18283508.

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

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:\MWHOME\Oracle_BI1\bifoundation\server and D:\MWHOME\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository.
I prefer to backup D:\MWHOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog as well.
Please note: If you changed configuration files or added pictures not in AnalyticsRes folder (as described here, back the changes as well. They will be erased by the patch).

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 we 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:\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 18283508
with 8 sub-directories in  prod_mwhome\Oracle_BI1 (in my case D:\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  or later).

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 or check the start menu).

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:\MWHOME\Oracle_BI1)
DON'T leave empty spaces in the set, such as set ORACLE_HOME=   D:\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 Oracle_BI1, run:

cd 18283508

cd 16913445
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\16997936
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17300045
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\17891247
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\18290942
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\18290979
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\18291001
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd..\18291015
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.

We will return to the basic prod_mwhome\Oracle_BI1\18283508 directory and run opatch.

Enter the following commands:
 
cd ..
opatch napply –skip_duplicate

 


This time I installed the patch on fresh 11.1.1.7.0 installation, so I was asked once  "Do you want proceed?" on finished the installation without warnings.
 
If you installed one of the bundle patches before, you will be asked twice "Do you want proceed?"  The identical patches are skipped.
In that case the installation will finish with warnings (older patch screen bellow):


It's all because of previous patches components that are the same in this bundle.

In case you don't trust opatch or simply enjoy unnecessary work you can run each patch separately with opatch apply. PLEASE check,you need to install only the new versions and not all  8 you see. 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:\MWHOME\Oracle_BI1\clients\bipublisher\repository\Tools to D:\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 and later.

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_domain\servers\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 don’t have to repeat it if you have done it with 11.1.1.7.1 or later patches. Backup  <Oracle BI Home>\clients\epm\SmartView (In my caseD:\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. Before you do you might want to have a look at section 5.2 bellow (it requires you to stop the serer again). Bon Voyage.


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\appv2\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\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\sk_mylookandfeel\dvt

 2. Stop and Start the Oracle BI Presentation Services system component using EM or by running:
opmnctl stopproc ias-component=coreapplication_obips1
opmnctl startproc ias-component=coreapplication_obips1

3. Clear the browser cache.




Section 5.2: Editing Settings in OracleBIJavahostComponent

If you installed (and followed instructions) 11.1.1.7.131017 or later, you already have done this part.

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. Stop the server, (including Weblogic)

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

    3. 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).

    4. Start the WebLogic Administration Server (and Managed Server and BI System).

Also see document "OBIEE 11g: How To Improve the Functionality of Exporting Data from Analyses, Dashboards, and other Oracle BI Presentation Catalog Objects into Microsoft Excel with OBIEE 11.1.1.7.131017 and Later (Doc ID 1595671.1)" at Oracle Support Site, about changing the value value="-server -Xmx2048M from value="-server -Xmx1024M in the file config.xml of opmn.

For Oracle Business Intelligence Client Tools only (not the Windows server): Having applied the Oracle BI EE Suite Bundle Patch 11.1.1.7.140415, you must also update each desktop installation of the Oracle Business Intelligence Client Tools (Oracle BI Administration Tool, Job Manager, and Catalog Manager in part 18291015, the 8th part of this bundle patch) 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.

You didn’t do it? You might get OBIEE - NQSError 46036 in BI administration after patching BI Server

No comments:

Post a Comment