Joords Oracle DBA blog

When using "emca -config dbcontrol db -repos create -cluster" on a RAC Database the installation of EM database Control fails. Investigation of the logs will see an error in the emca_repos_config_ .log

The Problem Enterprise Manager Database Control with Oracle Database 10.2.0.4 and 10.2.0.5 " The DBCONSOLE" will not work. The root certificate used to secure communications via the Secure Socket Layer (SSL) protocol will expire on 31-Dec-2010 00:00:00.  ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - Patch Required from 31-Dec-2010 onwards [ID 1217493.1] Solving this problem If you plan to configure Database Control with either of these Oracle Database releases, Oracle strongly recommends that you apply   Patch 8350262   to your Oracle Home installations before you configure Database Control. Configuration of Database Control is typically done when you create or upgrade Oracle Database, or if you run Enterprise Manager Configuration Assistant (EMCA) in standalone mode.

Step-By-Step - DBconsole RAC Uninstall WARNING: The uninstall process will Quiesce the database. Do not run on a live system 1. Ensure you have the following information before continuing. Database unique name Listener port number Password for SYS user Password for SYSMAN user 2. Log onto any node in the cluster. 3. Set-up your environment . oraenv ORACLE_SID = [SID] ? enter sid 4. Deconfigure dbconsole and drop the repository emca -deconfig dbcontrol db -repos drop -cluster