Oracle Applications and Database Monitoring Tools

Database Monitoring Tools

Database management involves the monitoring, administration, and maintenance of the databases and database groups in your enterprise. Enterprise Manager is the premier tool for managing your database environment.

With Enterprise Manager, you receive:

·         A complete set of integrated features for managing Oracle Databases

·         Unparalleled scalability that lets you manage a single database or thousands of instances

·         An intuitive management product that leads the industry in ease of deployment and use

There are two flavors of Enterprise Manager

1.       Oracle Enterprise Manager DBCosole or DBControl

2.       Oracle Enterprise Manager Grid Control

OEM DBConsole

·         Database Control is the Enterprise Manager Web-based application for managing Oracle Database 11g Release 1 (11.1) and later

·         Database Control is installed and available with every Oracle Database 11g installation

·         From Database Control, you can monitor and administer a single Oracle Database instance

·         There is no extra hardware, software or licensing cost to use it

OEM Grid Control

·         Grid Control is the Enterprise Manager console you use to centrally manage your entire Oracle environment

·         Within Grid Control, you access the multiple database targets using the Targets tab, then Databases

·         It also provide GUI interface for Oracle Data Guard

·         Separate server is required to install OEM 11g Grid Control

·         Additional software installation and licensing of the following is required to use OEM Grid Control

1.       Oracle WebLogic Server 11g Release 1

2.       Oracle Enterprise Manager Grid Control 11g Release 1

3.       Oracle Database 11g Release 1 or 2

Oracle E-Business Suite Monitoring Tools

The Oracle E-Business Suite Plug-in 4.0 can be used to manage Oracle E-Business Suite systems.

• The Oracle E-Business Suite Plug-in 4.0 includes functionality that was available in previous releases of the Oracle Application Management Pack for E-Business Suite (AMP) and the Oracle Application Change Management Pack for E-Business Suite (ACMP).
• All of the functionality that was previously available for AMP is now classified as "System Management for E-Business Suite".
• All of the functionality that was previously available for ACMP is now classified as "Change Management for E-Business Suite".

System Management for Oracle E-Business Suite

Oracle E-Business Suite Plug-in extends Enterprise Manager Grid Control to monitor and manage Oracle E-Business Suite systems.

This new release of Oracle E-Business Suite Plug-in offers the following key capabilities:

• Oracle Enterprise Manager 11g Grid Control Support: All components of the management suite are certified with Oracle Enterprise Manager 11g Grid Control.
• Built-in Diagnostic Ability: Release 4.0 has numerous major enhancements that provide the necessary intelligence to determine if the product has been installed and configured correctly. There are diagnostics for Discovery, Cloning, and User Monitoring that will validate if the appropriate patches, privileges, setups, and profile options have been configured. This feature improves the setup and configuration time to be up and operational.

Change Management for Oracle E-Business Suite

Oracle E-Business Suite Plug-in is Oracle's offering for customers to monitor and manage Oracle E-Business Suite changes. Application Change Management Pack Plug-in provides a centralized view to monitor and orchestrate changes (both functional and technical) across multiple Oracle E-Business Suite systems.

In Release 4.0 Oracle E-Business Suite Plug-in has been enhanced to provide more control and flexibility in managing Oracle E-Business Suite changes.