Use Enterprise Manager to Manage and Monitor Databases

You can use Oracle Enterprise Manager to manage and monitor Autonomous Transaction Processing dedicated databases.

Note:

You must be using, at a minimum, Enterprise Manager version 13.3 with EM DB Plugin Bundle Patch 13.3.2.0.190731 to manage and monitor dedicated databases.

Enterprise Manager is Oracle’s management platform, providing a single pane of glass for managing all of your Oracle deployments, whether in your data centers or in Oracle Cloud. Through deep integration with Oracle’s product stack, Enterprise Manager provides market-leading management and automation support for Oracle applications, databases, middleware, hardware and engineered systems.

To use Enterprise Manager to manage and monitor your dedicated database, you perform these high-level tasks:

  1. Configure connectivity between your Enterprise Manager deployment (whether on-premises or on Oracle Cloud Infrastructure Marketplace) and your Autonomous Transaction Processing dedicated database.

  2. Use the Enterprise Manager console, CLI or REST API to discover the dedicated database and add it as a target.

For detailed steps to perform these tasks, see Discover Autonomous Databases in Enterprise Manager Cloud Control Administrator's Guide for Oracle Autonomous Databases.

After performing the discovery tasks, you can use Enterprise Manager to:

  • Monitor the health and performance of your database and perform deep diagnostics on the Performance Hub.
  • Perform database administration tasks such as storage management, and schema management tasks such as creating database objects.

For details about how to use these features, see Monitoring and Administration Tasks in Enterprise Manager Cloud Control Administrator's Guide for Oracle Autonomous Databases.