How To Verify if the EM Database Control Console Software is Installed and Database Console is Configured For a Database in an ORACLE_HOME

How To Verify if the EM Database Control Console Software is Installed and Database Console is Configured For a Database in an ORACLE_HOME

1.Check if the Database Console / Enterprise Manager Software is installed under the ORACLE_HOME.
The ORACLE_HOME should have the following nine software components installed which can be verified using the "opatch lsinventory -detail" command.

10.2 sample:

opatch lsinventory -detail|grep Manager
Enterprise Manager Agent Core 10.2.0.1.0
Enterprise Manager Agent Core Patch 10.2.0.5.0a
Enterprise Manager Agent DB 10.2.0.1.0
Enterprise Manager Agent DB 10.2.0.5.0
Enterprise Manager Baseline 10.2.0.1.0
Enterprise Manager Baseline 10.2.0.5.0
Enterprise Manager Common Core Patch 10.2.0.5.0a
Enterprise Manager Common Files 10.2.0.1.0
Enterprise Manager Minimal Integration 10.2.0.1.0
Enterprise Manager Minimal Integration 10.2.0.5.0
Enterprise Manager plugin Common Files 10.2.0.1.0
Enterprise Manager plugin Common Files 10.2.0.1.0
Enterprise Manager plugin Common Files Patch 10.2.0.5.0
Enterprise Manager Repository Core 10.2.0.1.0
Enterprise Manager Repository Core patch 10.2.0.5.0a
Enterprise Manager Repository DB 10.2.0.1.0
Enterprise Manager Repository DB 10.2.0.5.0
Oracle Enterprise Manager Console DB 10.2.0.1.0
Oracle Enterprise Manager Console DB 10.2.0.5.0

11.1 sample:

opatch lsinventory -detail|grep Manager
Enterprise Manager Agent 10.2.0.3.1
Enterprise Manager Agent Core Files 10.2.0.3.1
Enterprise Manager Agent Core Files Patch 10.2.0.4.1
Enterprise Manager Agent Patch 10.2.0.4.1
Enterprise Manager Common Core Files 10.2.0.3.1
Enterprise Manager Common Core Files Patch 10.2.0.4.1
Enterprise Manager Common Files 10.2.0.3.1
Enterprise Manager Common Files Patch 10.2.0.4.1
Enterprise Manager Database Plugin -- Agent Support 11.1.0.5.0
Enterprise Manager Database Plugin -- Agent Support Patch 11.1.0.7.0
Enterprise Manager Database Plugin -- Management Service Support 11.1.0.5.0
Enterprise Manager Database Plugin -- Repository Support 11.1.0.5.0
Enterprise Manager Database Plugin -- Repository Support Patch 11.1.0.7.0
Enterprise Manager Grid Control Core Files 10.2.0.3.1
Enterprise Manager Grid Control Core Files Patch 10.2.0.4.1
Enterprise Manager Minimal Integration 11.1.0.6.0
Enterprise Manager plugin Common Files 11.1.0.5.0
Enterprise Manager plugin Common Files Patch 11.1.0.7.0
Enterprise Manager Repository Core Files 10.2.0.3.1
Enterprise Manager Repository Core Files 10.2.0.4.1
Oracle Enterprise Manager Console DB 11.1.0.5.0
Oracle Enterprise Manager Database Console Patch 11.1.0.7.0

11.2 sample:

opatch lsinventory -detail|grep Manager
Enterprise Manager Agent 10.2.0.4.3
Enterprise Manager Agent Core Files 10.2.0.4.3
Enterprise Manager Common Core Files 10.2.0.4.3
Enterprise Manager Common Files 10.2.0.4.3
Enterprise Manager Database Plugin -- Agent Support 11.2.0.2.0
Enterprise Manager Database Plugin -- Repository Support 11.2.0.2.0
Enterprise Manager Grid Control Core Files 10.2.0.4.3
Enterprise Manager plugin Common Files 11.2.0.2.0
Enterprise Manager Repository Core Files 10.2.0.4.3
Oracle Enterprise Manager Console DB 11.2.0.2.0

2.To verify DBConsole is configured for a particular database:

A.Check the presence of <hostname>_<sid> under <ORACLE_HOME> and OC4J_DBConsole_<hostanme>_<SID> under <ORACLE_HOME>/oc4j/j2ee. For each database under the ORACLE_HOME, above directories with respective Hostname and SID exists if DBConsole is configured for the database.

B.Check for "Oracle Enterprise Manager" component in dba_registry.
SQL > select COMP_NAME, STATUS from dba_registry where COMP_NAME like '%Enterprise Manager%';

If DBConsole is configured, above sql should return one row for "Oracle Enterprise Manager" component from dba_registry. If DBConsole is not configured for the database, the "Oracle Enterprise Manager" component does not exist in dba_registry and above SQL should return zero rows.