2. Changes in Previous Releases
  3. AHF Release 24.4

AHF Release 24.4

Parent topic: Changes in Previous Releases

Preserving Oracle Database 23ai Availability and Performance From Day One

AHF is included and fully integrated with Oracle Database 23ai.

Oracle announced Database 23ai general availability, with a focus on three key areas:

  • AI for Data
  • Dev for Data
  • Mission Critical for Data

Oracle Autonomous Health Framework is fully integrated and included with Oracle Database 23ai out of the box. The first version of Oracle Database 23ai ships with AHF 24.2 and every future Release Update (RU) will include new AHF releases.

Use AHF Insights to:

  • Proactively view Oracle Database 23ai health checks, which check for and recommend resolutions to drifts from best practice configuration.
  • Take a bird’s-eye view of your Oracle Database 23ai system
  • Explore Oracle Database 23ai diagnostics, with AI powered anomaly detection and timeline analysis

For more information about Oracle Database 23ai see Oracle Database 23ai Free.

Parent topic: AHF Release 24.4

Node Eviction Detection and Resolution

AHF Insights now provides a single page problem summary for node evictions, showing the detected node restart, the cause, evidence, and resolution steps.

Node evictions are one of the most problematic Oracle Grid Infrastructure (GI) issues. They can have a huge impact on service performance and used to be difficult to resolve, often requiring long engagements with Oracle Support to diagnose.

AHF now automatically detects node evictions and generates a diagnostic collection containing an AHF Insights report.

The Insights report provides a single page problem summary, which brings together all data from AHF components to show simply and succinctly what happened and how to avoid it in the future.

Detected node evictions are shown in the Problems panel of the Insights dashboard. From there users can drill-down to a specific node eviction.

The page presents the Problem Summary containing:

  • Problem – including which node was restarted and at what time.
  • Reason – explaining why the node was restarted.
  • Cause – explaining the root cause.
  • Evidence – providing a bullet list audit trail detailing relevant operating system and database resource metrics, which were out of normal range leading up to the event.
  • Resolution Steps – detailing in simple terms exactly how to resolve the problem.

Evidence is expandable, showing charts or log details to confirm the evidence.

This release provides the ability to detect node evictions caused by HugePages over allocation. Future releases will continue to expand to identify other node eviction causes.

An AHF Insights report can also be generated on-demand by running:
ahf analysis create --type insights

Related Topics

Parent topic: AHF Release 24.4

Ability to Downgrade AHF

AHF now supports downgrading to the last version previously upgraded from, as long as it is less than 6 months old.

AHF is installed with Grid Infrastructure, which also supports downgrading, however after a GI downgrade AHF used to become unusable because of broken GI Python and JDK dependencies.

Additionally, customers who had performed an AHF install outside of GI were unable to downgrade, without losing configuration and event data.

This was because the AHF installer would prevent a new install if it found a more recent version on the system. Customers had to uninstall the current version and reinstall an older one, there was no way to retain configuration or event data, which resulted in its loss.

Now AHF supports downgrading to the last version previously upgraded from, if it is less than 6 months old. 24.4 is the first version you will be able to downgrade to.

During the downgrade process, AHF will:

  1. Export configuration and event data from the installed version.
  2. Remove the installed binaries.
  3. Install the older binaries.
  4. Import the exported configuration and event data.
To perform a downgrade:
  1. Find your eligible downgrade target version by running:
    ahf software get-downgrade-target [--version] [–location]
  2. Validate AHF Installer by running:
    ahf software validate-downgrade-installer --installer <installer file>
  3. Run the following command using the downgrade target AHF installer:
    ahf_setup -downgrade

If you do not have access to the AHF installer from the previous version, contact Oracle Support to obtain it.

Related Topics

Parent topic: AHF Release 24.4

Automatic Diagnostic Collection for Database Anomalies

AHF can now be configured to automatically collect diagnostic collections whenever it detects certain database performance anomalies.

Often by the time database performance anomalies are reported, it can be too late to capture important real-time diagnostic data.

AHF can now detect the following database anomalies and trigger an automatic diagnostic collection:

  • Controlfile Enqueue Hang
  • Log File Sync Hang

The resulting collection contains all real-time data required for Oracle Support to help resolve the problem, from first failure.

To enable automatic anomaly collection run:
tfactl set chaAutoCollect=<on|off> -c

Related Topics

Parent topic: AHF Release 24.4

Faster AHF Insights Report Generation

Insights report generation has been optimized to be twice as fast as previous releases.

Customers rely on AHF Insights for a bird’s-eye view of the entire system. It helps spot problems, drill into their root cause and understand how to resolve.

Insights report generation has now been optimized to be much faster. Internal testing shows AHF Insights is now twice as fast as previous releases to generate the report. AHF Insights is automatically included within AHF diagnostic collections. It can also be generated on-demand using the command:
ahf analysis create --type insights

Transfer the resulting zip to a system with browser support, extract it and open index.html.

Related Topics

Parent topic: AHF Release 24.4

Insights Accessibility Improvements

Accessibility improvements have been made to AHF Insights, home button, navigation, and drawers.

Accessibility refers to the design and implementation of digital products and environments that are usable by all people, regardless of their abilities or disabilities. This includes ensuring that people with disabilities can perceive, understand, navigate, and interact with digital content and interfaces effectively.

As part of the efforts to provide the most accessible experience to our users, we are happy to introduce the next accessibility features for 24.4:

Accessible Home Button

Revamped the Home tab to make it more user-friendly, especially for those using screen readers. Now, it behaves exactly like a tab should, eliminating any confusion caused by its previous behavior as a button.

Accessible Navigation:

Following on from the Insights Accessibility Improvements, this has now been replicated across the rest of Insights.

The old pagination component has been replaced with a sleek new scrollbar, making it easier to navigate through content without losing focus. The new scrollbar ensures a seamless browsing experience, especially for the users using screen readers.

Here are all the sections that include the new scrollbar:

  • CLUSTER
  • RECOMMENDED SOFTWARE
  • DATABASES
  • RPM LIST
  • DB PARAMETERS
  • KERNEL PARAMS
  • SPACE ANALYSIS

Introducing Drawers:

Insights now uses drawers instead of expanding rows. As well as enhancing accessibility with built-in support for screen readers, the new draws bring a more streamlined look to the page.

Here are the sections using drawers in this release:

  • PATCH ANALYSIS
  • DATABASES

To get started with AHF Insights run ahf analysis create --type insights in the resulting zip file open the index.html.

Parent topic: AHF Release 24.4

Diagnose and Resolve ORA-04030 using AHF

Oracle Database has published a new AHF Fix Flow article and video, showing how to use AHF to diagnose and resolve ORA-04030 errors.

The error “ORA-04030: out of process memory when trying to allocate bytes“, occurs when an Oracle process runs out of operating system memory.

The error is caused by either:

  • Exhausting total machine physical memory
  • Exhausting designated space in the Program Global Area (PGA)

The AHF team have created a new Fix Flow article showing how to use AHF to collect diagnostic collections for this error. The article explains why the error occurs and gives step-by-step guidance to use AHF to capture a diagnostic collection, then how to use it to either find a resolution or get more help from Oracle Support.

Read more about ORA-04030.

For more information for how AHF can help resolve database issues see the user guide on Resolve Database Issues.

Parent topic: AHF Release 24.4

New Oracle Orachk and Oracle Exachk Best Practice Checks

Release 24.4 includes the following new Oracle Orachk and Oracle Exachk best practice checks.

Best Practice Checks Common to Both Oracle Orachk and Oracle Exachk

  • Verify no obsolete patches installed in ORACLE_HOME.
  • Dedicated Tablespace for Unified Audit Trail

All checks can be explored in more detail via the Health Check Catalogs:

Related Topics

Parent topic: AHF Release 24.4