Creating RA Oracle Retail Agent JDBC and Program Connection Objects

To link the RA Oracle Retail Agent to Oracle Retail, you must create:

An RA Oracle Retail Agent JDBC Connection object for the Agent to connect to the Oracle Retail database.
One or more RA Oracle Retail Agent Program Connection objects for the Jobs to connect to Oracle Retail.

The Login field on the Attributes page is not used for Automation Engine Jobs of the Oracle Retail Agent.

Creating an RA Oracle Retail Agent JDBC Connection Object

Create a CONN > ORACLERETAILAGENT > JDBCCONNECTION object in client 0 as described in your Automation Engine help.

Define the Connection object by doing one of the following:

To:	Do this:
Enter the host, port, and connect string in the provided fields for an Oracle database	Select Oracle in the Database Type field. Fill in the Host, Port, and Service Name fields and keep the Free Form Entry box unchecked. The values you fill in will populate the read-only JDBC Connect String field in the Oracle 12c format: jdbc:oracle:thin:@//{host}:{port}/{service}, which is backwards compatible. If you need to find your service name, you can do it in one of the following ways: Log into to SQLPlus as the SYS* user and enter the following command: SQL> show parameter service_names On the command line, enter the lsnrctl status command to get the services and instances available on the machine. In previous releases, there was a SID field in place of the Service Name field. In those releases, the JDBC Connect String field was populated in the Oracle 9i/10g/11g format: jdbc:oracle:thin:@{host}:{port}:{sid}. If you need to continue using the older format going forward, you can enter the JDBC connect string manually as described below.
Manually enter a connect string	Select Oracle or SQLServer in the Database Type field. Specify the database driver class, userid, and password. Check the Free Form Entry box and enter a connect string in the JDBC Connect String field.
Manually enter an Oracle RAC connect string	Select Oracle RAC in the Database Type field. Specify the database driver class, userid, and password. Enter a RAC connect string in the Oracle RAC Connect String field.

To:

Do this:

Enter the host, port, and connect string in the provided fields for an Oracle database

Select Oracle in the Database Type field.

Fill in the Host, Port, and Service Name fields and keep the Free Form Entry box unchecked. The values you fill in will populate the read-only JDBC Connect String field in the Oracle 12c format: jdbc:oracle:thin:@//{host}:{port}/{service}, which is backwards compatible.

If you need to find your service name, you can do it in one of the following ways:

Log into to SQL*Plus as the SYS user and enter the following command:

SQL> show parameter service_names

On the command line, enter the lsnrctl status command to get the services and instances available on the machine.

In previous releases, there was a SID field in place of the Service Name field. In those releases, the JDBC Connect String field was populated in the Oracle 9i/10g/11g format: jdbc:oracle:thin:@{host}:{port}:{sid}. If you need to continue using the older format going forward, you can enter the JDBC connect string manually as described below.

Manually enter a connect string

Select Oracle or SQLServer in the Database Type field.

Specify the database driver class, userid, and password.

Check the Free Form Entry box and enter a connect string in the JDBC Connect String field.

Manually enter an Oracle RAC connect string

Select Oracle RAC in the Database Type field.

Specify the database driver class, userid, and password.

Enter a RAC connect string in the Oracle RAC Connect String field.

Configuration Requirements for Connecting to an Oracle 12c Application Database

Configuring the RA Oracle Retail Agent to connect to an Oracle 12c Application Database requires the ojdbc6.jar JDBC driver file. To put the ojdbc6.jar file in place:

Stop the Agent.
Copy the JDBC driver ojdbc6.jar file from the Oracle database client installation to the lib directory.

The file is located at ORACLE_HOME/jdbc/lib/.

For	On	Directory
Automation Engine v11 or above	UNIX	bin/lib
Automation Engine v11 or above	Windows	bin\lib
Automation Engine v9 or 10	UNIX	bin/shared
Automation Engine v9 or 10	Windows	bin\shared

If you want to save the old file, you can copy it to a backup location outside the path of the Agent.

Remove the old ojdbc14.jar file from the Agent directory, if there is one there.
Unpack the ojdbc6.zip file, and copy the new ojdbc6.jar file to the Agent directory as follows:
On Directory
UNIX bin/lib
Windows bin\lib
Restart the Agent.

On	Directory
UNIX	bin/lib
Windows	bin\lib

Configuration Requirements for Automation Engine v11.2 When You Do Not Use an Oracle 12c Application Database

Configuring the RA Oracle Retail Agent to connect to an Application Database that is not Oracle 12c when you are using Automation Engine v11.2 requires the ojdbc<version>.jar file. To put the ojdbc<version>.jar file in place:

Stop the Agent.
Copy the JDBC driver ojdbc<version>.jar file from the Oracle database client installation to the lib directory.

The file is located at ORACLE_HOME/jdbc/lib/.

Unpack the ojdbc<version>.zip file, and copy the new ojdbc<version>.jar file to the Agent directory as follows.
On Directory
UNIX bin/lib
Windows bin\lib
Restart the Agent.

On	Directory
UNIX	bin/lib
Windows	bin\lib

Creating an RA Oracle Retail Agent Program Connection Object

To create an RA Oracle Retail Agent program Connection object:

Create a CONN > ORACLERETAILAGENT > ORACLERETAILCONNECTION object in client 0 as described in your Automation Engine help.
On the Oracle Retail Connection page, specify values in the fields for your Oracle Retail installation.
Copy the Connection object to all local (non-zero) clients where RA Oracle Retail Agent Jobs will be defined.