EM12c/13c: Metrics Thresholds are failing with Internal Error has occurred. Check the log file for details.

(Doc ID 2184902.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.4 to 12.1.0.1.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Unable to update the Metric Thresholds for the ASM/Cluster/Rac database targets.

UI error shows:

Internal Error has occurred. Check the log file for details.

 

emoms.trc
2016-08-29 07:47:01,672 [EMUI_07_46_59_/console/metrics/target/metricThresholds] WARN target.MonitoringSettingsController handleOKEvent.775 - ORA-04063: package body "SYSMAN.EM_TEMPLATE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.EM_TEMPLATE"
ORA-06512: at "SYSMAN.MGMT_MONITORING", line 121
ORA-06512: at "SYSMAN.EMD_MNTR", line 12041
ORA-06512: at line 1

java.sql.SQLException: ORA-04063: package body "SYSMAN.EM_TEMPLATE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.EM_TEMPLATE"
ORA-06512: at "SYSMAN.MGMT_MONITORING", line 121
ORA-06512: at "SYSMAN.EMD_MNTR", line 12041
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

 

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