Search This Blog

Thursday 9 January 2014

ODI Master and Work Repository Creation Using RCU (OBIEE 11g)

Oracle Data Integrator (ODI) Installation steps are now more easy with Repository Creation Utility (RCU). Double click RCU.bat from the downloaded and unzipped RCU Folder.

Oracle Universal Installer checks prerequisites and system requirements and will load the first step of the installation. Just click 'Next' with the Below Screen
Select 'Create' and click 'Next' with this screen.
In this step, type all the necessary details in the required fields and click 'Next' with this step

Database Type: Oracle Database
Host Name: Bose-PC
Port: 1521
Service Name: ORCL
UserName: sys
Password: Password1
This step will check the prerequisites. Just click 'OK' once the prerequisites passes
In this step check 'Oracle Data Integrator' Component. Type if you want to change the prefix and repository name.
Once we clicked 'Next' with the above screen It will check prerequisites and click 'OK' with the below screen
Give the password which you want to give for ODI Work and Master repositories. If you want to give different password, select the appropriate option and click 'Next'
This step is an important step so Please keep in your mind or store somewhere all the credentials and details in a file which you are entering here and then click 'Next'

Master Repository ID(001): 001
Supervisor Password: Admin123
Confirm Supervisor Password: Admin123
Work Repository Type: D
Work Repository ID: 101
Work Repository Name: WORKREP01
Work Repository Password: Admin123
Confirm Work Repository Password: Admin123

This step will gives the information of ODI Schema name, schema owner and temporary tablespace name. Just Click 'Next' with this step
In this confirmation pop-up, Just click 'OK'
This will create the tablespace and click 'OK' once the steps passes
In this step, click 'Create'
so ODI Schema creation is completed with the above step. Just click 'Close' to complete the repository creation.
In the next coming post, we will continue to the ODI Installation using this ODI repositories.



  1. Hi can you please tell me why should I use repository in Oracle Bi Publisher or what is the use of it?? Thanks in advance

  2. Wonderful piece you got here , I feel quite happy after I read your Article because I found out that we still have intelligent informative researchers who can still take time out of their busy schedule to put all this together I will instantly grab your rss feed to stay informed of any updates you make and as well take the advantage to share some latest information about. credit card hack software

  3. Loved it. Very helpful article… Going to submit a link to My blog to every single directory. Thank you for sharing.

    Active Directory Training
    SAP Fico Corporate Training In India
    SAP Security Best Training in Hyderabad
    Oracle Certification Course


What is Oracle Database Link and How to create database link (DB Link)

Recent Posts