Recently oracle has bundled both Trace file analyzer(TFA /TFACTL) and orachk into Autonomous health framework popularly known as AHF. So just installing ahf setup will take care of both tfa and orachk including few other monitor tools.
STEPS TO INSTALL/UPGRADE AHF
Download the AHF tool from oracle support. – DOWNLOAD AHF
ENVIRONMENT – SOLARIS 2 NODE RAC ( dbhost-1, dbhost-2)
Important points:
- This need to be installed from root user
- If password less ssh is established for root user between all the RAC nodes, then you just need to run setup only one one node2 , it will do install the ahf automatically on all node. However in our case, for root user password less ssh was disabled. So i had to do the setup on each node one by one.
- If old ahf is already present, then this method will upgrade the same.
1. Copy and unzip in node 1 and node 2: ( dbhost-1 and dbhost-2)
root@dbhost-1:/export/home/software/AHF# ls -ltr total 2282547 -rwxr-xr-x 1 root root 590314841 Jun 26 17:34 ahf_setup -rw-r--r-- 1 root root 832 Jun 26 17:41 README.txt -rwxr-xr-x 1 software staff 577022152 Aug 21 17:34 AHF-SOLARIS.SPARC64_v20.2.0.zip
2. Run ahf_setup from node 1 as root user:( dbhost-1)
root@dbhost-1:/export/home/software/AHF# ./ahf_setup AHF Installer for Platform SunOS Architecture SPARC AHF Installation Log : /tmp/ahf_install_202000_11904_2020_08_21-17_47_55.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 20.2.0 Build Date: 202006260723 AHF is already installed at /opt/oracle.ahf Installed AHF Version: 19.3.1 Build Date: 201911181744 Do you want to upgrade AHF [Y]|N : y Login using root is disabled in sshd config. Installing AHF only on Local Node Upgrading /opt/oracle.ahf Shutting down AHF Services Upgrade Log File /gridapp/app/oracle.ahf/data/dbhost-1/diag/ahf/ahf_upgrade_21082020_17_48_37.log Old/New Lucene Versions - 8.1.1/8.1.1 Lucene upgrade not required WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Starting AHF Services WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Starting TFA.. Waiting up to 100 seconds for TFA to be started.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Successfully started TFA Process.. . . . . . WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. TFA Started and listening for commands WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. AHF sucessfully upgraded to latest version .---------------------------------------------------------------. | Host | TFA Version | TFA Build ID | Upgrade Status | +---------+-------------+----------------------+----------------+ | dbhost-1 | 20.2.0.0.0 | 20200020200626072308 | UPGRADED | | dbhost-2 | 19.3.1.0.0 | 19310020191118174453 | NOT UPGRADED | '---------+-------------+----------------------+----------------'
2. Check the tfactl status:
root@dbhost-1:/export/home/software/AHF# tfactl status .-----------------------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status | +---------+---------------+-------+------+------------+----------------------+------------------+ | dbhost-1 | RUNNING | 13948 | 5000 | 20.2.0.0.0 | 20200020200626072308 | COMPLETE | -> This one upgraded | dbhost-2 | RUNNING | 11193 | 5000 | 19.3.1.0.0 | 19310020191118174453 | COMPLETE | '---------+---------------+-------+------+------------+----------------------+------------------'
3. Now do the same on node 2: ( dbhost-2)
root@dbhost-2:/export/home/software/AHF# ./ahf_setup AHF Installer for Platform SunOS Architecture SPARC AHF Installation Log : /tmp/ahf_install_202000_19808_2020_08_21-17_53_53.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 20.2.0 Build Date: 202006260723 AHF is already installed at /opt/oracle.ahf Installed AHF Version: 19.3.1 Build Date: 201911181744 Do you want to upgrade AHF [Y]|N : y Login using root is disabled in sshd config. Installing AHF only on Local Node Upgrading /opt/oracle.ahf Shutting down AHF Services Upgrade Log File /gridapp/app/oracle.ahf/data/dbhost-2/diag/ahf/ahf_upgrade_21082020_17_54_36.log Old/New Lucene Versions - 8.1.1/8.1.1 Lucene upgrade not required WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Starting AHF Services WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. Starting TFA.. Waiting up to 100 seconds for TFA to be started.. . . . . . . . . . . . . . . . . . . . . Successfully started TFA Process.. . . . . . WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. TFA Started and listening for commands WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version. AHF sucessfully upgraded to latest version .---------------------------------------------------------------. | Host | TFA Version | TFA Build ID | Upgrade Status | +---------+-------------+----------------------+----------------+ | dbhost-2 | 20.2.0.0.0 | 20200020200626072308 | UPGRADED | | dbhost-1 | 20.2.0.0.0 | 20200020200626072308 | UPGRADED | '---------+-------------+----------------------+----------------'
root@dbhost-2:/export/home/software# tfactl status
.-----------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+---------+---------------+-------+------+------------+----------------------+------------------+
| dbhost-1 | RUNNING | 29271 | 5000 | 20.2.0.0.0 | 20200020200626072308 | COMPLETE |
| dbhost-2 | RUNNING | 29938 | 5000 | 20.2.0.0.0 | 20200020200626072308 | COMPLETE |
'---------+---------------+-------+------+------------+----------------------+------------------'
AHF setup has been completed for both nodes.
Check the status of all components:
root@dbhost-1:/export/home/software# tfactl toolstatus .------------------------------------------------------------------. | TOOLS STATUS - HOST : dbhost-1 | +----------------------+--------------+--------------+-------------+ | Tool Type | Tool | Version | Status | +----------------------+--------------+--------------+-------------+ | Development Tools | orachk | 20.2.0.0.0 | DEPLOYED | | | oratop | 14.1.2 | DEPLOYED | +----------------------+--------------+--------------+-------------+ | Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED | | | oswbb | 8.3.2 | RUNNING | | | prw | 12.1.13.11.4 | NOT RUNNING | +----------------------+--------------+--------------+-------------+ | TFA Utilities | alertsummary | 20.2.0.0.0 | DEPLOYED | | | calog | 20.2.0.0.0 | DEPLOYED | | | dbcheck | 18.3.0.0.0 | DEPLOYED | | | dbglevel | 20.2.0.0.0 | DEPLOYED | | | grep | 20.2.0.0.0 | DEPLOYED | | | history | 20.2.0.0.0 | DEPLOYED | | | ls | 20.2.0.0.0 | DEPLOYED | | | managelogs | 20.2.0.0.0 | DEPLOYED | | | menu | 20.2.0.0.0 | DEPLOYED | | | param | 20.2.0.0.0 | DEPLOYED | | | ps | 20.2.0.0.0 | DEPLOYED | | | pstack | 20.2.0.0.0 | DEPLOYED | | | summary | 20.2.0.0.0 | DEPLOYED | | | tail | 20.2.0.0.0 | DEPLOYED | | | triage | 20.2.0.0.0 | DEPLOYED | | | vi | 20.2.0.0.0 | DEPLOYED | '----------------------+--------------+--------------+-------------'
