RAC and DB Support Tools Bundle (Doc ID 1594347.1)

Post date: Sep 17, 2014 4:57:18 PM

Oracle's centre of expertise has been busy building tools to automatically monitor Oracle Databases that runs on the host.

Many customers have put together their own collections of disparate tools to try and do this, but obviously using those provided by Oracle will reduce the cost of developing and deploying these tools with the major advantage that Oracle Support can be contacted when any issues arise.

The Oracle Support Note, where you can download all of these tools bundled together, is RAC and DB Support Tools Bundle (Doc ID 1594347.1)

The tools included in the Support Tools Bundle are:

• • ORAchk (formerly RACcheck) - Proactive, self service tool tool to prevent rediscovery of known issues.  See Document 1268927.1 for additional details

  • Trace File Analyzer Collector (aka TFA) - Diagnostic file collection utility to simplify collection of ALL diagnostic data into a single command executed from a single node.  Diagnostic files are also trimmed around the incident time to drastically reduce diagnostic file upload sizes.  Additional information can be found in Document 1513912.1.

  • OSWatcher (formerly OSWatcher Black Box) - Script to collect and archive OS metrics.  OSWatcher is required for many reactive types of issues including Instance/Node Evictions and Performance Issues.  See Document 301137.1 for additional details.

  • Procwatcher - A script used to automate and capture diagnostic output for Severe Database Performance issues and Session Level Hangs.  See Document 459694.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 Document 1500864.1 for additional details.

  • SQLT - A tool designed to assist in the tuning of a given SQL Statement.  See Document 215187.1 for additional details.

  • RDA - Powerful diagnostic tool which provides a unified package of support diagnostics tools which provides comprehensive picture of the customer's environment to aid in problem diagnosis.  See Document 314422.1for additional details.

  • DA - (Installed with RDA) The Diagnostic Assistant (DA) tool provides a common, light-weight interface to multiple diagnostic collection tools (ADR, RDA, OCM, Explorer, and others).  See Document 201804.1 for additional details.

Be aware though that you must be able to run the bash shell to take advantage of a couple of these tools (Orachk & TFA), this standard came in with Oracle11g and shows the bias that Oracle have towards linux deployments.

Starting with TFA 12.1.2.3.0, The RAC and DB Support Tools Bundle that was formerly found in this MOS Note has been integrated into TFA Collector (aka TFA) which can be found in Document 1513912.1.  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.  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 collection.  To obtain the RAC and Database Support Tools Bundle, please download and install the latest version of TFA from Document 1513912.1.