Changes in this Release for Oracle Trace File Analyzer User’s Guide 18.2.0

This preface lists changes in Oracle® Trace File Analyzer User’s Guide 18.2.0.

• REST Service
  Oracle Trace File Analyzer now includes REST support allowing invocation and query over HTTPS.
• Oracle Cluster Health Advisor Integration
  Oracle Trace File Analyzer now integrates with Oracle Cluster Health Advisor and consumes the problem events that Oracle Cluster Health Advisor detects.
• New SRDCs
  This release includes new SRDCs.
• Metadata Search Capability
  All metadata stored in the Oracle Trace File Analyzer index is now searchable using tfactl search -showdatatypes|-json [json_details].

REST Service

Oracle Trace File Analyzer now includes REST support allowing invocation and query over HTTPS.

To facilitate REST support Oracle REST Data Services (ORDS) is included within the install.

To enable REST, start ORDS: tfactl rest -start.

REST supports printing details, starting a diagcollect, and downloading collections.

Oracle Cluster Health Advisor Integration

Oracle Trace File Analyzer now integrates with Oracle Cluster Health Advisor and consumes the problem events that Oracle Cluster Health Advisor detects.

When Oracle Cluster Health Advisor detects a problem event, Oracle Trace File Analyzer automatically triggers relevant diagnostic collection and sends an email notification.

Email notification is configured through the standard Oracle Trace File Analyzer notification process.

New SRDCs

This release includes new SRDCs.

• ORA-01031 for ORA-01031 errors

• ORA-01578 for ORA-01578 errors

• ORA-08102 for ORA-08102 errors

• ORA-08103 for ORA-08103 errors

• dbblockcorruption for problems showing alert log messages of Corrupt block relative dba

• dbfs for ASM, DBFS, DNFS, and ACFS problems

• dbpartition for create/maintain partitioned/subpartitioned table/index problems

• dbpartitionperf for slow create/alter/drop commands against partitioned table/index

• dbsqlperf for SQL performance problems

• dbundocorruption for UNDO corruption problems

• esexalogic for Oracle Exalogic full Exalogs data collection information

• listener_services for listener errors: TNS-12516, TNS-12518, TNS-12519, and TNS-12520

• naming_services for naming service errors: ORA-12154, ORA-12514, and ORA-12528

• dbaudit standard information for Oracle Database auditing

Additionally, a number of the existing RMAN related SRDCs have been collapsed into fewer SRDCs:

• dbrman for RMAN related issues, such as backup, maintenance, restore and recover, RMAN-08137 or RMAN-08120

• dbrman600 for RMAN-00600 error

• dbrmanperf for RMAN performance problems

As with all other SRDCs, use tfactl diagcollect -srdc srdc_name.

Metadata Search Capability

All metadata stored in the Oracle Trace File Analyzer index is now searchable using tfactl search -showdatatypes|-json [json_details].

You can search for all events for a particular Oracle Database between certain dates, for example,

tfactl search -json 
'{
  "data_type":"event",
  "content":"oracle",
  "database":"rac11g",
  "from":"01/20/2017 00:00:00",
  "to":"12/20/2018 00:00:00"
 }'

To list all index events: tfactl search -json '{"data_type":"event"}'

To list all available datatypes: tfactl search -showdatatypes