Oracle Trace File Analyzer (TFA) - All in One Diagnostic Tool for Grid and Database Issue - Overview
Introduction:
As a DBA, you're expected to do more work, with fewer resources all the time. You're under pressure to keep missioncritical apps up and running. When something goes wrong, everyone looks to you to understand what happened and how to fix it
Oracle Trace File Analyzer helps you perform real-time health monitoring, fault detection & diagnosis via a single interface. It will securely consolidate all distributed diagnostic data.
Its continuously available and watching your logs for significant problems that may affect your service. If desired it can also automatically collect the relevant diagnostics, when it sees these problems.
Oracle Trace File Analyzer knows what is relevant in log files. This allows it to trim them to the smallest size, yet still gather everything necessary. It also collects data across cluster nodes and consolidates everything in one place. Once done collecting it can automatically upload the collection to Oracle Support.
Autonomous Diagnostic Collections:
The resource footprint is small. You will not usually be aware it is running. The only times Trace File Analyzer will consume noticeable
CPU are:
» When performing an inventory of diagnostic files
» During diagnostic collection
Trace File Analyzer (TFA) will watch your logs for significant problems, such as internal errors like ORA-00600 or node evictions. If detected it will:
Invoke any necessary diagnostics and collect all relevant log data at the time of a problem
Trim log files around the time of the problem, so it only collects what is necessary for diagnosis
Collect and package all trimmed diagnostics. From all nodes in the cluster, consolidating everything on a single node
Store the collection in the repository
Send you email notification of the problem and details of diagnostic collection, ready for upload to Oracle Support
You can then either use TFA to upload the collection to Oracle Support, if you can make a connection from that environment, or transfer the collection somewhere else for upload
On-demand Analysis and Collection:
You can run Oracle Trace File Analyzer on-demand via the command line tool tfactl.
The tfactl command can:
» Provide you a real-time status summary
» Perform analysis using a combination of different database tools, using a common syntax.
» Collect all relevant diagnostic log data, with logs trimmed files around the time, collecting only what is necessary for diagnosis
» Securely consolidate all distributed collections on the node where tfactl was run from
» Upload the collection to Oracle Support
Real-time System & Cluster Status Summary
Use the summary command for a real-time report of system and cluster status. It shows a fast, easy to read summary of the status
including any potential problems with important elements.
Usage:
$ tfactl summary [options]
For more help use:
$ tfactl summary -help
Investigate Logs & Look for Errors
You can use Oracle Trace File Analyzer to analyze all your logs across your cluster and tell you about any recent errors.
For example:
$ tfactl analyze –last 1d
or
$ tfactl analyze –last 18h
This will report all errors it finds over the specified duration.
You can also use Oracle Trace File Analyzer to find all occurrences of a specific error on any node. For example, this command will
search for ORA-00600 errors:
$ tfactl analyze -search “ora-00600" -last 8h
Perform Analysis Using the Included Tools
Oracle Trace File Analyzer with database support tools bundle includes the following tools. These tools are only available when Oracle
Trace File Analyzer is downloaded from Document 1513912.1.
TOOLS INCLUDED ON LINUX / UNIX
Tool Description
orachk or exachk Provides health checks for the Oracle stack.
Oracle Trace File Analyzer will install either
» Oracle EXAchk for Engineered Systems, see document 1070954.1 for more details
or
» Oracle ORAchk for all non-Engineered Systems, see document 1268927.2 for more details
oswatcher Collects and archives OS metrics. These are useful for instance or node evictions & performance Issues. See document 301137.1 for more
details
procwatcher Automates & captures database performance diagnostics and session level hang information. See document 459694.1 for more details
oratop Provides near real-time database monitoring. See document 1500864.1 for more details.
sqlt Captures SQL trace data useful for tuning. See document 215187.1 for more details.
alertsummary Provides summary of events for one or more database or ASM alert files from all nodes
ls Lists all files Oracle Trace File Analyzer knows about for a given file name pattern, across all nodes
pstack Generates the process stack for the specified processes, across all nodes
grep Searches for a given string in the alert or trace files with a specified database
summary Provides high level summary of the configuration
vi Opens alert or trace files for viewing a given database and file name pattern in the vi editor
tail Runs a tail on an alert or trace files for a given database and file name pattern
param Shows all database and OS parameters that match a specified pattern
dbglevel Sets and unsets multiple CRS trace levels with one command
history Shows the shell history for the tfactl shell
changes Reports changes in the system setup over a given time period. This includes database parameters, OS parameters and patches applied
catalog Reports major events from the Cluster Event log
events Reports warnings and errors seen in the logs
manage logs Shows disk space usage and purges ADR log and trace files
ps Finds processes
triage Summarize oswatcher/exawatcher data
To verify which tools you have installed run:
$ tfactl toolstatus
Hope this helps!
Cheers!
Ramesh
Post a Comment: