1. Getting Started with Oracle Data Integrator on Oracle Cloud Marketplace
  2. Creating a Standalone Collocated Agent

A Creating a Standalone Collocated Agent

This appendix describes how to create a standalone collocated agent.

Setting up a standalone collocated agent involves the following steps:

A.1 Installing the Agent

Follow the below steps to install the standalone collocated agent:
  1. Verify that the existing standalone agent is down by running the following command:

    sudo systemctl status -l agentodi.service

    If the service is still active (up and running), use the following command to stop it:

    sudo systemctl stop agentodi.service

  2. Navigate to the following directory:

    $MW_HOME/oracle_common/common/bin

  3. Start the Configuration Wizard by running the following command:

    ./config.sh

  4. In the Create Domain screen, select Create a new domain and specify $MW_HOME/user_projects/domains/odisac_domain in the Domain Location field. Click Next.
  5. In the Templates screen, select Oracle Data Integrator – Standalone Collocated Agent [odi]. This will automatically select other options. Click Next.
  6. In the Administrator Account screen, provide the following information and click Next:
    1. Name: By default, weblogic is specified.
    2. Password: Specify a password for the weblogic user.
    3. Confirm Password: Retype the password.
  7. In the Domain Mode and JDK screen, select Production in the Domain Mode field and verify that you are pointing to the right JDK path "/u01/oracle/jdk1.8.0_191". Click Next.
  8. 8. In the Database Configuration Type screen, provide the following information:
    1. Host Name: Name of the server where the repository database is stored.
    2. DBMS/Service: Service name of the database where the repository is stored.
    3. Port: Port where the database where the repository is stored is running (1521).
    4. Schema Owner: Login owner of all ODI schemas. Leave the default as DEV_STB.
    5. Schema password: Password for ODI schemas provided in previous steps.
  9. Click Get RCU Configuration. This will verify the connectivity to the database.
  10. Once connectivity has been successfully verified, click Next.
  11. In the Component Datasources screen, click Next.
  12. In the JDBC Component Schema Test screen, you can see the progress of the status verifications in all components. Once all have green check marks, click Next.
  13. In the Advanced Configuration screen, select Node Manager and System Components. Click Next.
  14. In the Node Manager screen, provide the following information and click Next:
    1. Username: Specify weblogic.
    2. Password: Provide the password for the weblogic user.
    3. Confirm Password: Confirm the password.
  15. In the System Components screen, accept the defaults and click Next.
  16. In the ODI Server Configuration screen, provide the Supervisor user password. Leave all other default values and click Next.
  17. In the Machines screen, select the Unix Machine tab. Click Add. Leave all defaults and click Next.
  18. In the Assign System Components to Machines screen, leave all default values and click Next.
  19. In the Configuration Summary screen, you can review all your choices. Click Create.
  20. As the tasks progress, a green check will appear. This means that the tasks finished successfully. Once it finishes, click Next.
  21. In the End of Configuration screen, click Finish.

A.2 Defining the Agent in ODI

Follow the below procedure to define the agent:
  1. Log into ODI Studio.
  2. On the Topology tab, expand Physical Architecture. Right-click Agents and select New Agent.
  3. On the Agent panel, on the Definition tab, in Name, enter the name for the new agent. Save the configuration.
  4. On the Topology tab, expand Logical Architecture. Right-click Agents and select New Logical Agent.
  5. On the Logical ODI Agent panel, on the Definition tab, in Name, enter the name for the new agent.
  6. Select Global as the context. Save the configuration.

A.3 Starting the Agent

Follow the below procedure to start the standalone collocated agent:
  1. Navigate to the following directory:

    $MW_HOME/user_projects/domains/odisac_domain/bin

  2. Start the agent by executing the following command:

    nohup ./agent.sh -NAME=OracleDIAgent1 &

  3. Execute the tail nohup.out command.
  4. Start ODI Studio by running odi.sh available in the $MW_HOME/odi/studio/ directory.
  5. In the Topology tab, open the required agent and click Test.
  6. On receiving a successful test message, click OK.