Step 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
Step 2: Unzip the content of “ofm_rcu_win32_11.1.1.3.3_disk1_1of1.zip”.
Step 3: Execute the batch file from the desired location where the content has been already unzipped .
Repository Creation Utility screen pops up …
Step 4: Create the Repository from scratch .
Step 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 .
Step 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 .
Step 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 setup .
Step 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 .
Step 9: Finalise and accept the creation of new repository .
The RCU metadata creation started to target database in target schema and tablespaces .
Step 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 .