ORA-12012 and ORA-1403 Occurred on Auto Execute of JOB (Doc ID 1416056.1)

Last updated on AUGUST 06, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.1.0.6 to 11.1.0.6 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2016***

Symptoms

On 11.1.0.6, the following errors are reported in the alert log and trace file:

Alert log :

Sat Jan 28 09:23:30 2012
Errors in file e:\app\administrator\diag\rdbms\sysg\sysg\trace\sysg_j005_3440.trc:
ORA-12012: error on auto execute of job 11689
ORA-01403: no data found



Referenced trace file :

*** MODULE NAME:(DBMS_SCHEDULER) 2012-01-28 09:23:30.125
*** ACTION NAME:(BSLN_MAINTAIN_STATS_JOB) 2012-01-28 09:23:30.125


*** 2012-01-28 09:23:30.125
ORA-12012: error on auto execute of job 11689
ORA-01403: no data found

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms