Skip to main content
TrustRadius
Oracle Enterprise Manager

Oracle Enterprise Manager

Overview

What is Oracle Enterprise Manager?

Oracle’s Enterprise Manager is an on-premises monitoring and management tool. The console is designed primarily to manage other Oracle products, it but can integrate to manage non-Oracle components as well.

Read more

Learn from top reviewers

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Oracle Enterprise Manager?

Oracle’s Enterprise Manager is an on-premises monitoring and management tool. The console is designed primarily to manage other Oracle products, it but can integrate to manage non-Oracle components as well.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

22 people also want pricing

Alternatives Pricing

What is SolarWinds Pingdom?

SolarWinds Pingdom is a website uptime monitoring and alert tool, with additional reporting and Real User Monitoring capabilities. Pingdom is part of SolarWinds’s DevOps package, enabling full-stack monitoring as a service.

What is SolarWinds ipMonitor?

SolarWinds ipMonitor is a lightweight performance monitoring tool. It enables monitoring from a single console and out-of-the-box visibility, with some automation available.

Return to navigation

Product Demos

Oracle Enterprise Manager 12c: Managing Exalogic Elastic Cloud and WebLogic

YouTube

Advanced Installation of Oracle Enterprise Manager 13.2

YouTube

Backup Oracle Database using Oracle Enterprise Manager

YouTube
Return to navigation

Features

Monitoring Tasks

Various types of monitoring

8.2
Avg 7.8

Management Tasks

Various tasks required to keep systems running smoothly

7.8
Avg 7.3

Reporting

Report generation to help with system monitoring tasks

6.7
Avg 7.5

Security

Management of security aspects of system monitoring

3.5
Avg 6.2
Return to navigation

Product Details

What is Oracle Enterprise Manager?

The Oracle Enterprise Manager is an on-premises monitoring and management tool. It is designed primarily to manage the Oracle deployments in an environment but supports connectors in order to integrate with non-Oracle components. The OEM is scaled to manage enterprise-level applications, databases, hardware, virtual environments, and cloud-based systems.

Oracle’s Enterprise Manager also offers a drag-and-drop user interface, requiring minimal training or technical knowledge for usability. It also enables some automation, including generating routine reports, database backups, and problem detection and resolution, even on remote sites.

For more information visit https://www.oracle.com/enterprise-manager/technologies/

Oracle Enterprise Manager Video

Oracle Enterprise Manager Delivers Next Gen Automation

Oracle Enterprise Manager Competitors

Oracle Enterprise Manager Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Oracle’s Enterprise Manager is an on-premises monitoring and management tool. The console is designed primarily to manage other Oracle products, it but can integrate to manage non-Oracle components as well.

Zabbix and SolarWinds Server & Application Monitor are common alternatives for Oracle Enterprise Manager.

Reviewers rate Network device monitoring and Service configuration management highest, with a score of 9.

The most common users of Oracle Enterprise Manager are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

(1-5 of 18)

Oracle Enterprise Manager - a perfect tool for monitoring databases and for performance tuning.

Rating: 9 out of 10
December 18, 2018
Vetted Review
Verified User
Oracle Enterprise Manager
5 years of experience
Oracle Enterprise manager is being used for 2 purposes:
1. To monitor production databases for alerts against set thresholds.
2. To diagnose and drill down into details of the performance issues.
  • In OEM, the agents are installed on production database servers and they collect and send diagnostic information from databases to the OMS. The OMS compares this information with set thresholds and raises alerts in OEM. This is particularly done well as Oracle database does have lot of diagnostic information that OEM agent can collect.
  • It can monitor databases at set interval time for required diagnostic information and for error codes. It then displays that information in a GUI interface that is graphical and easy to understand. The OEM can raise alerts based on thresholds and it can send emails or input to other systems that can raise tickets or alert operations.
  • It can also run preventive actions based on alerts. This helps in reducing response time to errors and issues that can cause database downtime. There are predefined actions and DBAs can also write customized procedures to be run as preventive measures.
Cons
  • The OEM is very good at monitoring Oracle databases as they are from the same vendor and have in-depth knowledge of Oracle technology. However, improvements can be made to monitor all sorts of databases and even NoSQL databases which are now commonplace.
  • The OEM architecture can be simplified so installs and configurations can be simple and straightforward. Complex installations require a long implementation time and it increases cost of the implementation.
  • The OEM slows down response as it monitors a large number of busy prod databases. So scaling should be improved to handle large workloads.
  • The OEM should use standard TNS ports in place of non-standard ports which are often blocked in most networks. This causes delay in implementation due to violation of security compliance in most organizations.
Oracle Enterprise Manager (OEM) is suitable for a large scale Oracle DB and middle-layer product operation. Suitable if the monitoring of hundreds of Oracle databases is needed in one portal.

Enterprise Manager-Your database Watchdog

Rating: 9 out of 10
September 29, 2017
CC
Vetted Review
Verified User
Oracle Enterprise Manager
3 years of experience
We use Oracle EM to monitor multiple metrics across several of our databases including running processes, active sessions, tablespace and storage utilization, blocking sessions, and several other critical metrics. Oracle EM solves the issue of having to monitor different databases using scripts or linux reporting tools or mail alerts that can pass on cryptic data, but instead simplifies messages that indicate an issue with the database or database connections.
  • Creates visuals and graphic indicators for monitoring critical database operations and states.
  • Easily identify problematic connections, performance issues, blocking sessions, and identify sql code or scripts that are degrading database performance.
  • Easily display AWR reporting or ASH analytic's with a few clicks.
  • Easily set up jobs with Oracle scheduler, which you would have to otherwise script directly on the database.
Cons
  • Connections to targets can become lost or dropped, resulting in the application not doing anything when clicking on a link, with no type of indication of what the issues is.
  • Log outs from the console sometime do not complete, and users remain logged in, even after closing the browser session.
  • The timeout function in the console has always been problematic, causing me to have to change the time out setting in the config file, whereas the option to disable the time outs on the console when the option comes up does not work. Selecting the option to disable timeouts still causes idle sessions to timeout.
Oracle EM is perfect for monitoring database performance, alerting dba's of critical thresholds, setting up simple tasks using oracle scheduler, identifying problematic scripts or code that are degrading database performance, identifying and resolving blocking sessions and locking sql, and many other database performance monitoring tasks. Where it is a little less suited is configuring backups with non oracle backup systems such as NetApp, monitoring end users connections to the database, some administration tasks such as resizing the SGA or adding datafiles to tablespaces, or changing database configuration files such as the pfile.

Why use OEM? Why not?

Rating: 9 out of 10
October 26, 2018
JS
Vetted Review
Verified User
Oracle Enterprise Manager
6 years of experience
Our organization has ~180 Oracle databases and ~200 MSSQL databases. It is used by the DBA team at this time. We use OEM to monitor our database footprint, alerting us to issues such as downtime and compliance levels. At a glance we can the status of any of our databases, uptime, performance, last backups, patch level and other non functional details such as business group, location, application point of contact, and maintenance windows.
  • Database status. Being able to see which databases are up/down, at a glance, allows us to quickly react to issues.
  • Reporting. We report on last backups, daily status, a host of metrics, and compliance levels of all our databases. With reporting we come into the office with a set of "status" reports and we know instantly if a database has issues.
  • Metrics. We have a number of KPI's and SLA's we need to meet. Metrics applied to the databases allow us to stay on top of those requirements as well as fix common issues without a DBA needing to log in to assess the issue.
Cons
  • Bugs. Every version we upgrade to has a number of bugs. Some stop us from rolling to production OEM (we have a sandbox OEM), some are simply annoying. If I could improve on one thing, it would be for better QA from oracle before releasing each version.
  • Flash. I'm told that they are moving from Flash to Jet in version 13.3 and beyond (we are on 13.2 currently). That change cannot come soon enough. The OEM pages load SO slowly due to Flash.
  • Hierarchy Groups. OEM allows five Hierarchy groups. A Hierarchy group allows a top down metric/rule roll out. However, they limit you to five. I'd like to see them open that up, so that we can have any number of custom groups.
OEM is perfect if you have a number of databases that you need to monitor. It's also great for automated jobs and reporting. However, if you have a handful of databases, OEM is overkill and you can use scripts and crontab for monitoring/jobs.

OEM: Best Tool for Oracle Databases

Rating: 10 out of 10
November 05, 2019
Vetted Review
Verified User
Oracle Enterprise Manager
20 years of experience
Oracle Enterprise Manager (OEM) is being used in dev/test and prod environments. It is widely used by DBAs for monitoring and day-to-day operations. It is also widely used as the dashboard console for the managers to have an overview of the database systems.
  • Dashboard: Options to choose Home Page. Best for DBAs, best for new users and etc. I selected "best for DBAs" as my Home Page. It gives you the status (up or down) of all the databases registered. If you click each database a nice diagram shows up. On the left, you will see Load and Capacity, Incidents and Compliance, Recommendations for findings and SQL tuning, Last Backup and if there are any Jobs running.
  • Performance Home: Overview diagram of host average runnable processes, average active sessions, throughput, I/O, parallel execution, services. It also provides additional links to top consumers, instance locks, duplicate SQL, instance activities and SQL response time.
  • Top activity is another nice feature: details for 5 minute intervals. It further provides top SQL and top session. This is my go-to page for database performance tuning. You click the top SQL to get details on the "troubled" query, statistics, activities, plan and tuning history.
  • SQL tuning advisor is another nice feature: you can schedule a job to run the SQL tuning advisor or run it immediately.
  • AWR Report: when we start having DB performance issues, we run AWR a pare of snapshot reports and then compare them with a baseline report to nail down what has caused performance degradation.
  • Security: users, roles, profiles, auditing settings, data masking, and subsetting, data redaction, transparent data encryption, data vault, label security, virtual private database, and enterprise user security.
  • Scheduling jobs: we have 70 jobs running every day - backup, space, monitoring and sending alerts to email.
Cons
  • We also use OEM to monitor SQL Server. However, OEM only provided limited features for SQL Server. It would be nice if we can schedule backup jobs for SQL Server in OEM.
  • The ability to run SQL queries. You can't run queries in OEM. I have to go to SQL Developer or SQL PLUS to run. queries.
It is a great tool for DBAs and management with limited access. In my opinion, this is not very useful for developers. DBAs can't seem to daily work without OEM.

Oracle Enterprise Manager - A Comprehensive Enterprise-Wide Database System Management Tool

Rating: 9 out of 10
September 18, 2019
Vetted Review
Verified User
Oracle Enterprise Manager
8 years of experience
Oracle Enterprise Manager is being used by the database administrators in the IT department. It servers as an important tool and interface for database monitoring.
  • It manages all relevant targets (hosts, Oracle databases, and listeners) in one place
  • We can use it to quickly drill down an issue to its detail
  • In addition to monitoring and performance tuning, it can be used to present information effectively
Cons
  • It relies on a monitoring agent to be installed on monitored target hosts, and that dependency can be problematic at times
  • The performance of Oracle Enterprise Manager itself can be slow
Oracle Enterprise Manager is well suited for monitoring multiple oracle database, especially RAC databases (where multiple hosts are involved in clusters). It is probably an overkill if just for one or two single instances. It is also good at troubleshooting complex performance issues with queries, when an effective time-based monitoring on multiple facets of the system (CPU, memory, I/O, and SQL plans, etc) is needed. It is a good tool to present such information as well, in a well laid out, graphical manner.
Return to navigation