This chapter describes how to create and configure your domain for the colocated standalone agent.
Before you continue, make sure that you have completed the Enterprise Installation install type (Chapter 2). This is for obtaining ODI Studio, which is only available with this install type, and also for obtaining the files necessary to configure a WebLogic domain and colocated standalone agent.
The following topics are covered in this chapter:
Section 6.2, "Configuring Your WebLogic Domain for Your Colocated Standalone Agent"
Section 6.3, "Creating a Standalone Agent in the Master Repository Using ODI Studio"
Before you can configure the topology for your colocated standalone agent, make sure you have created the necessary schema in your database. See Chapter 3 for instructions.
This section provides instructions for creating a WebLogic domain for your colocated standalone agent using the configuration wizard. For more information on other methods available for domain creation, see "Additional Tools for Creating, Extending, and Managing WebLogic Domains" in Creating WebLogic Domains Using the Configuration Wizard.
The following topics are covered in this section:
To begin domain configuration, navigate to the ORACLE_HOME
/oracle_common/common/bin
directory and start the WebLogic Server Configuration Wizard.
On UNIX operating systems:
./config.sh
On Microsoft Windows operating systems:
config.cmd
Follow the instructions in this section to create and configure the domain for the topology.
Task 1, "Selecting the Domain Configuration Type and Existing Domain"
Task 9, "Configuring the Administration Server Listen Address"
Task 13, "Designating a Machine for Your Standalone Colocated Agent"
Task 15, "Reviewing Your Configuration Specifications and Configuring the Domain"
Task 16, "Writing Down Your Domain Home and Administration Server URL"
On the Configuration Type screen, select Create a New Domain.
In the Domain Location field, specify your Domain home directory.
It is recommended that you locate your Domain home in accordance with the directory structure summarized in "Understanding the Recommended Directory Structure" in Planning an Installation of Oracle Fusion Middleware, where the Domain home is located outside the Oracle home directory. This directory structure will help you avoid issues when you need to upgrade or reinstall your software.
Tip:
More information about the other options on this screen can be found in Configuration Type in Creating WebLogic Domains Using the Configuration Wizard.
On the Templates screen, select the Oracle Data Integrator - Standalone Colocated Agent - 12.1.2.0 [odi] template.
Selecting this template automatically selects the following as dependencies:
Oracle JRF - 12.1.2.0 [oracle_common]
Oracle Coherence Cluster Extension - 12.1.2.0 [wlserver]
On the Administrator Account screen, specify the user name and password for the default WebLogic Administrator account for the domain.
It is recommended that you make a note of the user name and password specified on this screen; you will need these credentials later to boot and connect to the domain's Administration Server.
On the Domain Mode and JDK screen:
Select Production in the Domain Mode field.
Select the Oracle HotSpot JDK in the JDK field.
Tip:
More information about the options on this screen can be found in Domain Mode and JDK in Creating WebLogic Domains Using the Configuration Wizard.
Select RCU Data to activate the fields on this screen. The RCU Data option instructs the Configuration Wizard to connect to the database and Service Table (STB) schema to automatically retrieve schema information for the schemas needed to configure the domain.
Note:
If you choose to select Manual Configuration on this screen, you will have to manually fill in the parameters for your schema on the JDBC Component Schema screen.
After selecting RCU Data, fill in the following fields:
Field | Description |
---|---|
DBMS/Service |
Enter the database DBMS name, or service name if you selected a service type driver. |
Host Name |
Enter the name of the server hosting the database. |
Port |
Enter the port number on which the database listens. |
Schema Owner Schema Password |
Enter the username and password for connecting to the database's Service Table schema. This is the schema username and password that was specified for the Service Table component on the "Schema Passwords" screen in RCU (see Task 5 in Section 3.3). The default username is |
Click Get RCU Configuration. The following output in the Connection Result Log indicates that the operating succeeded:
Connecting to the database server...OK Retrieving schema data from database server...OK Binding local schema components with retrieved data...OK Successfully Done.
Tip:
More information about the other options on this screen can be found in Datasource Defaults in Creating WebLogic Domains Using the Configuration Wizard
Verify that the values on the JDBC Component Schema screen are correct for all schemas. If you selected RCU Data on the previous screen, the schema table should already be populated appropriately.
Tip:
For high availability environments, see the following sections in High Availability Guide for additional information on configuring data sources for Oracle RAC databases:
More information about the other options on this screen can be found in JDBC Component Schema in Creating WebLogic Domains Using the Configuration Wizard.
Use the JDBC Component Schema Test screen to test the datasource connections.
A green check mark in the Status column will appear next to the ODI Master Repository component, indicating a successful test. The template you have selected does not require the other datasource connections in the domain to be tested.
If you encounter any issues, see the error message in the Connection Result Log section of the screen, fix the problem, then try to test the connection again.
Tip:
More information about the other options on this screen can be found in Test Component Schema in Creating WebLogic Domains Using the Configuration Wizard
To complete domain configuration for the topology, select the following options on the Advanced Configuration screen:
Administration Server
This is required to properly configure the listen address of the Administration Server.
Node Manager
This is required to configure Node Manager.
Note:
If you want to create a standalone agent for use without an Administration Server or Node Manager (create an agent not managed by WebLogic components), do not select either Administration Server or Node Manager:
Skip ahead to Task 11 and follow the instructions to complete domain configuration.
Start your standalone agent by using the instructions in Section 6.4.2.2.
System Components
This is required to configure the standalone agent.
On the Administration Server screen, select the drop-down list next to Listen Address and select the IP address on the host where the Administration Server will reside. Do not use "All Local Addresses."
Do not specify any server groups for the Administration Server.
The Node Manager screen can be used to select the type of Node Manager you want to configure, along with the Node Manager credentials.
Note:
This screen will only appear if you selected Node Manager in Task 8:
After the Node Manager and agent are configured, you start the agent using the instructions in Section 6.4.2.1.
If you chose not to configure Node Manager, start the agent using the instructions in Section 6.4.2.2.
Select Per Domain as the Node Manager type, then specify the Node Manager credentials.
Tip:
More information about the options on this screen can be found in Node Manager in Creating WebLogic Domains Using the Configuration Wizard.
More information about the types of Node Manager can be found in "Node Manager Overview" in Administering Node Manager for Oracle WebLogic Server.
On the System Components screen, specify OracleDIAgent1
in the System Component column as the name of the agent (the name of the Java EE agent created earlier is OracleDIAgent
), and make sure ODI is selected in the Component Type column.
On the ODI Server Configuration screen, provide the information as described in the following table.
Field | Value |
---|---|
System Component |
Make sure |
Server Listen Address |
Enter the host name or IP address of the system on which the agent resides. Do not use "localhost." |
Server Listen Port |
Specify the port number on which this agent will listen. |
Supervisor Username |
Make sure this user name is |
Supervisor Password |
Specify the password for the |
Preferred Datasource |
Use the default |
Note:
Oracle recommends that you write down the host name and port number of the agent; you will need this later when you create the agent in the master repository (Section 6.3).
Tip:
More information about the other options on this screen can be found in ODI Server Configuration in Creating WebLogic Domains Using the Configuration Wizard
The system component you just created is automatically assigned to a machine called LocalODIMachine
. The Machines screen shows that this machine is already created.
In the Node Manager Listen Address field, select the IP address of the host running Node Manager. Do not use "localhost".
On the Assign System Components to Machines screen, verify that your system component OracleDIAgent1
is already assigned to the LocalODIMachine
.
Tip:
More information about the options on this screen can be found in Assign System Components to Machines in Creating WebLogic Domains Using the Configuration Wizard.
The Configuration Summary screen contains the detailed configuration information for the domain you are about to update. Review the details of each item on the screen and verify that the information is correct.
You can go back to any previous screen if you need to make any changes, either by using the Back button or by selecting the screen in the navigation pane.
Domain creation will not begin until you click Update.
Tip:
More information about the options on this screen can be found in Configuration Summary in Creating WebLogic Domains Using the Configuration Wizard.
The Configuration Success screen will show the Domain home location and URL of the Administration Server you just configured:
When domain creation is complete, click Finish to dismiss the configuration wizard.
A physical agent corresponds to a single standalone agent or a Java EE agent. A physical agent should have a unique name in the topology.
As part of its startup sequence, an agent connects to the Master Repository to see if there is a physical agent defined with its name. If it finds its entry, the agent continues with startup and, once started, it reads all the scheduled jobs of itself from the repository and starts processing.
If there is no physical agent entry for an agent, then the agent startup fails.
ODI Studio can be used to create the agent:
To start the ODI Studio, go to the ORACLE_HOME
/odi/studio
directory and run the following commands:
On UNIX operating systems:
./odi.sh
On Windows operating systems:
odi.exe
Before an agent can be created you must connect to the Master repository:
Note:
If you have installed any previous version of Oracle Data Integrator on the same computer you are currently using, you may be asked whether or not you want to import preferences and settings from those previous installations into ODI Studio. The tasks and descriptions in this section assume that no previous versions of Oracle Data Integrator exist on your computer.
For more information, refer to the topics in the ODI Studio Help menu.
From the ODI Studio menu, select File, then select New.
On the New gallery screen, select Create a New ODI Repository Login, then click OK.
On the Oracle Data Integrator Login screen, click the plus sign (+) icon to create a new login. On the Repository Connection Information screen:
Oracle Data Integrator Connection section:
Login Name: Specify a custom login name.
User: Specify SUPERVISOR
(all CAPS).
Password: Specify the password defined for the Supervisor user on both the RCU Custom Variables screen and also the Credentials screen in the Configuration Wizard.
Database Connection (Master Repository) section
User: Specify the schema user name for the Master repository. This should be prefix
_ODI_REPO
as specified on the Select Components screen in RCU.
Password: Specify the schema password for the Master repository. This was specified on the Schema Passwords screen in RCU.
Driver List: Select the appropriate driver for your database from the drop-down list.
URL: Specify the connection URL. Click on the magnifying glass icon for more information about the connection details for your driver.
In the Work Repository section, select Master Repository Only.
Click Test to test the connection, and fix any errors. After the test is successful, click OK to create the connection.
If you want to keep your Oracle Data Integrator and repository passwords encrypted, select Store passwords in secure wallet, then specify and confirm a new wallet password on the New Wallet Password screen.
If you do not want to encrypt your credentials, select Store passwords without secure wallet.
After you have successfully created a new login, you are returned to ODI Studio.
Select Connect to Repository and, when prompted, provide your new wallet password.
After providing your wallet password, the Oracle Data Integrator Login screen appears. Provide the following information to log in:
In the drop-down menu in the Login Name field, select the name of the new login you just created.
Specify SUPERVISOR
as the user name.
Provide the password for the Supervisor user.
When you are logged in, follow the instructions in Section 6.3.3 to create the standalone agent.
Follow the instructions in this section to create an ODI agent after you have connected to the repository in ODI Studio.
In the navigation pane on the left side, select the Topology tab, then right-click Agents, then select New Agent.
Specify the new agent details as summarized in the following table:
Field | Description |
---|---|
Name |
Specify This name must match the system component name in Task 11 in Section 6.2.2. |
Host |
Enter the IP address or name of the machine where the agent is running. Do not use "localhost." |
Port |
Enter the port number on which the agent listens. |
Note:
If your environment includes a cluster with Oracle HTTP Server acting as a front-end to the cluster, you should provide the host name and port of the Oracle HTTP Server host instead.
From the ODI Studio menu, select File, then select Save All to save your changes.
After configuration is complete, do the following to access the tools with which you can manage your domain:
Note:
For more information on additional tools you can use to manage your domain, see "Overview of Oracle Fusion Middleware Administration Tools" in Administering Oracle Fusion Middleware.
Starting the Administration Server enables you to manage your agent using Oracle Fusion Middleware control. If you do not want to do this, skip this section and go to Section 6.4.2.2 to start your agent.
If you want to start the Administration Server, go the DOMAIN_HOME
/bin
directory.
On UNIX operating systems, run:
./startWebLogic.sh
On Windows operating systems, run:
startWebLogic.cmd
If you selected Production Mode on the Domain Mode and JDK screen in Task 4, you will be prompted for the login credentials of the Administrator user as provided on the Administrator Account screen in Task 3.
Tip:
For more information about starting the Administration Server, see "Starting and Stopping Administration Servers" in Administering Oracle Fusion Middleware.
In production mode, a boot identity file can be created to bypass the need to provide a user name and password when starting the Administration Server. For more information, see "Creating a Boot Identity File for an Administration Server" in Administering Server Startup and Shutdown for Oracle WebLogic Server.
You can verify that the Administration Server is up and running by access the Administration Server Console. The URL is provided on the Configuration Success screen in Task 16.
Note:
Make sure that the database hosting your product schemas is up and running and accessible by the Administration Server.
http://administration_server_host:administration_server_port/console
The default Administration Server port number is 7001
.
For more information about how to use the Administration Console, see "Getting Started Using Oracle WebLogic Server Administration Console" in Administering Oracle Fusion Middleware.
There are two ways to start the standalone agent:
If you chose to configure a Node Manager (Task 10), use the instructions in Section 6.4.2.1 to start your standalone agent.
If you want to start your standalone agent without Node Manager, use the instructions in Section 6.4.2.2.
This section contains instructions for:
To start your per-domain Node Manager, go to the DOMAIN_HOME
/bin
directory.
On UNIX operating systems, start the Node Manager as shown below, using nohup
and nm.out
as an example output file:
nohup ./startNodeManager.sh > nm.out&
On Windows operating systems, run:
startNodeManager.cmd
Note:
On Windows operating systems, it is recommended that you configure Node Manager to run as a startup service. This allows Node Manager to start up automatically each time the system is restarted.
For more information, see "Running Node Manager as a Startup Service" in Administering Node Manager for Oracle WebLogic Server.
For more information about additional Node Manager configuration options, see Administering Node Manager for Oracle WebLogic Server.
After the Node Manager is started, go to the DOMAIN_HOME
/bin
directory and run the following commands:
On UNIX operating systems:
./startComponent.sh OracleDIAgent1
On Windows operating systems:
startComponent.cmd OracleDIAgent1
You will be prompted for the Administrator password for the domain.
To verify that your agent was started, go to the following URL in your browser:
http://examplehost.exampledomain.com:port/oraclediagent
To start your standalone agent without Node Manager, go to the DOMAIN_HOME
/bin
directory and run the following commands:
On UNIX operating systems:
./agent.sh -NAME=OracleDIAgent1
On Windows operating systems:
agent.cmd -NAME=OracleDIAgent1
The -NAME
parameter must be entered in all CAPS and the name of the agent (in this case, OracleDIAgent1
) is also case-sensitive.
Section 7.1 contains basic administration tasks. You should familiarize yourself with the tasks described in this section and perform them as needed to verify that your domain is properly configured.
Section 7.2 contains additional domain configuration tasks that take advantage of additional Oracle Fusion Middleware products and features.
Section 7.3 contains common tasks to help prepare your Oracle Data Integrator environment for development.
Section 7.4 contains important tasks to help prepare your environment to move to a highly available environment.