ora-27366 & ora-27478 when trying to stop/drop a scheduler job
Hi,
Last weekend we had a problem with a production database. It's a 11.1.0.7.0 version database, 64 bit running on a Red Hat 5.3 64 bit server.
When we tried to stop a scheduler job which according to dba_scheduler_jobs_running was running Oracle returned a ora-27366 (job is not running) message. I also tried to drop the job but Oracle returned a ora-27478 (job is running). Using the force option for stop/drop didn't help.
After some unsuccesfull actions to solve the problem I did a point in time restore/recover.
Browsing through Metalink I've come some related issues but have found no patch yet. Bug 8300942: ORA-27478 ATTEMPTING TO DROP SCHEDULER JOB is very much like the problem we encountered. Before I log a Tar I wanted to know if someone has had the same problem and if the is a patch for it.
regards,
Ivan