环境介绍:os：OracleLinux9.3
db:19.22
[root@sztech AHF-LINUX]# ./ahf_setup -extract orachk
AHF Insaller for Platform Linux Architecture x86_64
Linux Version : 9
AHFInstallation Log : /tmp/ahf_install_247000_40258_2024_08_27-18_18_53.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 24.7.0 Build Date: 202407302206
Default AHF Location : /opt/oracle.ahf
Do you want to install AHF at [/opt/oracle.ahf] ? [Y]|N : Y
AHF Location : /opt/oracle.ahf
AHF Data Directory : /opt/oracle.ahf/data
Extracting AHF to /opt/oracle.ahf
Setting up AHF CLI and SDK
AHF is deployed at /opt/oracle.ahf
ORAchk is available at /opt/oracle.ahf/bin/orachk
AHF binaries are available in /opt/oracle.ahf/bin
AHF is successfully Installed
Moving /tmp/ahf_install_247000_40258_2024_08_27-18_18_53.log to /opt/oracle.ahf/data/sztech/diag/ahf/
Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1]. . .
. .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . .
. . . . . . . . .
-------------------------------------------------------------------------------------------------------
Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
-------------------------------------------------------------------------------------------------------
sztech No No Yes No No Yes orcl
-------------------------------------------------------------------------------------------------------
Copying plug-ins
. .
. . . . . .
*** Checking Best Practice Recommendations ( Pass / Warning / Fail ) ***
.
Translated Message files for the language (zh) is not found. Using the default (en) Message files
============================================================
Node name - sztech
============================================================
. . . . . .
Collecting - Database Undocumented Parameters for orcl database
Collecting - List of active logon and logoff triggers for orcl database
Collecting - CPU Information
Collecting - Disk I/O Scheduler on Linux
Collecting - DiskMount Information
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - OS Packages
Collecting - Operating system release information and kernel version
Collecting - Patches for RDBMS Home
Collecting - Patches xml for RDBMS Home
Collecting - RDBMS patch inventory
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - Database Server Infrastructure Software and Configuration
Collecting - Database details for Infrastructure
Collecting - Disk Information
Collecting - Root user limits
Collecting - Verify ORAchk scheduler configuration
Collecting - Verify TCP Selective Acknowledgement is enabled
Collecting - Verify no database server kernel out of memory errors
Collecting - Verify the vm.min_free_kbytes configuration
Data collections completed. Checking best practices on sztech.
------------------------------------------------------------
INFO => Traditional auditing is enabled in database for orcl
WARNING => SYSTEM tablespace is being used by audit objects for orcl
WARNING => There are some application objects with STALE statistics for orcl
WARNING => Package libstdc++-devel-11.2.1-9.4.0.2.el9-x86_64 is recommended but not installed
WARNING => Package libaio-devel-0.3.111-13.el9-x86_64 is recommended but not installed
INFO => Most recent ADR incidents for /u01/app/oracle/product/19.22.0/db_1
INFO => Oracle GoldenGate failure prevention best practices
WARNING => Oracle database software owner soft stack shell limit is not configured according to recommendation
FAIL => The vm.min_free_kbytes configuration is not set as recommended
INFO => user_dump_dest has trace files older than 30 days for orcl
INFO => At some times checkpoints are not being completed for orcl
WARNING => One or more redo log groups are not multiplexed for orcl
WARNING => Primary database is not protected with Data Guard (standby database) for real-time data protection and availability for orcl
INFO => Important Storage Minimum Requirements for Grid & Database Homes
CRITICAL => Operating system hugepages count does not satisfy total SGA requirements
WARNING => OSWatcher is not running as is recommended.
WARNING => Consider setting the value of the parameter _cursor_obsolete_threshold to 1024 for Non-Multitenant environment which is the appropriate recommended value for orcl
INFO => Operational Best Practices
INFO => Database Consolidation Best Practices
INFO => Computer failure prevention best practices
INFO => Data corruption prevention best practices
INFO => Logical corruption prevention best practices
INFO => Database/Cluster/Site failure prevention best practices
INFO => Client failover operational best practices
WARNING => cgroup setting cpu.rt_runtime_us is not configured as recommended. for orcl
WARNING => Oracle clusterware is not being used
WARNING => DISK_ASYNCH_IO is NOT set to recommended value for orcl
FAIL => Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for orcl
WARNING => Flashback on PRIMARY is not configured for orcl
INFO => Database failure prevention best practices
WARNING => Database Archivelog Mode should be set to ARCHIVELOG for orcl
FAIL => Active Data Guard is not configured for orcl
INFO => The Optimizer fixes for 19c database version is disabled by default for bugs with status value 0 for orcl
INFO => Software maintenance best practices
INFO => Oracle recovery manager(rman) best practices
INFO => Database feature usage statistics for orcl
WARNING => Linux Disk I/O Scheduler should be configured to Deadline
WARNING => Consider investigating changes to the schema objects such as DDLs or new object creation for orcl
FAIL => Recommended bug fixes are not applied for RDBMS home for /u01/app/oracle/product/19.22.0/db_1
------------------------------------------------------------