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