OBIEE 11.1.1.7 to 11.1.1.9 upgrade
OBIEE 11.1.1.9 was released on May 15, 2015 and has a few interesting new features. It is the first (and possibly the last) major release in the last couple of years. From my point of view, it isn't a revolution but evolution of the 11.1.1.7.x branch.
It's very easy to upgrade existing 11.1.1.7.x instance to 11.1.1.9.0 and involves the following steps:
- Download OBIEE 11.1.1.9.0 distributive
- Determine currently used Weblogic server release
- Download Weblogic 10.3.6 upgrade installer [optional]
- Upgrade Weblogic to 10.3.6 [optional]
- Upgrade OBIEE software
- Upgrade database repository (MDS and BIPLATFORM)
- Upgrade various system components
Download OBIEE 11.1.1.9.0 distributive
OBIEE 11.1.1.9.0 does not need a separate distributive for the upgrade process. The same distributive is used for the installation of a new system or patching an existing one. At the time of this post, distributive is available only at OTN. Download all the files for your platform, copy to a server and unzip to one directory.
.png)
Determine currently used Weblogic server release
Typically when you install OBIEE 11.1.1.6 or 11.1.1.7 it comes prepackaged with Weblogic server 10.3.5. The only supported for OBIEE 11.1.1.9.0 version of Weblogic is 10.3.6. You need to check for (or remember) a currently installed version of Weblogic server. To do it, open //yourserver:port/console (default port is 7001) and check Weblogic version. If it is 10.3.6 then skip the next step and navigate to "Upgrade OBIEE software". If your Weblogic version is 10.3.5 go to the next step.
Download Weblogic 10.3.6 upgrade installer
For upgrading Weblogic server 10.3.5 to 10.3.6 you need to download Weblogic upgrade installer from My Oracle Support. The easiest way is to search by patch number: 13529623. For most of the platforms, you will find a generic patch (not platform-specific).
Upgrade Weblogic to 10.3.6
Upgrading of Weblogic is quite simple and takes only a couple of minutes.
Stop all OBIEE components. You may use scripts from my post if you want to.
Copy Weblogic upgrade distributive to a server and unzip it.
There are only two files in the archive. One of them is a readme.html and the other one is the installer. Run the installer with command:
java -jar wls1036_upgrade_generic.jarNote. This installer can work either in graphical or text mode. The upgrade process is pretty straightforward and doesn't need much commenting. Just follow the process and select the desired option by typing its number.
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
Upgrade OBIEE software
Upgrading of an OBIEE software is made by the usual installer without any special options or something like that. Simply run runInstaller (for Unix) or setup.exe (for Windows). Note. OBIEE installer has only a graphical mode so you need to setup X11 forward before you start. All steps should be familiar for you as they are exactly the same as during installation process of the previous release..png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
Upgrade database repository (MDS and BIPLATFORM)
There are a couple things left before you start newly patched system. You need to upgrade database repository schemas. Change directory to $ORACLE_HOME/bin and run psa (psa.bat) utility. It's Patch Set Assistant and it'll do repository upgrade part of the task..png)
.png)
/u01/oracle/Middleware/Oracle_BI1/bin/../../oracle_common/bin/psa: line 167: /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.79.x86_64/bin/java: No such file or directoryThe easy way to solve this problem is to install java-1.7.0-openjdk-devel.x86_64 package.
yum install java-1.7.0-openjdk-devel.x86_64
Upgrade various system components
It's possible to do this manually or by Configuration Assistant. Using Configuration Assistant is much easier and faster. This guide shows how to use Configuration Assistant.
Note. I haven't found it in the documentation or at MOS, but on my system Configuration Assistant freezes at "Executing: opmnctl startall" step. Log file shows libnuma.so.1 related error (error while loading shared libraries: libnuma.so.1: cannot open shared object file). This error could be solved by installing numactl package.
Before running Configuration Assistant Node manager and AdminServer should be started. If not, process will freeze at Starting Managed Server: biserver1 step.
The rest is pretty obvious.
Change directory to $ORACLEHOME/bin. Run config.sh and follow the wizard.
Select Upgrade BI Domain option and fill in required fields.
Note. It's possible you'll need to interrupt the process because of this or that (numactl error or anything else). After starting Configuration Assistant, you may stuck at the third step (AdminServer credentials) without any error. Just nothing happens. Step 5 of this document will help you Troubleshooting.
Now it's time to start your system.
Everythyng is ok for me.
Version is 11.1.1.9.0.
The last thing left to be done. Go to Administration page and select Scan and Update Catalog Objects That Require Updates option.
Select Update Catalog Objects
Wait for a few seconds...
Start exploring OBIEE 11.1.1.9.0 new features.
Have a nice day!
I'm doing my best to provide as detailed and simple guide as I can. But sometimes I can fail. So, don't hesitate to leave a comment, ask a question, say if everything is understandable or not. No registration is required for commenting.
troubleshooting oracle obiee 11.1.1.9 patch

Andrew Fomin
OBIEE specialist since 2007 and Oracle Discoverer before. DWH architect, BI enthusiast, blogger. Lazy cats owner. All opinions are my own and not the views of my employer.