Link to home
Start Free TrialLog in
Avatar of vr76413
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
ASKER CERTIFIED SOLUTION
Avatar of necati_cehreli
necati_cehreli
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think it is checking TEMP tablespace usage regularly