Oracle Enterprise Manager: 7 Robust Features to Put in Action

Datavail 0 views 48 slides Oct 14, 2025
Slide 1
Slide 1 of 48
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12
Slide 13
13
Slide 14
14
Slide 15
15
Slide 16
16
Slide 17
17
Slide 18
18
Slide 19
19
Slide 20
20
Slide 21
21
Slide 22
22
Slide 23
23
Slide 24
24
Slide 25
25
Slide 26
26
Slide 27
27
Slide 28
28
Slide 29
29
Slide 30
30
Slide 31
31
Slide 32
32
Slide 33
33
Slide 34
34
Slide 35
35
Slide 36
36
Slide 37
37
Slide 38
38
Slide 39
39
Slide 40
40
Slide 41
41
Slide 42
42
Slide 43
43
Slide 44
44
Slide 45
45
Slide 46
46
Slide 47
47
Slide 48
48

About This Presentation

Oracle Enterprise Manager: 7 Robust Features to Put in Action
Managing complex IT environments that include multiple Oracle and non-Oracle databases can be challenging. Oracle Enterprise Manager (OEM) simplifies this process by providing a centralized platform for monitoring, management, and automat...


Slide Content

Putting 7 Robust Oracle Enterprise
Manager Features into Action
Zane Warton
Global Practice Leader,
Oracle Database
Datavail

Experienced
•20+ years of Oracle DBA
•Multiple roles & industries
Connect or follow me on LinkedIn
https://www.linkedin.com/in/
robert-zane-warton-b7b7485
Accredited
•OCP certificated
•Master of Science Degree
Leader
•Guides team of DBAs who
deliver world class services
to 100+ customers
Zane
Warton
Oracle Database Practice
Leader,
Datavail
Over 20+ years of
experience

Datavail Company Overview
Database Operations
•All major platforms: MS SQL, Oracle,
DB2, MySQL, MongoDB, Postgres
•Comprehensive development &
operational services
•24x7 in-office delivery
•US & Global models
•Reactive & proactive services
Application Development,
Integration & Maintenance
•Oracle EBS
•Hyperion
•Microsoft Dynamics CRM
•SharePoint
•Custom development (Microsoft .NET)
Analytics, Visualization &
Integration
•Microsoft SSRS, SSIS, SSAS
•PowerBI
•Oracle OBIEE, BICS, Golden Gate
•Informatica
•Oracle Data Integrator
•ETL development & operational run
16+ years delivering
data services
700+ customers,
average client
retention of 7 years
Managed services,
projects, and
staffing 1 2 3
We are database, analytics, and application data integration specialists.

Free Beer for a Year!
Fill Out the Evaluation
Form to Enter!

Agenda
•Oracle Enterprise Manager (OEM) Overview
•History of OEM
•Who Uses OEM?
•Why Do Organizations Choose OEM?
•Seven Highlights of OEM Cloud Control 13c
•Bonus Content!

OEM Overview
Oracle Enterprise Manager
(OEM) is a monitoring &
management tool that supports
small to large and sometimes
complex environments.

OEM Overview
OEM can monitor and manage your
wide-ranging enterprise
environment including:
•Databases
•Applications
•Middleware
•Virtualization Infrastructure
•Cross Deployments
•Non-Oracle Targets
OEM provides additional functionality with
the help of management packs that
include:
•Oracle Diagnostics Pack and Oracle Tuning
Pack, Database Lifecycle Management Pack,
Oracle Configuration Management Pack,
Oracle Change Management Pack, Oracle
Data Masking Pack and many more.
•These management packs require a separate
license.

History of OEM
2001 2004 2010 20222016
OEM
Database
Control
OEM
Application
Server Control
OEM Grid
Control
OEM Cloud
Control
OEM Cloud
Control 13c
Version 5

Who Uses OEM?
•OEM is intended for database administrators
and system administrators supporting
enterprise-level infrastructure.
•Organizations heavily invested in Oracle-
based infrastructure gain the most significant
benefits among potential users, since this is a
first-party enterprise management tool.
•However, other companies can find
significant value even if you have a limited
Oracle focus.

Why Do Organizations
Choose OEM?
•Oracle has a rock-solid reputation for offering
enterprise-grade solutions that are powerful and secure.
•Both your on-premises and Oracle Cloud-based
technologies are supported, along with a long list of
other assets.
•OEM has been in development for 20 years & Oracle
continually releases improvements that enhance this
platform.
•Automation, database optimizations, user experience
– a win for a DBA.
•Extensions combined with flexibility.

Seven Highlights of OEM 13c
1.Intelligent Incident Compression
2.Chef Job Support
3.Always-ON Monitoring
4.Notification Blackouts
5.System Broadcast
6.Export & Import Incident Rule Sets
7.Metric Enhancements

Intelligent Incident Compression
(Smart Alerting)
•“Flood of Alerts” experienced with 11g and/or 12c OEM
•With the release of Enterprise Manager 13c, Intelligent Incident Compression allows
multiple events to be automatically grouped into a single incident.
•Situations where it’s useful to deal with multiple related events as a single incident are:
•Consolidation of events from targets on same host.
•Merging of all Tablespace Used (%) alerts across all tablespaces for a particular database
into a single incident.
•You want to automatic union of all Metric Collection Errors for a target into a single incident.
•By compressing notifications, we can manage related events as one unit.
•This is now happening by default due to update 12!

Intelligent Incident Compression

Intelligent Incident Compression

Chef Job Support
•Chefis a declarative configuration
management and automation platform.
•Chef has become popular for its concept of
“infrastructure as code,” in which machine-
readable files called Chef recipes are used
to provision infrastructure including
computing hardware and networking.
•Chef recipes are now supported with a new
job type introduced in 13c Enterprise
Manager Cloud Control.

Chef Job Support
•You can now manage and access Chef cookbooks
and Chef recipes in the software library.
•The execution of chef recipes is now supported
by deployment procedures.
•You can store Chef cookbooks and Chef recipes
in the software library or even locally to a host
where it gets executed:
•Must have chef-solo setup
•Create a folder in Software library
•Chef cookbook should be uploaded
•Create an OEM job using the new Chef job type
and submit it

Chef Job Support

Always-ON Monitoring
•THE WAIT IS OVER for monitoring
targets in critical and down alerts
when OEM is down for a planned
maintenance or unavailable during
an outage with Always-ON
Monitoring.
•Always-ON Monitoring (AOM) is a
lightweight application that is
included in 13c Cloud Control.
•You can enable AOM monitoring by
following a few simple steps in OEM.
•The Administrator can enable notifications as and when
required, but it’s best practice to keep AOM running all
the time and notifications can be enabled as per
requirement.
•The monitoring configuration of targets and
notifications data including contacts and email gateway
configuration synchronized with Always-ON Monitoring
as it will be reusing existing configuration of Enterprise
Manager.
•Once AOM is properly setup and synchronized, the EM
notifications can be received even when Enterprise
Manager services are unavailable.

Always-ON Monitoring
Alerts
Email
Monitoring
Service
Always ON
Agents
OMS Repository
Enterprise Manager
Example:
emctl set property -name "oracle.sysman.core.events.ems.emsURL" -value "https://yourhostname:8081/upload" -sysman_pwd sysman

Notification Blackouts
•Notification Blackout disables
notifications during the blackout
period on the targets which are under
notification blackout.
•There are two types of Notification
Blackouts:
•Maintenance Notification Blackout
•Notification-only Notification Blackout

Notification Blackouts

Retroactive Blackout

System Broadcast
•Best practice is to notify users currently connected to Enterprise Manager about
outages before any planned maintenance.
•Oracle introduced a new feature in 13c Cloud Control known as System Broadcast.
•The super administrator can notify all users who are connected to Enterprise Manager
by sending a message before any planned maintenance work.
•The EMCLI provides new send_system_broadcast verb using which we can send
message including severity levels.
•Based on the requirement you should set necessary user preferences for System
Broadcasts

Example:
emcli send_system_broadcast -
messageType="INFO" -
toOption="ALL" -
message="Enterprise Manager will
be taken down in an hour for an
emergency patch"
System Broadcast

EMCLI Extra
emclilogin -username=dvdba
emclisync
emcliget_targets-noheader-script | awk '/listen/{print $4":"$3":Lifecycle
Status:Stage"}'>oem.txt
emcliset_target_property_value-property_records="REC_FILE" -
input_file="REC_FILE:oem.txt" -separator=property_records="\n"
awk '{if ($0 ~/PRD/) {print $0"Production"} else {if($0 ~/DEV/){print $0"Development"}
else {print $0"Test"}}}' oem.txt >oem2.txt

Export and Import of Incident Rule Sets
•Exporting incident rule sets from One Enterprise Manager site into another is now available in
13c Cloud Control.
•Mimic the rule set with multiple Enterprise Managers without redoing the configuration of
incident rule sets manually.
•Please Note: The rulesets along with incident rules, users, recipients’ email addresses, targets
on which ruleset are configured and notification methods can also be exported.
•If any of these entities are already available in the target Enterprise Manager cloud control then they will be
kept in the rule set, else they are removed during the import to target site.
•Standardizes the notification rule sets across multiple enterprise managers in the global
complex environment where multiple Enterprise managers are hosted in different data centers.

Export and Import of Incident Rule Sets

Metric Enhancements
•In previous releases of OEM, users extended
monitoring by creating user defined metric -
which had limited functionality and was
available only for a few known target types.
•In 13c Cloud Control, the metric extensions
allow you to create full-fledged metrics for a
multitude of target types:
•Hosts
•Databases
•Oracle Exadata databases and storage servers
•Siebel components
•Oracle Business Intelligence components
•Fusion Applications IBM WebSphere
•Advantages of Metric Extensions
•Metric Comparison operators can now be modified
for alerts.
•Compute expressions are now supported in metric
extensions.
•Metric extensions are can be setup for RAC and
NON-RAC (single instance) databases.
•These enhancements in Metric extensions
provide better monitoring and flexibility to
meet requirement of monitoring complex
environments.

Metric Enhancements

Bonus Section!
•Oracle's Observability Blogs – Daniela Hansell
•https://blogs.oracle.com/observability/search.html?q=13c+release+5+update
•https://blogs.oracle.com/observability/rss
•OCI Integration
•Advanced Dashboarding
•PAM Integration
•EBS Streamlining and Monitoring
•Exadata Storage and Infrastructure Reporting
•RU Availability Announcements

13.5.0.1
October 2021
•Graphical Interface for Databases Patching
•Support for Database
Backup to OCI
Object Storage
•Simplified Agent
•Patching

13.5.0.2
November 2021
•Enterprise Manager Dashboards Enhancements
•Sharding
Visualization

13.5.0.3
December 2021
•EXAchk
Monitoring
•EM Mobile 1.4

13.5.0.4
Feb 2022
•Pluggable Database Update and Upgrade
using Fleet Maintenance UI
•Monitor a Database Using a Custom
(non-dbsnmp) User
•New Compliance Rule Detail Tab

13.5.0.5
August 2022
•BI Publisher Removed!
•New EM Federation Dashboard
•New Compliance and Comparison & Drift Dashboards

13.5.0.6
April 2022
•Kerberos and RADIUS Authentication
•New Database Migration Workbench Guide
•New EXAchk AHF Compliance Standards
•Updates to thebackup_databaseEMCLI Verb

13.5.0.7
June 2022
•Enterprise Manager Dynamic Runbooks
•Migration Workbench Multiphase Transportable Tablespace Migrations

13.5.0.8
July 2022
•Event Compression Policy

13.5.0.9
September 2022
•Widget Builder
•New Monitoring Guide
•https://docs.oracle.com/en/enterprise-manager/cloud-
control/enterprise-manager-cloud-control/13.5/emmon/index.html

13.5.0.11
October 2022
•Exadata Warehouse Enhancements
•Job System
Configuration

13.5.0.12
January 2023
•Support for Oracle Autonomous VM Clusters in Exadata Cloud
Discovery
•Auto-generate Secure Passwords for Database and
Monitoring Users

13.5.0.13
March 2023
•ADDM
Spotlight

13.5.0.13 B
December 2021
•Top Activity Lite in Performance Hub

13.5.0.14
April 2023
•Privileged Access Management Integration with Enterprise Manager
•New resync_target EM CLI Verb

13.5.0.15
May 31, 2023!
•New Runbooks Features
•New High Availability Role Target Property
•ADDM Spotlight Enhancements

Free Beer for a Year!
Fill Out the Evaluation
Form to Enter!

Q&A

Thank You for Attending!
Please remember to fill out the session survey in the app!
Feel free to reach out to me with questions:
[email protected]
866-811-6764