oracle trace file analyzer (tfa) - aioug new in... · database install / upgrade problems local...

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle Trace File Analyzer (TFA) with Database Support Tools Bundle

What’s New in 12.2.1.1.0


Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

2


Why TFA?

Provides one interface for all diagnostic needs

Collects data across the cluster and consolidates it in one place

Collects all relevant diagnostic data at the time of the problem

Reduces time required to obtain diagnostic data, which saves your business money

3


Program Agenda

Faster & easier SR data collection

Quick system & cluster summary

Log maintenance made easy

Simple IPS (Incident Packaging Service) interface

Microsoft Windows support

Easy to use menu interface

Built on the latest, most secure Java release 1.8

1

4

6

4

2

5

7

3


Program Agenda








1

4

6

5

2

5

7

3

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 6

Faster & Easier SR Data Collection

Type of Problem SRDC Types Collection Scope

ORA Errors

• ORA-00600

• ORA-00700

• ORA-04030

• ORA-04031

• ORA-07445

• ORA-27300

• ORA-27301

• ORA-27302

Local only

Other internal database errors • internalerror Local only

Database performance problems • dbperf Cluster wide

Database patching problems • dbpatchinstall

• dbpatchconflict Local only

Database install / upgrade problems • dbinstall

• dbupgrade Local only

Enterprise Manager tablespace usage metric problems • emtbsmetrics Local only (on EM Agent target)

Enterprise Manager general metrics page or threshold problems • emmetricalert Local only (on EM Agent target & Repository DB)

Enterprise Manager debug log collection • emdebugon

• emdebugoff Local only (on EM Agent target & OMS)

New

New

New

New

New

New

New

New

tfactl diagcollect –srdc <srdc_type>


Program Agenda








1

4

6

7

2

5

7

3


View System & Cluster Summary

8

Quick summary of status of key components

Choose an option to drill down further

Summary is currently only available on Linux


Summary ASM Drill Down Example

9

Problems found

ASM Cluster wide status

ASM Overview

ASM cluster wide summary

Problems found on myserver69

Also disk space warning on both servers


Summary ASM Drill Down Example

10

View recent problems detected

View component status

View node wise & drill into myserver69

View ASM status summary for myserver69

View ASM problems for myserver69


Summary Options

Option Description

-overview Complete summary overview (default)

-crs CRS status summary

-asm ASM status summary

-acfs ACFS status summary

-database Database status summary

-exadata Exadata status summary

-patch Patch details

-listener Listener status summary

-network Network status summary

-os OS status summary

11

tfactl summary [options]

Option Description

-tfa TFA status summary

-summary Summary tool metadata

-json JSON format as well as via the summary

interface

-html HTML format as well as via the summary

interface

-print Display [html or json] report at console

-silent Interactive console by default

-node

<local|node> Local or comma separated node name(s)

-help Display help


Program Agenda








1

4

6

12

2

5

7

3


Automatic Database Log Purge

• TFA can automatically purge database logs – OFF by default

– Except on a Domain Service Cluster (DSC), which it is ON by default

• Turn auto purging on or off:

• Will remove logs older than 30 days – configurable with:

• Purging runs every 60 minutes – configurable with:

13

tfactl set manageLogsAutoPurge=<ON|OFF>

tfactl set manageLogsAutoPurgePolicyAge=<n><d|h>

tfactl set manageLogsAutoPurgeInterval=<minutes>


Manual Database Log Purge

• TFA can manage ADR log and trace files

– Show disk space usage of individual diagnostic destinations

– Purge these file types based on diagnostic location and or age:

• "ALERT“, "INCIDENT“, "TRACE“, "CDUMP“, "HM“, "UTSCDMP“, "LOG“ tfactl managelogs <options>

Runs as the ADR home owner. So will only be able to purge files this owner has permission to delete

Option Description

–show usage Shows disk space usage per diagnostic directory for both GI and database logs

-show variation –older <n><m|h|d> Use to determine per directory disk space growth.

Shows the disk usage variation for the specified period per directory.

-purge –older <n><m|h|d> Remove all ADR files under the GI_BASE directory, which are older than the time specified

–gi Restrict command to only diagnostic files under the GI_BASE

–database [all | dbname] Restrict command to only diagnostic files under the database directory. Defaults to all,

alternatively specify a database name

-dryrun Use with –purge to estimate how many files will be affected and how much disk space will be

freed by a potential purge command.

May take a while for a large number of files

14


Manual Database Log Purge

tfactl managelogs –show usage tfactl managelogs –show variation –older <n><m|h|d>

Use -gi to only show grid infrastructure

Use –database to only show database


Manual Database Log Purge tfactl managelogs –purge –older n<m|h|d> -dryrun tfactl managelogs –purge –older n<m|h|d>

Use –dryrun for a “what if”


Disk Usage Snapshots

• TFA will track disk usage and record snapshots to: – tfa/repository/suptools/<node>/managelogs/usage_snapshot/

• Snapshot happens every 60 minutes, configurable with:

• Disk usage monitoring is ON by default, configurable with:

17

tfactl set diskUsageMonInterval=<minutes>

tfactl set diskUsageMon=<ON|OFF>


Program Agenda








1

4

6

18

2

5

7

3


• TFA can invoke IPS to query and collect these packages


• Database incidents are stored in the ADR (Automatic Diagnostic Repository)

• IPS packages details about these incidents for later diagnosis

19

Command Description

tfactl ips Invoke IPS

tfactl ips show incidents Show all IPS incidents

tfactl ips show problems Show all IPS problems

tfactl ips show package Show all IPS packages

tfactl diagcollect -ips –help Show all available diagcollect IPS options

tfactl diagcollect –ips Perform an IPS collection following prompts

tfactl diagcollect -ips -adrbasepath

<adr_base> -adrhomepath <adr_home>

Perform an IPS collection in silent mode.

tfactl diagcollect -ips -incident <incident id> Collect ADR details about a specific incident id

tfactl diagcollect -ips -problem <problem id> collect ADR details about a specific problem id

tfactl ips <options>

tfactl diagcollect –ips <options>

or


• Display details of incidents recorded in ADR

20

Show Incidents

tfactl ips show incidents

• Incident ID

• Problem Key

• Create Time


• Display details of problems recorded in ADR

21

Show Problems

tfactl ips show problems

• Problem ID

• Problem Key

• Last Incident

• Last Incident Time


• Display details of packages recorded in ADR

22

Show Package

tfactl ips show package

List of packages &

details of each package


Collect Packages

tfactl diagcollect -ips

Select ADR home

Generate package

Rest of collection

Resulting collection zips


Program Agenda








1

4

6

24

2

5

7

3


Windows Installation 1. Download from 1513912.1

2. Copy to one required machine and unzip

3. Open a command prompt as administrator and run:

Will : – Prompt for local or cluster install and install remotely if required

– Auto discover relevant Oracle Software

– Start monitoring for problems & perform auto collections

25

install.bat –perlhome <perl_home>

TFA is only supported on Windows 64 bit

https://support.oracle.com/epmos/faces/DocContentDisplay?id=1513912.1&parent=slides&sourceId=whatsnew12.2.1.1.0


Program Agenda








1

4

6

26

2

5

7

3


Program Agenda








1

4

6

28

2

5

7

3


• TFA now uses the latest Java features

• JRE 1.8 is now a requirement – Already shipped with the latest versions of the 12c

Database and Grid Infrastructure

– Also included with the download install

• The JRE is platform specific – As TFA includes the JRE, the install is now platform specific

29



For more info see Document: 1513912.1

30

https://support.oracle.com/epmos/faces/DocContentDisplay?id=1513912.1&parent=slides&sourceId=whatsnew12.2.1.1.0


Safe Harbor Statement

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

31

oracle trace file analyzer (tfa) - aioug new in... · database install / upgrade problems local...

Documents