Oracle Enterprise Manager Review
Very helpful to have the ability to enable centralized control & administration of Oracle products from a single console


What is our primary use case?

Provide 24x7 monitoring of application system availability and forecasting data relating to overall system utilization (or under-utilization.)

How has it helped my organization?

With over 2,700 different target components deployed and in-use, it would be impossible for 4 DBA's to otherwise monitor and assess the condition of this number of separate application and database systems by individually logging into separate administration consoles for each product. The automation elements reduce the training time required to get our junior operators up to speed doing routine patching or cloning, and allow the senior staff to have more resource time available for strategic planning and ensuring overall availability of the critical systems without sacrificing proper monitoring and security awareness checking.

What is most valuable?

The 13cR2 updates to the OEM family, strongly integrate Cloud (off-site, hybrid and on-premise) services providing a seamless way to see all of your resources regardless of where they are deployed.

Of the 12c series of Oracle Enterprise Manager products, version 12.1.5.0.x introduces Cloud (both public and private) support for both monitoring, and lifecycle management. This allows individual components, or entire systems to be resident either in-house on conventional hardware/VM's, or ported into virtualized datacenter environments, off-site, whether for fault tolerance and disaster recovery, or simply to reduce the cost of non-Production systems by using a pay-to-play methodology (reducing investment in specific hardware just to support disposable and transitional software systems development?) Consolidated and uniform monitoring of all Oracle-related technologies. Ability to enable centralized control and administration of Oracle products from a single console. Ability to see at a glance, all conditions of all products throughout the enterprise. Version 13c includes hybrid cloud support making transparent the transfer of provisioning systems between Oracle's Cloud and on-premise equipment. All of the cloud systems and in-house systems appear in logical groups according to their common function (Applications, Middleware, Databases, etc.) The configurations are also snapshot-friendly and made comparable to quickly isolate differences between similar systems.

What needs improvement?

Reporting and statistical charting is largely still left up the end-user to develop custom solutions. Having more pre-built standard industry-generic reports using Business Intelligence (BI) Publisher provides out-of-the box basic analysis would be increasingly useful. The actual product inventory discovery and configuration process has improved, but is still fairly convoluted and requires multiple pre-requisite setup steps to be completed, requiring numerous Cancel, Go back and set something else up, then Return to the process you were performing types of process flows. It works really well if all the technology stack layers are current releases, but the more heterogeneous the architecture is, the more you will spend more time configuring outlying systems, or systems that aren't quite up-to-date.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

During upgrades, plugins take on 2 different architectures - some are built as standard WebLogic composites, allowing hot upgrades and installation (meaning you don't have to have an outage for the OEM Management System (OMS) in order to complete the installation. Others are more complex requiring specific outage windows during which time the OMS will not be able to monitor targets (often the OEM Agents are still operating, and collecting information, but you need to develop standalone OS-based alerting on the individual boxes to leverage an individual Agent's ability to provide outage notifications when the OMS is down.) These OMS-downtime upgrades and installations can also be the most prone to potential failure during installation requiring complete system rollback to a backup point.

What do I think about the scalability of the solution?

None, other than the licensing costs of high-availability for both the middle-tier and database layers.

How is customer service and technical support?

Customer Service:

7 of 10 for customer service (often various contacts are disconnected from each other communication-wise regarding the profile and installation data of customers).

Technical Support:

8 of 10 for technical support (My Oracle Support is well-integrated into the OEM platform and guides the user quickly to relevant solutions.)

Which solutions did we use previously?

Previously used prior release of OEM (version 9.2.0.6) - these older versions are no longer supported by Oracle, and are prone to many security, stability and incompatibility issues with most newer product releases (for example, 10g (10.2.0.x) is the only client still capable of backwards-compatible connections to 9i and 8i databases, and also forwardly compatible to 11g and 12c databases - but it is not supported anymore, patch or bugfix-wise.)

How was the initial setup?

Straight-forward - the basic deployment simply requires an adequately sized and certified hardware platform with sufficient storage to hold the software, and database repository, and sufficient CPU to run a web-based application based upon the number of potential monitored targets and users.

What about the implementation team?

In-house implemented. 3 days from initial download to production operation.

What was our ROI?

The typical acquisition and year-to-year support maintenance costs equate roughly to a person-year of a typical DBA. You can expect that given the ability of the existing staff to either become more precise and strategic at preventing issues from arising without adding additional staff, makes this an easy pitch. e.g. You could either add 3 additional dedicated DBA's whose job is to login and monitor every application in a typical 4-5 major application environment (EBS, HR, BI, Webapps, Mobile, SOA, etc.) 24x7, or you can install OEM and configure it to provide the requisite alerts and projection reports needed to ensure the same SLA requirements, without adding staff.

What's my experience with pricing, setup cost, and licensing?

Based upon 3 days of implementation by a single person, plus licensing costs would be approximately $60,000, including the virtualized hosts. Day-to-day is very roughly $100 for routine patching and maintenance. High-availability significantly may double or even triple these expenditures, but for some environments that's inevitable. If one system needs that level of oversight, then all of the infrastructure will be managed to the same level of oversight by OEM. There is also an augmented set of separate, but useful features being added under the Oracle Management Cloud suite of products designed to focus more on analytical problem identification (such as when one issue triggers a seemingly unrelated set of other symptoms) and leverages the power of mass target data agglomeration at the expense of having costs driven by the volume of data being recorded. But this is typical of most cloud-based solutions, where bandwidth utilization is a cost driver.

Which other solutions did I evaluate?

ELK, HP OpenView, BMC Patrol

What other advice do I have?

Analyze your daily monitoring and service intervention needs, based upon the available (or target) headcount, otherwise you may find yourself inundated with more alerts and notifications than can actually be handled by your staff. Don't just turn on all the alerting and notifications out of the box. Start with what you know you want and are capable of responding to, and closing effectively. Enable those. Then work outwards towards the nice-to-know, or discovery alerts.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
3 visitors found this review helpful

3 Comments

it_user516591Real User

Used Oracle Enterprise Manager for a long time and it is very helpful in doing monitoring of Oracle Database. It helps in Utilization Monitoring and Performance Monitoring. What I want on it is that is can provide insights on database fine tuning as we are working on high performance database. We are currently using EM 12C and integrating all our Database Servers and Database Instances on it to have a better view on the whole spectrum of our infrastructure.

20 September 16
it_user516651User

I have installed these EM versions from 11g, 12c, and 13c. So far Oracle support is quite helpful in the process.

20 September 16
James LuiReal UserTOP 5POPULAR

Agreed. Though with the Lifecycle management suite, the configuration comparisons of changes to parameters overlaid on the ABSTRACT for the same periods can provide good insights. Any thoughts on the specific "fine tuning" elements you would like to see added? Those kinds of recommendations can always be relayed back to the product development team.

21 September 16
Guest
Why do you like it?

Sign Up with Email