Hi all,
While installing Oracle Data Integrator 11g it will ask for MASTER and WORK repositories, for that we have two options:
Note: Repositories are nothing but schema where the odi work information and data is stored.
1. Create Repositories using the RCU utility
2. Creating Repositories manually through Command line.
Today we shall see how to create the repositories using the RCU utility.
Follow the below steps:
1. Navigate to the rcu.bat file, and double click to execute.
2. Utility window will open with Welcome page, click on Create Repository tab and select Create radio button. Click Next.
7. Confirm the Schema details and click Next.
8. Click Next and OK to confirm.
9. Confirm the summary details and click Create to create the repositories.
10. Check the completion summary and close the window.
11. Congratulations!! You have created the repositories required by ODI installation.
While installing Oracle Data Integrator 11g it will ask for MASTER and WORK repositories, for that we have two options:
Note: Repositories are nothing but schema where the odi work information and data is stored.
1. Create Repositories using the RCU utility
2. Creating Repositories manually through Command line.
Today we shall see how to create the repositories using the RCU utility.
Follow the below steps:
1. Navigate to the rcu.bat file, and double click to execute.
2. Utility window will open with Welcome page, click on Create Repository tab and select Create radio button. Click Next.
3. In this tab, select the parameters such as Database Type, Host-name, Port, Service Name, Database System user having DBA privileges and password, Select the Role as SYSDBA and Click on Next.
4. Select the components required by ODI as shown and click Next:
5. Provide any password for the schema which will be generated by rcu, here "password" and click Next.
6. Provide the Repository Names and Passwords you want to assign as shown and click Next:
