EM12c: ORA-01878 When Attempting to Access Exadata Storage Cell Metrics
(Doc ID 2107086.1)
Last updated on AUGUST 22, 2023
Applies to:
Enterprise Manager Base Platform - Version 12.1.0.4.0 to 13.1.1.0.0 [Release 12.1 to 13c]Enterprise Manager for Exadata - Version 12.1.0.4.0 to 13.1.1.0.0 [Release 12.1 to 13c]
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |