OEM 13c: OEM Cloud Control Will Not Start with Invalid Objects in OEM Database Repository (Doc ID 2778289.1)

Last updated on JULY 13, 2021

Applies to:

Symptoms

On : 13.4.0.0.0 version, OMS

OEM Cloud Control Will Not Start with Invalid Objects in OEM Database Repository

emoms.log shows the following:

00009,0:1056:13:74] [APP: empbs] [partition-name: DOMAIN] [tenant-name: GLOBAL] Encountered an unexpected error during initialization: ORA-04063: package body "SYSMAN.EM_MTM_PKG" has errors[[
ORA-06512: at "SYSMAN.EM_NOTIFY_DEVICE", line 616
ORA-06512: at line 1
 java.sql.SQLException: ORA-04063: package body "SYSMAN.EM_MTM_PKG" has errors
ORA-06512: at "SYSMAN.EM_NOTIFY_DEVICE", line 616
ORA-06512: at line 1

  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:224)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:57)
  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:908)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3833)
  at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1301)
  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3940)
  at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableState

ERROR
-----------------------
ORA-06512

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.