Creating RA Oracle E-Business Suite Agent CONN Objects

You will need to create a CONN object for the RA Oracle E-Business Suite Agent solution AGENT and JOBS objects.

Prerequisites

Before creating CONN objects, you must:

Set up Oracle Advanced Queuing as described in topic Setting Up Oracle Advanced Queuing.
Check your Oracle prerequisites and privileges as described in topic Checking Prerequisites and Privileges.
Load the OEBSAgent_deploy_file.jar for your Automation Engine as described in topic Installing/Upgrading the RA Oracle E-Business Suite Agent in an Existing AE System.

The Login field on the Attributes page is not used for Automation Engine Jobs of the Oracle E-Business Suite Agent.

Creating the CONN Object

Create an OEBSAGENT > JDBCCONNECTION object in Client 0 as described in your Automation Engine documentation.

Although JDBC CONN objects allow you to select any option from the Database Type field, the only currently supported option for the RA Oracle E-Business Suite Agent is Oracle.

The recommended and supported user for the RA Oracle E-Business Suite Agent CONN object is the apps user.

The CONN object will be used for your RA Oracle E-Business Suite Agent solution AGENT and JOBS objects.

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 Name/Userid/Password, userid, and password. In Oracle RAC Connect String, enter the TNS name of the Oracle RAC connection without the jdbc:oracle:thin: prefix. For example: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST)))

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 Name/Userid/Password, userid, and password.

In Oracle RAC Connect String, enter the TNS name of the Oracle RAC connection without the jdbc:oracle:thin: prefix. For example:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST)))