AHF compliance checks from Oracle Orachk and Oracle Exachk are now fully integrated into AHF Insights Best Practice section.

AHF has thousands of Best Practice Compliance Checks, which are run automatically by AHF Oracle Orachk and Oracle Exachk. The results of these checks are viewable in HTML reports and output in JSON and XML for consumption into other tools. In addition, all Best Practice Compliance Checks are fully integrated into AHF Insights for running on-demand.

AHF Insights makes it easy to quickly see the Health Score, understand where systems are out of compliance and then take the necessary corrective action.

ahf analysis create --type insights

For more information, see Compliance Checking with Oracle Orachk and Oracle Exachk and Best Practice Issues.

AHF 23.8 includes the following enhancements to the user interface to make it more intuitive and easier to use.

You can now:

• Copy data in text format into the clipboard to post it into SR body while raising a service request.
  Copy button is included in the following sections of the report:

  • Cluster
  • Databases
  • Database Servers
  • Storage Servers
  • Fabric Switches
  • Recommended Software
• Spot the disks that have anomalies. In the Operating System Issues tab, under Local IO, click Disk to view Disk Metrics. Disks that have anomalies are marked with an X mark.
• Explore process aggregate from operating system details in a more intuitive way.
  • Demarcated process aggregates per the instance group like Databases, ASM, APX (Apex), IOS, Clusterware, and so on.
  • Legends specific to individual category rather than single legend for all categories.

Upload AHF Insights report automatically if Object Store is configured as part of AHF or Pre-Authenticated URL (PAR) for centralized monitoring.

Uploading AHF Insights reports helps Oracle Cloud Operations to identify, investigate, track, and resolve system health issues and divergences in best practice configurations quickly and effectively.

ahfctl setupload -name oss -type https -user <user> -url <object_store> -password

ahf analysis create --type insights

tfactl diagcollect -insights -last 1h -par <par_url>

tfactl insight -last 1h -par <par_url>

Schedule cron jobs to generate AHF Insights report.

• To get cron details:

  tfactl get cron

  # tfactl get cron
    .----------------------------------------------.
    |                <hostname>                    |
    +--------------------------------------+-------+
    | Configuration Parameter              | Value |
    +--------------------------------------+-------+
    | Enable/disable the TFA cron ( cron ) | OFF   |
    '--------------------------------------+-------'

• To enable cron:

  tfactl set cron=on

  # tfactl set cron=on
    Successfully set cron=ON
    .----------------------------------------------.
    |                <hostname>                    |
    +--------------------------------------+-------+
    | Configuration Parameter              | Value |
    +--------------------------------------+-------+
    | Enable/disable the TFA cron ( cron ) | ON    |
    '--------------------------------------+-------'

• To reload cron with modifications:

  tfactl refreshconfig modifycron -enable true -id <ID> -validFor all

  # tfactl refreshconfig modifycron -enable true -id id001 -validFor all
  modifycron() completed successfully.

• To list existing cron details:

  # tfactl refreshconfig listcrons

  # tfactl refreshconfig listcrons
    TFA CRON item:
    Name:     id001
    Command:  ahf analysis create --type insights --last 5m
    Schedule: 0 3 * * 1

• To turn off cron:

  # tfactl set cron=off

  # tfactl set cron=off
    Successfully set cron=OFF
    .----------------------------------------------.
    |                <hostname>                    |
    +--------------------------------------+-------+
    | Configuration Parameter              | Value |
    +--------------------------------------+-------+
    | Enable/disable the TFA cron ( cron ) | OFF   |
    '--------------------------------------+-------'

AHF Balance no-longer requires a GI Home and now works with any Oracle Home.

Database CPU use is limited by the database CPU_COUNT parameter. When these limits add up to more than the number of CPUs on a machine, noisy-neighbor problems are possible.

AHF Balance analyzes database CPU configuration and historical CPU usage data from Enterprise Manager. The high-level results of this analysis are shown in the Oracle Orachk / Oracle Exachk MAA Score Card.

Further reports can be run to:

• Get an overview of possible noisy neighbors across the fleet.
• See detailed information about a specific database.
• Generate a corrective action plan.

For more information, see Data Source.

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