My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.