AHF Release 24.3

Diagnose and Resolve ORA-04031 and ORA-07445 Using AHF

Oracle Database has published two AHF Fix Flow articles and a video, showing how to use AHF to diagnose and resolve ORA-04031 and ORA-07445 errors.

ORA-04031: unable to allocate bytes of shared memory, occurs because more shared memory was needed than was available.

ORA-07445 exception encountered: core dump, can happen anywhere within Oracle code. It’s caused by an operating system exception occurring which should result in the creation of a core file.

Both of these error are frequently seen by Database customers.

The AHF team have created two new Fix Flow articles showing how to use AHF to collect diagnostic collections for either error. Each 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.

For more information, see Resolve Database Issues.

Compliance Checks for GoldenGate Microservices Architecture

AHF now support compliance checks for GoldenGate Microservices Architecture.

AHF has supported compliance checks against GoldenGate classic for several years. This release now expands that support to include GoldenGate Microservices Architecture.

To run the new GoldenGate compliance checks configure the REST connection details by running:
ahf configuration set --type goldengate --all
Then run either Orachk and Exachk with the goldengate profile:
orachk -profile goldengate
exachk -profile goldengate

Insights Accessibility Improvements

As part of the efforts to provide the most accessible experience to our users, AHF 24.3 introduces the next accessibility features.

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.

Accessible Home Button

Revamped 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.

Enhanced Accessibility within Home Page Regions

Support for screen readers to all items within the Topology and Insights sections in Home page. This means that users relying on screen readers can now easily identify and understand each item they’re focusing on along with the valuable information it provides.

Accessible Navigation in Timeline

Replaced the old pagination component in Timeline it with a sleek new scroll bar, making it easier for you to navigate through content without losing focus. The new scroll bar ensures a seamless browsing experience, specially for the users using screen readers.

Introducing Accordions

Now, within the Best Practice Issues section, you’ll find accordions that act as top-level details for each check. When expanded, these accordions reveal check-related data points, providing you with a clear and organized view of the information you need. This not only preserves the functionality of the previous layout but also eliminates the nested tables pattern, ensuring better accessibility support for all users, including those relying on screen readers. With this update, accessing and understanding your reports has never been easier!

For more information, see Explore Diagnostic Insights.

Enhancements to Unified AHF CLI

The AHF release 24.3 adds new command options to ahf analysis create, ahf configuration set, ahf configuration get, ahf configuration unset, and ahf configuration check.

  • ahf analysis create --type insights --tag <tag>
  • ahf configuration set --type upload <options>
  • ahf configuration get --property reposizeMB
  • ahf configuration get --property repositorydir
  • ahf configuration get --type upload <options>
  • ahf configuration unset --type upload <options>
  • ahf configuration check --type upload --name <upload_config>
  • ahf configuration check --type fleet-insights

Additionally, AHF 24.3 adds a command option --to-json for rendering the output in JSON format. Except for ahf software get-mrp-level --oracle-home <oracle-home>, use --to-json when you run any ahf command.

ahf software get-version --component ahf --to-json
{
  "api_invocation": {
    "api": "categories.software.version",
    "args": [],
    "kwargs": {}
  },
  "version": "24.3.0",
  "ahf_version": "24.3.0",
  "tfa_version": "",
  "compliance_version": "",
  "compliance_metadata_version": "",
  "build_timestamp": "20240305221412"
}

New Oracle Orachk and Oracle Exachk Best Practice Checks

Release 24.3 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 orphaned files exist in ASM

Oracle Orachk Specific Best Practice Checks

  • Verify grid inventory node list

Oracle Exachk Specific Best Practice Checks

  • Exadata Critical Issue EX85

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