 Posted 6/15/2010 10:58:37 AM
|
|
|
|
| ORA-12012: error on auto execute of job 101 ORA-12005: may not schedule automatic refresh for times in the past I see Errors in my alert log , and these errors are generated every 5 minutes. It seems to be that some PL/SQL Block under SYSTEM is throwing these errors.
here is the error message in alert log.
++++++++++++++++++++++++++++++++++
Fri Feb 27 10:04:17 2009
Errors in file /u10/app/ORACLE/admin/dss/bdump/dss_j000_12401.trc:
ORA-12012: error on auto execute of job 144338
ORA-06550: line ORA-06550: line 1, column 531:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 1, column 439:
PL/SQL: SQL Statement ignored
, column :
Fri Feb 27 10:09:17 2009
Errors in file /u10/app/ORACLE/admin/dss/bdump/dss_j000_12515.trc:
ORA-12012: error on auto execute of job 144338
ORA-06550: line ORA-06550: line 1, column 531:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 1, column 439:
PL/SQL: SQL Statement ignored
, column :
+++++++++++++++++++++++++++++++++++++
I looked up into one of those TRACE file that it refers in ALERT LOG
---------------------------------------------------------------------------------------------
/u10/app/ORACLE/admin/dss/bdump/dss_j000_12515.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u10/app/ORACLE/product/10.2.0.1
System name: SunOS
Node name: oscora02z
Release: 5.10
Version: Generic_127127-11
Machine: sun4u
Instance name: dss
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 12515, image: oracle@oscora02z (J000)
*** ACTION NAME JOB_SNAP_TEMP_USAGE) 2009-02-27 10:09:17.131
*** MODULE NAMEDBMS_SCHEDULER) 2009-02-27 10:09:17.131
*** SERVICE NAMESYS$USERS) 2009-02-27 10:09:17.131
*** SESSION ID312.17680) 2009-02-27 10:09:17.131
*** 2009-02-27 10:09:17.131
ORA-12012: error on auto execute of job 144338
ORA-06550: line ORA-06550: line 1, column 531:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 1, column 439:
----------------------------------------------------------------------------------------------
So my question is , why is this 'JOB_SNAP_TEMP_USAGE' runnign every 5 minutes. How do i disable it or what happens, if i delete this JOB ?
|
|
|
Posted 6/15/2010 10:58:55 AM
|
|
|
|
Use :
select dbr.sid, s.serial#, s.username, dbj.*
from dba_jobs_running dbr, dba_jobs dbj , v$session s
where dbj.job = 144338;
to see what is being executed via the job (dbj WHAT column) and correct the incorrect PL/SQL syntax.
I don't recommend but If you want to kill the job; first make the job broken :
begin
dbms_job.broken(144338,true);
end;
and then kill the session that's running this job :
alter system kill session 'SID,SERIAL' immediate;
change SID and SERIAL# according to the output of first query.
|
|
|
Posted 6/15/2010 11:10:43 AM
|
|
|
|
I am getting the error 12012 auto execute job error but i ca't seem to find this job. The error that come is
ORA-12012: error on auto execute of job 101
ORA-02236: invalid file name
But querying user_jobs does not show this job, strange...
|
|
|
Posted 6/15/2010 11:11:05 AM
|
|
|
|
Re: ORA-12012: error on auto execute of job query dba_jobs and dba_jobs_running |
|
|
Posted 6/17/2010 2:10:13 PM
|
|
|
|
I am receiving following error in my og. But job is not broken and there are no failure. Any idea how tio fix it.
ORA-12012: error on auto execute of job 14
ORA-12005: may not schedule automatic refresh for times in the past
dbms_refresh.refresh('"ECOM"."CUSTRUN"');
Broken = N
Faliure = 0
Interval = trunc(sysdate)+23/24
Last Date =06/11/2010 10:02:15 AM
Next Date =06/11/2010 04:01:17 PM
ORA-12012: error on auto execute of job 14
ORA-12005: may not schedule automatic refresh for times in the past
What= dbms_refresh.refresh('"ECOM"."CUSTRUN"');
Here is the fix: Date should be fixed to be:
trunc(sysdate+1)+23/24
|
|
|
|