Repository Creation Utility - OBIEE 11g

RCU is the short name and is basically used to create the database schema for Fusion Middleware 11g.

The first screen welcomes you !!!

This screen provides an option to create or drop the FMW schema. Here I have selected Create option so that I can create the schema for OBIEE.

This screen helps to specify the database and its details where the repository will be created. It also provides an option to install the repository on a RAC database.

Next the RCU validates the database. Here I got a warning message that the database is not AL32UTF8 character set. I have opted to ignore but it is recommended to create the database with the AL32UTF8 character set.

The below screen lists a successful pre-check.

Next I have given a Prefix and also selected "Business Intelligence Platform" , automatically the dependencies are selected.

Prerequisites relevant to BI are checked and verified in the below screen.

Here we have to input the password for the schemas , I have opted a common password.

Review screen for the tablespaces.

The below screen show that the tablespaces are created and validated.

With all the inputs provided summary page is displayed. After verifying it by clicking the create button the necessary schema will be created in the target database.

Information of the successful creation of repository for OBIEE.

Looks good , RCU was simple and good to me.

The next tasks would be to Install OBIEE.

OBIEE 11g Getting Started

After a long gap I am looking into OBIEE 11g. After completing Datacenter Migration Project and Database 11g Upgrade Project, I am now set to go for Fusion Middleware 11g Upgrade early next year.

But this December it is OBIEE 11g.
Early this year I created a OBIEE 10g Environment with BI Publisher 10g. But I see that there has been a lot(a lot) of enhancement done with OBIEE 11g.

As a preparation I created the Database that is required for the Repository. In OBIEE 11g we have to build a repository. I am building it on a 11g R1 database. I made a Oracle Home Cloning and created a database on it.

Oracle Home cloning is pretty simple.

1. Copy a healthy Oracle Home

2. Source the environment variables

3. Run the clone scripts

perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE=$ORACLE_BASE ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=test11_1

In three simple steps the Oracle Home is Ready and now it is the time for DBCA to take care of the rest in creating the database.

Between I have downloaded the following

- Repository Creation Utility.

- Softwares necessary for OBIEE 11g.

You can find more details here (this link might change in the future )

Will keep posting on the developments.