1 2 Previous Next 16 Replies Latest reply: Dec 5, 2012 6:02 AM by spajdy RSS

    Error on auto execute of job

    Santosh Pradhan
      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