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.
N/A
Precisely Assure MIMIX
Score 9.9 out of 10
N/A
Assure MIMIX from Precisely (formerly Syncsort) offers IBM i high availability (HA) and disaster recovery (DR) for companies worldwide, from small businesses to global enterprises, who can use Assure MIMIX to prevent data loss and eliminate planned and unplanned downtime. Assure MIMIX provides scalable real-time replication with options for automating administration, monitoring and alerting, customizable switch automation, and a graphical…
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.
MIMIX is clearly the best IBMi solution for most high availability and disaster recovery situations. It provides rock-solid replication and agile ability to switch quickly. In its earlier days, some organizations used it as a primary daily system backup method. With the advent of Ransomware, this is no longer advisable. The strength of MIMIX real-time replication becomes a weakness if IBMi data becomes infected. As in any real-time replication product, at that point, two systems are infected.
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.
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.
MIMIX is software built for availability. By its nature it is must be available. As long as the underlying system and communication network are available MIMIX is working. And if there are failures in either of those, MIMIX is designed to allow for a quick and resilient recovery once underly systems or communications are restored
I have never seen MIMIX itself be a performance bottleneck. However it is important to consider the network in overall performance of any remotely replicated systems. MIMIX can only replicate as fast as the network allows. But a strong capability of MIMIX is its ability to "buffer" its replication, so it can be sent without error as the network allows
I still rate OEM as a must-have tool for central management of Oracle fleet. The pros and cons of the product is prominent. Meanwhile, I also acknowledge that OEM was design about a decade ago. At that time, it did not have the landscape we have today, such as cloud, DEVOPS, machine learning, etc. I hope in future releases, the design will incorporate those features.
Support is available and efficient. Response time is good and likelyhood of a quick resolutiion is high. However the mature solid product and proactive management tools, fortunately make support requirements relatively rare. The support for version upgrades is also strong, but again the basic upgrade process is usually straightforward and well documented.
Toad for Oracle is more suited for individual users who have a strong focus on database development, and it is not as comprehensive as Oracle Enterprise Manager. While it is quite decent in logical database layer tasks, such as schema objects and SQL, it lacks visibility into host level and I/O layer performance stats.
We used MIMIX for its role for iSeries high availability. We used Double Take by Vision Solutions for our production Windows environment. MIMIX is designed for iSeries, and Double Take was designed for Windows. We had VMware virtual environment, running multiple VMs for production ERP Lawson M3, now Infor. Both MIMIX and Double Take played the role well for what needed to be done. Without either MIMIX or DoubleTake, the business would have been impacted.
MIMIX works to its intended functionality. It provides real time data replication across multiple partitions and systems as defined. I have never witnessed any problems with MIMIX in scaling to larger systems or adding new data groups. In conjunction with the inherent scalability of IBMi scalability and configuration flexibillity are rather quick and easy.
