5.1 Collecting Diagnostics Automatically

This section explains automatic diagnostic collection concepts.

If Oracle Trace File Analyzer detects any problems, then it performs the following actions:

  • Runs necessary diagnostics and collects all relevant log data at the time of a problem

  • Trims log files to collect only what is necessary for diagnosis

  • Collects and packages all trimmed diagnostics from all nodes in the cluster, consolidating everything on a single node

  • Stores diagnostic collections in the Oracle Trace File Analyzer repository

  • Sends you email notification of the problem and details of diagnostic collection that is ready for upload to Oracle Support

Figure 5-1 Automatic Diagnostic Collections

Description of Figure 5-1 follows
Description of "Figure 5-1 Automatic Diagnostic Collections"

Oracle Trace File Analyzer has a mechanism that prevents repeat errors from overwhelming your system with excessive, automatic collections.

Identifying an event triggers the start point for a collection and five minutes later Oracle Trace File Analyzer starts collecting diagnostic data. Starting five minutes later enables Oracle Trace File Analyzer to capture other relevant events in one operation. If events are still occurring after five minutes, then diagnostic collection continues to wait. Oracle Trace File Analyzer waits for 30 seconds with no events occurring up to an additional five minutes.

If events continue after 10 minutes, then Oracle Trace File Analyzer continues to perform diagnostic collection.

After completing the diagnostic collections, Oracle Trace File Analyzer sends email notifications that include the collection location to the designated recipients.

If your environment can make a connection to oracle.com, then you can use Oracle Trace File Analyzer to upload the collection to a Service Request.

$ tfactl set autodiagcollect=ON|OFF

Automatic collections are ON by default.

Table 5-1 Log Entries that Trigger Automatic collection

String Pattern Log Monitored

ORA-297(01|02|03|08|09|10|40)

ORA-00600

ORA-07445

ORA-04(69|([7-8][0-9]|9([0-3]|[5-8])))

ORA-32701

ORA-00494

ORA-04020

ORA-04021

ORA-01578

ORA-00700

System State dumped

Alert Log - Oracle Database

Alert Log - Oracle ASM

Alert Log - Oracle ASM Proxy

Alert Log - Oracle ASM IO Server

CRS-016(07|10|11|12)

Alert Log - Oracle Clusterware

Additionally, when Oracle Cluster Health Advisor detects a problem event, Oracle Trace File Analyzer automatically triggers the relevant diagnostic collection.