Changes in this Release for Oracle Autonomous Health Framework Checks and Diagnostics User's Guide 20.2

This preface lists changes in the Oracle Autonomous Health Framework Checks and Diagnostics User's Guide 20.2.

• Resource Savings Through Fewer Repeat Collections for Similar Issues
  Flood control avoids unnecessary repeat collections for similar events and helps conserve system resources.
• Limit Oracle Trace File Analyzer's CPU Usage
  On Linux the CPU usage of Oracle Trace File Analyzer can be limited with the command tfactl setresourcelimit [-value value]
• Easier to Upload Diagnostic Collections
  The command tfactl setupload -name config_name -type config_type can be used to configure where diagnostic collections from Oracle Trace File Analyzer, Oracle ORAchk, and Oracle EXAchk are automatically uploaded.
• Latest Most Secure Python Stack
  The Python stack has been upgraded to 3.7.7.
• Run All Database Server Compliance Checks Without Needing root Password
  All complaince checks can now be run on the database server without requiring the root password.
• Integration of Oracle DBSAT into Oracle Autonomous Health Framework
  DBSAT is a lightweight utility that will not impair system performance in a measurable way.
• Integration of AutoUpgrade utility into Oracle Autonomous Health Framework
  The AutoUpgrade utility identifies issues before upgrades, performs pre- and postupgrade actions, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database.

Resource Savings Through Fewer Repeat Collections for Similar Issues

Flood control avoids unnecessary repeat collections for similar events and helps conserve system resources.

The flood control limit instructs Oracle Trace File Analyzer to only collect a certain amount of times for the same event and then pause collection for that event for a set duration.

Limit Oracle Trace File Analyzer's CPU Usage

On Linux the CPU usage of Oracle Trace File Analyzer can be limited with the command tfactl setresourcelimit [-value value]

For example to limit Oracle Trace File Analyzer to a maximum of 50% of a single CPU use: tfactl setresourcelimit -value 0.5

CPU resource limits for Oracle Trace File Analyzer can be set between a minimum of 0.5 and maximum of 4 or 75% of available CPUs, whichever is lower. By default, the Oracle Trace File Analyzer CPU limit is set to the maximum.

Easier to Upload Diagnostic Collections

The command tfactl setupload -name config_name -type config_type can be used to configure where diagnostic collections from Oracle Trace File Analyzer, Oracle ORAchk, and Oracle EXAchk are automatically uploaded.

Collection configurations can also be used on-demand using tfactl upload. Multiple upload configurations can be stored by giving them unique names.

For example to configure Oracle ORAchk uploads to be stored in a database you can use:

tfactl setupload -name mysqlnetconfig -type sqlnet

Oracle Trace File Analyzer will then prompt you for the required values.

Along with setupload, you can also use:

• tfactl getupload -name config_name to retrieve all values
• tfactl checkupload -name config_name to check if the values can be used to make a connection to the resource
• tfactl unsetupload -name config_name [-parameter parameter | -all] to unset one or all the values for the configuration

Latest Most Secure Python Stack

The Python stack has been upgraded to 3.7.7.

This upgrade avoids all known Python security issues.

Run All Database Server Compliance Checks Without Needing root Password

All complaince checks can now be run on the database server without requiring the root password.

Oracle ORAchk root checks can be passed to the Oracle Trace File Analyzer root daemon for excution as root. This means as a DBA you can now run all checks without requiring the root password.

Integration of Oracle DBSAT into Oracle Autonomous Health Framework

DBSAT is a lightweight utility that will not impair system performance in a measurable way.

Integration of AutoUpgrade utility into Oracle Autonomous Health Framework

The AutoUpgrade utility identifies issues before upgrades, performs pre- and postupgrade actions, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database.