Wednesday, April 2, 2014

OBIEE 11.1.1.6.0 RCU Installation



OBIEE 11.1.1.6.0 RCU Installation

BI 11g is now standardized with Oracle fusion middleware and hence leverage database for metadata storage just like any other middleware product. So here we are going to install BI11g metadata schema on oracle database you just installed and configured. Same process can be leveraged to install metadata schema on other supported databases as well.
If you have not done already, please download BI11g installation files and RCU installation files. Please make sure all the zipped files have downloaded correctly and unzipped into a single folder.
We can download the software from below Download page:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html


Now we will start the installation of metadata schema using RCU.

From unzipped folder for RCU, run rcu.bat file to start the utility: rcu.bat file is located under rcuHome\BIN directory.



RCU utility will launch the GUI based wizard to guide you through the steps. Click Next to continue.

Select create from the below screen and click Next
 


In the below step Make sure database type is Oracle Database and enter following information to continue. 
For e.g:
Host Name: localhost 
Port: 1521 
Service Name: XE
Username: sys
Role: sysdba
Password:  manager
 

since we are using oracle database, RCU will show a warning message that we can just ignore and can continue the installation.
 

Click OK to continue once RCU validates and initializes database configuration.
 

In the next step it will ask for the prefix to create the metadata schemas. By default it is showing 'DEV'. If we want to change the prefix we can  change it.
From the below window select appropriate schemas which we need to install.
I have selected only two which is showing in the screenshot.

Click 'Next' from the above screen to create schema and the click 'OK' once RCU shows schema creation prerequisites check completed.

No comments:

Post a Comment

Data engineering Interview Questions

1)  What all challenges you have faced and how did you overcome from it? Ans:- Challenges Faced and Overcome As a hypothetical Spark develop...