@@@@Platform-“OnPrem”

@@@@Product-“Database”

@@@@ReleaseVersion-“26.11”

@@@@info-map-label-“Analyzing Logs Using the Oracle Database Support Tools”

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: