Upgrading/Installing TFA with OSWatcher
June 10, 2019 1 Comment
The whole process is very simple and straightforward.
Post seems big but most of the content is a command output.
1. Download TFA Collector – TFA with Database Support Tools Bundle from Doc ID 1513912.1
2. Place downloaded zip file on rac1 and unzip it:
# cd /u01/app/sw # ll … -rw-r--r-- 1 root root 264751391 Apr 25 19:18 TFA-LINUX_v19.2.1 # unzip TFA-LINUX_v19.2.1
3. Install TFA:
[root@rac1 sw]# ./installTFA-LINUX TFA Installation Log will be written to File : /tmp/tfa_install_21556_2019_06_03-10_39_10.log Starting TFA installation TFA Version: 192100 Build Date: 201904251105 TFA HOME : /u01/app/12.2.0/grid/tfa/rac1/tfa_home Installed Build Version: 184100 Build Date: 201902262137 TFA is already installed. Upgrading TFA TFA Upgrade Log : /u01/app/12.2.0/grid/tfa/rac1/tfapatch.log TFA will be upgraded on : rac1 rac2 Do you want to continue with TFA Upgrade ? [Y|N] [Y]: Y Checking for ssh equivalency in rac2 Node rac2 is not configured for ssh user equivalency SSH is not configured on these nodes : rac2 Do you want to configure SSH on these nodes ? [Y|N] [Y]: N Patching remote nodes using TFA Installer /u01/app/sw/installTFA-LINUX… Copying TFA Installer to rac2… lost connection Starting TFA Installer on rac2… Upgrading TFA on rac1 : Stopping TFA Support Tools… Shutting down TFA for Patching… Shutting down TFA Removed symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service. Removed symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service. Successfully shutdown TFA.. No Berkeley DB upgrade required Copying TFA Certificates… Starting TFA in rac1… Starting TFA.. Created symlink from /etc/systemd/system/multi-user.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service. Created symlink from /etc/systemd/system/graphical.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service. Waiting up to 100 seconds for TFA to be started.. . . . . . Successfully started TFA Process.. . . . . . TFA Started and listening for commands Enabling Access for Non-root Users on rac1… Connection refused!rac2 RemoteUtil : Connection refused!rac2 .------------------------------------------------------------. | Host | TFA Version | TFA Build ID | Upgrade Status | +------+-------------+----------------------+----------------+ | rac1 | 19.2.1.0.0 | 19210020190425110550 | UPGRADED | | rac2 | - | - | NOT UPGRADED | '------+-------------+----------------------+----------------'
The reason why it did not upgrade on rac2, is that I did not have ssh equivalency between nodes for root user.
I could enable ssh passwordless authentication and TFA would be upgraded in one step, but because of the security I will not enable it and just manually install TFA on the second node:
4. Copy installation file to rac2 and install:
[root@rac2 ~]# mkdir -p /u01/app/sw/ [root@rac2 ~]# chmod -R 777 /u01/app/sw/ [root@rac2 ~]# su - oracle [oracle@rac2 ~]$ cd /u01/app/sw/ [oracle@rac2 sw]$ scp rac1:/u01/app/sw/installTFA-LINUX . installTFA-LINUX 100% 254MB 114.9MB/s 00:02
[root@rac2 sw]# ./installTFA-LINUX TFA Installation Log will be written to File : /tmp/tfa_install_15370_2019_06_03-10_50_05.log Starting TFA installation TFA Version: 192100 Build Date: 201904251105 TFA HOME : /u01/app/12.2.0/grid/tfa/rac2/tfa_home Installed Build Version: 184100 Build Date: 201902262137 TFA is already installed. Upgrading TFA TFA Upgrade Log : /u01/app/12.2.0/grid/tfa/rac2/tfapatch.log TFA-00002 Oracle Trace File Analyzer (TFA) is not running TFA-00002 Oracle Trace File Analyzer (TFA) is not running Unable to determine the status of TFA in other nodes. TFA will be upgraded on Node rac2: Do you want to continue with TFA Upgrade ? [Y|N] [Y]: Upgrading TFA on rac2 : Stopping TFA Support Tools… Shutting down TFA for Patching… Shutting down TFA Removed symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service. Removed symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service. . . . . . . . . Successfully shutdown TFA.. No Berkeley DB upgrade required Copying TFA Certificates… Starting TFA in rac2… Starting TFA.. Created symlink from /etc/systemd/system/multi-user.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service. Created symlink from /etc/systemd/system/graphical.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service. Waiting up to 100 seconds for TFA to be started.. . . . . . Successfully started TFA Process.. . . . . . TFA Started and listening for commands Enabling Access for Non-root Users on rac2… .------------------------------------------------------------. | Host | TFA Version | TFA Build ID | Upgrade Status | +------+-------------+----------------------+----------------+ | rac2 | 19.2.1.0.0 | 19210020190425110550 | UPGRADED | | rac1 | 19.2.1.0.0 | 19210020190425110550 | UPGRADED | '------+-------------+----------------------+----------------'
5. Stop and Start TFA on rac1 and rac2:
# tfactl stop Sending stoptfa Success Stopping TFA from the Command Line Nothing to do ! LCM is not running TFA is running - Will wait 5 seconds (up to 3 times) TFA-00104 Cannot establish connection with TFA Server. Please check TFA Certificates Killing TFA running with pid 16627 . . . Successfully stopped TFA.. # tfactl start TFA-00002 Oracle Trace File Analyzer (TFA) is not running Starting TFA.. Waiting up to 100 seconds for TFA to be started.. Successfully started TFA Process.. # ps -ef|grep OSWatcher root 14528 1 0 May30 ? 00:44:11 /bin/sh ./OSWatcher.sh root 14850 14528 0 May30 ? 00:00:58 /bin/sh ./OSWatcherFM.sh 48 /home/fg/oswbb/archive
6. Check OSWatcher repository location:
# ll /home/fg/oswbb/archive drwxr-xr-x 2 root root 202 May 30 22:00 oswcpuinfo drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswifconfig drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswiostat drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswmeminfo drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswmpstat drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswnetstat drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswnfsiostat drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswpidstat drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswpidstatd drwxr-xr-x 2 root root 6 May 30 21:56 oswprvtnet drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswps drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswslabinfo drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswtop drwxr-xr-x 2 root root 4096 Jun 3 11:00 oswvmstat drwxr-xr-x 2 root root 6 May 30 21:56 oswxentop
About Mariami Kupatadze
DBA Knowledge Base 
Pingback: Reduce high CPU usage by TFA |