Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Autonomous Health Framework User’s Guide Release 12c
- New Features for Oracle Database 12c Release 2 (12.2)
- New Features for Oracle ORAchk and Oracle EXAchk 12.1.0.2.7
- Simplified Enterprise-Wide Data Configuration and Maintenance
- Tracking Changes to File Attributes
- Find Health Checks that Require Privileged Users to Run
- Support for Broader Range of Oracle Products
- Easier to Run Oracle EXAchk on Oracle Exadata Storage Servers
- New Health Checks for Oracle ORAchk and Oracle EXAchk
- New Features for Cluster Health Monitor 12.2.0.1.1
- New Features for Oracle Trace File Analyzer 12.2.0.1.1
- New Features for Hang Manager
- New Features for Memory Guard
- New Features for Oracle Database Quality of Service Management 12c Release 2 (12.2.0.1)
- 1
Introduction to Oracle Autonomous Health Framework
- 1.1 Oracle Autonomous Health Framework Problem and Solution Space
- 1.2
Components of Oracle Autonomous Health Framework
- 1.2.1 Introduction to Oracle ORAchk and Oracle EXAchk
- 1.2.2 Introduction to Cluster Health Monitor
- 1.2.3 Introduction to Oracle Trace File Analyzer Collector
- 1.2.4 Introduction to Oracle Cluster Health Advisor
- 1.2.5 Introduction to Memory Guard
- 1.2.6 Introduction to Hang Manager
- 1.2.7 Introduction to Oracle Database Quality of Service (QoS) Management
- 2
Analyzing Risks and Complying with Best Practices
- 2.1 Using Oracle ORAchk and Oracle EXAchk to Automatically Check for Risks and System Health
- 2.2 Email Notification and Health Check Report Overview
- 2.3 Configuring Oracle ORAchk and Oracle EXAchk
- 2.4 Using Oracle ORAchk and Oracle EXAchk to Manually Generate Health Check Reports
- 2.5 Managing the Oracle ORAchk and Oracle EXAchk Daemons
- 2.6 Tracking Support Incidents
- 2.7 Tracking File Attribute Changes and Comparing Snapshots
- 2.8
Collecting and Consuming Health Check Data
- 2.8.1 Selectively Capturing Users During Login
- 2.8.2 Bulk Mapping Systems to Business Units
- 2.8.3 Adjusting or Disabling Old Collections Purging
- 2.8.4 Uploading Collections Automatically
- 2.8.5 Viewing and Reattempting Failed Uploads
- 2.8.6 Authoring User-Defined Checks
- 2.8.7 Finding Which Checks Require Privileged Users
- 2.8.8 Creating or Editing Incidents Tickets
- 2.8.9 Viewing Clusterwide Linux Operating System Health Check (VMPScan)
- 2.9 Locking and Unlocking Storage Server Cells
- 2.10 Integrating Health Check Results with Other Tools
- 2.11 Troubleshooting Oracle ORAchk and Oracle EXAchk
- 3 Collecting Operating System Resources Metrics
- 4
Collecting Diagnostic Data and Triaging, Diagnosing, and Resolving Issues
- 4.1 Understanding Oracle Trace File Analyzer
- 4.2 Getting Started with Oracle Trace File Analyzer
- 4.3 Automatically Collecting Diagnostic Data Using the Oracle Trace File Analyzer Collector
- 4.4 Analyzing the Problems Identified
- 4.5
Manually Collecting Diagnostic Data
- 4.5.1 Running On-Demand Default Collections
- 4.5.2 Running On-Demand Event-Driven SRDC Collections
- 4.5.3
Running On-Demand Custom Collections
- 4.5.3.1 Collecting from Specific Nodes
- 4.5.3.2 Collecting from Specific Components
- 4.5.3.3 Collecting from Specific Directories
- 4.5.3.4 Changing the Collection Name
- 4.5.3.5 Preventing Copying Zip Files and Trimming Files
- 4.5.3.6 Performing Silent Collection
- 4.5.3.7 Preventing Collecting Core Files
- 4.5.3.8 Collecting Incident Packaging Service Packages
- 4.6 Analyzing and Searching Recent Log Entries
- 4.7 Managing Oracle Database and Oracle Grid Infrastructure Diagnostic Data
- 4.8 Upgrading Oracle Trace File Analyzer Collector by Applying a Patch Set Update
- 4.9 Troubleshooting Oracle Trace File Analyzer
- 5
Proactively Detecting and Diagnosing Performance Issues for Oracle RAC
- 5.1 Oracle Cluster Health Advisor Architecture
- 5.2 Monitoring the Oracle Real Application Clusters (Oracle RAC) Environment with Oracle Cluster Health Advisor
- 5.3 Using Cluster Health Advisor for Health Diagnosis
- 5.4 Calibrating an Oracle Cluster Health Advisor Model for a Cluster Deployment
- 5.5 Viewing the Details for an Oracle Cluster Health Advisor Model
- 5.6 Managing the Oracle Cluster Health Advisor Repository
- 5.7 Viewing the Status of Cluster Health Advisor
- 6 Resolving Memory Stress
- 7 Resolving Database and Database Instance Hangs
- 8 Monitoring System Metrics for Cluster Nodes
- 9 Monitoring and Managing Database Workload Performance
- A Oracle ORAchk and Oracle EXAchk Command-Line Options
- B OCLUMON Command Reference
- C Diagnostics Collection Script
- D Managing the Cluster Resource Activity Log
- E
chactl Command Reference
- E.1 chactl monitor
- E.2 chactl unmonitor
- E.3 chactl status
- E.4 chactl config
- E.5 chactl calibrate
- E.6 chactl query diagnosis
- E.7 chactl query model
- E.8 chactl query repository
- E.9 chactl query calibration
- E.10 chactl remove model
- E.11 chactl rename model
- E.12 chactl export model
- E.13 chactl import model
- E.14 chactl set maxretention
- E.15 chactl resize repository
- F
Oracle Trace File Analyzer Command-Line and Shell Options
- F.1 Running Administration Commands
- F.2 Running Summary and Analysis Commands
- F.3
Running Diagnostic Collection Commands
- F.3.1 tfactl diagcollect
- F.3.2 tfactl directory
- F.3.3
tfactl ips
- F.3.3.1 tfactl ips ADD
- F.3.3.2 tfactl ips ADD FILE
- F.3.3.3 tfactl ips COPY IN FILE
- F.3.3.4 tfactl ips REMOVE
- F.3.3.5 tfactl ips REMOVE FILE
- F.3.3.6 tfactl ips ADD NEW INCIDENTS PACKAGE
- F.3.3.7 tfactl ips GET REMOTE KEYS FILE
- F.3.3.8 tfactl ips USE REMOTE KEYS FILE
- F.3.3.9 tfactl ips CREATE PACKAGE
- F.3.3.10 tfactl ips FINALIZE PACKAGE
- F.3.3.11 tfactl ips GENERATE PACKAGE
- F.3.3.12 tfactl ips DELETE PACKAGE
- F.3.3.13 tfactl ips GET MANIFEST FROM FILE
- F.3.3.14 tfactl ips GET METADATA
- F.3.3.15 tfactl ips PACK
- F.3.3.16 tfactl ips SET CONFIGURATION
- F.3.3.17 tfactl ips SHOW CONFIGURATION
- F.3.3.18 tfactl ips SHOW PACKAGE
- F.3.3.19 tfactl ips SHOW FILES PACKAGE
- F.3.3.20 tfactl ips SHOW INCIDENTS PACKAGE
- F.3.3.21 tfactl ips SHOW PROBLEMS
- F.3.3.22 tfactl ips UNPACK FILE
- F.3.3.23 tfactl ips UNPACK PACKAGE
- F.3.4 tfactl collection
- F.3.5 tfactl print
- F.3.6 tfactl purge
- F.3.7 tfactl managelogs
- Index