Home » RDBMS Server » Server Administration » strange job error
strange job error [message #194002] Wed, 20 September 2006 06:14 Go to next message
Messages: 1
Registered: September 2006
Junior Member

Hi I've strange job errors on my Oracle 8i instance.

ORA-12012: error on auto execute of job 959 (number may differ)
ORA-23421: job number 959 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 525
ORA-06512: at "SYS.DBMS_IJOB", line 258
ORA-06512: at line 1

Why It is strange? Because there are no such jobs in jobs list. Look at this:

SQL> select job, log_user, broken, what, failures from sys.dba_jobs;

       JOB LOG_USER BROKE WHAT                                                      FAILURES
---------- -------- ----- ------------------------------------------------------- ----------
       802 ASKUEANA N     RepConfig.runBatchReport(784,job,next_date);                     0

       753 ASKUEANA N     RepConfig.runBatchReport(780,job,next_date);                     0

       754 ASKUEANA N     RepConfig.runBatchReport(776,job,next_date);                     0

       755 ASKUEANA N     RepConfig.runBatchReport(627,job,next_date);                     0

       JOB LOG_USER BROKE WHAT                                                      FAILURES
---------- -------- ----- ------------------------------------------------------- ----------

       756 ASKUEANA N     RepConfig.runBatchReport(632,job,next_date);                     0

       757 ASKUEANA N     RepConfig.runBatchReport(781,job,next_date);                     0

       759 ASKUEANA N     RepConfig.runBatchReport(738,job,next_date);                     0

       760 ASKUEANA N     RepConfig.runBatchReport(739,job,next_date);                     0

       JOB LOG_USER BROKE WHAT                                                      FAILURES
---------- -------- ----- ------------------------------------------------------- ----------

       761 ASKUEANA N     RepConfig.runBatchReport(754,job,next_date);                     0

       782 ASKUEANA N     archiving.replaceparvaluetoar;                                   0

10 rows selected.

SQL> show parameter job

NAME                                 TYPE    VALUE
------------------------------------ ------- ------------------------------
job_queue_interval                   integer 60
job_queue_processes                  integer 10
SQL> show err
No errors.

As you can see there is no such jobs! How that could happen? And how should I correct that? Is there any scripts that could check database if it is in correct state ot not?

Re: strange job error [message #194108 is a reply to message #194002] Wed, 20 September 2006 16:53 Go to previous message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Where do You get the error - the alert.log?

It is a common error to get, if fx. You try to drop/modify etc. another users job.
Previous Topic: LOcation of Pfile
Next Topic: SVRMGRL Confusion
Goto Forum:

Current Time: Tue Oct 25 17:53:30 CDT 2016

Total time taken to generate the page: 0.11464 seconds