Wednesday 15 May 2013

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.

"System Requirements and Specifications”....

Do you have plane to install obiee11g? Then check first whether you system hardware and operating system fulfils the “System Requirements and Specifications” provided by oracle. You can view the System Requirements and Specifications on link



If your system fulfils the Requirements and Specifications provided by Oracle then check further detail OBIEE11G Installation.

No comments:

Post a Comment