Cisco Cisco Workload Automation 6.3 User Guide
33
Using the Oracle Database Adapter
Troubleshooting Issues with Oracle Database Jobs
—
Index created
—
Index deleted
All other database events require a specific table name. The value entered here must be all uppercase without any
spaces.
spaces.
By User
– The name of the user making the change in the database. The value entered here must be all uppercase
with without any spaces. The wildcards characters * and ? can be used in this text field.
Schedule Tab
From the
Schedule
tab, you define when the event monitor will operate. Refer to the Schedule tab section in the Events
chapter of the Cisco Workload Automation User Guide for a description of the options on this tab of the
Oracle DB
Event
dialog.
Associated Action(s) Tab
This tab associates action(s) with the Oracle database event. An event must have an associated action before it can be
enabled. For information about the options on this tab, refer to Associated Action(s) tab in the Events chapter of the Cisco
Workload Automation User Guide.
enabled. For information about the options on this tab, refer to Associated Action(s) tab in the Events chapter of the Cisco
Workload Automation User Guide.
Description Tab
This is a free text field where you can provide a description and notes about this particular event, up to 255 characters.
Trigger History Tab
The
Trigger History
tab lists all of the instances when the event was triggered during the trigger history retention
period. This retention period is configured on the
Default
tab of the
System Configuration
dialog. For information
about the options on this tab, refer to Trigger History tab in the Events chapter of the Cisco Workload Automation User
Guide.
Guide.
Troubleshooting Issues with Oracle Database Jobs
Some of the more basic conditions to check whenever encountering any difficulty processing Oracle database jobs are
provided below.
provided below.
Event monitors do not work correctly.
Verify that all of the required audit trail views are enabled. The audit trail views that are required for data event monitoring
are listed in the section,
are listed in the section,
.
There are no database jobs in the Job Name field.
If you are running Oracle 10g and no jobs display in the
Job Name
field, check the status of the connection to the Oracle
database. A valid connection is required to retrieve and display the list of predefined jobs from the Oracle database. Even
if there is no connection though, the name of the job can be typed into the text field and the job definition will run when
the connection is reestablished (as long as the job name is correctly spelled).
if there is no connection though, the name of the job can be typed into the text field and the job definition will run when
the connection is reestablished (as long as the job name is correctly spelled).
No Oracle jobs will run.
Verify that there is a good connection to the Oracle database.
If there is a red status light next to the Oracle database connection in the Connections pane, verify that the
connection information in the connection definition is accurate.
connection information in the connection definition is accurate.