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 completewith no errors, click OK to dismiss the screen and proceed to the Select Componentsscreen.
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
Two metadata repositories are required:
1) Extract the RCU .zip file; access the
2) The Welcome screen opens. Click Next
3) In the next screen you can see the two options
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 completewith no errors, click OK to dismiss the screen and proceed to the Select Componentsscreen.
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
- the Metadata Services (MDS)
- And Business Intelligence Platform (BIPLATFORM)
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
4) Provide the database detail where do you want to create the schemas
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 completewith no errors, click OK to dismiss the screen and proceed to the Select Componentsscreen.
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
