My Oracle Support Banner

Master Note for Enterprise Manager Configuration Assistant (EMCA) in Single Instance Database Environment (Doc ID 1099271.1)

Last updated on OCTOBER 24, 2019

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.

Purpose

This Master Note helps the reader to understand the EMCA utility used to perform Enterprise Manager (EM) Database Control configurations and provides assistance in using diagnostics to effectively debug, troubleshoot and resolve possible problems.

Attention: In Enterprise Manager Database Control with Oracle Database 10.2.0.4 and 10.2.0.5, the root certificate used to secure communications via the Secure Socket Layer (SSL) protocol expired on 31-Dec-2010 00:00:00. The certificate expiration will cause errors if you attempt to configure Database Control on or after 31-Dec-2010.
Existing Database Control configurations are not affected by this issue. If you are in the following situations:

* Have an existing Oracle Database 10.2.0.4 or 10.2.0.5 installation and plan to configure or re-configure Database Control on or after 31-Dec-2010. Database Control is configured when using one of the following tools:
• Database Configuration Assistant (DBCA)
• Database Upgrade Assistant (DBUA)
• Enterprise Manager Configuration Assistant (EMCA)
* Plan to install Oracle Database 10.2.0.4 or 10.2.0.5 on or after 31-Dec-2010 and intend to configure Database Control

then refer to <Note: 1217493.1> ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - Patch Required from 31-Dec-2010 onwards

Scope

This document is intended to assist Database Administrators to effectively troubleshoot EMCA failures in different scenarios. This document covers the following topics:

About EMCA
How to Perform EMCA Operations
Diagnostic Tools
Troubleshooting EMCA Failures

If you would like to discuss the features of EMCA with other EMCA users or Oracle Support, please feel free to join in the EM MOS Community discussion:

Details

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
Purpose
Scope
Details
 All About EMCA
 1. EMCA Concepts
 2. EMCA Documentation
 Oracle Database 11g Release 2
 Oracle Database 11g Release 1
 Oracle Database 10g Release 2
 3. EMCA Syntax
 4. Prerequisites for running the EMCA command
 How to Perform EMCA Operations
 1. How to create Database Control using EMCA
 2. How to drop Database Control using EMCA or manually (with and without repository)
 3. How to recreate Database Control using EMCA
 4. How to change ports for Database Control using EMCA commands
 Diagnostic Tools
 Troubleshooting EMCA Failures
 1. EMCA failing while connecting to Database
 2. EMCA failing due to Oracle Home software related issues
 3. EMCA failing due to Hostname and Port related issues
 4. EMCA failing due to Database or OS configuration
 5. EMCA failing due to SYSMAN and other existing objects during re-configuration
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.