The new feature enhancements for Database Management (DBM) service in the Oracle Cloud Infrastructure (OCI) help rectify degrading performance trends before they become larger issues. OCI DBM provides a single-pane-of-glass view to track weekly resource trends with a concise overview to manage a healthy database environment. Database groups combine database resources – in the cloud or in a data center – to track the top trending databases across CPU, memory, or throughput usage to efficiently triage at-risk environments. Once a database has been identified as declining in overall performance, the Automatic Database Diagnostic Monitor (ADDM) can be invoked to assist in identifying the root cause of the degradation.
Oracle Enterprise Manager 13c Release 5 Update 8 (188.8.131.52), RU8 for short, is now available for download from My Oracle Support > Patches & Updates.
Release Updates Details
Release Updates (RUs) are the agile way to roll out new EM features and bug fixes quickly to customers, so they don’t have to wait for a major release. Release Updates are versioned with a trailing digit indicating the RU version. Note that RUs are cumulative, which means that the most recent RU includes functionality from all previous release updates. Our general recommendation is to apply the most current Release Update as soon as possible.
Oracle Cloud Infrastructure (OCI) will launch new sovereign cloud regions for our customers across the European Union.
Cloud is not one size fits all. As companies and governments move more mission critical workloads to cloud, there is increasing demand for protection of sensitive data in public clouds that span national borders and jurisdictions. Countries and jurisdictions are placing more requirements on data within their borders, and organizations are asking their global cloud providers for more transparency and control over how and where their data is stored, handled, and secured.
In a prior blog, we shared enhancements on Oracle Application Performance Monitoring (APM). It was well received, so we thought we would summarize another set of updates that happened in the last couple of months.
Dedicated Vantage Points
Synthetic monitoring allows for proactively generated user transactions on-demand, from various vantage points, and analysis of the sytem response just like end users would. This way, problem detection occurs before they are reported by users. Many of our customers applications are deployed on-premises or within secure networks and they could not be tested from a public vantage point. Often, these secure applications APIs also need to be tested in order to integrate with other applications. APM’s monitors allow you to meet all these requirements. With APM Dedicated Vantage Pointset up you can run APM monitors. Dedicated Vantage Points define a secure location within a tenancy, give complete control over network settings, and enable endpoint monitoring for endpoints that are not publicly accessible.
Our seventh Release Update for Oracle Enterprise Manager 13.5! Oracle Enterprise Manager 13c Release 5 Update 7 (184.108.40.206), RU7 for short, is now available for download from My Oracle Support > Patches & Updates.
Key Updates in RU7
Here is a list of new features this EM 13.5 Release Update is introducing:
Enterprise Manager Dynamic Runbooks
A Runbook is generally understood as a collection of instructions, or a recipe book, for performing common tasks and IT operations procedures. Runbooks can be created to provide step-by-step guidance to efficiently and accurately resolve an issue, based on previous experiences. Senior team members can this way share their knowledge with junior members and save detailed procedural steps for anyone to use in the future.
The Enterprise Manager Dynamic Runbooks are collections of automated steps that can be used to resolve incidents and events by leveraging the wealth of knowledge and monitoring expertise in an IT organization. Many of these steps, if not all, can be performed using Enterprise Manager.
Migration Workbench Multiphase Transportable Tablespace Migrations
Oracle Enterprise Manager Migration Workbench has been supporting Transportable Tablespace (TTS) migrations, a migration method of choice, especially for large databases since the downtime can be minimized. With this release update, you now have more control over the various migration phases. You have the option to control the number of incremental backups and initiate the final migration step during a planned maintenance window. This final migration step is the only time when your source data would not be available. The job execution’s Launchpad user interface, with its tree-like structure, makes it easy to review the various phases and incremental backups, and you can schedule and complete them as needed.
Fleet Maintenance Automatic Operation Scheduling
You can now automatically schedule Fleet Maintenance operations such as Migrate Listener and Update Databases to be performed at a specific time or immediately after the previous task completes.
New Configuration and Compliance Management Views
The Compliance Framework added two new management views: the Compliance view mgmt$rules_evaluated_per_day, which provides information on rules evaluated daily, and the Enterprise Configuration Management view mgmt$changes_per_snapshot, a diagnostic view that tracks changes performed per snapshot.
STIG Standard Version 2 Release 3 for Oracle Database 11g Release 2, 12c, and 19c
The latest STIG Version 2 Release 3 standards for Oracle Database 11g Release 2, 12c, and 19c are now available via the Self Update option and the traditional Configuration and Compliance standard options.
Support for Chargeback Templates
The Cloud Management Pack’s Chargeback option, for the functionality that allows you to divide the cost among Oracle Cloud Infrastructure entities and charge based on usage, has been enhanced to support templates. You can now save the input from a wizard session to a template and then apply it to future Chargeback setup sessions. This capability saves significant time and effort, especially when working with a large number of entities/targets.
New metric group for PDBs
A new metric group, Resource Usage, is now available for Pluggable Databases (PDBs). The metrics in this metric group, such as Average Buffer Cache Usage and Average CPU Utilization, enable you to monitor the various aspects of PDB resource usage.
Export Enterprise Manager data to Exadata Warehouse
Enterprise Manager collects and stores valuable performance data from all its targets, including on-premises or Cloud Exadata Database Machine and ZDLRA targets. This Engineered Systems data can now be exported to an Exadata Warehouse for longer retention and analysis.
New REST API Reference Documentation
Oracle Enterprise Manager has now released a new reference guide for REST API endpoints that allow you to manage core framework subsystems. This guide includes an initial set of APIs that are now officially released. As new REST APIs get tested and made available, their full descriptions will be added to this guide.
Reorganized Metric Reference Guides
The Enterprise Manager Cloud Control Oracle Database Plug-in Metric Reference Manual has now been split into three independent guides to provide a better user experience in searching and accessing the various metrics. The metrics are separated by types such as Grid Infrastructure, Database, and Engineered Systems.
Share Insight In New Ways Using Grafana and EM
Team members in DevOps, Development, and Application owners roles are often interested in the rich data collected by EM, but don’t have access to EM directly or are not interested in using EM’s full functionality. Using the EM App for Grafana, EM customers can display data from their managed targets into another tool already in use, like Grafana. Enabling this capability also helps organizations reduce collection overhead and finger-pointing. The app is available to EM customers at no additional cost. Check that you have the applicable EM Management Packs licensed that provide the data before using.
The sixth Release Update for Oracle Enterprise Manager 13.5! Oracle Enterprise Manager 13c Release 5 Update 6 (220.127.116.11), RU6 for short, is now available for download from My Oracle Support > Patches & Updates.
Release Updates Details
If you are new to the Oracle Enterprise Manager (EM) solution you may find this information useful: Release Updates (RUs) enable us to roll out new features and bug fixes quickly so you don’t have to wait for a new major release. Release Updates are versioned using a trailing digit indicating the RU version and are cumulative, which means that the most recent RU includes functionality from all previous Release Updates. Our general recommendation is to apply the most current Release Update as soon as possible.
Stack Monitoring application discovery and topology
You can’t monitor what you can’t see and using different tools that just monitor a piece of an application delays issue resolution. In one click, Stack Monitoring performs discovery of Oracle E-Business Suite (EBS) and its components such as: Concurrent Processing, Forms System, Workflow Group as well as the underlying WebLogic Clusters and WebLogic Servers that they run on. You can also discover the Oracle Database which serves as the database tier for the EBS application. The topology of the EBS application is automatically constructed, enabling the correlation of the EBS application with the specific WebLogic Server(s) and Oracle Database it depends on. This provides the foundation to better monitor and correlate issues across the stack for an EBS application and eliminate legacy tools that monitor a piece of the application.
Engage with Oracle experts and leadership at the Enterprise Manager Technical Forum 2022, live April 19-21! In this webinar series you will hear about many new features along with tips and best practices for the top use cases for those using Enterprise Manager to manage your IT infrastructure. Detailed descriptions of each session can be found at the registration page so sign up today.
Senior Vice President, Operating Systems
and Virtualization Engineering
Product Management Vice President,
Enterprise and Cloud Manageability
Join featured speakers Wim Coekaerts, SVP of Engineering, Mughees Minhas, VP of Product Management, and key product experts to learn about the latest innovations in Enterprise Manager and get your most pressing questions answered.
Immerse yourself in three days of interactive, technical 30 minute sessions covering topics such as performance management, security hardening, hybrid cloud management, best practices, and more.
April 19th Conference Keynote, Customer Spotlight and six Technology Spotlight sessions
April 20th General Session Database Lifecycle and Security and seven Technology Spotlight sessions
April 21st General Session Database Performance and six Technology Spotlight sessions
Check out the detailed agenda and register today.
Zero Downtime Migration (ZDM) 21.3 is available for download! ZDM is Oracle’s premier solution for moving Oracle Database workloads to Oracle Cloud, supporting various Oracle Database versions as the source and most Oracle Cloud Database Services as targets. Zero Downtime Migration 21.3 enhances the existing functionality by adding online cross-platform migration, Standby Databases as a source, Data Guard Broker Integration, and many more features!
Read the complete article by Ricardo Gonzalez