4. Descripció de la solució
4.2. Solució tècnica
4.2.2. Gestió de les interrupcions
John is responsible for data loading, transformation, and validation. He created Master and Work Repositories. Now he continues setting up his ODI environment by installing an ODI Agent.
Background:
A common task in ODI is to set up and install an ODI Agent as a service. After the ODI
scenarios are created, they can be scheduled and orchestrated by using an ODI Agent, which is a lightweight Java process that orchestrates the execution of ODI scenarios. In this practice, you create and execute an ODI Agent, which will be used in subsequent practices for
orchestration of the execution of ODI objects.
First, you run encode <password> to generate an encrypted password.
You copy and paste that string into the odiparams.bat file that contains ODI agent parameters.
You then switch to ODI, and define a physical agent named localagent. Next, you define a logical agent also named localagent, mapping it to the same-named physical agent. You specify the Global context as the context in which to make this particular mapping of logical to physical agents.
In the command window, you execute agent.bat to start the agent that you named localagent.
In ODI, you test a connection to your newly created agent.
The directions on the following pages will take you through these activities:
1. Run encode oracle1 to generate an encrypted password string 2. Edit odiparams.bat, inserting the encrypted password
3. In ODI, define a physical agent named localagent
4. In ODI, define a logical agent named localagent, mapping it to the physical agent named localagent for the Global context
5. Execute agent.bat to start an agent named localagent.
6. Verify connection to the newly created agent localagent in ODI
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2014, Oracle and/or its affiliatesฺ
Your Tasks:
1. Before executing the agent.bat file to create the ODI Agent, you must run the encode password command to generate an encrypted password and paste it into the
odiparams.bat parameter file. To do so, perform the following steps:
Step Screen/Page Description
Choices or Values a. MS Windows and
text editor
Open the Windows Explorer, and navigate to the ODI_HOME directory, where ODI is installed and open the agent\bin subdirectory:
(C:\oracle\Middleware\Oracle_ODI1\oracledi\agen t\bin). Navigate to the odiparams.bat file, right-click this file, and select Edit to open it with a text editor. Leave this editor open. You will run a batch file from a Command window and return to this text editor to copy the results into the
odiparams.bat file.
Explanation: You need to edit the odiparams.bat file to set the repository connection information for the ODI Agent to use.
The password information is stored as an encrypted string. You will generate the encrypted string in a Command window.
b. Command Prompt Leave the text editor open, and open the Command window (Start > Run > cmd). Change the directory to the
ODI_HOME\agent\bin directory:
C:\oracle\Middleware\Oracle_ODI1\oracledi\agent
\bin
c. Command Prompt To generate the encrypted password string, you will be using the agent command, encode <password>. Because your password is “oracle1”, enter and execute the following command in the Command window and press ENTER:
encode oracle1
Note: Keep the Command window open, because you will be returning to it after editing the odiparams.bat file.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable
license to use this Student Guideฺ
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Practices for Lesson 3: ODI Topology Concepts
d. Command Prompt and text editor
Copy the generated, encrypted password from the Command window (from the Command window’s drop-down menu, select Edit > Mark, then highlight the password with your mouse; then select Edit > Copy) and insert it into the odiparams.bat file as the value for the ODI_MASTER_ENCODED_PASS parameter (overwriting the existing password). Verify and, if necessary, edit settings for other parameters from the following table, save the odiparams.bat file, and then close it. The agent’s
connectivity is now set up.
Parameter Value
Insert your encoded password.
(overwrite the existing password)
ODI_SECU_WORK_REP WORKREP
ODI_SUPRVISOR_ENC
ODED_PASS Leave the default value.
ODI_USER Leave the default value.
ODI_ENCODED_PASS Leave the default value.
ODI_JAVA_HOME c:\oracle\Middleware\jdk160_29 Note
• DEV_ODI_REPO is an RDBMS schema/user (Oracle 11g) for the Master Repository. It was pre-created for this and subsequent practices.
• The Work Repository name is WORKREP.
• Because each time that you encode the password, it receives different values, your encoded password will differ from the one provided in the screen.
• Do not change the default value of the ODI_USER and ODI_ENCODED_PASS parameters. Those parameters were pre-coded during ODI installation.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2014, Oracle and/or its affiliatesฺ
a.
b.
c.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable
license to use this Student Guideฺ
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Practices for Lesson 3: ODI Topology Concepts
d.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2014, Oracle and/or its affiliatesฺ
2. Now that you have generated an encoded password and pasted it into the
odiparams.bat file, you need to create the ODI physical and logical agent definitions. To create these ODI agent definitions, perform the following steps:
Step Screen/Page Description
Choices or Values a. MS Windows
ODI Login
If it is not started, start Oracle Data Integrator. Click Connect To Repository. Select DEV_ODI_REPO from the Login Name drop-down list. Click OK.
b. Topology navigator Click the Topology navigator tab. In the Topology navigator, select the Physical Architecture panel. Right-click the Agents node. Select New Agent.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable
license to use this Student Guideฺ
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Practices for Lesson 3: ODI Topology Concepts
Step Screen/Page Description
Choices or Values c. Agent: localagent Fill in the following fields:
Name: localagent
Host: Network name or IP address of the machine that the agent has been launched on. Verify that this parameter is set to localhost.
Port: Listening port used by the agent. By default, this port is 20910. Leave the default value.
Web Application Context: Name of the Web application corresponding to the Java EE agent deployed on an
application server. For stand-alone agents, this field should be set to oraclediagent.
Set Maximum number of sessions supported by this agent to 250. Click the Save button.
d. Topology Navigator Local Agent: New
Now you have to insert a logical agent in Logical Architecture, and map it to the newly created Physical agent. At the bottom of the Topology navigator tab, click the Logical Architecture tab. Right-click Agents and select New Logical Agent. On the screen that follows, set the Name to localagent. For the Global context, set the Physical Agents column to
localagent. From the File menu, click Save. Close the localagent tab that you just worked on, leaving the other localagent tab open.
a.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2014, Oracle and/or its affiliatesฺ
b.
c.
d.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable
license to use this Student Guideฺ
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Practices for Lesson 3: ODI Topology Concepts
3. Now that you have created the agent and defined the ODI physical and logical agents, you can start the agent directly from the command line.
Step Screen/Page Description
Choices or Values
a. Command Prompt Switch back to the Command window you left open at the ODI_HOME\agent\bin directory
(C:\oracle\Middleware\Oracle_ODI1\oracledi\agen t\bin). Execute the agent.bat file by using the following command:
agent -NAME=localagent
b. Services The agent is now starting. Verify that ODI Agent is successfully started. Minimize (do not close) the window Command
Prompt – agent-NAME=localagent.
Note: This command window should remain open during all labs.
c. Oracle Data Integrator
In ODI, in the localagent tab that remains open, click the Test icon to verify connection of the agent localagent.
You successfully created and connected to ODI agent. Close the localagent tab . Also, close the
Messages - Log tab.
a.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2014, Oracle and/or its affiliatesฺ
b.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable
license to use this Student Guideฺ
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Practices for Lesson 3: ODI Topology Concepts
c.
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2014, Oracle and/or its affiliatesฺ
Rahul Sharma (rahulฺgฺsharma@oracleฺcom) has a non-transferable
license to use this Student Guideฺ
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.