DBMS_SCHEDULER Scheduled Jobs Not Running After 19c Upgrade
(Doc ID 3038193.1)
Last updated on MARCH 12, 2025
Applies to:
Gen 2 Exadata Cloud at Customer - Version All Versions to All Versions [Release All Releases]Oracle Database - Enterprise Edition - Version 11.2.0.3 to 23.5 [Release 11.2 to 23]
Information in this document applies to any platform.
Symptoms
DBMS_SCHEDULER scheduled Jobs not running after 19c upgrade.
1. Scheduler is ok when only one RAC instance is up and running. If the other instance is started, dbms_scheduler jobs runs for a while then stop working.
2. If starting the database (both instances) from srvctl, scheduler don't start any job.
3. Starting instances individually from SQLPLUS prompt has the problem.
Changes
Database upgraded from 12.1 to 19c
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |