Oracle Enterprise Manager Reviews and Ratings

Rating: 5.7 out of 10

Score

5.7 out of 10

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

October 14, 2022

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.

Kevin Zhang

Manager of Oracle Infrastructure in Information Technology at Scotiabank (10,001+ employees)

Vetted Review

10 years of experience

View profile

Oracle created an awesome cloud console

Rating: 7 out of 10

Incentivized

February 24, 2022

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

Verified User

Director in Information Technology (501-1000 employees)

Vetted Review

1 year of experience

Great management solution for large enterprises

Rating: 9 out of 10

Incentivized

April 16, 2021

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.

Verified User

Administrator in Engineering (51-200 employees)

Vetted Review

2 years of experience

Oracle Enterprise Manager is definitely a one-stop solution

Rating: 9 out of 10

Incentivized

December 13, 2020

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.

Verified User

Administrator in Information Technology (1001-5000 employees)

Vetted Review

10 years of experience

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

Rating: 9 out of 10

Incentivized

November 24, 2019

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.

Verified User

Engineer in Information Technology (5001-10,000 employees)

Vetted Review

5 years of experience

OEM: Best Tool for Oracle Databases

Rating: 10 out of 10

Incentivized

November 5, 2019

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.

Verified User

Consultant in Research & Development (10,001+ employees)

Vetted Review

20 years of experience

The best tool for admins on Oracle Environment.

Rating: 10 out of 10

Incentivized

October 22, 2019

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

If you have an Oracle environment. It is necessary. 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.You can advanced operations like firmware os update, live migration on LDOMs, snap operations at ZFS, etc easily. Auto case submit.But If you do not have it does not suit you.

OŞ

Osman ŞEN

IT Systems Architect in Information Technology at Kuveyt Turk Participation Bank (5001-10,000 employees)

Vetted Review

2 years of experience

View profile

OEM is the best!!!

Rating: 9 out of 10

Incentivized

October 15, 2019

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.

Ken Turner

Oracle Database Administrator in Information Technology at Auburn University (5001-10,000 employees)

Vetted Review

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

October 14, 2019

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.

Maurice Samuels

DBA in Information Technology at Duquesne Light Company (1001-5000 employees)

Vetted Review

15 years of experience

Enterprise Manager Cloud Review

Rating: 10 out of 10

Incentivized

October 9, 2019

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.

Verified User

Analyst in Information Technology (51-200 employees)

Vetted Review

4 years of experience

Loading Reviews List....

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

Rating: 7 out of 10

Incentivized

October 14, 2019

Use Cases and Deployment Scope

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.

Maurice Samuels

DBA in Information Technology at Duquesne Light Company (1001-5000 employees)

Vetted Review

15 years of experience