Analyzing Logs Using the Oracle Database Support Tools

The Oracle Database support tools bundle is available only when you download Oracle Trace File Analyzer from My Oracle Support note 2550798.1.

Oracle Trace File Analyzer with Oracle Database support tools bundle includes the following tools:

Tools Included in Linux and UNIX

Tool	Description
`orachk` or `exachk`	Provides health checks for the Oracle stack. Oracle Autonomous Health Framework installs either Oracle EXAchk for engineered systems or Oracle ORAchk for all non-engineered systems. For more information, see My Oracle Support notes 1070954.1 and 2550798.1.
`oswatcher (oswbb)`	Collects and archives operating system metrics. These metrics are useful for instance or node evictions and performance Issues. For more information, see My Oracle Support note 301137.1.
`procwatcher (prw)`	Automates and captures database performance diagnostics and session level hang information. For more information, see My Oracle Support note 459694.1.
`oratop`	Provides near real-time database monitoring. For more information, see My Oracle Support note 1500864.1.
`alertsummary`	Provides summary of events for one or more database or Oracle ASM alert files from all nodes.
`ls`	Lists all files that 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 operating system parameters that match a specified pattern.
`history`	Shows the shell history for the `tfactl` shell.
`changes`	Reports changes in the system setup over a given time period. The report includes database parameters, operating system parameters, and the patches that are applied.
`calog`	Reports major events from the cluster event log.
`events`	Reports warnings and errors in the logs.
`managelogs`	Shows disk space usage and purges Automatic Diagnostic Repository (ADR) log and trace files.
`ps`	Finds processes.
`triage`	Summarizes `oswatcher` or `exawatcher` data.

Tools Included in Microsoft Windows

Tool	Description
`calog`	Reports major events from the cluster event log.
`changes`	Reports changes in the system setup over a given time period. The report includes database parameters, operating system parameters, and patches applied.
`dir`	Lists all files Oracle Trace File Analyzer knows about for a given file name pattern across all nodes.
`events`	Reports warnings and errors seen in the logs.
`findstr`	Searches for a given string in the alert or trace files with a specified database.
`history`	Shows the shell history for the `tfactl` shell.
`managelogs`	Shows disk space usage and purges ADR log and trace files.
`notepad`	Opens alert or trace files for viewing a given database and file name pattern in the `notepad` editor.
`param`	Shows all database and operating system parameters that match a specified pattern.
`summary`	Provides high-level summary of the configuration.
`tasklist`	Finds processes.

To verify which tools you have installed:

$ tfactl toolstatus

You can run each tool using tfactl either in command line or shell mode. To run a tool from the command line:

$ tfactl run tool

The following example shows how to use tfactl in shell mode. Running the command starts tfactl, connects to the database MyDB, and then runs oratop:

$ tfactl
tfactl > database MyDB
MyDB tfactl > oratop

For more information, see: