Enterprise Manager

Oracle Enterprise Manager provides a comprehensive monitoring and management solution for Oracle Database and Engineered Systems deployed in cloud and customer data centers. Customers can run Enterprise Manager on-premises and in Oracle Cloud Infrastructure.

In this interview with Wim Coekaerts, SVP, Oracle, theCUBE explores questions on why Oracle supports a broad array of deployment architectures for cloud and on-premises, and the importance of end-to-end observability and management.

A recent survey by Pique Solutions showed that companies using Enterprise Manager lowered operational management costs by more than 60%. Read the full report to discover all the business benefits of Enterprise Manager.

Watch Edward Screven, Oracle’s Chief Corporate Architect, and Mughees A. Minhas, Oracle's Vice President of Product Management, to learn about the new capabilities in Oracle Enterprise Manager 13c Release 5.

Don’t miss the pre-event Enterprise Manager Master Class at CloudWorld.

Explore Oracle Enterprise Manager

Database performance management

Find, fix, validate

Monitor and manage an entire Oracle Database estate from a top-level view across cloud and on-premises. Integrated and automated deep dive analytics help DBAs quickly find performance problems, fix them, and validate the fixes before promoting them to production.

Find

• Provides built-in powerful, automated, and integrated diagnostics
• Automatic Database Diagnostic Monitor (ADDM) - built into the Oracle Database kernel simplifies identifying performance issues
• Automatic Workload Repository (AWR) and Active Session History (ASH) automatically collect and analyze database performance data
• Monitors and provides alerts and notifications for the database instance and host operating system

Fix

• SQL Tuning Advisor automatically provides comprehensive SQL tuning recommendations
• SQL Profiles transparently improve application SQL performance without need for patches
• SQL Access Advisor recommends structures to optimize performance
• Real-time SQL Monitoring and Database Operations Monitoring provide insights into SQL and PL/SQL job executions

Validate

• Comprehensive real-world testing reduces risk due to unexpected problems encountered in the production systems with minimal effort
• Database Replay captures the database workload on a production system, and replays it on a test system to speed validation testing
• SQL Performance Analyzer (SPA) provides fine-grain assessment of the impact of system changes on SQL response times
• Seamless integration with SQL Tuning Advisor and SQL Plan Baselines helps eliminate SQL performance regressions

• Blog: The Best Kept Secret for Database Performance Monitoring
• ASH Mash! A tour of the amazing Active Session History (1:04:40)
• Livelabs: EM - Database Performance Management: Find-Fix-Validate Workshop

Database Ops Automation

Automate operations at scale

A rich set of features supports database consolidation, enforces standardization, and automates time-consuming tasks. Enterprise Manager provides complete Ops automation including provisioning new clusters, patching, and upgrading databases as well as configuration and compliance management—all essential for organizations embracing automation.

Automated provisioning and cloning

• Out-of-the-box deployment procedures to provision and clone Oracle Databases (Single Instance, CDB, PDB and RAC) including the operating system
• Provision new databases from a gold image
• Create rapid clones of large production databases with integrated data masking

Automated, scalable Fleet Maintenance

• Simplifies patching and upgrades of the entire fleet of Oracle Database and Oracle Grid Infrastructure
• Improves predictability of database operations using gold image and preflight checks
• Minimizes touchpoints by providing end-to-end automation, including credentials, alerts blackouts, configuration, and compliance
• Reduces MTTR with a rich UI that provides actionable insights when things go wrong

Configuration management

• Standardize on configurations to reduce security risks and maintenance cost
• On-demand comparison, drift detection at scale
• Leverage configuration extensions to augment comparison and drift detection

Security and compliance enforcement

• Automate built-in security controls up and down the stack from database to infrastructure
• Manage database security posture and compliance with CIS, STIG, and customized policies
• Secure Linux hosts with industry standards such as STIG, PCI-DSS, and HIPAA profiles
• Leverage Oracle Autonomous Health Framework (AHF) compliance standards to secure all engineered- system components

Database Migration Workbench

• Perform database migrations and consolidations efficiently and less risk
• Automate identification and repair of source targets with advisors
• Monitor detailed steps of migration in real time
• Analyze and optimize the performance of the newly migrated database

Database as a Service

• Self-service portal to deploy databases on designated zones
• Role based Service Catalog with standardized database configuration templates
• Automation via RESTful APIs and CLI
• Metering, Show back, and Chargeback

• Overview: Patch and Upgrade Oracle Databases with Fleet Maintenance (PDF)
• Blog: Next Generation Database Fleet Maintenance
• Case Study: Comcast Database self-service patching Fleet Maintenance (PDF)
• Fleet Maintenance Documentation
• EM Database Migration Workbench Demo (13:44)
• Demo: Fleet Maintenance—Patching GI and RAC (8:02)

Exadata Management

Monitor and manage Exadata components as one

Meet Exadata management challenges with easy access to all Exadata components. Monitor all databases, clusters, and hardware components in a single view. Use alerting, monitoring, and configuration management to stay current on status. Optimize for consolidation without overprovisioning.

Discovery

• Discover all Exadata components automatically Monitor
• See relationships between hardware and software components with topology view
• Monitor storage cells down to discs, Flash, and I/O performance
• Monitor the impact of IORM and other configurations
• See utilization of CPU, storage, and memory on all servers in one view

Manage

• Use automated alerts to get ahead of potential issues
• Discover IORM changes on storage grid or individual storage cells to ensure resources to key applications
• Manage InfiniBand switches from Enterprise Manager

Capacity Planning and Migration

• Monitor utilization history and use it for predictive capacity analysis
• Estimate capacity needs for consolidation and migration with Database Migration Planner
• Optimize migration strategy to meet SLAs with Database Migration Workbench
• Validate migration with Real Application Testing to proactively eliminate regression

• Docs: Oracle Exadata Database Machine Getting Started Guide
• Docs: Oracle Enterprise Manager Cloud Control for Oracle Exadata Cloud

Enterprise Monitoring

Smarter, scalable single-pane-of-glass monitoring

With deep monitoring for Oracle Database, including Oracle Autonomous Database, Exadata, Middleware, packaged applications, get complete visibility into your stack running on-premises or on Oracle Cloud Infrastructure.

Enterprise-class monitoring

• Out-of-the-box monitoring for Oracle technologies
• Rich alerting and notification customization
• Send email, SNMP traps, open tickets, and share event data
• Extensible monitoring using Metric Extensions
• Maintenance windows support with Blackouts
• Always-On Monitoring for critical alert notification during Enterprise Manager maintenance

Monitoring scalability and automation

• Scale monitoring setup using Admin Groups and Template Collections
• Automate ops privilege assignment using privilege-propagating groups
• Fix issues automatically using Corrective Actions

Incident management

• Smart Event Compression autocompresses related events into a smaller set of actionable Incidents
• Manage full incident lifecycle including assignment, tracking, escalation
• Use Incident Manager for assignment and troubleshooting of incidents
• Execute Dynamic Runbook procedures in EM for faster incident resolution
• Use Incident Dashboard for insights into incident backlog

• Oracle Enterprise Manager Monitoring Overview (34:11)
• Intelligent Incident Compression Overview (13:11)
• Metric Extensions Overview (20:05)
• Integration with 3rd Party Systems (18:41)
• Strategies for Scalable, Smarter Monitoring using Oracle Enterprise Manager Cloud Control 13c (PDF)
• Blog: Monitoring Best Practices Report for Enterprise Manager 13c

Middleware Management

Automated middleware operations

Oracle’s middleware management capabilities ease administrators’ lives by providing a full-lifecycle solution encompassing configuration and compliance management, patching, provisioning, and performance management, as well as administration and auditing.

Comprehensive management solution for:

• Oracle WebLogic Server
• Oracle Coherence
• Oracle HTTP Server
• Oracle SOA Suite
• Oracle WebCenter Suite
• Oracle Identity Management
• Oracle Business Intelligence Enterprise Edition
• Non-Oracle middleware (for example, Apache Tomcat, JBoss Application Serve,r and IBM WebSphere Application Server)

Key features and benefits

• Monitor middleware availability and performance metrics out-of-the-box
• Improve quality of service by avoiding downtime and improving end-to-end response time
• Manage multiple domains centrally
• Monitor real end user experience with the integrated KPIs
• Gain in-depth JVM diagnostics
• Detect configuration changes in real time and track historically
• Reduce cost by automating manual, error-prone lifecycle management operations

• Video: Managing Oracle WebLogic Server with Oracle Enterprise Manager (48:50)
• Video: Monitor EM Metrics for WebLogic Server with Oracle EM App for Grafana (3:31)
• Blog: OOTB WLS Dashboards are now available with Oracle EM App for Grafana
• Datasheet: WLS Management Pack EE (PDF)
• Datasheet: Management Pack Plus for IDM (PDF)
• Datasheet: Management Pack for Oracle Coherence (PDF)
• Datasheet: Oracle Real User Experience Insight (PDF)

Application Management

Automated application operations

Oracle Enterprise Manager Cloud Control provides complete application performance management (APM) for custom applications and Oracle Applications, including E-Business Suite, Siebel, PeopleSoft, JD Edwards, and Fusion Applications.

User Experience Management

• Integrated problem diagnostics and impact analyses, natively from Oracle Enterprise Manager console
• Customizable dashboards per application, user group segmented
• User flow tracking, including transaction abandonment analysis
• User session diagnostics and full session replay
• Geographic user visualization

RUEI app now available on Oracle Cloud Marketplace

• Preconfigured stack contains RUEI server and repository, deployed on a single Linux host
• Monitor real-user experience of cloud applications
• Drastically simplified installation and network setup process

JVM monitoring and diagnostics

• Integrated with JVM Diagnostics feature in Enterprise Manager
• Zero-overhead, production Java and DB diagnostics for Oracle and non-Oracle platforms
• Always-on, real-time and historical monitoring and diagnostics
• Diagnose the problem at production—no need to reproduce in house
• No application instrumentation or server restarts required
• Constant, low overhead by Java thread sampling method
• Complete visibility into JVM stack: requests, threads, heap, GC
• Java Workload Explorer: detailed comparison across time and servers

• RUEI Demo (17:59)
• RUEI Marketplace (3:00)
• Managing Oracle WebLogic Server with Oracle Enterprise Manager (48:50)
• Blog: RUEI is now on Oracle Cloud Marketplace
• How to Deploy RUEI to Oracle Cloud and Monitor E-Business Suite (PDF)
• Blog: Centralize Oracle Weblogic Server Monitoring Using Enterprise Manager
• RUEI Documentation

Extensibility

Extending visualization, monitoring, and connectivity

Enterprise Manager is designed to support a breadth of enhanced visualization capabilities, from customizing out-of-the-box dashboards to using the Enterprise Manager App for Grafana. Further extend Enterprise Manager capabilities with REST APIs to interoperate with third-party tools.

Visualization and mobile access

• Create dashboards using prebuilt and custom widgets
• Grafana app for versatile dashboarding experience
• Mobile app for on-the-go administration
• Enterprise Manager federation visualization
• Single pane of glass summary across federated EM instances

Heterogeneous management

• Monitor and manage Non-Oracle Databases using monitoring plugins for Microsoft SQL Server, IBM DB2 and Sybase ASE
• Event Connectors to share EM events with external systems
• Service Desk Connectors to open tickets in external systems

REST API support

• Automate EM management operations from external tools using REST APIs

• Blog: Introducing Enterprise Manager App for Grafana
• Blog: Top new features of Oracle Enterprise Manager App for Grafana
• Demo: Integration with 3rd Party Systems (18:25)
• Docs: Getting started with Grafana
• Community Forum EM App for Grafana

Platform

Resilient platform

Enterprise Manager is used to monitor and manage highly available database, middleware, and application technology requiring a resilient platform. Features include rapid platform update for patching and updates, proactive health monitoring and diagnostics, and flexible high availability deployment options.

Reduce maintenance windows and maintain critical monitoring using rapid platform update

• Minimize patching maintenance windows to meet service level agreements
• Maintain monitoring and alerting continuity during maintenance windows for mission-critical targets
• Schedule flexible maintenance windows to adapt to business requirements
• Reduce human errors with patch automation in the multi-OMS environment

• Rapid platform update blog
• Rapid platform update technical brief (PDF)

Privileged Access Management (PAM) integration

• Extensible model
  • Credential framework to plug in with any PAM provider
  • Simplified integration with Enterprise Manager for workflows, such as database patching, using Fleet Maintenance
  • Prevent administrator errors and privilege abuse
  • Reduce the risk of a potentially costly insider data breaches and address regulatory and compliance requirements
  • Easily track privileged access activities and detect suspicious behavior with detailed auditing and reporting capabilities
  • Easily control privileged accounts and streamline the access process
  • Reduce access management effort and improve security posture
  • Blog: PAM integration with Enterprise Manager
  • Docs: Cloud Control Security Guide

  Enterprise Manager on Cloud (Oracle Cloud Marketplace)

  • Start monitoring your estate in minutes by deploying Enterprise Manager on cloud
  • Flexible deployment sizes and configurations with built-in high availability
  • Leverage the self-healing features of Autonomous Database as a repository to boost the overall operational efficiency of Enterprise Manager

  Supercharged job system for peak workloads

  • Prioritize and parallelize jobs for greater scalability and efficiency

  Enhanced self-monitoring and diagnostics

  • Automatically alerts admin to EM health issues
  • Continuously evaluates and recommends EM sizing configuration for OMS and repository based on workload
  • Job diagnostics dashboards to drill down into the performance and real-time status of the jobs running in or blocking the system

  Oracle Enterprise Manager Mobile (Apple App Store and Google Play Store)

  • Deploy the mobile app and manage targets from anywhere
  • Monitor and assign, share, and triage incidents from your mobile device
  • Enterprise Manager downloads
  • Enterprise Manager documentation

  Enterprise Manager Federation

  • Consolidated view of all Enterprise Manager sites
  • Summary pages with clickable links to deep analysis

  Comcast maximizes performance with Oracle Enterprise Manager

  Comcast uses Oracle Enterprise Manager database lifecycle management for deep performance visibility into their database fleet and to automate provisioning, maximize utilization, and provide a self-service database provisioning portal.

  Enterprise Manager use cases

  Find, fix, and validate database performance issues

  Automate database lifecycle operations including provisioning

  Resolve issues before users are impacted

  One of the highest costs of deploying IT resources in the cloud or on-premises is day-to-day operations. Oracle’s new edition of Enterprise Manager includes features such as Dynamic Workbooks, Smart Event Compression, and Automatic Workload Analysis that automate many previously manual tasks. These features can significantly reduce IT operational cost and complexity by enabling consistent automation practices across a mix of IT deployment architectures.

  David Floyer CTO and Co-Founder, Wikibon

  Oracle Enterprise Manager is analogous to the smart home—in fact the latest release is effectively a smart Oracle Database hub. This is another example of Oracle’s focused drive on automation by automating Oracle Database operations and reducing operational costs by up to 60%. Oracle has put all the expertise into Enterprise Manager instead of the administrator—transforming anyone who uses it into an expert.

  Marc Staimer President of DS Consulting and Wikibon analyst

  December 7, 2023

  Oracle Enterprise Manager 13c Release 5 Update 18 (13.5.0.18) is now available

  Daniela Hansell, Director, Observability and Management, Oracle

  Release Updates (RUs) are the agile way to roll out new EM features and bug fixes quickly to customers, so they don't have to wait for a major release. RUs are versioned with a trailing digit indicating the RU version.