E1: SCH: Scheduler Submits Outstanding Jobs Then Stops Every Time (Doc ID 2747767.1)

Last updated on JANUARY 28, 2021

Applies to:

Symptoms

Enterprise Servers: AIX 7.2
Database: Oracle 19c

Issue: Once Scheduler is started, which then will runs reports in the queue, but then Scheduler halts and will not submit any more reports.

It does not zombie, or throw any errors in the logs, it just go into hibernation.

When it runs, it correctly changes the Next Submit Date to show the next date/time a job should run, and the Next Job Monitoring Date also appears correctly, but it just goes to sleep after running the outstanding jobs.

To recover customer has to attempts the following which will submit any missed reports, and the Scheduler then halts again and goes into a wait state not submitting any more reports, until the next manual intervenes.

Below actions will wakes it up and it runs the missed jobs, but then it goes right back into hibernation.
-create a new scheduled job,
-pause and un-pause the monitor,
-pause and un-pause the launcher,
-reset the scheduler,
-stop/start the scheduler,


Here is what customer have tried:
-Deleted all records from F91320 and bounced services.
-Deleted all records from F91300, bounced services, and recreated the *SCHEDULER record using the Scheduler Application. Then created a single recurring job that runs every two minutes.
-Tried running the Scheduler Server on 3 different Enterprise Servers with the same results.

The only error seen in any of the server logs is the following from the Scheduler kernel log:

SCHEDULER - Unable to send message. Failed with 2

Switch to windows enterprise server fixes the issue.
Issue only happen to unix with Oracle 19c

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.