Table of Contents

• List of Figures
• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documentation
  • Conventions
• Changes in This Release for Oracle Autonomous Health Framework User’s Guide Release 12c
  • New Features for Oracle Database 12c  Release 2 (12.2)
    • Oracle Cluster Health Advisor
    • Enhancements to Grid Infrastructure Management Repository (GIMR)
  • New Features for Oracle ORAchk and Oracle EXAchk 12.1.0.2.7
    • Simplified Enterprise-Wide Data Configuration and Maintenance
      • Bulk Mapping Systems to Business Units
      • Selectively Capturing Users During Log In
      • Configuring Details for Upload of Health Check Collection Results
      • Viewing and Reattempting Failed Uploads
      • Managing Oracle Health Check Collection Purges
    • 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.1.1 Availability Issues
    • 1.1.2 Performance Issues
  • 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.2.1 First Email Notification
    • 2.2.2 What does the Health Check Report Contain?
    • 2.2.3 Subsequent Email Notifications
  • 2.3 Configuring Oracle ORAchk and Oracle EXAchk
    • 2.3.1 Deciding Which User Should Run Oracle ORAchk or Oracle EXAchk
    • 2.3.2 Handling of Root Passwords
    • 2.3.3 Configuring Email Notification System
  • 2.4 Using Oracle ORAchk and Oracle EXAchk to Manually Generate Health Check Reports
    • 2.4.1 Running Health Checks On-Demand
    • 2.4.2 Running Health Checks in Silent Mode
    • 2.4.3 Running On-Demand With or Without the Daemon
    • 2.4.4 Generating a Diff Report
    • 2.4.5 Sending Results by Email
  • 2.5 Managing the Oracle ORAchk and Oracle EXAchk Daemons
    • 2.5.1 Starting and Stopping the Daemon
    • 2.5.2 Configuring the Daemon for Automatic Restart
    • 2.5.3 Setting and Getting Options for the Daemon
      • 2.5.3.1 AUTORUN_SCHEDULE
      • 2.5.3.2 AUTORUN_FLAGS
      • 2.5.3.3 NOTIFICATION_EMAIL
      • 2.5.3.4 collection_retention
      • 2.5.3.5 PASSWORD_CHECK_INTERVAL
      • 2.5.3.6 AUTORUN_INTERVAL
      • 2.5.3.7 Setting Multiple Option Profiles for the Daemon
      • 2.5.3.8 Getting Existing Options for the Daemon
    • 2.5.4 Querying the Status and Next Planned Daemon Run
  • 2.6 Tracking Support Incidents
  • 2.7 Tracking File Attribute Changes and Comparing Snapshots
    • 2.7.1 Using the File Attribute Check With the Daemon
    • 2.7.2 Taking File Attribute Snapshots
    • 2.7.3 Including Directories to Check
    • 2.7.4 Excluding Directories from Checks
    • 2.7.5 Rechecking Changes
    • 2.7.6 Designating a Snapshot As a Baseline
    • 2.7.7 Restricting System Checks
    • 2.7.8 Removing 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.8.1 Creating Incident 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.10.1 Integrating Health Check Results with Oracle Enterprise Manager
    • 2.10.2 Integrating Health Check Results with Third-Party Tool
    • 2.10.3 Integrating Health Check Results with Custom Application
  • 2.11 Troubleshooting Oracle ORAchk and Oracle EXAchk
    • 2.11.1 How to Troubleshoot Oracle ORAchk and Oracle EXAchk Issues
    • 2.11.2 How to Capture Debug Output
    • 2.11.3 Remote Login Problems
    • 2.11.4 Permission Problems
    • 2.11.5 Slow Performance, Skipped Checks and Timeouts
• 3 Collecting Operating System Resources Metrics
  • 3.1 Understanding Cluster Health Monitor Services
  • 3.2 Collecting Cluster Health Monitor Data
  • 3.3 Using Cluster Health Monitor from Enterprise Manager Cloud Control
• 4 Collecting Diagnostic Data and Triaging, Diagnosing, and Resolving Issues
  • 4.1 Understanding Oracle Trace File Analyzer
    • 4.1.1 Oracle Trace File Analyzer Architecture
    • 4.1.2 Oracle Trace File Analyzer Automated Diagnostic Collections
    • 4.1.3 Oracle Trace File Analyzer Collector On-Demand Diagnostic Collections
      • 4.1.3.1 Types of On-Demand Collections
  • 4.2 Getting Started with Oracle Trace File Analyzer
    • 4.2.1 Supported Platforms and Product Versions
    • 4.2.2 Oracle Grid Infrastructure Trace File Analyzer Installation
    • 4.2.3 Oracle Database Trace File Analyzer Installation
    • 4.2.4 Securing Access to Oracle Trace File Analyzer
    • 4.2.5 Masking Sensitive Data
    • 4.2.6 Configuring Email Notification Details
  • 4.3 Automatically Collecting Diagnostic Data Using the Oracle Trace File Analyzer Collector
    • 4.3.1 Managing the Oracle Trace File Analyzer Daemon
    • 4.3.2 Viewing the Status and Configuration of Oracle Trace File Analyzer
    • 4.3.3 Configuring the Host
    • 4.3.4 Configuring the Ports
    • 4.3.5 Configuring SSL and SSL Certificates
      • 4.3.5.1 Configuring SSL/TLS Protocols
      • 4.3.5.2 Configuring Self-Signed Certificates
      • 4.3.5.3 Configuring CA-Signed Certificates
    • 4.3.6 Managing Collections
      • 4.3.6.1 Including Directories
      • 4.3.6.2 Managing the Size of Collections
    • 4.3.7 Managing the Repository
      • 4.3.7.1 Purging the Repository Automatically
      • 4.3.7.2 Purging the Repository Manually
  • 4.4 Analyzing the Problems Identified
  • 4.5 Manually Collecting Diagnostic Data
    • 4.5.1 Running On-Demand Default Collections
      • 4.5.1.1 Adjusting the Time Period for a Collection
    • 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.7.1 Managing Automatic Diagnostic Repository Log and Trace Files
    • 4.7.2 Managing Disk Usage Snapshots
    • 4.7.3 Purging Oracle Trace File Analyzer Logs Automatically
  • 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
  • 6.1 Overview of Memory Guard
  • 6.2 Memory Guard Architecture
  • 6.3 Enabling Memory Guard in Oracle Real Application Clusters (Oracle RAC) Environment
  • 6.4 Use of Memory Guard in Oracle Real Application Clusters (Oracle RAC) Deployment
• 7 Resolving Database and Database Instance Hangs
  • 7.1 Hang Manager Architecture
  • 7.2 Optional Configuration for Hang Manager
  • 7.3 Hang Manager Diagnostics and Logging
• 8 Monitoring System Metrics for Cluster Nodes
  • 8.1 Monitoring Oracle Clusterware with Oracle Enterprise Manager
  • 8.2 Monitoring Oracle Clusterware with Cluster Health Monitor
  • 8.3 Using the Cluster Resource Activity Log to Monitor Cluster Resource Failures
• 9 Monitoring and Managing Database Workload Performance
  • 9.1 What Does Oracle Database Quality of Service (QoS) Management Manage?
  • 9.2 How Does Oracle Database Quality of Service (QoS) Management Work?
  • 9.3 Overview of Metrics
  • 9.4 Benefits of Using Oracle Database Quality of Service (QoS) Management
• A Oracle ORAchk and Oracle EXAchk Command-Line Options
  • A.1 Running Generic Oracle ORAchk and Oracle EXAchk Commands
  • A.2 Controlling the Scope of Checks
  • A.3 Managing the Report Output
  • A.4 Uploading Results to Database
  • A.5 Configuring the Daemon Mode
  • A.6 Controlling the Behavior of the Daemon
  • A.7 Tracking File Attribute Changes
• B OCLUMON Command Reference
  • B.1 oclumon debug
  • B.2 oclumon dumpnodeview
  • B.3 oclumon manage
  • B.4 oclumon version
• C Diagnostics Collection Script
• D Managing the Cluster Resource Activity Log
  • D.1 crsctl query calog
  • D.2 crsctl get calog maxsize
  • D.3 crsctl get calog retentiontime
  • D.4 crsctl set calog maxsize
  • D.5 crsctl set calog retentiontime
• 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.1.1 tfactl diagnosetfa
    • F.1.2 tfactl host
    • F.1.3 tfactl set
    • F.1.4 tfactl access
  • F.2 Running Summary and Analysis Commands
    • F.2.1 tfactl summary
    • F.2.2 tfactl changes
    • F.2.3 tfactl events
    • F.2.4 tfactl analyze
    • F.2.5 tfactl run
    • F.2.6 tfactl toolstatus
  • 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