![]() That is what we are going to see in this article. From TFA you will be able to start every tool, stop it, run it, and s on. This includes database a parameters, OS parameters, patches applied etc. dbglevel – A tool to set and unset multiple CRS trace levels with one command history – Shows the shell history for the tfactl shell changes – reports any noted changes in the system setup over a given time period. param – shows all database and OS parameters that match a specified pattern. ![]() tail – runs a tail on an alert or trace files for a given database and file name pattern. vi – opens alert or trace files for viewing a given database and file name pattern in the vi editor. summary – Gives a high level summary of the configuration. grep – searches alert or trace files with a given database and file name pattern, for a search string. pstack – takes a process stack for specified processes across all nodes. ls – lists all files TFA knows about for a given file name pattern across all nodes. alertsummary – Generates a summary of events for one or more database or ASM alert files from all nodes. See Doc ID 210804.1 for additional details. DARDA - The Diagnostic Assistant (DA) tool provides a common, light-weight interface to multiple diagnostic collection tools (ADR, RDA, OCM, Explorer, and others). See Doc ID 215187.1 for additional details. SQLT - A tool designed to assist in the tuning of a given SQL Statement. See Doc ID 1500864.1 for additional details. ORATOP - A utility allowing for near real-time monitoring of databases (RAC and Single Instance), this utility is built for the Linux platform but can remotely monitor databases on ANY platform from a Linux Client. See Doc ID 459694.1 for additional details. Procwatcher - A script used to automate and capture diagnostic output for Severe Database Performance issues and Session Level Hangs. See Doc ID 301137.1 for additional details. OSWatcher is required for many reactive types of issues including Instance/Node Evictions and Performance Issues. OSWatcher (formerly OSWatcher Black Box) - Script to collect and archive OS metrics. EXAchk is intended for use with engineered systems. See Doc ID 1070954.1 for additional details. ORAchk is intended for use with non-engineered systems EXAchk - Proactive, self service tool to prevent rediscovery of known issues. See Doc ID 1268927.1 for additional details. The tools that are included starting in TFA 12.1.2.3.0 are the following: ORAchk (formerly RACcheck) - Proactive, self service tool to prevent rediscovery of known issues. This integration into TFA Shell greatly simplifies the execution of the tools by providing a common interface to each of the tools while ensuring that the output of the tools are collected by TFA Diagnostic collections. As part of the integration of the Support Tools Bundle in TFA, command line execution of each of the tools has been added into TFA Shell. ANOUNCEMENT: Starting with TFA 12.1.2.3.0, The RAC and DB Support Tools Bundle (Document 1594347.1) has been integrated into TFA. 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 -help ~]# However Starting with TFA version 12.1.2.3.0, TFA has included the RAC and DB Support Tools, and instead of work with every tool separately I recommend manage all these tools from TFA, it is always easy to work from only one place. ~]# /u01/app/12.1.0/grid/tfa/bin/tfactl -h Usage : /u01/app/12.1.0/grid/bin/tfactl = 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. A simple "-h" will show that basically we can start it, stop and print the status, nothing related to diag tools. | rac1 | +-+-+ | Configuration Parameter | Value | +-+-+ | TFA version | 12.1.2.0.0 | | Automatic diagnostic collection | OFF | | Trimming of files during diagcollection | ON | | Repository current size (MB) in rac1 | 0 | | Repository maximum size (MB) in rac1 | 1194 | | Inventory Trace level | 1 | | Collection Trace level | 1 | | Scan Trace level | 1 | | Other Trace level | 1 | | Max Size of TFA Log (MB) | 50 | | Max Number of TFA Logs | 10 | '-+-' However, this version doesn't include options to manage the tools like OSWatcher, ORAchk, etc. The version that come with GI 12.1.0.2 is 12.1.2.0.0 as you can see below: ~]# /u01/app/12.1.0/grid/tfa/bin/tfactl print config. If you have installed Grid Infrastructure 12.1.0.2 you will notice that TFA is already included there, and actually TFA started to be included since Oracle GI 11.2.0.4.
0 Comments
Leave a Reply. |