AHF Release 23.3

Enable Database SRDCs for the Platinum Role

Starting in release 23.3, database SRDCs can be run by users with platinum role on the system in the dba group.

When an AHF user has been granted the required AHF role, they can request a subset of database-specific SRDCs to be executed even if they are not in the dba group for that database. Only the AHF owner (root) can grant the role.

Predominantly, in the Platinum environment, diagnostic requests are executed on the customer's system through the Platinum Gateway as the orarom user. The specific user may not be orarom, but in most cases it is and this user may be granted the platinum AHF role.

When a user with the platinum role (initial implementation) requests an SRDC collection that requires normally to be run as a user in the dba group and is within a limited whitelist, the request will not be rejected. Instead, the request will be executed as the DB owner or Grid owner as appropriate.

This solves the case where the Platinum team are not able to gather some diagnostics automatically through their gateway due to their user not being added to the dba group for all of a customers databases.

Unified AHF Command-Line Interface Monthly Recommended Patches (MRP) Support

In release 23.3, the unified AHF command-line interface has been enhanced to report Monthly Recommended Patches (MRP) information.

In November 2022, Oracle introduced Monthly Recommended Patches (MRP). MRP provides customers with frequent access to recommended and well-tested patch collections. For more information, see Introducing Monthly Recommended Patches (MRPs) and FAQ (Doc ID 2898740.1).

It is difficult for the customers to determine which MRP level and patches they have installed. The AHF command-line now provides a command to query the MRP level and installed patches.

To get the MRP level for the specified Oracle Home:
ahf software get-mrp-level --oracle-home TEXT
To compare MRP level against the specified Oracle Home to determine installed and missing patches:
ahf software compare-mrp-level --oracle-home TEXT --mrp-level TEXT

For more information, see ahf software.

New Oracle Orachk and Oracle Exachk Best Practice Checks

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

Oracle Orachk Specific Best Practice Checks

  • Verify important bug fixes on long term recent releases

Oracle Exachk Specific Best Practice Checks

  • Verify symbolic link for cloud registration file
  • Verify database TDE wallet configuration
  • Verify TNS configuration and connectivity to database using SYS credentials

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