ORA-16639 When trying to Stop Jobs Forcefully In RAC Environment,with No OS Process Detected for the Job (Doc ID 2092652.1)

Last updated on DECEMBER 30, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

When trying to  Stop Jobs Forcefully In RAC Environment,the below error will be encountered ,

SQL> BEGIN
DBMS_SCHEDULER.stop_job (job_name => 'AQ$_PLSQL_NTFN_1438866628');
END; 2 3
4 /
BEGIN
*
ERROR at line 1:
ORA-16639: specified instance inactive or currently unavailable
ORA-06512: in "SYS.DBMS_ISCHED", line 210
ORA-06512: in "SYS.DBMS_SCHEDULER", line 557
ORA-06512: in line 2

In this case we can kill the job by using its OS process(kill -9 PSID)

But When tried to get the detail of  OS process associated with the job by using the below query,It will show as null (no OS process detected for the job)

SQL> select owner,JOB_NAME,SESSION_ID,RUNNING_INSTANCE,ELAPSED_TIME,CPU_USED from dba_scheduler_running_jobs where JOB_NAME='AQ$_PLSQL_NTFN_1438866628';

JOB_NAME                                       SLAVE_PROCESS_ID                  SLAVE_OS_PRO
------------------------------ ---------------- -------------------------------------------------------------
AQ$_PLSQL_NTFN_1438866628

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms