EM12c: ORA-01878 When Attempting to Access Exadata Storage Cell Metrics (Doc ID 2107086.1)

Last updated on FEBRUARY 16, 2016

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 to 13.1.1.0.0 [Release 12.1 to 13.1]
Enterprise Manager for Exadata - Version 12.1.0.4.0 to 13.1.1.0.0 [Release 12.1 to 13.1]
Information in this document applies to any platform.

Symptoms

When trying to access the metrics of Exadata Storage cells - for example:  Monitoring -> All Metrics -> Exadata Cell Metric -> CPU Utilization - the following errors are generated in a popup window:

"Error retrieving information from database. Exception: ORA-01878: specified field not found in datetime or interval
java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval
oracle.sysman.emSDK.app.exception.EMSystemException"

"JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-20206: Target does not exist: :
ORA-06512: at "SYSMAN.MGMT_TARGET", line 1228
ORA-06512: at "SYSMAN.EM_MONITORING", line 62
ORA-06512: at line 1
JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-20206: Target does not exist: :
ORA-06512: at "SYSMAN.MGMT_TARGET", line 1228
ORA-06512: at "SYSMAN.EM_MONITORING", line 62
ORA-06512: at line 1"

Your monitored target is located in the Brazilian Sao Paulo time zone.

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