Maintaining the performance and availability of your Oracle RAC databases has meant learning to quickly react to issues using an array of utilities and features including ORAchk/EXAchk, Cluster Verification Utility, Cluster Health Monitor, etc.
In this session learn how these and new tools including Memory Guard, QoS Management, Collection Manager, Trace File Analyzer and Cluster Health Advisor have been integrated into a 24/7 framework that autonomously monitors, alerts, recommends and can take action to resolve issues before they become evident to your users.
Learn through demonstration of actual issues including database hangs, I/O latencies and CPU utilization problems how the new Oracle Database 12c / Rel. 2, Autonomous Health Framework provides early warnings, pinpoints specific causes and recommends or takes specific corrective action.
Automating and streamlining the tasks associated with software distribution and maintenance allows IT to accelerate and scale operations. A standardized approach to provision, patch and upgrade across all layers of software infrastructure improves predictability and control.
Rapid Home Provisioning (RHP) is a new feature in Oracle Database 12c that allows for centralized software deployment. Software is installed once, stored on an RHP server, and then provisioned to any node or cluster in the private cloud.
For maintenance, RHP minimizes impact by distributing new homes out-of-place, and applying rolling updates whenever possible. A single command performs the entire operation and a simple switchback command is available in case problems arise. Upgrades are handled in a similar fashion.
By relieving the burdens of software maintenance, the IT organization can meet the demands of the scale and pace that cloud is bringing, and focus on innovative activities that bring the most business value.
Key benefits include:
» Enables and enforces standardization
» Simplifies provisioning, patching, scaling and upgrading
» Minimizes the impact and risk of maintenance
» Increases automation and reduces touch points
» Supports large scale deployments
Key features include:
» Centralized repository of gold images – Grid Infrastructure, Database, application, middleware and generic homes
» Manage existing 11.2 and 12.1 deployments with no changes needed
» Provision new pools and databases onto base machines
» Non-disruptive distribution of homes to minimize maintenance windows
» Provision, scale, patch or upgrade with a single command
» Built-in fallback capabilities
» Notification model
» Custom workflow support
» Supports all deployment models – base machines, VMs, Zones; SIDB, RAC One, RAC, Multitentant
Diagnosing and resolving Oracle RAC database problems has required extensive knowledge not only of database internals but networking, storage and O/S interactions. Frequently, these issues needed to be escalated to Oracle Support Services delaying their resolution.
New in Oracle Database 12c Release 2 is the Cluster Health Advisor that continuously analyses database ASH/AWR data and network, storage and O/S metrics to provide early warning and targeted resolution to over a hundred database issues. This session will explain its adaptive learning and prognostics design and use of this new feature including calibration to your workloads. It will conclude with demonstrations of its use with actual issues using the new CHACTL utility and standalone GUI tool as well as integration with Enterprise Manager Cloud Control 13c.