tfa
Table of Contents
Oracle Autonomous Health Framework / Trace FIle Analyser
Oracle's Autonomous Health Framework (including OraCHK, ExaCHK, TFA) is now being used to collect and diagnose errors.
Install TFA as oracle user (non-root)
- Clean up any old TFA installations
$ORACLE_HOME/suptools/oracle.ahf/bin/tfactl uninstall rm -rf $HOME/.tfa
- Run the setup
/oracle/Patches/AHF-AIX-PPC64_v21.1.0/ahf_setup -ahf_loc $ORACLE_HOME/suptools
AHF Installer for Platform AIX Architecture PPC64 AHF Installation Log : /tmp/ahf_install_211000_25362870_2021_05_05-14_52_23.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 21.1.0 Build Date: 202104131158 AHF Location : /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf AHF Data Directory : /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/data Extracting AHF to /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf Configuring TFA in Standalone Mode... Build Version : 211000 Build Date : 202104131158 Discovering Nodes and Oracle Resources .---------------------------------------------------------------------------------------------------------------. | Summary of TFA Configuration | +----------------+----------------------------------------------------------------------------------------------+ | Parameter | Value | +----------------+----------------------------------------------------------------------------------------------+ | TFA Location | /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/tfa | | Data Directory | /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/data/hn5114/tfa | | Repository | /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/data/repository | | Diag Directory | /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/data/hn5114/diag/tfa | | Java Home | /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/jre | '----------------+----------------------------------------------------------------------------------------------' .-----------------------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status | +--------+---------------+-----+---------+------------+----------------------+------------------+ | hn5114 | RUNNING | - | OFFLINE | 21.1.0.0.0 | 21100020210413115827 | COMPLETED | '--------+---------------+-----+---------+------------+----------------------+------------------' AHF is deployed at /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf ORAchk is available at /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/bin/orachk AHF binaries are available in /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/bin AHF is successfully installed Moving /tmp/ahf_install_211000_25362870_2021_05_05-14_52_23.log to /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/data/hn5114/diag/ahf/
- Run a collection
/cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/bin/tfactl diagcollect -srdc ora07445 Enter the time of the Error [YYYY-MM-DD HH24:MI:SS,<RETURN>=ALL] : Enter the Database Name [Required for this SRDC] : cwmd 1. May/04/2021 22:00:11 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 2. May/03/2021 22:00:11 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 3. May/02/2021 22:09:08 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 4. May/02/2021 18:08:59 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 5. May/02/2021 14:08:50 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 6. May/02/2021 10:08:41 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 7. May/02/2021 06:00:16 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 8. May/01/2021 22:08:11 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 9. May/01/2021 18:08:02 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] 10. May/01/2021 14:07:57 : [cwmd] ORA-07445: exception encountered: core dump [PC:0xEE00] [SIGSEGV] [ADDR:0x7C7A03A67C7242A6] [PC:0xEE00] [Address not mapped to object] [] Please choose the event : 1-10 [1] Selected value is : 1 ( May/04/2021 22:00:11 ) Scripts to be run by this srdc: ipspack Components included in this srdc: OS NOCHMOS Scanning files from May/04/2021 21:30:11 to May/04/2021 22:30:11 Collection Id : 20210505150326hn5114 Detailed Logging at : /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/data/repository/srdc_generic_collection_Wed_May_05_15_03_30_CEST_2021_node_local/diagcollect_20210505150326_hn5114.log 2021/05/05 15:04:25 CEST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom 2021/05/05 15:04:25 CEST : Collection Name : tfa_srdc_generic_Wed_May_05_15_03_30_CEST_2021.zip 2021/05/05 15:04:26 CEST : Scanning of files for Collection in progress... 2021/05/05 15:04:26 CEST : Collecting additional diagnostic information... 2021/05/05 15:05:01 CEST : Getting list of files satisfying time range [05/04/2021 21:30:11 CEST, 05/04/2021 22:30:11 CEST] 2021/05/05 15:05:16 CEST : Completed collection of additional diagnostic information... 2021/05/05 15:05:22 CEST : Collecting ADR incident files... 2021/05/05 15:05:23 CEST : Completed Local Collection .-----------------------------------. | Collection Summary | +--------+-----------+-------+------+ | Host | Status | Size | Time | +--------+-----------+-------+------+ | hn5114 | Completed | 5.5MB | 58s | '--------+-----------+-------+------' Logs are being collected to: /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/data/repository/srdc_generic_collection_Wed_May_05_15_03_30_CEST_2021_node_local /cln/tst/ora_bin1/app/oracle/product/19/dbhome_1/suptools/oracle.ahf/data/repository/srdc_generic_collection_Wed_May_05_15_03_30_CEST_2021_node_local/hn5114.tfa_srdc_generic_Wed_May_05_15_03_30_CEST_2021.zip
stuff below no longer needed ?!
- Initialise the installation
export TFA_HOME="$ORACLE_HOME/suptools/oracle.ahf"
export PATH="${TFA_HOME}/bin:$PATH"
export PERL5LIB="/opt/freeware/lib/perl5/5.28.1:${PERL5LIB}"
- Trick $ORACLE_HOME/suptools/oracle.ahf/tfa/bin/tfactl.pl into picking up the above PERL5LIB
export BEGIN_BLOCK=1
- Configure TFA as standalone
$ORACLE_HOME/suptools/oracle.ahf/tfa/bin/tfactl -standalone
Some useful commands
tfactl -help tfactl print config tfactl print collections tfactl print components tfactl diagcollect -srdc ORA-00600 tfactl diagcollect -srdc ORA-00700 tfactl diagcollect -srdc ora07445 tfactl diagcollect -srdc ORA-07445 -from "2021-05-01 13:00:00" -to "2021-05-01 15:00:00" tfactl diagcollect # for all components over past 12 hours
tfa.txt · Last modified: 2023/12/13 17:47 by 127.0.0.1