Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

ORA-12012: error on auto execute of job 144338

Avatar of vr76413
vr76413 asked on
Oracle Database
3 Comments1 Solution3023 ViewsLast Modified:
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_cehreliFlag of Turkey image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers