Significant New Changes in Oracle Real Application Clusters (RAC) 18c and 19c

Here is a shout out to a very good blog post by Anil Nair Oracle Senior Principal Product Manager on How to upgrade to Significant New Changes in Oracle Real Application Clusters (RAC) 18c and 19c.

A quick recap on this topic:

• Starting with 18c and higher releases RMV process has been renamed to RS process.
• LMS is not running in High Priority mode. In fact LMS process runs in multi-threaded mode now.
• USM Process.
• A whole lot more.

The entire blog post by Anil can be found here.

Cheers.

Oracle Real Application Clusters (RAC) 19c - Best Practices and Internals Summary

Today's post is another shout out to an excellent presentation by Anil Nair Oracle Senior Principal Product Manager on Real Application Clusters 19c - Best Practices and Internals Summary.

Here is a brief summary of the presentation by Anil:

• Oracle 19c Upgrade Best Practices.
• Oracle 19c Grid Infrastructure New Features.
• What's new with Oracle Cache Fusion?
• Oracle 19c requires Linux 7.
• One Command for all Autoupgrade checks.
• Oracle Grid Infrastructure Management Repository is no longer mandatory with 19c
• gridSetup can now be run with a -dryRunForUpgrade option for Oracle Grid Infrastructure Upgrades.
• Faster Cloning can be done with Real Only Oracle Homes (ROOH) store as Oracle Configuration files are stored outside of the Oracle Home.
• You can patch faster with -SwitchHome.
• New Grid Infrastructure (GI) Resource Modeling for PDBs.
• Oracle Clusterware Runtime Diagnostics.
• Oracle 19c Clusterware attempts to auto-diagnose unsuccessful startup issues.
• Private Network Interface Check.
• Oracle Clusterware Ciphers.
• Optimized Resource Master Placement.
• Real Application Clusters (RAC) Performance Automation.
• RAC Exadata optimizations.

To summarize, Oracle RAC 19c is improved and optimized with a lot of automations to make the DBA's life easier than before. Check out Anil's presentation here.

Enjoy the new features of Oracle RAC 19c.

Cheers.

Life After Oracle Autonomous Database

I will be presenting at Oracle Open World (OOW19) alongside my fellow ACE Director Francisco Munoz Alvarez. Please come join us at OOW19 to learn more on Oracle Autonomous Database & Cloud DBAs.

Does the Cloud Mean the End of the DBA? Life After Oracle Autonomous Database.

Session Code: CON2405

Topic: Innovate in the Cloud

Job Role: DBA

Products and Solutions A–Z: Business Intelligence and Analytics, Autonomous Database, Database Cloud Service

Session Type: Conference Session

SCHEDULE: Monday, September 16, 02:45 PM - 03:30 PM | Moscone West - Room 3014

The cloud is transforming the enterprise and the career path of the DBA. As the cloud gains momentum and migrations of applications and databases become more common, people can’t help but wonder whether the cloud means the end of the DBA. In this session learn why the answer to that question is No, but it is an agent in unprecedented change. Learn how the cloud is bringing about an evolution and what today's DBAs must know to be successful in a cloud-enabled future. Topics covered include how the DBA role is transforming into more strategic roles such as data architect, and how today's DBAs can prepare and develop skillsets that will translate into a successful career path in the cloud. The session also offers a look at trends and predictions on what will impact IT in the future.

SPEAKERS:

Tariq Farooq, BrainSurface

Francisco Munoz Alvarez, CloudDB

Leveraging Machine Learning to diagnose Real Application Clusters Issues & Incidents

Today's post is a shout out to a much needed presentation by Anil Nair Oracle Senior Principal Product Manager on Leveraging Machine Learning to diagnose Real Application Clusters Issues & Incidents.

Here is a brief summary of the presentation by Anil:

• Scalability without changing Application Code.
• Problem Resolution Paths & Approaches.
• Reactive & Proactive Diagnosis.
• Common Problems such as Hangs, Performance Issues, Deadlocks etc.
• Case Studies of Incidents & Issues in Real Application Clusters (RAC).
• Automatic Notification & Diagnosis Collection with Trace File Analyzer (TFA).
• Cluster Health Advisor TFA SMTP Notifications.
• Configuring OraChk to run in DAEMON mode.
• Node Evictions due to Memory Pressure.
• RAC Misconfigurations.
• Oracle Memory Guard.
• Aggregated Data by Process Type provided by CHM.
• Sample Problems & Resolutions.
• Reconfiguration Diagnosability.
• Dynamic Remastering (DRM) Diagnosability.
• Grid Infrastructure Management Repository (GIMR).
• Autonomous Health Framework (AHF) collects much of the data that OSWatcher collects.
• Documents & Resources
• Whats New?
• Oracle Autonomous Health Framework (New).
• Applied Machine Learning Diagnostics (New).
• Autonomous Health - Database Performance (New).
• Cluster Health Advisor Graphical (CHAG) (New).

As should be clear by this excellent presentation, Leveraging Machine Learning to diagnose Real Application Clusters Issues & Incidents makes the whole RAC diagnosis process easier & faster.

Cheers.

Autonomous Database on Dedicated Exadata Cloud Infrastructure - A Quick Overview

Autonomous Database on Dedicated Exadata Cloud Infrastructure - A Quick Overview.

Here is a very good blog post by Maria Colgan Master Product Manager at Oracle Product Management summarizing this offering by Oracle. Here is a quick recap on this topic.

• You can get your very own Private Database Cloud on Exadata infrastructure in the Oracle Public Cloud. Now thats kinda cool.
• You get two choices with Oracle Autonomous Database: Dedicated or Serverless.
• With Autonomous Database, Oracle takes care of stuff for you: Autonomous Database Serverless automates database management/maintenance with all common management features provided by Oracle such as Configuration, Monitoring, Provisioning, Backups, Performance Tuning etc.
• Dedicated Exadata Cloud Infrastructure in the Oracle Public Cloud enables total isolation from other tenants and requirements customization according to organization's specific footprint/needs.
• Patching Schedules can be customized/scheduled according the organization's specific requirements.
• Autonomous Container Databases are easy to provision, configure and setup.
• The system can be partitioned into a customizable number of clusters or container DBs (CDBs).
• Operational Policies can be customized e.g. Density, Patching/Updated Schedules, High Availability etc.
• Summary
• You can now get your very own Private Database Cloud on Exadata infrastructure in the Oracle Public Cloud with control over operational policies such as patching, versions, density, high availability etc.
• With Serverless, you can quickly and rapidly build applications against without worrying about operational details such as patching, versions etc.

This video by Juan Loaiza gives a good recap on this topic.

I hope you got a quick overview of Autonomous Database on Dedicated Exadata Cloud Infrastructure.

Cheers.

Exadata Database Machine X8: The Foundation for Cloud & Autonomous Databases: A Primer

Here is a very beneficial blog post on this topic.

Quick Recap - Oracle has introduced the following Hardware and Software with its next generation of Exadata Family:

• Exadata X8-2 & X8-8 Database Server Overview.
• Exadata X8-2 Intelligent Storage Server High Capacity (HC).
• Exadata X8-2 Intelligent Storage Server Extreme Flash (EF).
• Exadata X8-2 Storage Server Extended (XT).
• Flexibility & Elasticity: License Cores as Workloads require them.
• Exadata continues to lead in overall Database Performance.

Enjoy the next generation of Exadata with X8.

Cheers.