In Oracle : Create OBIEE schemas with RCU (Repository Creation Utility)

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Business Intelligence (BI)

-> Create OBIEE schemas with RCU (Repository Creation Utility)

 

 Create OBIEE schemas with RCU

 

 

   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):

    http://www.oracle.com/technetwork/middleware/downloads/fmw-11-download-092893.html

 

   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

    Create OBIEE schemas with RCU : start RCU

 

    The following screen will appear:

    Create OBIEE schemas with RCU : Create repository

    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

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

Create OBIEE schemas with RCU : Checking Prerequisites

 

Click on "OK".

The following screen will appear:

Create OBIEE schemas with RCU : Select Components

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

Create OBIEE schemas with RCU : Checking Prerequisites

 

Click on "OK".

The following screen will appear:

Create OBIEE schemas with RCU : Schema passwords

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

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

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

Create OBIEE schemas with RCU : Create

 

When the schemas/ tablespaces are created the following screen will appear:

Create OBIEE schemas with RCU : Completion Summary

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.

 

 

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Business Intelligence (BI)

-> Create OBIEE schemas with RCU (Repository Creation Utility)

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.