Oracle Trace File Analyzer (TFA) - AIOUG

1 Copyright 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Trace File Analyzer (TFA) with Database Support Tools Bundle What s New in Copyright 2017, Oracle and/or its affiliates. All rights reserved. | 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.

2 The development, release, and timing of any features or functionality described for Oracle s products remains at the sole discretion of Oracle . 2 Copyright 2017, Oracle and/or its affiliates. All rights reserved. | 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 Copyright 2017, Oracle and/or its affiliates.

3 All rights reserved. | 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 4 6 4 2 5 7 3 Copyright 2017, Oracle and/or its affiliates. All rights reserved. | 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 4 6 5 2 5 7 3 Copyright 2017, Oracle and/or its affiliates.

4 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)

5 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> Copyright 2017, Oracle and/or its affiliates. All rights reserved. | 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 4 6 7 2 5 7 3 Copyright 2017, Oracle and/or its affiliates.

6 All rights reserved. | 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 Copyright 2017, Oracle and/or its affiliates. All rights reserved. | 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 Copyright 2017, Oracle and/or its affiliates. All rights reserved. | 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 Copyright 2017, Oracle and/or its affiliates.

7 All rights reserved. | 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]

8 Report at console -silent Interactive console by default -node <local|node> Local or comma separated node name(s) -help Display help Copyright 2017, Oracle and/or its affiliates. All rights reserved. | 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 4 6 12 2 5 7 3 Copyright 2017, Oracle and/or its affiliates. All rights reserved.

9 | 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> Copyright 2017, Oracle and/or its affiliates. All rights reserved. | 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.

10 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.