Getting "'MGMT_TIME_SYNC.STARTUPSYNC' must be declared" error after Dbconsole creation (Doc ID 1498439.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Database control creation is failing with following errors:

The emca* log file generated while doing database control configuration has following errors:

 

INFO: Securing Database Control (this may take a while) ...
Oct 13, 2012 1:05:09 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/oracle/product/11.2.0/bin/emctl config emkey -repos
Oct 13, 2012 1:05:09 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed.
Oct 13, 2012 1:05:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
WARNING: Error securing Database control.
Oct 13, 2012 1:05:09 PM oracle.sysman.emcp.EMDBPostConfig setWarnMsg
INFO: Error securing Database Control, Database Control has been brought up in non-secure mode.

 

 'emctl status emkey' command output gives following errors:

 

[oracle@test log]$ emctl status emkey
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Please enter repository password:

Exception caught
ORA-06550: line 1, column 13:
PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:73)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:472)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:422)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1089)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:200)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1029)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1347)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3556)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3727)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:8130)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1209)
at oracle.sysman.emSDK.conf.ConfigManager.startupEmKey(ConfigManager.java:539)
at oracle.sysman.emSDK.conf.ConfigManager.statusEmKeyInRepos(ConfigManager.java:797)
at oracle.sysman.eml.sec.rep.EmKeyUtil.statusEmKey(EmKeyUtil.java:264)
at oracle.sysman.eml.sec.rep.EmKeyUtil.main(EmKeyUtil.java:572)

 emoms.trc has following errors:

 

2012-10-13 11:13:44,295 [HTTPThreadGroup-2] ERROR eml.OMSHandshake processFailure.806 - OMSHandshake failed.(AGENT URL = http://test.oracle.com:3938/emd/main)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: EM Key is Missing)
2012-10-13 11:13:55,869 [HTTPThreadGroup-2] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = ORA-06550: line 1, column 7:
PLS-00201: identifier 'SETEMUSERCONTEXT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

2012-10-13 11:13:55,871 [EMUI_11_13_55_/console/aboutApplication] ERROR svlt.PageHandler handleRequest.639 - java.lang.IllegalStateException: Response has already been committed
java.lang.IllegalStateException: Response has already been committed
at com.evermind.server.http.EvermindHttpServletResponse.resetBuffer(EvermindHttpServletResponse.java:1892)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:249)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
at oracle.sysman.emSDK.svlt.PageHandler.render(PageHandler.java:1113)


Software library configuration failed. Provisioning archives are deployed. Please configure it manually.

  

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