TrustRadius: an HG Insights company
Back to Overview
Oracle Enterprise Manager Logo

Oracle Enterprise Manager Reviews and Ratings

Rating: 7 out of 10
Score
7 out of 10
Learn More

Community insights

TrustRadius Insights for Oracle Enterprise Manager are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Seamless Updates: Users have appreciated the seamless application of security patches and feature fixes, ensuring minimal downtime during updates. The efficient patching process has allowed users to maintain system stability without disruptions, especially during critical update periods.

Anomaly Detection Feature: Reviewers find the anomaly detection feature valuable for quickly alerting the operations team to issues, enabling timely action and preventing potential disruptions effectively. This real-time alert mechanism has been instrumental in resolving issues promptly and maintaining smooth operations.

Database Monitoring Capabilities: Customers value the ability to monitor database patch status and receive alerts on tablespace usage, helping prevent space-related issues effectively. This proactive monitoring approach has proven essential in maintaining optimal database performance by addressing potential capacity challenges before they impact operations significantly.

Reviews

26 Reviews

OEM review from an OEM veteran with more than 1000 bugs opened from my SRs

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

Oracle Enterprise Management is our central management tool of the whole Oracle inventory. We use many features except Cloud Pack and Data Masking pack.

Pros

  • Enterprise Monitoring
  • DB provisioning and patching
  • Exadata Management

Cons

  • Security subsystem, supporting integration with other PAM products
  • Offer more MGMT views to retrieve needed information
  • Log management, including one-click download of procedure activity log,
  • Support of record management based on admin group, e.g. display incidents based on admin group, save incident records based on admin groups
  • Better support of cross server OEM migration (OMS, repository DB), mostly on post tasks, such as mass promoting targets, mass transfer target properties
  • Better emcli support for mass automation, such as agent cloning
  • Better EM dashboard features to create needed reports
  • Future integration with DEVOPS tools, such as Terraform, Ansible, Bitbucket, K8
  • OEM features can be expanded to support central DB management, such as integrated RMAN catalog, TDE key catalog, etc. Currently, you need a separate DB to handle.
  • Support built-in patching scheduling and auto notification feature

Likelihood to Recommend

In short, Oracle Enterprise Manager (OEM) is designed for frontline DBA rather than DBA managers who want to get ad-hoc information. For frontline DBA, it is easy to see an incident and take actions. Almost all details are captured and organized in tabs. That is beautifully done. As a manager, it is hard to get a complete picture of operational status based on his selection criteria. In large EM deployments, mostly, targets are organized by using admin group. Besides, the incident records displayed by clicking on [Get Results] cannot be saved as Excel sheet. If that can be one, we can use Excel features to compare. Besides, OEM is inconsistent in log management. Certain results can be saved in offline format and certain cannot. It is extremely important to save procedure activity log in an offline html that preserves the format for internal auditing requirements. This proves a task is done successfully in OEM.

KZ
Kevin Zhang
Manager of Oracle Infrastructure in Information Technology at Scotiabank (10,001+ employees)
Vetted Review
Oracle Enterprise Manager
10 years of experience
View profile

Oracle created an awesome cloud console

Rating: 7 out of 10
Incentivized

Use Cases and Deployment Scope

Oracle Enterprise Manager Cloud provides a central control for your Oracle applications and databases. It provides monitoring templates and report templates. One can create alerts and have issues notification. How does it help us? this tool helps centralize monitoring needs and provide monitoring, so that we can react in time to some critical alerts. It also allows us documenting easily and clearly.

Pros

  • Monitoring
  • Console / Dashboard

Cons

  • Performance
  • UX

Likelihood to Recommend

Monitoring - It provides monitoring templates and report templates.

Alerting - One can create alerts and have issues notification.

Management Console - this tool helps centralize monitoring needs and provide monitoring, so that we can react in time to some critical alerts. It also allows us documenting easily and clearly.

Dashboards and reporting

VU
Verified User
Director in Information Technology (501-1000 employees)
Vetted Review
Oracle Enterprise Manager
1 year of experience

Great management solution for large enterprises

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

Oracle Enterprise Manager is the right tool for the job for us, due to our needs for monitoring a highly-regulated production environment. We leverage Oracle Enterprise Manager across our entire organization for the full automation lifecycle of common database management tasks. This allows our IT team to focus on delivering value and avoiding toil.

Pros

  • Seamless application of security and feature/fix patches
  • Elegant rolling updates to ensure little or no downtime
  • Anomaly detection to quickly alert ops team to issues

Cons

  • Upgrade speed can sometimes be slow and unpredictable
  • Occasional anomalies that cannot be automatically rectified and require human intervention.
  • UI can be sometimes buggy and slow

Likelihood to Recommend

For large organizations with many Oracle database projects across the fleet, there is no better choice. Otherwise ops teams will be doomed to maintain homegrown scripts that are error prone and would not scale well across many databases. Having a single pane of glass for DB management has been a real paradigm shift made possible by Oracle Enterprise Manager.

VU
Verified User
Administrator in Engineering (51-200 employees)
Vetted Review
Oracle Enterprise Manager
2 years of experience

Oracle Enterprise Manager is definitely a one-stop solution

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

Oracle Enterprise Manager is primarily used by the database team as well as two other departments for monitoring purposes. For me as a DBA, it helps me to get a holistic picture of the databases and their components in the organization. It makes it easy managing and monitoring the databases easier. Also, in case of incidents, we get notified instantly, along with repeat alerts, which helps to address and resolve the issues sooner.

Pros

  • Helps to see what databases are not up to date with respect to patches
  • Tablespace usage alerts help to avoid running out of space
  • End-to-end database component management is very simple

Cons

  • Performance home for instances at times misses data when it transitions from one instance to another

Likelihood to Recommend

From my experience, I believer Oracle Enterprise Manager makes life easy for the management of all the databases and their components over URI as well as for automating certain management tasks using the command line. It's a blessing, especially when there are hundreds of databases with different database versions (because of legacy applications) running.

VU
Verified User
Administrator in Information Technology (1001-5000 employees)
Vetted Review
Oracle Enterprise Manager
10 years of experience

Oracle Enterprise Manager - a valuable product for maintaining thousands of databases

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

I use Oracle Enterprise Manager (OEM) on a daily basis. I use it for individual database/cluster monitoring and enterprise wide for our entire client base.

It's great for monitoring multiple systems and has a wide variety of pre-built metrics. It can be used for deploying scripts to our entire system. It's easy to use and critical for technical users as well as non-technical users.

Pros

  • Displays visuals of database health
  • Shows internal data structures (tablespaces, objects, users, etc)
  • Monitors database health
  • Can be used for deployment of PL/SQL and other scripts

Cons

  • It can be very buggy, sometimes preventing jobs from running
  • It can miss errors and lead to database outages
  • Can be slow during updating of internal settings

Likelihood to Recommend

It's great for managing many database systems, from hundreds to thousands of systems. If your system has few databases, it may not be suitable. It also monitors other non-Oracle systems.

If you have small databases that are lightweight and are low-maintenance, OEM may not be useful. For larger companies, it can be very useful.

VU
Verified User
Engineer in Information Technology (5001-10,000 employees)
Vetted Review
Oracle Enterprise Manager
5 years of experience

OEM: Best Tool for Oracle Databases

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

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.

Pros

  • 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.

Likelihood to Recommend

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.

VU
Verified User
Consultant in Research & Development (10,001+ employees)
Vetted Review
Oracle Enterprise Manager
20 years of experience

The best tool for admins on Oracle Environment.

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

The best tool for the Oracle environment. Sparc CPU has a high frequency that Intel can not provide. Using this CPU has some cost benefits on Oracle DB licenses. With the ZFS and the Logical Domain combination, you get extra flexibility. It can be hard for some admins to use CLI to manage it. In that case, Oracle Enterprise Manager will be your indispensable tool to cope with this problem. This tool will provide you with ease of administration and visibility in both hardware and software layers. Performance, hardware, and software monitoring, automatic case submitting at problems, new ldom installations, live migration between ldoms, ZFS snapshot management and similar operations in the Web-based graphical interface will provide you real comfort.

Pros

  • If you use Oracle (Sparc) environment, This software is essential.
  • Deep visiblity to Hardware, Software and Performance.
  • Manage easily even you are not familier with this enviranment.

Cons

  • Not yet.

Likelihood to Recommend

<p>If you have an Oracle environment. It is necessary. </p><p>You will save time at admin operations. You get comfort with well designed GUI. You will have a great visibility at its topology, hardware and software.</p><p>You can advanced operations like firmware os update, live migration on LDOMs, snap operations at ZFS, etc easily. Auto case submit.</p><p></p><p>But If you do not have it does not suit you.</p>

OŞ
Osman ŞEN
IT Systems Architect in Information Technology at Kuveyt Turk Participation Bank (5001-10,000 employees)
Vetted Review
Oracle Enterprise Manager
2 years of experience
View profile

OEM is the best!!!

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

We are using Oracle Enterprise Manager to manage all of our databases and manage all jobs within the department. We also use it for SQL tuning, AWR and running SQL on many databases at one time.

Pros

  • Allows you to manage multiple databases in one GUI.
  • Allows you to run jobs on multiple databases at one time.
  • Helps you maximize Oracle Database tuning and SQL tuning.
  • Also, helps manage dataguard within multiple databases.

Cons

  • Notification emails. Notifications are sending out emails for failed jobs 7 days later of the same error of the same job.
  • Being able to have redundancy for Oracle Enterprise Manager. This is way too complicated to get set up and has too many problems getting it set up. The documentation is not very good. Just making it more user-friendly and easier to install.
  • Starting OMS takes to long. Depending on the machine it can take up to 10 minutes for OMS to start up.

Likelihood to Recommend

Oracle Enterprise Manager is well suited if you have to manage multiple databases. It helps with job configuration, not only for the database but also for each database host. It allows you to run different types of jobs on each host and you can run pl/sql jobs or host scripted jobs from each server.

KT
Ken Turner
Oracle Database Administrator in Information Technology at Auburn University (5001-10,000 employees)
Vetted Review
Oracle Enterprise Manager
12 years of experience
View profile

OEM great for Oracle dbs and current hardware; older vendors, not so much

Rating: 7 out of 10
Incentivized

Use Cases and Deployment Scope

OEM is used to monitor Oracle databases and Exadata machines and perform routine maintenance operations like backups, statistics, etc. It's used by the dba teams for performance monitoring and usage tracking. It functions as a central repository for all Oracle databases within the organization. It has the ability to be utilized by non dba staff for quick database metrics like uptime, storage, utilization, backup duration, etc.

Pros

  • Provides a graphical interface to Oracle database metrics (therefore one does not need to manually execute queries on a database to find information).
  • Provides a graphical interface to hardware metrics (like cpu, memory, network, i/o utilization). This is very important as it allow non system administrators to view and understand information regarding the hardware that an Oracle database is running on.
  • Has built in features to dynamically build databases, implement RAC (cluster), implement Data Guard, and many other optional add on features to Oracle databases.
  • Has the ability to generate performance data (and other) reports that can be also be easily delivered within the organization, all through the OEM interface.

Cons

  • Information can sometimes be hard to find within OEM. There are so many different attributes that it can be difficult to find the exact area where key information can be found.
  • If OEM is running slowly, it can be hard to diagnose where the problem exists.
  • If OEM is having a performance issues and disconnects, all data is lost. This can be particularly frustrating if reports are being generated or a data guard configuration is being implemented.
  • Configuring credential setup can be very time consuming and confusing. There should be a central user that has base level OEM access for any database added to the OEM OMS repository.
  • Manually inputting credentials is very onerous.
  • As a graphical interface, not all query information is provided and therefore it can be difficult to hone a dba skill set. Since not all queries are shown, if OEM is unavailable, one will not know how to retrieve the same information directly from the database.

Likelihood to Recommend

OEM is very well suited for all Oracle products, especially Oracle databases and Exadata machines; even not Oracle hardware, it is very good and displaying high level details.

OEM is not well suited for older hardware vendors like AIX, HP-UX, DEC/Digital, Microsoft (sql server). This is a big negative as most large companies have a heterogeneous environment with many different vendor hardware and (database) software products.

MS
Maurice Samuels
DBA in Information Technology at Duquesne Light Company (1001-5000 employees)
Vetted Review
Oracle Enterprise Manager
15 years of experience

Enterprise Manager Cloud Review

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

Oracle Enterprise Manager is used to manage our Oracle Database, MySQL, and on-prem IT infrastructure that includes both Oracle and non-Oracle components and cloud deployment including OCI.

Pros

  • Oracle Enterprise Manager Cloud Control is best in breed to manage and monitor Oracle IT assets including Oracle Database and Oracle Cloud.
  • It is also able to monitor non-Oracle components as well including non-Oracle storage, middleware, and virtualization technologies.
  • It has a simple UI that can be used to pretty much do most basic management and IT life cycle management tasks for the full IT stack, both on-prem and cloud.

Cons

  • Oracle Enterprise Manager Cloud Control can do a better job in actively managing (as opposed to monitoring) non-Oracle IT components including non-Oracle database, middleware, and storage.
  • The UI is less responsive and sometimes slow and the user experience could certainly be improved.
  • There is also an issue with positioning as other Oracle products sometimes come with their own versions of management console so it is hard to justify paying for Oracle Enterprise Manager Cloud Control separately or as a new attachment.

Likelihood to Recommend

Oracle Enterprise Manager Cloud Control is well suited when you need a single console to manage a full IT stack, especially when most of the components in the IT stack are Oracle products.

VU
Verified User
Analyst in Information Technology (51-200 employees)
Vetted Review
Oracle Enterprise Manager
4 years of experience