Pages

Friday 5 April 2013

OBIEE 11.1.1.7 Upgrade

I have just upgraded a test server from OBIEE 11.1.1.6.2 BP1 to the latest and greatest version 11.1.1.7

After past experiences of upgrade I was half expecting to have no nails left and be pulling my hair out, but this time it went right.

Note: If you are running a simple install, ie. everything runs from port 7001, this whole process will not work for you, and at some stage in the next week or two I'll document exactly what you have to do.

This is for the Enterprise Install only.

Software Only Installer

1. Shut down all BI processes, OPMN and node manager.
2. Run the installer and choose Software only install.
    The installer will do a few checks.
    Find the default middleware home
    Find the weblogic install
    and finally start the install.

So that is fairly painless and in about 20 minutes or so you have updated binaries.

Patch Set Assistant

1. Navigate to {middleware home}/oracle_common/bin directory
2. Run psa.bat
3. Select the component to upgrade. (Oracle Business Intelligence)
4. Then, much like most of the GUI installers, fill in the connection details of the MDS and BIPLATFORM schemas.
5. Once you verify you have backed up and are running an appropriate version of the database
6. You are asked to upgrade.

Start Weblogic

Now start the Node Manager Service 
and, navigate to {middleware_home}\user_projects\domains\bifoundation_domain\bin
and run startWebLogic.cmd
When the server is in the running state

Configuration Assistant

1. Start the configuration assistant
   {middleware_home}\Oracle_BI1\bin and run config.bat
2. Select the upgrade option
3. Fill in the details to connect to the admin server (usually 7001)
4. And off it goes.

The configuration assistant will do stopping and starting of all the appropriate services at various times and leave you with a updated OBIEE 11.1.1.7 

Compared to the previous updates this was easy, but be warned, updating a simple install means that you have to do all the steps covered by the configuration assistant manually.

I'm just getting to grips with the new features and visualisations, and hope to bring you more over the coming weeks.

Update
Here are the manual steps for upgrading a simple install. Please keep me informed of any issues you encounter.

3 comments:

  1. Any luck on coming up with a process/instructions for the Simple Install?

    ReplyDelete
  2. hi in enterprise installation i'm upgrading from 11.1.1.6.2 to 11.1.1.7.0it got failed in Configuration progress while configuring the start managed bi_server1..can u suggest us..

    ReplyDelete
  3. Hi i'm upgrading obiee 11.1.1.6.2 to 11.1.1.7.0, but it was failed at Configuration Assistant..while starting managed bi_server1 can u suggest us...

    ReplyDelete