Ora-01878: Specified Field Not Found In Datetime Or Interval in Alert.log after DST change (Doc ID 1328496.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.1.0.7 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2016***
Oracle RDBMS 11.1.0.7 , 11.2.0.1 and 11.2.0.2


Symptoms

Errors like

Tue Jun 07 10:44:30 2011
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_j000_10012.trc:
ORA-12012: error on auto execute of job 3
ORA-01878: specified field not found in datetime or interval
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_j000_10012.trc:
ORA-12012: error on auto execute of job 4002
ORA-01878: specified field not found in datetime or interval


are seen repeatedly in the alert.log and the Trace file contains errors like


Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
ORACLE_HOME = /u01/app/oracle/product/11.2.0
System name: Linux
Node name: host
Release: 2.6.18-164.el5
Version: #1 SMP Tue Aug 18 15:51:48 EDT 2009
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 132
Unix process pid: 10012, image: oracle@host (J000)


*** 2011-06-07 10:44:30.926
*** SESSION ID:(39.14490) 2011-06-07 10:44:30.926
*** CLIENT ID:() 2011-06-07 10:44:30.926
*** SERVICE NAME:(SYS$USERS) 2011-06-07 10:44:30.926
*** MODULE NAME:() 2011-06-07 10:44:30.926
*** ACTION NAME:() 2011-06-07 10:44:30.926

ORA-12012: error on auto execute of job 3
ORA-01878: specified field not found in datetime or interval

*** 2011-06-07 10:44:30.928
ORA-12012: error on auto execute of job 4002
ORA-01878: specified field not found in datetime or interval

Changes

There was a DST transition that had the clock "moving forward" when the error started to appear.

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