I read an interesting article from Michael Schulze, Optiz Consulting in the actual „Red Stack Magazin / April 2020“, about Tools for the daily Exadata maintenance but it is not so easy as described.
Since some time ago AHF (Autonomous Health Framework) is the tool for checks of any kind on the Exadata.
I have installed and used here Version 19.3 which is an old one. I will update in a few weeks the whole environment to Version 20.1.
So I try to create the „summary HTML“ Report but it will not work as described in Michaels article.
Why?
tfactl summary -overview -html
Sometimes you need to start the command twice and you NEED to enter a „q“
after you saw the „tfactl_summary>“ this is important otherwise the HTML report will not be created.
Example
tfactl summary -overview -html
WARNING – TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
Executing Summary in Parallel on Following Nodes:
Node : exa01
Node : exa02
Node : exa03
Node : exa04
LOGFILE LOCATION : /opt/oracle.ahf/data/repository/suptools/exa01/summary/root/20200502174852/log/summary_command_20200502174852_exa01_177655.log
Component Specific Summary collection :
– Collecting CRS details … Done.
– Collecting ASM details … Done.
– Collecting ACFS details … Done.
– Collecting DATABASE details … Done.
– Collecting EXADATA details … Done.
– Collecting PATCH details … Done.
– Collecting LISTENER details … Done.
– Collecting NETWORK details … Done.
– Collecting OS details … Done.
– Collecting TFA details … Done.
– Collecting SUMMARY details … Done.
Remote Summary Data Collection : In-Progress – Please wait …
– Data Collection From Node – exa02 .. Done.
– Data Collection From Node – exa03 .. Done.
– Data Collection From Node – exa04 .. Done.
Prepare Clusterwide Summary Overview … Done
cluster_status_summary
DETAILS STATUS COMPONENT
+---------------------------------------------------------------------------------------------------+---------+-----------+
.-----------------------------------------------. PROBLEM CRS
| CRS_SERVER_STATUS : ONLINE |
| CRS_STATE : ONLINE |
| CRS_INTEGRITY_CHECK : FAIL |
| CRS_RESOURCE_STATUS : OFFLINE Resources Found |
'-----------------------------------------------'
.-------------------------------------------------------. PROBLEM ASM
| ASM_DISK_SIZE_STATUS : WARNING - Available Size < 20% |
| ASM_BLOCK_STATUS : PASS |
| ASM_CHAIN_STATUS : PASS |
| ASM_INCIDENTS : FAIL |
| ASM_PROBLEMS : FAIL |
'-------------------------------------------------------'
.-----------------------. OFFLINE ACFS
| ACFS_STATUS : OFFLINE |
'-----------------------'
.-----------------------------------------------------------------------------------------------. PROBLEM DATABASE
| ORACLE_HOME_DETAILS | ORACLE_HOME_NAME |
+----------------------------------------------------------------------------+------------------+
| .------------------------------------------------------------------------. | OraDB12Home1 |
| | DB_CHAINS | DB_BLOCKS | INCIDENTS | PROBLEMS | DATABASE_NAME | STATUS | | |
| +-----------+-----------+-----------+----------+---------------+---------+ | |
| | PROBLEM | PASS | PROBLEM | PROBLEM | i10 | PROBLEM | | |
| | PROBLEM | PROBLEM | PROBLEM | PROBLEM | p10 | PROBLEM | | |
| | PASS | PASS | PROBLEM | PROBLEM | i20 | PROBLEM | | |
| '-----------+-----------+-----------+----------+---------------+---------' | |
'----------------------------------------------------------------------------+------------------'
.--------------------------------. PROBLEM EXADATA
| SWITCH_SSH_STATUS : CONFIGURED |
| CELL_SSH_STATUS : CONFIGURED |
| ENVIRONMENT_TEST : PASS |
| LINKUP : PASS |
| LUN_STATUS : NORMAL |
| RS_STATUS : RUNNING |
| CELLSRV_STATUS : RUNNING |
| MS_STATUS : RUNNING |
'--------------------------------'
.----------------------------------------------. OK PATCH
| CRS_PATCH_CONSISTENCY_ACROSS_NODES : OK |
| DATABASE_PATCH_CONSISTENCY_ACROSS_NODES : OK |
'----------------------------------------------'
.-----------------------. OK LISTENER
| LISTNER_STATUS : OK |
'-----------------------'
.---------------------------. OK NETWORK
| CLUSTER_NETWORK_STATUS : |
'---------------------------'
.-----------------------. OK OS
| MEM_USAGE_STATUS : OK |
'-----------------------'
.----------------------. OK TFA
| TFA_STATUS : RUNNING |
'----------------------'
.------------------------------------. OK SUMMARY
| SUMMARY_EXECUTION_TIME : 0H:2M:31S |
'------------------------------------'
+---------------------------------------------------------------------------------------------------+---------+-----------+
### Entering in to SUMMARY Command-Line Interface ###
tfactl_summary>list
Components : Select Component - select [component_number|component_name]
1 => overview
2 => crs_overview
3 => asm_overview
4 => acfs_overview
5 => database_overview
6 => exadata_overview
7 => patch_overview
8 => listener_overview
9 => network_overview
10 => os_overview
11 => tfa_overview
12 => summary_overview
tfactl_summary>q
### Exited From SUMMARY Command-Line Interface ###
--------------------------------------------------------------------
REPOSITORY : /opt/oracle.ahf/data/repository/suptools/exa01/summary/root/20200502174852/exa01
HTML REPORT : <REPOSITORY>/report/Consolidated_Summary_Report_20200502174852.html
--------------------------------------------------------------------
So enter „q“ and the HTML Report is created. Then start a browser and you the Report which is really helpful.
Have fun :-) and if possible use directly AHF 20.1, or do an Update like me …..
