RCU Installation For OBIEE 11g

How to create metadata repository using Oracle Repository Creation Utility (RCU).

i.  Description
Find the procedure to create metadata repository using Oracle Repository Creation Utility (RCU) in Procedure Section.

ii. Procedure

1. Download Repository Creation Utility from OTN using below link .It would be found under Additional Software section .Windows 32 Bit version for RCU is 11.1.1.3.3 .This is prerequisite and mandatory for OBIEE 11g platform installation .

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

2. Unzip the content of  “ofm_rcu_win32_11.1.1.3.3_disk1_1of1.zip”.

3. Execute the batch file from the desired location where the content has been already unzipped.

iii. Prerequisites:

Here I am giving the installation steps that how I have installed RCU in my windows 32bit Operating system. If you have 64 bit OS, no worry the steps are same.
• Minimum of 4GB RAM required, 4 GB RAM would work but, system would be
slow.
• Minimum of 10GB hard disk memory required.
• not use any directory name with space while installing/working with Oracle
DB and BI 11g.

Repository Creation Utility screen pops up...

4. Create the Repository from scratch.

5. Specify the Oracle 11g connection parameters and the SYSDBA connection credentials.

It will prompt for pre-requisites check .Click Ok to Proceed . Since I have already installed Oracle 11g DB in AL32UTF8 format hence it will never prompt for non-recommended character set

6. Select the Oracle Business Intelligence Component. This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schema group), which is also required by Oracle Business Intelligence.

7. Specify the password same for below 2 different schemas .Be aware of the current setup related issue with RCU schema password(Seems to be an Oracle Bug) .2 different schema’s having different password or the password having underscore (‘_’) character causing issue while set up OBIEE 11g Fusion Middleware .Hence for the current situation I keep password simple and same for both schema’s as ‘rcu’ .This password will be reused later during OFMW11g set-up.

8. Specify the different Tablespace if required otherwise ignore and proceed 

Click Ok for the below popup to accept creation of new Tablespace.

The Tablespace creation will be started after that.

9. Finalize and accept the creation of new repository.

The RCU metadata creation started to target database in target schema and table spaces.

10. RCU has been created successfully and hence close the window.

The SQL scripts and the installation log can be found in below reference location of the executed batch file.