Creating Repositories Using RCU in ODI12c

·        Starting the Repository Creation Utility

a)     Navigate to Oracle_home/oracle_common/bin

·        Start RCU:

On UNIX Operating System:

./rcu

On Windows Operating System:

rcu.bat

1.1.                     Navigating Screens

1.1.1.  Introducing RCU – Click Next

1.1.2.  Creating Repository

1.1.2.1.      System load and Product load - If you have the necessary permission and privileges to perform DBA activities on your database

1.1.2.2.      Prepare Scripts for System Load - If you do not have the necessary permission or privileges to perform DBA activities in the database

1.1.2.3.      Perform Product Load – System load scripts have been run by DBA

1.1.3.  Connection Details – Provide DBA privileges

1.1.4.  Select Component – Oracle Data Integrator

1.1.5.  Schema Password – Password for Schemas (Note it down)

1.1.6.  Custom Variables –  Below details need to specify

1.1.6.1.      Supervisor Password – Note it down used for when we are connecting to Repositories from ODI

1.1.6.2.      Confirm Supervisor Password – Re-enter the password which you mentioned above

1.1.6.3.      Work Repository type – D or I

1.1.6.3.1.           D- Development Work Repository where all our development can be done

1.1.6.3.2.           I – Execution Work Repository where we can’t do any development (for example : In production environment we shouldn’t do development)

1.1.6.4.      Work Repository Name – Mention the name of Work Repository

1.1.6.5.      Work Repository Password – Mention the password of Work Repo

1.1.6.6.      Confirm Work Repository Password – Re-enter the earlier entered password

1.1.7.  Map Tablespaces – Nothing to do , defaults are fine

1.1.8.  Summary Page – Cross check and say create