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:
SQL> BEGIN
 2 SYS.DBMS_SCHEDULER.DROP_JOB
 3 (job_name => 'OC_BPS."send_bps_notifications1"');
 4 END;
 5
 BEGIN
 *
 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
 FROM DBA_SCHEDULER_JOBS
 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)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: