Tuesday, April 19, 2011

Patch for Enterprise Manager Database Control Or

The Problem
Enterprise Manager Database Control with Oracle Database and " 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 Or - 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.


  1. I have no words for this great post such a awe-some information i got gathered. Thanks to Author.

  2. i have same problem with my "DBCONSOLE" doesn't work, today apply the Patch 8350262 but with one Warning (see down). Then i want to apply this command :
    "emca -config dbcontrol db -repos recreate" but i don't know what exactly it does and what information\File ist important to secure(Backup) and if i want use this command affects functionality for my database? pls could u help me. :)

    ..oracle\product\10.2.0\db_1\OPatch\8350262>opatch apply
    Invoking OPatch

    Oracle Interim Patch Installer version
    Copyright (c) 2007, Oracle Corporation. All rights reserved.
    Oracle Home : e:\oracle\product\10.2.0\db_1
    Central Inventory : C:\Program Files\Oracle\Inventory
    from : n/a
    OPatch version :
    OUI version :
    OUI location : e:\oracle\product\10.2.0\db_1\oui
    Log file location : e:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch2013-01-28_11-10-42AM.log

    ApplySession applying interim patch '8350262' to OH 'e:\oracle\product\10.2.0\db_1'

    Running prerequisite checks...

    OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

    Backing up files and inventory (not for auto-rollback) for the Oracle Home
    Backing up files affected by the patch '8350262' for restore. This might take a
    Backing up files affected by the patch '8350262' for rollback. This might take a

    Patching component oracle.sysman.agent.core,
    Updating jar file "e:\oracle\product\10.2.0\db_1\sysman\jlib\emCORE.jar" with "\
    ApplySession adding interim patch '8350262' to inventory

    Verifying the update...
    Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventory with
    proper meta-data.
    Files check OK: Files from Patch ID 8350262 are present in Oracle Home.
    ----------------------------------------------------------------------The following warnings have occurred during OPatch execution:
    1) OUI-67294:
    **********************************************************************Oracle Configuration Manager is installed but not configured. OCM enables Oracl
    e to
    provide superior, proactive support for our customers. Oracle strongly recommend
    s customers
    configure OCM. To complete the configuration of OCM, refer to the OCM Installati
    on and
    Administration Guide (http://www.oracle.com/technology/documentation/ocm.html).
    OPatch Session completed with warnings.
    OPatch completed with warnings.

  3. See http://joordsblog.vandenoord.eu/2010/06/how-to-install-and-deinstall-dbconsole.html link for installing and deinstalling from the DBCONSOLE.