dbms_scheduler jobs stop running after reboot.
Date: Thu, 28 Feb 2019 11:55:39 -0500
Message-ID: <CAEhBma7Mj6RVriW8Hh4+TDet34_wRPRzK_J+_nE-exzc0Np-QA_at_mail.gmail.com>
Hi List,
We planned to increase the SGA_target from 50G to 64G. Ended up we had to change back to 50G due to the page size was not supported. However, after the database rebooted all of the scheduler jobs stopped to execute. (There are more than 500 jobs, fired every 5 min in application)
The last_start_date in dba_scheduler_jobs was the time prior to the database rebooting, which was 2/23 9pm, and the state was SCHEDULED.
The job queue is 50, cjg0 is running. we don't use oracle OIM.
The developer had tried to disable/enable the scheduler. They had also tried to use exec DBMS_SCHEDULER.run_job to test. The job ran, but did not fire after 5 min for the next run.
The database is 4 TB in size. Previously the database had bounced several times, but it had never caused any scheduler jobs issue before. We are trying to find any resource and had opened an Oracle SR for this issue. We just wanted to find out if you have have any insight.
Much thanks in advance.
Joan
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 28 2019 - 17:55:39 CET