Re: dbms_scheduler jobs stop running after reboot.

Joan,

If you're running 12.1 (maybe 12.2) there's a bug with scheduler jobs not firing after a database restart . Oracle support should have the metalink article as I don't have it in front of me at the moment.

We run into this on our db occasionally.

Chris

On Sun, Mar 3, 2019, 7:22 PM Mladen Gogala <gogala.mladen_at_gmail.com wrote:

> Hi Joan!
>
> Each and every queue process has a trace. To enable an additional trace,
> you can use event 10046, level 16 on few of those processes and see what
> is going on within the traced processes. Looking into DBA_SCHEDULER_JOBS,
> DBA_SCHEDULER_JOB_LOG and DBA_SCHEDULER_JOB_RUN_DETAILS would also be a
> good idea. And what was that about "unsupported page size"? What OS are you
> using? What version of Oracle? However, the very first place to look in
> would be the alert log. ADRCI can be useful here, too.
>
> Regards
> On 2/28/19 11:55 AM, Joan Hsieh wrote:
>
> 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
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

--
http://www.freelists.org/webpage/oracle-l