Upgrading OBIEE to 11.1.1.7

OBIEE 11.1.1.7 was released earlier this week, and brings with it the usual delights and challenges of the Fusion Middleware (FMW) platform. Because OBIEE is part of Fusion Middleware, and because it is made up of OBIEE-specific components (such as the BI Server) and FMW-generic components (such as Web Logic domains), the upgrade documentation isn’t quite so simple as it could be in a standalone product.

There are two options for upgrading to OBIEE 11.1.1.7 from an earlier release of 11g:

  1. Out-of-Place”, which in the olden days of software was called “reinstallation”. A brand new copy of OBIEE is installed, and the relevant configuration files (RPD, web cat, and so on) are migrated to the new installation, and then the old one decommissioned.
  2. In-Place” - OBIEE is upgraded where it resides, and what was a 11.1.1.6 (or .3 or .5) OBIEE then becomes 11.1.1.7. In-place upgrade is not possible if you installed OBI using the Simple Install option

There are pros and cons to each approach, including:

  1. In-place upgrade are big bang, where as out-of-place lets you migrate in a phased manner if you want to. Depending on the scale of the changes in the upgrade, or the amount of regression testing you want to do, this may be a factor
  2. In 11.1.1.3 -> 11.1.1.5 -> 11.1.1.6, the in-place upgrade was complex and infamous for being buggy. From what I’ve seen of two separate in-place 11.1.1.6 -> 11.1.1.7 upgrades it is simple to do and with no problems discovered yet.
  3. An out of-place upgrade is ‘safer’ because you are just doing a reinstallation. When you do an in-place upgrade you are trusting the tools to not fail and/or damage your current installation. The counter argument to this is that you should always have backups, and in doing an out-of-place upgrade you may yourself make mistakes or have trouble migrating content

Christian Screen wrote about the advantages of an out of place upgrade, but I think some of these could be less relevant now. Given the simplicity of the in-place upgrade, out-of-place strikes me as more complex and risky.

Getting started

Take a full backup of your OBIEE installation. You do take backups, right? If not, now is a very good time to start, upgrade or not. See the backup documentation, here

Next, regardless of upgrade method, you need to download the complete OBIEE 11.1.1.7 installers for your platform, from here

Out-of-place upgrade

The installation process for 11.1.1.7 is identical to previous versions (except you now have the option to install Essbase too).

Once you have installed 11.1.1.7, you migrate your RPD, web catalog, security configuration and component configuration over from your existing installation. You also need to think if you want to keep any of your RCU table content (Usage Tracking, Event Polling, etc), and manually migrate this, watching out for if the RCU table definitions have changed.

In-place upgrade

An in-place upgrade will upgrade your existing 11g (whether 11.1.1.3, 11.1.1.5, or 11.1.1.6) to 11.1.1.7. It is documented here: Moving from 11.1.1.3, 11.1.1.5, or 11.1.1.6 to 11.1.1.7.

In-place upgrade is not possible if you installed OBI using the Simple Install option

I have tested it on Linux and Windows, from both 11.1.1.6.2 BP1 and 11.1.1.6.9, to 11.1.1.7.
Be aware that previous in-place upgrades (11.1.1.3 -> 11.1.1.5 -> 11.1.1.6) had issues, and I have not tested in-place upgrading 11.1.1.3/11.1.1.5 -> 11.1.1.7.

The outline of an in-place upgrade is as follows:

  1. Do a Software Only Install of 11.1.1.7, into the existing installation
  2. Run the Patch Set Assistant to update the RCU schemas for 11.1.1.7
  3. Run the Configuration Assistant to update the BI domain

This can be done using the GUI tools, or scripted using response files.

In-place upgrade using the GUI, step by step

  1. Shutdown the BI stack (WLS Admin Server, Managed Server, Node Manager, OPMN)
  2. Run 11.1.1.7 installer (runInstaller on Linux or setup.exe on Windows)
    1. Select Software Only Install
    2. Specify the existing FMW_HOME (this should be pre-populated in the OUI installer screen)
    3. Click Next through the following screens, until the installation begins.
  3. Run the Patch Set Assistant (PSA). This is located in oracle_common/bin/ and is called psa on Linux or psa.cmd on Windows
    1. Under Available upgrades select Oracle Business Intelligence
    2. Before running the PSA you should make sure you’ve got a valid database backup (just as you should for the whole BI stack). You are given checkbox to tick to confirm you’ve taken the backup.
    3. Enter the details of the database where your existing RCU tables reside, along with a DBA-privileged user. When specifying DB credentials, note that it is different from the RCU screens - if connecting as SYSDBA you must enter SYSDBA AS DBA (as you would if connecting from sqlplus etc)Click Connect. The PSA then brings back a list of RCU schemas; select the MDS one
    4. Complete the following screen for the BIPLATFORM schema, and continue through the PSA. Click Upgrade.
  4. Start Node Manager
    1. On Windows, this is a service
    2. On Linux, go to your FMW home and run ./wlserver_10.3/server/bin/startNodeManager.sh
  5. Start the Web Logic Administration Server (AdminServer)
    1. On Windows, go to your FMW home folder and then double click on user_projects\domains\bifoundation_domain\bin\startWebLogic.cmd
    2. On Linux, go to your FMW home and run ./user_projects/domains/bifoundation_domain/bin/startWebLogic.sh
    Wait until the Admin Server is running - you should be able to login to the WLS Console at http://<yourhost>:7001/console, and the Admin Server command window will show Server started in RUNNING mode
  6. Run the Configuration Assistant
    1. The script is in the Oracle_BI1\bin folder
      1. On Windows, go to your FMW home folder and then double click on Oracle_BI1\bin\config.bat
      2. On Linux, go to your FMW home and run ./Oracle_BI1/bin/config.sh
    2. Select Update BI Domain and then enter the details of your domain. Note on Windows, if you are using a loopback adaptor (which you should on a DHCP host such as often found on a VM) make sure the hostname that you specify is the one you have in your hosts file for the loopback IP.
  7. The Configuration Assistant will [re]start AdminServer, the managed server, and OPMN components.
  8. Flush your browser cache, and then login to OBIEE and enjoy the new version number and the sloping tabs of Fusion skin

Command-line / “Silent” in-place upgrade

The three utilities that are run to do an in-place upgrade can all be run from the commandline only, using response files to specify the values and actions.

To create a response file, you can run the utility in GUI mode and then choose the Save option on the summary screen. You can also take an existing response file and modify it to suit your target environment.

Passwords in response files

When you create a response file from the GUI, passwords are not saved in clear text.

  • In the Patch Set Assistant response file passwords are saved encrypted, so if you don’t need to change them you can leave this file unmodified. Alternatively, you can change encrypted for cleartext:
    MDS.encryptedSchemaPassword = 0562A61E90282BD7CE8DDA04D618E53960D533DC3903301F63
    MDS.encryptedDbaPassword = 05115EE31A473F46DFCB9FB23C99C3A348DD8D3D2C4FBA68BF
    
    would become
    MDS.cleartextSchemaPassword = Password01
    MDS.cleartextDbaPassword = Password01
    
    And do the same for the BIPLATFORM schema and DBA passwords in the file
  • For the Configuration Assistant response file you need to replace all instances of <SECURE VALUE> with the actual password

Step by step silent in-place upgrade

  1. Shutdown the BI stack (WLS Admin Server, Managed Server, Node Manager, OPMN)
  2. Run the Software Only install of 11.1.1.7
    cd bishiphome\Disk1\
    setup.exe -silent -responsefile c:\response_files\1_swonly.rsp
    
  3. Run the Patch Set Assistant
    cd $FMW_HOME\oracle_common\bin\
    psa.bat -response c:\response_files\2_psa.rsp
    
  4. Start Node Manager
  5. Start AdminServer
    cd $FMW_HOME\user_projects\domains\bifoundation_domain\bin\
    startWebLogic.cmd 
    
    Wait until the Admin Server is running - you should be able to login to the WLS Console at http://<yourhost>:7001/console, and the Admin Server command window will show Server started in RUNNING mode
  6. Run the Configuration Assistant script.
    cd $FMW_HOME\Oracle_BI1\bin\
    config.bat -waitforcompletion -silent -responseFile c:\response_files\3_config_ass.rsp
    
    The -waitforcompletion is optional but useful on Windows as it stops the cmd window which you launch the script from disappearing

You can download the response files used from here, or generate them yourself using the utilities in GUI mode.

In-place upgrade of a scaled-out BI domain

If you have a scaled-out (horizontal cluster) BI domain, the in-place upgrade is simple for the additional nodes. Since the domain and RCU upgrades are handled by the Configuration Assistant and Patch Set Assistant respectively, you just need to update the binaries, using the Software Only Install

On each additional node:

  1. Shutdown all WLS, OPMN
  2. Run 11.1.1.7 installer
    1. Select Software Only Install
    2. Specify existing FMW_HOME (should be pre-populated in OUI)
    3. Takes c.10 minutes
  3. Start up Managed Server, and OPMN
  4. That’s it

Known issues

Common Header no longer visible

If you don't flush your browser cache then you can expect to see the header missing from OBIEE :

Flush your browser cache and then refresh / relogin, and it should display correctly:

INST–08112

Error: INST-08112: The Admin Server is listening on multiple network interfaces and the default listening address 192.168.248.160 cannot be accessed from the scale out host

Diagnostics: Windows machine has loopback (10.10.10.10) plus a NAT NIC (IP 192.168.248.160)

Resolution: In WLS console, set the Listen Address for the Admin Server to 10.10.10.10

Known issues from the release notes

These are currently listed in the release notes and are related to in-place upgrades: