Connecting to Oracle Applications Instances

To schedule workload in an Oracle Applications instance, you must first set up a connection between Redwood Server and the Oracle Applications instance.

  • A JDBC credential for the Oracle database
  • Database object that uses the credential and points to the Oracle database
  • Oracle Applications object that references the database object
    • Process Server and Queue are created automatically.

Credentials

The username and password is stored in a credential. Redwood Server retrieves the username and password by using the JDBC credential which has an Endpoint matching the value of the Database object and has default set as the Virtual Username.

Connection String

The connect string must be an Oracle JDBC compliant connect string as follows:

Copy 
JDBC:oracle:thin:@<host>:<port>:<sid>
or
JDBC:oracle:thin:@//<host>:<port>/<service>
  • <host> - the hostname of the Oracle Applications database host
  • <port> - the port the Oracle database is listening on
  • <sid> - the SID of the Oracle database
  • <service> - the name of the service of the Oracle database

Example

Copy 
JDBC:oracle:thin:@/oraapps.example.com:1521/orcl

Note: Oracle recommends connecting using the service over the sid, as connecting via sid will be deprecated.

Prerequisites

  • Oracle Applications 11.5 or higher
    • Oracle database 8.1.7.4 or higher, an Oracle 8 database requires the 10.2.0.4 Oracle database client (JDBC)
  • on-site-related topic To connect to instances of Oracle Applications, you need a free slot in the ProcessServerService.OraApps.limit license key

Procedure

Create an Oracle Applications System Object

  1. Navigate to "Security > Credentials".
  2. Choose New Credential from the context menu.
  3. Select the JDBC protocol, fill the username and password, as Endpoint it is recommended to choose the database name.
  4. Navigate to Environment > Databases.
  5. Choose New Database from the context menu.
  6. Fill in the fields Name (referred to as <ora_name>) and JDBC Connect String.
  7. Select the credential for the database connection.
  8. Click Save & Close.
  9. Navigate to "Environment > Oracle Applications".
  10. Choose New Oracle Applications System from the context menu.
  11. Select the Database object you just created and set the Default Time Zone.
  12. In the Output Retrieval area, choose how you wish to retrieve output files. Redwood recommends the HTTP(S) method.

  13. The Pre-fill default values for process parameters field lets you control when RunMyJobs queries Oracle EBS for default parameter values. The options are as follows.

    • Never: Do not query Oracle EBS for default values.

    • Mandatory: Query Oracle EBS for default values only for required fields.

    • Always: Query Oracle EBS for default values for all fields. This is the default setting.

    Note: If your Oracle EBS database is large, fetching a full set of default values can take considerable time. To avoid this, consider selecting Mandatory or Never. You can also override this setting at the Process Definition level by adding one of the following lines to the Source field: DEFAULT_LOV_VALUES=Never, DEFAULT_LOV_VALUES=Mandatory, or DEFAULT_LOV_VALUES=Always.

  14. If you would like to use a Platform Agent, you will have to install one on the EBS server.
  15. cloud-related topic If you registered the Platform Agent with the central Redwood Server, select a Process Server as Spool Host; note that output files will be stored on the central Redwood Server.
  16. Click Save & Close.
  17. Navigate to "Environment > Process Servers".
  18. If you did register the Platform Agent with the central Redwood Server:
  19. Choose Start from the context menu of the Process Servers named <ora_name>_ProcessServer.
  20. If you did not register the Platform Agent with the central Redwood Server:
  21. Choose Edit from the context menu of the Process Servers named <ora_name>_ProcessServer.
  22. On the Process Server tab, ensure the PlatformAgentService is present and all native interpreters that the platform has are selected.
  23. On the Parameters tab, Fill the RemoteHostName, RemotePort (optional, default 1555), and SharedSecret (optional if the Platform Agent has none) parameters;.
  24. Click Save & Close.

Start the Process Server

  1. Navigate to "Environment > Process Servers".
  2. Choose Start from the context menu of the Process Server _<ora_name>ProcessServer.
  3. Refresh the window until the Process Server is starting, if after two minutes the Process Server has not started, inspect the Operator Messages Monitor.

Submit a test job

  1. Navigate to Definitions > Processes and choose Submit from the context menu of System_OraApps_ConcurrentProgramImport.
  2. Select the newly created Oracle Applications system, select an Application short name and Concurrent Program name; note that the values are retrieved from the remote Oracle Applications system.
  3. Choose the _<ora_name>Queue Queue served by the Oracle Applications Process Server and monitor the process until it reaches the status Completed, if the process reaches status Error, check "Monitoring > Operator Messages".

Install a Platform Agent on the Oracle Applications Server (Optional)

  1. Download the appropriate installer for your platform from "Configuration > Software".
  2. Navigate to "Environment > Process Servers".
  3. Choose New Process Server from the context menu, fill the Port field, select the appropriate platform; choose Next.
  4. Fill a name into the Name field, select or create a Partition for the Process Server, and select the OS Family; choose Next.
  5. Select a Native installer, choose Next.
  6. Transfer the Platform Agent binary to the Oracle Applications Application server and run it with administrative privileges.
  7. If you register the Platform Agent with the central Redwood Server, you specify the name of the Process Server in the Spool Host field of the Oracle Applications object (see Create an Oracle Applications System Object section below).
  8. If you choose not to register the Platform Agent with the central Redwood Server, you add RemoteHostName, RemotePort, and SharedSecret to the Process Server created by the Oracle Applications object. (see Create an Oracle Applications System Object section below).

Note: You can use the default settings, on UNIX, you should ensure the user the jobs run under is a valid user. See the Creating Platform Process Servers topic for more information on installing Platform Agents.

See Also