Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_scheduler.stop_job(jobName, force=>true) fails with ora-27366

juanavelezSep 25 2007 — edited Feb 12 2010

I hope someone has experienced the same. I have googled the problem with no success. I am running Oracle 10.2.0.3.0 on a RAC environment (2 Instances), Red Hat EL Linux.

We have jobs which are currently running on the schema where they were created (and owned). Our schema has the manage_scheduler privilege but for some running jobs (and they are not the same all the time), when they are tried to be stopped using dbms_scheduler.stop_job(jobName, force=>true) we get ORA-27366.

We are not sure what's going on here and we have exhausted all workarounds except going back to dbms_job which we do not want to

Has anyone experienced the same? Do you think this might be an Oracle Bug?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 12 2010

Added on Sep 25 2007

#database-key-features, #scheduler

4 comments

42,211 views