OBIEE11g RCU (Repository Creation Utility) Installation
If you want to install the OBIEE Server you have to create some schemas in the database which will keep the OBIEE repository. For working, OBIEE needs some schemas to be created. This work is dome automatically by using rcu (Repository Creation Utility).
In order to create the OBIEE schemas with the RCU, you must have installed an Oracle database (11g).
Here is the link for downloading the rcu (Repository Creation Utility):
My Oracle database is installed on Linux 64-bit (Centos 5.4). However the rcu (Repository Creation Utility) is downloaded and run from Windows XP SP3.
Here are the steps in order to create the OBIEE schemas using the RCU (Repository Creation Utility):
1. Download the rcu from oracle (link: http://www.oracle.com/technetwork/middleware/downloads/fmw-11-download-092893.html )
You must unzip the file and put it in a easy to access folder. We can consider this folder as an Oracle Home (rcu Home). In my case this is C:\rcuHome
2. Run the rcu (Repository Creation Utility):
cd C:\rcuHome\BIN
rcu.bat
Create OBIEE schemas with RCU : start RCU
The following screen will appear:
Create OBIEE schemas with RCU : Create repository
3. Choose "Create and load component schemas into a database." and press "Next".
The following screen will appear:
Create OBIEE schemas with RCU : Database Connection Details
In this screen the host name "linux" is the host name I have in the "hosts" file.
4. Choose the database connection details and after that click on "Next" button.
The following screen will appear:
Create OBIEE schemas with RCU : Checking Prerequisites
Click on "OK".
The following screen will appear:
Create OBIEE schemas with RCU : Select Components
5. Choose "Business Intelligence Platform" and let the prefix be "DEV" (if you want you can change it).
"Metadata Services" will be checked if no AS Common Schemas is installed. Click on "Next".
The following screen will appear:
Create OBIEE schemas with RCU : Checking Prerequisites
Click on "OK".
The following screen will appear:
Create OBIEE schemas with RCU : Schema passwords
6. Choose the password for the DEV_MDS and DEV_BIPLATFORM (in my case I choose "ptest" ).
Click on "Next". The following screen will appear:
Create OBIEE schemas with RCU : Map tablespaces
7. Choose the tablespace names for the DEV_MDS and DEV_BIPLATFORM schemas.
If you want you can modify some tablespace propreties.
Click on "Next". The following screen will appear:
Create OBIEE schemas with RCU : Summary
8. Click on "Create" in order to create the needed schemas (DEV_MDS and DEV_BIPLATFORM) and their tablespaces.
The following screen will appear:
Create OBIEE schemas with RCU : Create
When the schemas/ tablespaces are created the following screen will appear:
Create OBIEE schemas with RCU : Completion Summary
Click on "Close" and all the stuff is done. Now you are ready to install the OBIEE Server.
