Cisco Cisco Workload Automation 6.3 User Guide

Configuring the Oracle Applications Adapter

Configuring Oracle for Scheduler

You can test the Oracle Applications connection by right-clicking within the 

 pane and selecting the 

 

option from the context menu. This test checks the status of the connection between the database and the client but 
does not verify the health of the connection between the master and the client. 

Configuring Oracle for Scheduler

There are some configuration procedures that Cisco recommends be performed to ensure optimal interaction between 
Oracle and the Scheduler adapter:











Configuring Oracle Parameters

At the time that the Oracle Applications adapter is installed, the following parameters in Oracle should be configured by 
the Oracle database administrator:

Configuring User Access

In most cases, user accounts should be locked down by the DBA to prevent users from going into their accounts to 
modify their access. If users have access to their account, they could enhance their security access to ensure that their 
concurrent requests bypass the interception criteria that was created to control the flow of concurrent requests being 
processed.

The Oracle DBA should configure each user’s access to their profile to prevent users from accessing the profile to make 
changes. On the 

 screen of a profile, configure the profile’s security by clearing the checkmark in the 

 option in the 

 section. The user can still access their account but they cannot modify the profile.

Configuring Interception Criteria Access

The ability to set up criteria for intercepting jobs is controlled from within Oracle. The Oracle DBA can maintain total 
control over job interception if needed or the DBA can give the administrator in Cisco Workload Automation the capability 
to manage job interception. To grant the Cisco Workload Automation administrator this ability to manage job interception 
criteria, the Oracle DBA must select the 

 option in the 

 section of the 

 screen. 

If a user in Scheduler cannot modify the interception criteria, the 

 button on the 

 tab of the Oracle 

connection definition is unavailable.

Parameter

Value

REL_EXT_REQ

Specifies whether external requests should be released. Valid values are Y or N.

LOG_EXT_REQ

Specifies whether to log the messages about external requests. Valid values are Y or N

MASTER_ALLOWED

Specifies which Scheduler master can release external requests.

PURGE_FREQUENCY

Specifies how often the log data recorded about the external requests should be purged. 
Values are numerical expressing the number of days to keep the data.

PROFILE_ACCESS

Specifies whether the Scheduler administrator can access the Oracle Applications Profile 
settings to modify the interception criteria. Valid values are Y or N.