Category: BI Administration

Installing OBIEE 11g on Windows XP

I recently installed OBIEE 11g on a Windows XP box.  I followed instructions I found on the deliverbi.blogspot.com Blog site … thank you Shahed Munir.

I would like to add some details to 2 of the steps, in case it helps clarify those steps for others:

 

– The detailed instructions I got from Shahed’s blog can be found here …

http://deliverbi.blogspot.com/2010/11/obiee-11g-windows-xp-installation.html

 

– And the details I would like to add are below …

1. Step 4 (Install Oracle Database 11g). 

Download your Oracle database software to, and run from, a directory without spaces. 

If you get an error such as …

“Windows cannot find ‘C:Documents’. Make sure you typed the name correctly, and then try again. ….”

then you have downloaded and are trying to run the RCU from a directory under ‘C:Documents and Settings…’ (for example)

As mentioned above, download to and install from a directory such as ‘C:Oracle_rcu…’ (no spaces)

2. In Step 7 (Create RCU Repository), it does not specify how to run the RCU.  Go to the [Extract Directory]rcuHomeBin and run rcu.bat from there  -or-  run it from a command prompt …

for example … C:[Extract Directory]rcuHomeBin> rcu.bat

3. If you get an error in Step 7, verify that the following services have been started and try again:

  • OracleServiceORCL
  • OracleOraDb11g_home1ClrAgent
  • OracleOraDb11g_home1TNSListener

The entire install process took about 90 minutes.  Good luck!

Upgrading OBIEE 10g to 11g – Information Sources

I am in the process of planning an OBIEE 10g to 11g upgrade.  As you would expect, finding the appropriate documentation is the first step in the process.  Instead of rehashing what is already out there, this article simply shares some of the resources that I found along the way as I prepared for the upgrade.

Learn more about OBIEE 11g new features.

This link takes you to a “menu” of oracle documentation for Oracle Fusion Middleware Release 1 (11.1.1.6) – the latest release at the time of this writing. This is probably the most comprehensive source for information about this topic.

From the link above, click on “Business Intelligence” in the bottom-left and then locate the various documents – such as “Installation Guide”, “Upgrade Guide”, etc.

Specifically, click here for the System Requirements document; and click here for the Certification document.

I found this presentation by Rittman Mead on “Upgrading from OBIEE 10g to OBIEE 11g” useful – it provided a great overview of what’s involved in the upgrade process.   And another short article by Rittman Mead on “How, Why, Should I Upgrade to OBIEE 11.1.1.6?” added a few tidbits of information.

In this article from the howtobi blog, “Upgrading OBIEE 10g content to 11g”, you will find great step-by-step upgrade instructions.  Another step-by-step article, Upgrading OBIEE10g RPD and Web Catalog to OBIEE 11g, was found on the obieefans blog.

This is an article in Oracle Magazine covering the essentials of the upgrade process.

You may also want to view this tutorial on Oracle Learning Library:   Upgrading Oracle Business Intelligence from 10g to 11g

Although some of the information overlaps from article to article, it’s still a good idea to read various articles to pick up a few different bits of information from each.  I would recommend highlighting or capturing important content from each document, and start putting together a task list/project plan that you continuously enhance as you learn more.

When you are ready, the OBIEE 11g software can be downloaded here.

And to get a preview of what 11g looks like and some of the new features, you can check out these two tutorials on the Oracle Learning Library site:  Creating a Repository using Oracle BI 11g Administration Tool and Creating Analyses and Dashboards 11g

And of course, there is a lot more information out there.

Good luck with your upgrade!