Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk

本文链接：https://blog.csdn.net/ctypyb2002/article/details/122812892

Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk (文档 ID 2550798.1)

在这里插入图片描述

# su - oracle
$ cd /tmp
$ rz
$ ls -l AHF*
-rw-r--r--  1 oracle oinstall 417185977 Feb  7 18:00 AHF-LINUX_v21.4.1.zip

$ unzip AHF-LINUX_v21.4.1.zip
Archive:  ./AHF-LINUX_v21.4.1.zip
  inflating: README.txt              
  inflating: ahf_setup               
 extracting: ahf_setup.dat           
  inflating: oracle-tfa.pub

$ ./ahf_setup 

AHF Installer for Platform Linux Architecture x86_64

AHF Installation Log : /tmp/ahf_install_214100_17017_2022_02_07-18_13_20.log

Starting Autonomous Health Framework (AHF) Installation

AHF Version: 21.4.1 Build Date: 202201112133

Default AHF Location : /home/oracle/oracle.ahf

Do you want to install AHF at [/home/oracle/oracle.ahf] ? [Y]|N : n

Please Enter new AHF Location : /u01/app/oracle/product/19.3.0/db_1/suptools/ahf

AHF Location : /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf

AHF Data Directory : /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/data

Extracting AHF to /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf

Configuring TFA in Standalone Mode...

Build Version : 214100  Build Date : 202201112133

Discovering Nodes and Oracle Resources

.--------------------------------------------------------------------------------------------------.
|                                   Summary of TFA Configuration                                   |
+----------------+---------------------------------------------------------------------------------+
| Parameter      | Value                                                                           |
+----------------+---------------------------------------------------------------------------------+
| TFA Location   | /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/tfa                 |
| Data Directory | /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/data/ora19/tfa      |
| Repository     | /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/data/repository     |
| Diag Directory | /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/data/ora19/diag/tfa |
| Java Home      | /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/jre                 |
'----------------+---------------------------------------------------------------------------------'

.----------------------------------------------------------------------------------------------.
| Host  | Status of TFA | PID | Port    | Version    | Build ID             | Inventory Status |
+-------+---------------+-----+---------+------------+----------------------+------------------+
| ora19 | RUNNING       | -   | OFFLINE | 21.4.1.0.0 | 21410020220111213353 | COMPLETED        |
'-------+---------------+-----+---------+------------+----------------------+------------------'

AHF is deployed at /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf

ORAchk is available at /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/bin/orachk

AHF binaries are available in /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/bin

AHF is successfully installed

Moving /tmp/ahf_install_214100_17017_2022_02_07-18_13_20.log to /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/data/ora19/diag/ahf/

$ cd /u01/app/oracle/product/19.3.0/db_1/suptools/ahf
$ ls -l
total 0
drwxr-xr-x 13 oracle oinstall 169 Feb  7 18:14 oracle.ahf
$ cd oracle.ahf/
$ ls -l
total 4
drwxr-xr-x 5 oracle oinstall   43 Jan 12 13:34 ahf
drwxr-x--x 2 oracle oinstall    6 Feb  7 18:14 analyzer
drwxr-xr-x 2 oracle oinstall   60 Feb  7 18:15 bin
drwxr-x--x 3 oracle oinstall   17 Feb  7 18:14 chm
drwxr-xr-x 7 oracle oinstall   64 Jan 12 13:34 common
drwxr-xr-x 5 oracle oinstall   49 Feb  7 18:14 data
-rw-r--r-- 1 oracle oinstall 1779 Feb  7 18:14 install.properties
drwxr-x--x 6 oracle oinstall  198 Jan 12 13:34 jre
drwxr-xr-x 7 oracle oinstall  251 Feb  7 18:14 orachk
drwxr-xr-x 6 oracle oinstall  206 Jan 11 12:28 python
drwx------ 2 oracle oinstall   57 Jan 12 13:34 rpms
drwxr-x--x 8 oracle oinstall  163 Feb  7 18:14 tfa

$
$ cd bin
$ ls -l
total 16
-rwxr-xr-x 1 oracle oinstall 4894 Feb  7 18:15 ahfctl
lrwxrwxrwx 1 oracle oinstall   78 Feb  7 18:14 oerr -> /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/orachk/lib/oerr.sh
lrwxrwxrwx 1 oracle oinstall   73 Feb  7 18:14 orachk -> /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/orachk/orachk
-rwxr-xr-x 1 oracle oinstall 4894 Feb  7 18:15 tfactl


$ ./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]. 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
-------------------------------------------------------------------------------------------------------
      ora19                      No           No          Yes           No       No      Yes                orcl
-------------------------------------------------------------------------------------------------------


Copying plug-ins

. .
.  .  .  .  .  .  





*** Checking Best Practice Recommendations ( Pass / Warning / Fail ) ***


.  

Collections and audit checks log file is 
/u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/data/ora19/orachk/orachk_ora19_orcl_020722_181638/log/orachk.log

============================================================
                  Node name - ora19
============================================================
. . . . . . 


 Collecting - Database Parameters for orcl database
 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 - Table of file system defaults
 Collecting - number of semaphore operations per semop system call


Data collections completed. Checking best practices on ora19.
------------------------------------------------------------



 WARNING =>  Linux swap configuration does not meet recommendation
 INFO =>     Most recent ADR incidents for /u01/app/oracle/product/19.3.0/db_1
 INFO =>     Oracle GoldenGate failure prevention best practices
 INFO =>     user_dump_dest has trace files older than 30 days 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
 WARNING =>  kernel.shmmax parameter is NOT configured according to recommendation
 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.
 FAIL =>     Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for orcl
 WARNING =>  Database home does not fix for bug 30937410 /u01/app/oracle/product/19.3.0/db_1
 FAIL =>     Database parameter DB_LOST_WRITE_PROTECT is not set to recommended value on orcl instance
 INFO =>     umask for RDBMS owner is not set to 0022
 INFO =>     The Optimizer Fix 28345522 is disabled by default for orcl
 WARNING =>  Database parameter DB_BLOCK_CHECKING on primary is not set to the recommended value. for orcl
 INFO =>     The Optimizer Fix 22149010 is disabled by default for orcl
 INFO =>     The Optimizer Fix 25167306 is disabled by default for orcl
 WARNING =>  Oracle patch 30786641 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 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 =>  Oracle patch 30712670 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Oracle patch 29423227 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Oracle patch 31031240 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Oracle patch 29867728 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Oracle patch 31142749 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Oracle patch 26749785 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Oracle patch 29302565 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Oracle patch 29259068 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Duplicate objects were found in the SYS and SYSTEM schemas for orcl
 WARNING =>  Oracle patch 28907129 is not applied on RDBMS_HOME /u01/app/oracle/product/19.3.0/db_1
 WARNING =>  Oracle clusterware is not being used
 WARNING =>  RAC Application Cluster is not being used for database high availability on orcl instance
 WARNING =>  DISK_ASYNCH_IO is NOT set to recommended value for orcl
 WARNING =>  Flashback on PRIMARY is not configured for orcl
 INFO =>     Database failure prevention best practices
 WARNING =>  fast_start_mttr_target has NOT been changed from default on orcl instance
 FAIL =>     Active Data Guard is not configured for orcl
 FAIL =>     Found incompatibilities between PDB(s) and the CDB for orcl
 INFO =>     The Optimizer Fix 29132869 is disabled by default for orcl
 INFO =>     Oracle recovery manager(rman) best practices
 INFO =>     Database feature usage statistics for orcl
 WARNING =>  Consider investigating changes to the schema objects such as DDLs or new object creation for orcl
Best Practice checking completed. Checking recommended patches on ora19
--------------------------------------------------------------------------------
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/19.3.0/db_1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
1 Recommended RDBMS patches for 190000 from /u01/app/oracle/product/19.3.0/db_1 on ora19
--------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description                       
--------------------------------------------------------------------------------
33192793 no               merge                Database Release Update 19.13.0.0.211019                                       
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
              RDBMS homes patches summary report
--------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME    
--------------------------------------------------------------------------------
1              1              0                /u01/app/oracle/product/19.3.0/db_1
--------------------------------------------------------------------------------

------------------------------------------------------------
Detailed report (html) -  /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/data/ora19/orachk/orachk_ora19_orcl_020722_181638/orachk_ora19_orcl_020722_181638.html





UPLOAD [if required] - /u01/app/oracle/product/19.3.0/db_1/suptools/ahf/oracle.ahf/data/ora19/orachk/orachk_ora19_orcl_020722_181638.zip