OEM 13.5: After DST Change the OEM DB Repository Throws the Error “Ora-01878: Specified Field Not Found in Datetime or Interval” (Doc ID 2937124.1)

Last updated on MARCH 22, 2023

Applies to:

Symptoms

On : 13.5.0.0.0 version,

Post OEM Upgrade from 13.4 to 13.5 and DST change the below alert is thrown from OEM Repository DB.

Host=<Hostname>
Target type=Database Instance
Target name=<Repository DB Name>
Categories=Error
Message=ORA-01878: specified field not found in datetime or interval
Severity=Critical
Event reported time=Mar 19, 2023 1:59:58 AM CDT
Target Lifecycle Status=Production
Operating System=Linux
Platform=x86_64
Associated Incident Id=21094
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=None
Associated Incident Escalation Level=0
Event Type=Metric Evaluation Error
Event name=db_autotask_client
Metric Group=AutoTask Client
Collection Name=oracle_dbconfig
Rule Name=Rule Set for Prod,Compress metric collection error events for a target
Rule Owner=SYSMAN
Update Details:
ORA-01878: specified field not found in datetime or interval
Incident created by rule (Name = Rule Set for Prod, Compress metric collection error events for a target; Owner = SYSMAN).
 

ERROR
-----------------------
ORA-01878

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.