Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Error:
When the database is upgraded to version 10.2.0.4 or 10.2.0.5, the Enterprise Manager configuration ends with an error and fails to start manually.
Reason:
Bug 8350262
Solution:
After the update is finished, manually create EM repository with emca.
1 2 | emca -config dbcontrol db -repos recreate -cluster // For RAC emca -config dbcontrol db -repos recreate // For Single Instance |
You may get an error like this when doing this.
Jan 11, 2011 4:18:05 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) …
Jan 11, 2011 4:19:31 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Jan 11, 2011 4:28:38 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at /myhost/oracle/product/10.2.0/db_1/cfgtoollogs/emca/catest/emca_2011-01-11_
04-11-01-PM.log for more details.
Could not complete the configuration. Refer to the log file at /myhost/oracle/product/10.2.0/db_
1/cfgtoollogs/emca/catest/emca_2011-01-11_04-11-01-PM.log for more details.
If this process is completed with an error like above, you can install the patch 8350262 with Opatch and start EM with the following commands.
1 2 3 | <ORACLE_HOME>/bin/emctl secure dbconsole -reset <ORACLE_HOME>/bin/emctl secure dbconsole // This step will apply if there is rac. <ORACLE_HOME>/bin/emctl start dbconsole |
