OID (TSPurge) DBMS Jobs Are Stuck After DST Time Change / Alert.log Error: ORA-01878 (Doc ID 1318547.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Internet Directory - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Database (DB) 11gR2 used as repository for Oracle Internet Directory (OID) 11g, i.e., 11.1.1.2.0.

OID database DBMS jobs scheduled by default installation to run in the 2am-3am timeframe end up being "stuck," and error ORA-01878 is logged in the alert log every 1-2 minutes.

This started happening since the time changed on US Central site for Daylight Savings Time (DST).

In reviewing the ODS (OID DB schema) jobs:

SQL> select job,last_date,last_sec,next_date,next_sec,this_date,this_sec, broken,what from user_jobs;


The following three are stuck and/or broken:


JOB   NEXT_DATE                     SCHEMA_USER  WHAT
----- ----------------------------- ------------ ----------------------------
63    13-Mar-2011 02:00:00          ODS
DECLARE rc integer ; BEGIN rc := TSPurge.purgeDirObject('cn=comparefailure stats purgeconfig' ); END;

64    13-Mar-2011 02:15:00          ODS
DECLARE rc integer ; BEGIN rc := TSPurge.purgeDirObject('cn=comparesec stats purgeconfig' ); END;

65    13-Mar-2011 02:30:00          ODS
DECLARE rc integer ; BEGIN rc := TSPurge.purgeDirObject('cn=bindsec stats purgeconfig' ); END;


Oracle database alert.log file messages reported are as follows:

ORA-12012: error on auto execute of job 63
ORA-01878: specified field not found in datetime or interval
Errors in file /opt/oracle/diag/rdbms/spldpd1/SPLDPD1/trace/SPLDPD1_j000_23626.trc:
ORA-12012: error on auto execute of job 64
ORA-01878: specified field not found in datetime or interval
Errors in file /opt/oracle/diag/rdbms/spldpd1/SPLDPD1/trace/SPLDPD1_j000_23626.trc:
ORA-12012: error on auto execute of job 65
ORA-01878: specified field not found in datetime or interval

Changes

Oracle database server clock changed to DST on US Central site.

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