Information Technology Reference
In-Depth Information
Troubleshooting ESS
The Fusion Application Administrator console provides many views of the Oracle
Enterprise Scheduler. The scheduler's history is always available in the
re-
quest_history
table under the
fusion_ora_ess
schema. This table can also
be queried to get the status of the scheduler's jobs.
If a job remains in the
WAIT
state, the following checks can be made:
1.
Make sure the ESS Managed server is up and running.
2.
Make sure the ESS Application instance is up and running.
3.
Make sure the Request Dispatcher is up and running.
If a job remains in the
RUNNING
state, the following checks can be made:
1.
Make sure that
Request Processor
is up and running.
2.
In case of asynchronous jobs, check on the status of the remote schedule
job, and if required, troubleshoot the long-running job.
3.
If the remote schedule job is completed, check on its ability to notify the com-
pletion status.
4.
If the job is running on the database, the performance issues can be traced
at the database level.
In some cases, a job may run for a long time and would be seen consuming a large
number of CPU cycles. It may also be consuming large amount of memory on the
database server. In such cases, it would be possible to troubleshoot the issue by tra-
cing the database session. To trace a database session, perform the following steps:
1.
Log
in
to
Application
(
http://hostname.domain.name:port/
homePage
).
2.
Navigate to
Help
|
Troubleshooting
|
Troubleshooting Options
, shown as
follows:
Search WWH ::
Custom Search