Creation of Master and Work Repository in ODI 12C & ODI 11g

Below are the steps to be followed to create master and work repository in ODI 11g and ODI 12c.

Create user ODIMR and give connect and resource privilege 

Open ODI and go to Master Repository creation wizard - Give all the DB credentials as mentioned below

Create Master Repository Creation Wizard - Authenticate with SPERVISOR user.

Click Finish

You master repository creation was successful and it will show as below.

to to New Gallery and click on Create a new ODI repository login

Give the Database details as follows and test the connection 

Go to topology and right click the work repository and create new work repository 

click on test connections

Give Yes and proceed further

Give your default password

Give Yes

Create Login name

Login to ODI

Congrats!! You have configured ODI Master and work repository.