We care for your speed. Below is an easy way to perform an upgrade/re-installation of Oracle Trace File Analyzer in Oracle Real Application Clusters.
What is Oracle Trace File Analyzer ?
- Trace File Analyzer Collector (TFA) is a diagnostic collection utility to simplify diagnostic data collection on Oracle Cluster ware/Grid Infrastructure, RAC and Single Instance Database systems.
- Oracle Trace File Analyzer collects and analyzes diagnostic data.
- You can use Oracle Trace File Analyzer with all supported versions of Oracle Database and Oracle Grid Infrastructure.
- To obtain the fullest capabilities of Oracle Trace File Analyzer, the software needs to be installed as root user.
- Trace file analyzer is very useful tool for collecting diagnostic data on-demand For errors like ORA-600/ORA-7445 useful for Oracle Support need to diagnose a specific type of problem.
|
1 2 3 4 |
tfactl diagcollect -srdc ORA-00600 tfactl diagcollect -srdc ORA-07445 tfactl diagcollect -srdc ORA-00700 |
- If you are unable to install as root, then install TFA can be installed as the oracle user but below functionality will not be usable.
-Automatic collections
-Collections from remote hosts
-Collecting of files which are not readable by the ORACLE_HOME owner, e.g. /var/log/messages or certain clusterware daemon logs.
TFA OSWATCHER :
- Oswatcher is integrated with TFA and is a very important tool used for Linux/UNIX paced operating systems where monitoring OS is very important aspect when it comes to identifying CPU, RAM or network related issues.
- One of the benefits of OSWatcher is that it will also examine the Cluster Interconnect for the Oracle RAC Cluster which helps in determining node eviction issues.
Oswatcher invokes below utilities depending on the OS platforms and collect diagnostics logs for determining performance issues.
oswvmstat
oswmpstat
oswnetstat
oswiostat
oswifconfig
oswtop
oswps
oswprvtnet
oswmeminfo
oswslabinfo
Installation of Oracle Trace File Analyzer:
TFA Collector – TFA with Database Support Tools Bundle (Doc ID 1513912.1) can be downloaded at below link.
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1513912.1
Please note : Oracle TFA is preinstalled with Grid software’s as a part of Oracle 12c Real application clusters installation. We need to uninstall/Install or upgrade it to the latest version of TFA 19.2.1.
Install as root user:
- It is always good to install Oracle TFA as root user as it will give you full capabilities to collect and analyze Diagnostics data.
- If TFA is already installed, reinstalling will upgrade the software in existing location.
Download the appropriate Oracle Trace File Analyzer zip, copy to required machine and unzip.
Run the installTFA command: $ ./ installTFA-LINUX
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 |
[root@RAC1 TFA]# ./installTFA-LINUX TFA Installation Log will be written to File : /tmp/tfa_install_36120_2019_09_04-12_50_03.log Starting TFA installation TFA Version: 192100 Build Date: 201904251105 TFA HOME : /u01/app/12.1.0/grid/tfa/RAC1/tfa_home Installed Build Version: 121200 Build Date: 201406190949 TFA is already installed. Upgrading TFA TFA Upgrade Log : /u01/app/12.1.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 RAC2 is configured for ssh user equivalency for root user TFA-00204 File components.xml is missing. Using SSH to upgrade TFA on remote nodes : Upgrading TFA on RAC2 : TFA_HOME: /u01/app/12.1.0/grid/tfa/RAC2/tfa_home Stopping TFA Support Tools... Usage : /u01/app/12.1.0/grid/bin/tfactl <command> [options] <command> = start Starts TFA stop Stops TFA enable Enable TFA Auto restart disable Disable TFA Auto restart print Print requested details access Add or Remove or List TFA Users and Groups purge Delete collections from TFA repository directory Add or Remove or Modify directory in TFA host Add or Remove host in TFA diagcollect Collect logs from across nodes in cluster analyze List events summary and search strings in alert logs. set Turn ON/OFF or Modify various TFA features uninstall Uninstall TFA from this node For help with a command: /u01/app/12.1.0/grid/bin/tfactl <command> -help Shutting down TFA oracle-tfa stop/waiting . . . . . Killing TFA running with pid 58227 . . . Successfully shutdown TFA.. Copying files from RAC1 to RAC2... /tmp/.36120.tfa/tfa_home/server.jks: No such file or directory /tmp/.36120.tfa/tfa_home/client.jks: No such file or directory /tmp/.36120.tfa/tfa_home/internal/ssl.properties: No such file or directory Current version of Berkeley DB in RAC2 is 5 or higher, so no DbPreUpgrade required Unable to update TFA Configuration file /u01/app/12.1.0/grid/tfa/RAC2/tfa_home/internal/config.properties Enabling TFA AutoDiagcollect... Successfully updated firediagcollectRT to true in TFA... Running commands to fix init.tfa and tfactl in RAC2... Updating init.tfa in RAC2... Removing old version serializale files in RAC2... Starting TFA in RAC2... Creating Sym Link /etc/rc.d/rc0.d/K17init.tfa to /etc/init.d/init.tfa Creating Sym Link /etc/rc.d/rc1.d/K17init.tfa to /etc/init.d/init.tfa Creating Sym Link /etc/rc.d/rc2.d/K17init.tfa to /etc/init.d/init.tfa Creating Sym Link /etc/rc.d/rc4.d/K17init.tfa to /etc/init.d/init.tfa Creating Sym Link /etc/rc.d/rc6.d/K17init.tfa to /etc/init.d/init.tfa Starting TFA.. oracle-tfa start/running, process 17485 Waiting up to 100 seconds for TFA to be started.. . . . . . Successfully started TFA Process.. . . . . . TFA Started and listening for commands Removing /u01/app/12.1.0/grid/tfa/RAC2/tfa_home/jlib/je-5.0.84.jar Enabling Access for Non-root Users on RAC2... ERROR: /u01/app/12.1.0/grid/tfa/RAC2/tfa_home/internal/.buildversion does not exists Setting DDU purging mode to profile on RAC2 Upgrading TFA on RAC1 : Stopping TFA Support Tools... Shutting down TFA for Patching... Shutting down TFA oracle-tfa stop/waiting . . . . . Killing TFA running with pid 37317 . . . Successfully shutdown TFA.. Copying je-6.4.25.jar to /u01/app/12.1.0/grid/tfa/RAC1/tfa_home/jlib/ Copying TFA Certificates... Unable to update TFA Configuration file /u01/app/12.1.0/grid/tfa/RAC1/tfa_home/internal/config.properties Starting TFA in RAC1... Creating Sym Link /etc/rc.d/rc0.d/K17init.tfa to /etc/init.d/init.tfa Creating Sym Link /etc/rc.d/rc1.d/K17init.tfa to /etc/init.d/init.tfa Creating Sym Link /etc/rc.d/rc2.d/K17init.tfa to /etc/init.d/init.tfa Creating Sym Link /etc/rc.d/rc4.d/K17init.tfa to /etc/init.d/init.tfa Creating Sym Link /etc/rc.d/rc6.d/K17init.tfa to /etc/init.d/init.tfa Starting TFA.. oracle-tfa start/running, process 40453 Waiting up to 100 seconds for TFA to be started.. . . . . . Successfully started TFA Process.. . . . . . TFA Started and listening for commands Removing /u01/app/12.1.0/grid/tfa/RAC1/tfa_home/jlib/je-5.0.84.jar Enabling Access for Non-root Users on RAC1... ERROR: /u01/app/12.1.0/grid/tfa/RAC1/tfa_home/internal/.buildversion does not exists .--------------------------------------------------------------------. | Host | TFA Version | TFA Build ID | Upgrade Status | +--------------+-------------+----------------------+----------------+ | RAC1 | 19.2.1.0.0 | 19210020190425110550 | UPGRADED | | RAC2 | 19.2.1.0.0 | 19210020190425110550 | UPGRADED | '--------------+-------------+----------------------+----------------' |
Now check the status of TFA.
|
1 2 3 4 5 6 7 8 9 |
[root@RAC1 TFA]# cd /u01/app/12.1.0/grid/tfa/bin [root@RAC1 bin]# ./tfactl status .----------------------------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status | +--------------+---------------+-------+------+------------+----------------------+------------------+ | RAC1 | RUNNING | 57054 | 5000 | 19.2.1.0.0 | 19210020190425110550 | COMPLETE | | RAC2 | RUNNING | 42975 | 5000 | 19.2.1.0.0 | 19210020190425110550 | COMPLETE | '--------------+---------------+-------+------+------------+----------------------+------------------' |
Custom Collections
Collecting from Specific Nodes
By default TFA will collect from all nodes in the cluster, to collect from only specific nodes,
use diagcollect –node <list of nodes>:
|
1 2 |
tfactl diagcollect -last 1d -node myserver65 |
By default TFA will collect from all database and Grid Infrastructure components. The components collected from can be restricted by specifying only those required.
For example to trim and collect all files from database hrdb & fdb in the last 1 day:
|
1 2 |
tfactl –diagcollect –database hrdb,fdb –last 1d |
To trim and collect all CRS files, operating system logs and CHMOS/OSW data from node1 & node2 updated in the last 6 hours:
|
1 2 |
tfactl diagcollect -crs -os -node node1,node2 –last 6h |
To trim and collect all ASM logs from node1 updated between from and to time:
|
1 2 |
tfactl diagcollect -asm -node node1 -from "2016-08-15" -to "2016-08-17" |
To collect Service request diagnostic collection for ora-600 and ora-7445 errors.
|
1 2 3 |
tfactl diagcollect -srdc ORA-00600 tfactl diagcollect -srdc ORA-07445 |
To collect TFA for specific time duration.
|
1 2 |
./tfactl diagcollect -from "MAR/02/2017 13:00:00" -to "MAR/02/2017 14:30:00" |
Steps for Uninstallaton of TFA software:
|
1 2 |
cd /u01/app/12.1.0/grid/tfa/RAC1/tfa_home/bin |
execute ./uninstalltfa.sh for uninstalling TFA from 1st Node ( or any Node)
It will uninstall TFA from all host nodes in RAC.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
[root@RAC1 bin]# ./uninstalltfa.sh TFA will be uninstalled on: RAC1 RAC2 Do you want to continue with TFA uninstall ? [Y|N] [Y]: Y Stopping TFA Support Tools... Stopping TFA in RAC1... Shutting down TFA oracle-tfa stop/waiting . . . . . Killing TFA running with pid 57054 . . . Successfully shutdown TFA.. TFA-00002 Oracle Trace File Analyzer (TFA) is not running Stopping TFA in RAC2 and removing /u01/app/12.1.0/grid/tfa/RAC2/tfa_home... Removing TFA from RAC2... Stopping TFA Support Tools... Stopping TFA in RAC2... Shutting down TFA oracle-tfa stop/waiting . . . . . Killing TFA running with pid 42975 . . . Successfully shutdown TFA.. TFA-00002 Oracle Trace File Analyzer (TFA) is not running Deleting TFA support files on RAC2: Removing /u01/app/grid/tfa/RAC2/database... Removing /u01/app/grid/tfa/RAC2/log... Removing /u01/app/grid/tfa/RAC2/output... Removing /u01/app/grid/tfa/RAC2... Removing /u01/app/grid/tfa... Removing /etc/rc.d/rc0.d/K17init.tfa Removing /etc/rc.d/rc1.d/K17init.tfa Removing /etc/rc.d/rc2.d/K17init.tfa Removing /etc/rc.d/rc4.d/K17init.tfa Removing /etc/rc.d/rc6.d/K17init.tfa Removing /etc/init.d/init.tfa... Removing /u01/app/12.1.0/grid/bin/tfactl... Removing /u01/app/12.1.0/grid/tfa/bin... Removing /u01/app/12.1.0/grid/tfa/RAC2... Removing /u01/app/12.1.0/grid/tfa... Deleting TFA support files on RAC1: Removing /u01/app/grid/tfa/RAC1/database... Removing /u01/app/grid/tfa/RAC1/log... Removing /u01/app/grid/tfa/RAC1/output... Removing /u01/app/grid/tfa/RAC1... Removing /u01/app/grid/tfa... Removing /etc/rc.d/rc0.d/K17init.tfa Removing /etc/rc.d/rc1.d/K17init.tfa Removing /etc/rc.d/rc2.d/K17init.tfa Removing /etc/rc.d/rc4.d/K17init.tfa Removing /etc/rc.d/rc6.d/K17init.tfa Removing /etc/init.d/init.tfa... Removing /u01/app/12.1.0/grid/bin/tfactl... Removing /u01/app/12.1.0/grid/tfa/bin... Removing /u01/app/12.1.0/grid/tfa/RAC1... Removing /u01/app/12.1.0/grid/tfa... [root@RAC1 bin]# |
Fresh Installation of Oracle Trace File Analyzer:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 |
[root@RAC1 TFA]# ./installTFA-LINUX TFA Installation Log will be written to File : /tmp/tfa_install_52085_2019_09_04-16_05_00.log Starting TFA installation TFA Version: 192100 Build Date: 201904251105 Enter a location for installing TFA (/tfa will be appended if not supplied) [/u01/TFA/tfa]: /u01/app/12.1.0/grid/tfa/ Running Auto Setup for TFA as user root... Would you like to do a [L]ocal only or [C]lusterwide installation ? [L|l|C|c] [C] : C The following installation requires temporary use of SSH. If SSH is not configured already then we will remove SSH when complete. Do you wish to Continue ? [Y|y|N|n] [Y] Y Installing TFA now... Discovering Nodes and Oracle resources Starting Discovery... Getting list of nodes in cluster . . . . . List of nodes in cluster: RAC1 RAC2 Checking ssh user equivalency settings on all nodes in cluster Node RAC2 is configured for ssh user equivalency for root user CRS_HOME=/u01/app/12.1.0/grid Searching for running databases... 1. CCRMELN Searching out ORACLE_HOME for selected databases... Getting Oracle Inventory... ORACLE INVENTORY: /u01/app/oraInventory Discovery Complete... TFA Will be Installed on the Following Nodes: ++++++++++++++++++++++++++++++++++++++++++++ Install Nodes ============= RAC1 RAC2 Do you wish to make changes to the Node List ? [Y/y/N/n] [N] TFA will scan the following Directories ++++++++++++++++++++++++++++++++++++++++++++ .-------------------------------------------------------------------------. | RAC1 | +--------------------------------------------------------------+----------+ | Trace Directory | Resource | +--------------------------------------------------------------+----------+ | /u01/app/12.1.0/grid/cfgtoollogs | CFGTOOLS | | /u01/app/12.1.0/grid/crf/db/RAC1 | CRS | | /u01/app/12.1.0/grid/crs/log | CRS | | /u01/app/12.1.0/grid/css/log | CRS | | /u01/app/12.1.0/grid/cv/log | CRS | | /u01/app/12.1.0/grid/evm/admin/log | CRS | | /u01/app/12.1.0/grid/evm/admin/logger | CRS | | /u01/app/12.1.0/grid/evm/log | CRS | | /u01/app/12.1.0/grid/install | INSTALL | | /u01/app/12.1.0/grid/inventory/ContentsXML | INSTALL | | /u01/app/12.1.0/grid/log | CRS | | /u01/app/12.1.0/grid/network/log | CRS | | /u01/app/12.1.0/grid/oc4j/j2ee/home/log | DBWLM | | /u01/app/12.1.0/grid/opmn/logs | CRS | | /u01/app/12.1.0/grid/racg/log | CRS | | /u01/app/12.1.0/grid/rdbms/log | ASM | | /u01/app/12.1.0/grid/rdbms/log | ASM | | /u01/app/12.1.0/grid/scheduler/log | CRS | | /u01/app/12.1.0/grid/srvm/log | CRS | | /u01/app/grid/cfgtoollogs | CFGTOOLS | | /u01/app/grid/crsdata/RAC1/acfs | ACFS | | /u01/app/grid/crsdata/RAC1/afd | ASM | | /u01/app/grid/crsdata/RAC1/chad | CRS | | /u01/app/grid/crsdata/RAC1/core | CRS | | /u01/app/grid/crsdata/RAC1/crsconfig | CRS | | /u01/app/grid/crsdata/RAC1/crsdiag | CRS | | /u01/app/grid/crsdata/RAC1/cvu | CRS | | /u01/app/grid/crsdata/RAC1/evm | CRS | | /u01/app/grid/crsdata/RAC1/output | CRS | | /u01/app/grid/crsdata/RAC1/trace | CRS | | /u01/app/grid/diag/asm/+asm/+ASM1/cdump | ASM | | /u01/app/grid/diag/asm/+asm/+ASM1/trace | ASM | | /u01/app/grid/diag/crs/RAC1/crs/cdump | CRS | | /u01/app/grid/diag/crs/RAC1/crs/trace | CRS | | /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/cdump | RDBMS | | /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/trace | RDBMS | | /u01/app/grid/diag/tnslsnr | TNS | | /u01/app/grid/diag/tnslsnr/RAC1/listener/cdump | TNS | | /u01/app/grid/diag/tnslsnr/RAC1/listener/trace | TNS | | /u01/app/grid/diag/tnslsnr/RAC1/listener_scan1/cdump | TNS | | /u01/app/grid/diag/tnslsnr/RAC1/listener_scan1/trace | TNS | | /u01/app/grid/diag/tnslsnr/RAC1/listener_scan2/cdump | TNS | | /u01/app/grid/diag/tnslsnr/RAC1/listener_scan2/trace | TNS | | /u01/app/grid/diag/tnslsnr/RAC1/listener_scan3/cdump | TNS | | /u01/app/grid/diag/tnslsnr/RAC1/listener_scan3/trace | TNS | | /u01/app/oraInventory/ContentsXML | INSTALL | | /u01/app/oraInventory/logs | INSTALL | | /u01/app/oracle/cfgtoollogs | CFGTOOLS | | /u01/app/oracle/diag/clients/user_oracle/host_1425789337_82/ | DBCLIENT | | /u01/app/oracle/diag/clients/user_oracle/host_1425789337_82/ | DBCLIENT | | /u01/app/oracle/diag/rdbms/ccrmel/CCRMEL1/cdump | RDBMS | | /u01/app/oracle/diag/rdbms/ccrmel/CCRMEL1/trace | RDBMS | | /u01/app/oracle/diag/rdbms/ccrmeln/CCRMELN1/cdump | RDBMS | | /u01/app/oracle/diag/rdbms/ccrmeln/CCRMELN1/trace | RDBMS | | /u01/app/oracle/product/12.1.0/dbhome/cfgtoollogs | CFGTOOLS | | /u01/app/oracle/product/12.1.0/dbhome/install | INSTALL | '--------------------------------------------------------------+----------' Installing TFA on RAC1: HOST: RAC1 TFA_HOME: /u01/app/12.1.0/grid/tfa/RAC1/tfa_home Installing TFA on RAC2: HOST: RAC2 TFA_HOME: /u01/app/12.1.0/grid/tfa/RAC2/tfa_home .---------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | +--------------+---------------+-------+------+------------+----------------------+ | RAC1 | RUNNING | 54534 | 5000 | 19.2.1.0.0 | 19210020190425110550 | | RAC2 | RUNNING | 54582 | 5000 | 19.2.1.0.0 | 19210020190425110550 | '--------------+---------------+-------+------+------------+----------------------' Running Inventory in All Nodes... Enabling Access for Non-root Users on RAC1... Adding default users to TFA Access list... Summary of TFA Installation: .----------------------------------------------------------------------. | RAC1 | +---------------------+------------------------------------------------+ | Parameter | Value | +---------------------+------------------------------------------------+ | Install location | /u01/app/12.1.0/grid/tfa/RAC1/tfa_home | | Repository location | /u01/app/grid/tfa/repository | | Repository usage | 0 MB out of 10240 MB | '---------------------+------------------------------------------------' .----------------------------------------------------------------------. | RAC2 | +---------------------+------------------------------------------------+ | Parameter | Value | +---------------------+------------------------------------------------+ | Install location | /u01/app/12.1.0/grid/tfa/RAC2/tfa_home | | Repository location | /u01/app/grid/tfa/repository | | Repository usage | 0 MB out of 10240 MB | '---------------------+------------------------------------------------' TFA is successfully installed... Usage : /u01/app/12.1.0/grid/bin/tfactl <command> [options] commands:diagcollect|collection|analyze|ips|run|start|stop|enable|disable|status|print|access|purge|directory|host|receiver|set|toolstatus|uninstall|diagnosetfa|syncnodes|setupmos|upload|availability|rest|events|search|changes|isa|blackout|rediscover For detailed help on each command use: /u01/app/12.1.0/grid/bin/tfactl <command> -help |
|
1 2 3 4 5 6 7 8 9 |
[root@drprdb2bdbn1 TFA]# /u01/app/12.1.0/grid/bin/tfactl status .----------------------------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status | +--------------+---------------+-------+------+------------+----------------------+------------------+ | RAC1 | RUNNING | 54534 | 5000 | 19.2.1.0.0 | 19210020190425110550 | COMPLETE | | RAC2 | RUNNING | 54582 | 5000 | 19.2.1.0.0 | 19210020190425110550 | COMPLETE | '--------------+---------------+-------+------+------------+----------------------+------------------' |
Examples for diagnostics collection:
Diagnostics collection for last 1 hour:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
[root@RAC1 bin]# ./tfactl diagcollect -last 1h Collecting data for all nodes Collection Id : 20190904162442drprdb2bdbn1 Detailed Logging at : /u01/app/grid/tfa/repository/collection_Wed_Sep_04_16_24_43_IST_2019_node_all/diagcollect_20190904162442_drprdb2bdbn1.log 2019/09/04 16:24:47 IST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom 2019/09/04 16:24:47 IST : Collection Name : tfa_Wed_Sep_04_16_24_43_IST_2019.zip 2019/09/04 16:24:48 IST : Collecting diagnostics from hosts : [RAC2, RAC1] 2019/09/04 16:24:48 IST : Scanning of files for Collection in progress... 2019/09/04 16:24:48 IST : Collecting additional diagnostic information... 2019/09/04 16:24:53 IST : Getting list of files satisfying time range [09/04/2019 15:24:47 IST, 09/04/2019 16:24:53 IST] 2019/09/04 16:24:58 IST : Collecting ADR incident files... 2019/09/04 16:26:39 IST : Completed collection of additional diagnostic information... 2019/09/04 16:26:43 IST : Completed Local Collection 2019/09/04 16:26:43 IST : Remote Collection in Progress... .----------------------------------------. | Collection Summary | +--------------+-----------+------+------+ | Host | Status | Size | Time | +--------------+-----------+------+------+ | RAC2 | Completed | 19MB | 113s | | RAC1 | Completed | 16MB | 115s | '--------------+-----------+------+------' Logs are being collected to: /u01/app/grid/tfa/repository/collection_Wed_Sep_04_16_24_43_IST_2019_node_all /u01/app/grid/tfa/repository/collection_Wed_Sep_04_16_24_43_IST_2019_node_all/RAC1.tfa_Wed_Sep_04_16_24_43_IST_2019.zip /u01/app/grid/tfa/repository/collection_Wed_Sep_04_16_24_43_IST_2019_node_all/RAC2.tfa_Wed_Sep_04_16_24_43_IST_2019.zip Upload above zip files to oracle support for analysis. |
Diagnostics collection for Specific time:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
[root@RAC1 bin]# ./tfactl diagcollect -from "SEP/04/2019 16:00:00" -to "SEP/04/2019 16:30:00" Collecting data for all nodes Scanning files from SEP/04/2019 16:00:00 to SEP/04/2019 16:30:00 Collection Id : 20190904163645RAC1 Detailed Logging at : /u01/app/grid/tfa/repository/collection_Wed_Sep_04_16_36_46_IST_2019_node_all/diagcollect_20190904163645_RAC1.log 2019/09/04 16:36:50 IST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom 2019/09/04 16:36:50 IST : Collection Name : .zip 2019/09/04 16:36:50 IST : Collecting diagnostics from hosts : [RAC2, RAC1] 2019/09/04 16:36:50 IST : Scanning of files for Collection in progress... 2019/09/04 16:36:50 IST : Collecting additional diagnostic information... 2019/09/04 16:36:55 IST : Getting list of files satisfying time range [09/04/2019 16:00:00 IST, 09/04/2019 16:30:00 IST] 2019/09/04 16:36:57 IST : Collecting ADR incident files... 2019/09/04 16:38:34 IST : Completed collection of additional diagnostic information... 2019/09/04 16:38:37 IST : Completed Local Collection 2019/09/04 16:38:37 IST : Remote Collection in Progress... .-----------------------------------------. | Collection Summary | +--------------+-----------+-------+------+ | Host | Status | Size | Time | +--------------+-----------+-------+------+ | RAC2 | Completed | 7.6MB | 99s | | RAC1 | Completed | 6.5MB | 107s | '--------------+-----------+-------+------' Logs are being collected to: /u01/app/grid/tfa/repository/collection_Wed_Sep_04_16_36_46_IST_2019_node_all /u01/app/grid/tfa/repository/collection_Wed_Sep_04_16_36_46_IST_2019_node_all/RAC1.tfa_Wed_Sep_04_16_36_46_IST_2019.zip /u01/app/grid/tfa/repository/collection_Wed_Sep_04_16_36_46_IST_2019_node_all/RAC2.tfa_Wed_Sep_04_16_36_46_IST_2019.zip Upload above zip files to oracle support for analysis. |
Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates
KTEXPERTS is always active on below social media platforms.
Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Note: Please test scripts in Non Prod before trying in Production.
(5 votes, average: 4.60 out of 5)
Loading...
Mohammad Mujeeb
Thanks Nilesh for sharing detailed information on TFA