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 22.214.171.124.3 . This is prerequisite and mandatory for OBIEE 11g platform installation .
Step 2: Unzip the content of “ofm_rcu_win32_126.96.36.199.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 .
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 .
The Tablespace creation will be started after that .
Step 9: Finalise and accept the creation of new repository .
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 .