Pages

Tuesday 3 September 2013

RCU(Repository Creation Utility) Installation Steps for OBIEE 11g

Now we are going to install RCU(Repository Creation Utility) BIplatform & Metadata schema in oracle database. We can download RCU and BI 11g software from the below link:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html
Please make sure all the zipped files have downloaded correctly and unzipped into a single folder.
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: ORCL
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.

In the next step Enter password for both the schema as you like with the password conditions (such as alphabet, numeric and with special character) and click 'Next' to continue.

Click 'Next' with the above step to have RCU create the selected schemas.

Click 'OK' to continue creation of tablespace.

Once tablespace created, click 'OK' to continue.

Now RCU will create required schema objects within the tablespace just created. So Click 'Create' with next step and continue

Click 'close' to finish RCU wizard once schemas are created successfully & the the installation of RCU is completed.

Note:Remember the password which we have given for all the users/schemas so far and we will continue to use the same password. We will need this password for BI installation as well to let BI installer knows where the metadata schemas located and what is the password to connect to the schema. Now we can login to the oracle database and can whether that two schems (DEV_BIPLATFORM, DEV_MDS) is available.

1 comment:

  1. I would highly recommend Mr, Benjamin services to any person in need financial help and they will keep you on top of high directories for any further needs. Once again I commend yourself and your staff for extraordinary service and customer service, as this is a great asset to your company and a pleasant experience to customers such as myself. Wishing you all the best for the future.Mr, Benjamin is best way to get an easy loan,here is there email.. / 247officedept@gmail.com     Or talk to Mr Benjamin On WhatsApp Via_+1-989-394-3740 Thank You for helping me with loan once again in my sincerely heart I'm forever grateful.

    ReplyDelete