ORA-27475: Errors With Scheduler Job In Invalid State
A job is hanging in RUNNING status.
- Other scheduler jobs are running normally
- When attempt to stop the job you get:
3 (job_name => 'OC_BPS."send_bps_notifications1"');
ERROR at line 1:
ORA-27478: job "OC_BPS.send_bps_notifications1" is running
ORA-06512: at "SYS.DBMS_ISCHED", line 213
ORA-06512: at "SYS.DBMS_SCHEDULER", line 657
ORA-06512: at line 2
When querying DBA_SCHEDULER_JOBS:
SQL> SELECT STATE
WHERE JOB_NAME = 'OC_BPS.send_bps_notifications1';
Found the job hanging in RUNNING status
To implement the solution, please execute the following steps:
drop the job by specifying FORCE=TRUE
Note: when the force option doesn't help, and the job is still existent and hanging in 'running' status then
unpublished bug 7258928 might be the reason for this.
The bug is fixed in product version 11.2.
Patches for lower versions are available.
MOS : ORA-27478 / ORA-27366 Errors With Scheduler Job In Invalid State (Doc ID 422134.1)