My Oracle Support Banner

EM 13.4 : OMS RU 10 Fails With - ORA-01870: the intervals or datetimes are not mutually comparable (Doc ID 2774630.1)

Last updated on MAY 11, 2021

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 to 13.4.1.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

Applying EM 13c Release 4 Update 10 (13.4.0.10) Patch fails while performing the Repository database artifacts.

32318082 - Oracle Enterprise Manager 13c Release 4 Update 10 (13.4.0.10) for Oracle Management Service

/<MIDDLEWARE_HOME>/oracle_common/rcu/log/empatch/logs/rcu_<TIMESTAMP>.log


The following artifact(s) have failed in deployment:

  Artifacts Log file
  --------- --------
SQL rcu_applypatch_original_patch_2021-04-23_11-42-56AM.log
OMSPatcher failed to execute some of the patching steps. Please check the Patching summary,individual logs and
try to resolve the issue. Once the issue is resolved,Please execute below script to complete patching session:
"/2725678.1/.omspatcher_storage/oms_session/scripts_2021-04-23_11-34-34AM/run_script_singleoms_resume.sh"
our DBA tried to fix the issue, but got no luck, after running the resume script, this is what I got:
Error encountered executing SQL statement FileName: '/2725678.1/sysman/emdrep/config/patch/sql/patchPostAction.sql' LineNumber: '29'
SQL Statement: [DECLARE
BEGIN
MGMT_PATCH_UTIL.MGMT_PATCH_POST_ACTION(MGMT_PATCH_UTIL.G_PATCH_MODE_APPLY);
END;
]
java.sql.SQLDataException: ORA-01870: the intervals or datetimes are not mutually comparable
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 1145
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 1145
ORA-06512: at "SYS.DBMS_ISCHED", line 3215
ORA-06512: at "SYS.DBMS_SCHEDULER", line 3035
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 1139
ORA-06512: at "SYSMAN.MGMT_PATCH_UTIL", line 299
ORA-01870: the intervals or datetimes are not mutually comparable
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 1145
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 1145
ORA-06512: at "SYS.DBMS_ISCHED", line 3215
ORA-06512: at "SYS.DBMS_SCHEDULER", line 3035
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 1139
ORA-06512: at "SYSMAN.MGMT_PATCH_UTIL", line 288
ORA-06512: at line 5

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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