vr76413
asked on
ORA-12012: error on auto execute of job 144338
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 NAME:(DBMS_SCHEDULER) 2009-02-27 10:09:17.131
*** SERVICE NAME:(SYS$USERS) 2009-02-27 10:09:17.131
*** SESSION ID:(312.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 ?
Thanks
Ram K
I did some research and looked up under DBA_SCHEDULER_JOBS and JOB NAME is
here is the error message in alert log.
++++++++++++++++++++++++++
Fri Feb 27 10:04:17 2009
Errors in file /u10/app/ORACLE/admin/dss/
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/
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/
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
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)
*** MODULE NAME:(DBMS_SCHEDULER) 2009-02-27 10:09:17.131
*** SERVICE NAME:(SYS$USERS) 2009-02-27 10:09:17.131
*** SESSION ID:(312.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 ?
Thanks
Ram K
I did some research and looked up under DBA_SCHEDULER_JOBS and JOB NAME is
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think it is checking TEMP tablespace usage regularly
Yes looks like the JOB is the one below:
http://www.oramoss.com/blog/2008/02/tracking-temp-usage-throughout-day.html
http://www.oramoss.com/blog/2008/02/tracking-temp-usage-throughout-day.html