How to install and configure ODI standalone agent 11G

In this post we walk through the steps to install the ODI agent .

The definition of “ODI agent” by Oracle is :

“The run-time agent functions as a listener and a scheduler agent”

Below you will see the agent was installed successfully, as we know, the ODI agent in other words is basically a Java service (JVM) and we can set it up to be an operating system service so that whenever the server is restarted for whatever reason the service comes up without somebody having to remember to manually start the ODI agent, as this post is about installing the ODI agent, I intend to create a separate post to show how to setup an ODI agent as an OS service.

Follow the below steps to set the agent, enjoy:

  • Navigate to the ODI installer files :
  • Navigate to “Disk 1”:

  • Run the “executable”:

  • Point to the “JDK” location:

  • Type the above path in the Universal installer prompt :

  • Click “Next”:

Check the “Skip software update” option and click “Next”:

  • Check: “Standalone installation” for the ODI standalone agent:

  • Checking the prereq’s:

  • Point it to a different “oracle home directory” :

  • Choose the second option “Skip Repository Configuration”, remember, we already created the repositories :

  • Now you will need to provide the Agent name: “DEV_AGENT_AY” and port number, you can assign the default port number: 20910 and click “Next

  • Skip the security updates, click ”next” and ”Yes” to ignore the warning:

  • Now you can see a summary of information about the ODI Installation, such as directory details and disk space, you could also save the response file (optional). Click” Install” :

Configuration in progress:

Installation completed, click finish:

-Next step is to bring the agent up so that you can schedule your processes to be run (“Load plans” and “Scenarios”), to do that we first need to create the AGENT in the repository and after that we need to configure a file called “ODI params”, follow the below steps:

  • Log in to “Studio” and go to “Topology”:

  • Right click in the agent and choose “New agent”:

  • Now we need to give a name to the agent, “Attention” the name and port must be exact the same as the ones we assigned when we installed the binaries.
  • Navigate to the below path, this is where the files are located, there, you will be able to see the agent Batch file : C:\oracle\product\11.1.1\Oracle_ODI_2\oracledi\agent\bin

Agent and port:

  • Give those information above to the agent you will create in studio and save it:

  • Now we need to configure the “ODI Params” file, in this step we pass several information about the db schema where the work repository is installed
  • we also need to pass on the ODI supervisor user name and encoded password, just follow the below steps:
  • Navigate to the following path: C:\oracle\product\11.1.1\Oracle_ODI_2\oracledi\agent\bin, and edit the odiparams file, below I highlighted in red the sections we will be editing.
  • First, pass the URL information: hostname, port and db name
  • Second, Pass the schema name
  • Third, open the command prompt and navigate to the above path where the agent is located and encode the Database schema password, just as a good practice take a copy of the “odiparams” file before editing, below are the default values that you will need to chage :
  • I passed the db and host info, in the next step we need to encode 2 passwords, one for Master and another for Super ODI user:
  • To encode the password open your command prompt and go to the path: C:\oracle\product\11.1.1\Oracle_ODI_2\oracledi\agent\bin

Run the following command: encode “password”, in my case “sys”:

  • Copy that encoded password and paste it in the ODI param: “ODI_MASTER_ENCODED_PASS” and save the file:

  • Now we need to encode the SUPERVISOR Password, again, in the same location and same command, you just need to pass the SUPERVISOR password, eg. Encode “SUNOPSIS”:
  • Again, copy that encoded pass and paste it in the “ODI_SUPERVISOR_ENCODED_PASS”, just remember, you need to replace the “example” encoded password with the one you just generated, paste it in the “odiparam” file and save it:

  • Last step is to bring the agent up and running, to do that, again, open the command prompt, navigate to the following location=> C:\oracle\product\11.1.1\Oracle_ODI_2\oracledi\agent\bin

Run the following command: agent.bat -NAME=”DEV_AGENT_AY” -PORT=”20910″

You can create a shell script to automate the startup of the agent or if the agent is created as an OS service it comes back in auto mode:

Agent is up and running:

  • Test the Agent is running ok, log in Studio, go to topology, expand “agents” and click “test”, it should be successful :
  • After that you need to create a logical agent and attach it to the physical agent that we have just created, in order to do that go to the “Logical architecture” , right click “agents” and click ”New logical agent” and create a logical agent:
  • Assign a name to the logical agent and attach the physical agent to it
  • Remember, the Logical Agent is related to physical agents through contexts in this case”global”context

-Reference

You will find several useful information in the link below:                    https://docs.oracle.com/middleware/1221/odi/develop/setup_topology.htm#ODIDG171

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s