==== 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.
* [[https://support.oracle.com/epmos/faces/DocumentDisplay?&id=1513912.1|Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk (Doc ID 2550798.1)]]
* [[https://support.oracle.com/epmos/faces/DocContentDisplay?id=153788.1|ORA-600/ORA-7445/ORA-700 Error Look-up Tool (Doc ID 153788.1)]]
* [[https://support.oracle.com/epmos/faces/ui/gr/GrHome.jspx?sourceId=153788.1&domainId=ORA7445|ORA-7445-Troubleshooting Tool]]
* [[https://support.oracle.com/epmos/faces/ui/gr/GrHome.jspx?sourceId=153788.1&domainId=ORA600|ORA-00600-Troubleshooting Tool]]
* [[https://docs.oracle.com/en/database/oracle/oracle-database/19/atnms/running-diagnostic-collection-commands.html#GUID-0463FC76-ACF9-4BAD-B540-D33B8E663A29|TFA Collections]]
* [[https://dbalifeeasy.com/tag/uninstall-tfa/|TFA – Uninstall Oracle Trace File Analyser - dbalifeeasy.com]]
==== 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,=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