This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Dec 5, 2012 4:02 AM by spajdy RSS

Error on auto execute of job

Santosh Pradhan Explorer
Currently Being Moderated
Hii,

I am using Oracle 11g version 11.2.0.2.0
From last few days i am getting the error
ORA-12012: error on auto execute of job 179297
ORA-01403: no data found
ORA-06512: at line 1
in my alert log.

The trace file details are :

Trace file C:\APP\MANAGER\diag\rdbms\c2kprod\c2kprod\trace\c2kprod_j002_5552.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 24 - type 8664, 2 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:13735M/32756M, Ph+PgF:77877M/95801M
Instance name: c2kprod
Redo thread mounted by this instance: 1
Oracle process number: 30
Windows thread id: 5552, image: ORACLE.EXE (J002)

*** 2012-10-27 00:10:17.259
*** SESSION ID:(394.10451) 2012-10-27 00:10:17.259
*** CLIENT ID:() 2012-10-27 00:10:17.259
*** SERVICE NAME:(SYS$USERS) 2012-10-27 00:10:17.259
*** MODULE NAME:() 2012-10-27 00:10:17.259
*** ACTION NAME:() 2012-10-27 00:10:17.259

ORA-12012: error on auto execute of job 19030
ORA-01403: no data found
ORA-06512: at line 1
Trace file C:\APP\MANAGER\diag\rdbms\c2kprod\c2kprod\trace\c2kprod_j002_5552.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 24 - type 8664, 2 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:7765M/32756M, Ph+PgF:70412M/95801M
Instance name: c2kprod
Redo thread mounted by this instance: 1
Oracle process number: 260
Windows thread id: 5552, image: ORACLE.EXE (J002)

*** 2012-11-06 13:50:27.895
*** SESSION ID:(1282.5387) 2012-11-06 13:50:27.895
*** CLIENT ID:() 2012-11-06 13:50:27.895
*** SERVICE NAME:(SYS$USERS) 2012-11-06 13:50:27.895
*** MODULE NAME:() 2012-11-06 13:50:27.895
*** ACTION NAME:() 2012-11-06 13:50:27.895

ORA-12012: error on auto execute of job 68977
ORA-01403: no data found
ORA-06512: at line 1
Trace file C:\APP\MANAGER\diag\rdbms\c2kprod\c2kprod\trace\c2kprod_j002_5552.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 24 - type 8664, 2 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:13738M/32756M, Ph+PgF:77307M/95801M
Instance name: c2kprod
Redo thread mounted by this instance: 1
Oracle process number: 165
Windows thread id: 5552, image: ORACLE.EXE (J002)

*** 2012-12-03 11:23:33.693
*** SESSION ID:(1350.229) 2012-12-03 11:23:33.693
*** CLIENT ID:() 2012-12-03 11:23:33.693
*** SERVICE NAME:(SYS$USERS) 2012-12-03 11:23:33.693
*** MODULE NAME:() 2012-12-03 11:23:33.693
*** ACTION NAME:() 2012-12-03 11:23:33.693

ORA-12012: error on auto execute of job 179297
ORA-01403: no data found
ORA-06512: at line 1

Can anybody please tell what happened and what is solution for this.
Thanks
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points