单机下安装Oracle AHF工具

jiawang

环境介绍: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/


[root@sztech AHF-LINUX]#
[root@sztech ahf]# cd /opt/oracle.ahf/bin/
[root@sztech bin]# ll
总用量 32
-rwxr-xr-x 1 root root 4631  8月 27 18:19 ahf
-rwxr-xr-x 1 root root 7771  8月 27 18:19 ahfctl
-rwxr-xr-x 1 root root 4701  8月 27 18:19 balance
-rwxr-xr-x 1 root root 4701  8月 27 18:19 iwareport
lrwxrwxrwx 1 root root   34  8月 27 18:19 oerr -> /opt/oracle.ahf/orachk/lib/oerr.sh
lrwxrwxrwx 1 root root   29  8月 27 18:19 orachk -> /opt/oracle.ahf/orachk/orachk
[root@sztech bin]# ./orachk
List of running databases

1. orcl
2. None of above


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


UPLOAD [if required] - /opt/oracle.ahf/data/sztech/orachk/orachk_sztech_orcl_082724_182233.zip

[root@sztech bin]#