Repository Creation Utility(RCU)

Two metadata repositories are required:

•    the Metadata Services (MDS)
•     And Business Intelligence Platform (BIPLATFORM)

To create the Oracle Business Intelligence schemas using RCU:

1) Extract the RCU .zip file; access the bin directory in the RCU_HOME. Run the rcu.bat for windows  environment or run the. /rcu for UNIX environment.
2) The Welcome screen opens. Click Next 
3) In the next screen you can see the two options

• Create: Create and load component schemas in to database
• Drop: Remove the component schemas from database 

    Select Create Radio button and click on next
4)  Provide the database detail where do you want to create the schemas

   Host Name: Name or ip of database server
   Port: it is by default 1521 provided by oracle for oracle database
   Services Name: Check the service name of your database in tnsname file and give it to service name field.
   User name & Password: provide the User name & Password which has dba privileges.
   Role: select Role depends upon the user you have given.
Click Next. The Checking Prerequisites screen opens. After the checking is complete with no errors, click OK to dismiss the screen and proceed to the Select Components screen.
5) Component Detail ->Select the Oracle Business Intelligence Component. This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schemas group), which is also required by Oracle Business Intelligence. 

6) Schema Passwords -> Use Same Password for all schemas

  
















7) Map Table space

8) After the schemas are created with no errors, the Completion Summary screen opens.
9) In the Completion Summary screen, click Close.
Congratulation!!! Now you have metadata schema required fro OBIEE installation. Click here to check how to install OBIEE11g.

Reference:
http://docs.oracle.com/cd/E21764_01/bi.1111/e10539/c3_requrmnts.htm