Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
Changes in this Release for Autonomous Health Framework Users Guide 18c
-
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 Oracle ORAchk and Oracle EXAchk 12.2.0.1.1
- New Features for Oracle ORAchk and Oracle EXAchk 12.2.0.1.2
-
New Features for Oracle ORAchk and Oracle EXAchk 12.2.0.1.3
- Upgrade to Oracle Database 12.2 with Confidence
- Improve Performance of SQL Queries
- Customize Oracle Health Check Collections Manager Email Notifications and Sample Data Usage
- Prevent Oracle Clusterware Related Outages and Corruptions
- Guard Against Exadata Critical Issue EX35
- Avoid an Oracle SuperCluster Critical Issue and Storage Problems
- New Features for Oracle ORAchk and Oracle EXAchk 12.2.0.1.4
- New Features for Oracle Trace File Analyzer
- New Features for Oracle Cluster Health Advisor
- New Features for Oracle Database Quality of Service (QoS) Management
-
New Features for Oracle ORAchk and Oracle EXAchk 12.1.0.2.7
-
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
- 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
-
Part I Analyzing the Cluster Configuration
-
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
Proactively Detecting and Diagnosing Performance Issues for Oracle RAC
- 3.1 Oracle Cluster Health Advisor Architecture
- 3.2 Monitoring the Oracle Real Application Clusters (Oracle RAC) Environment with Oracle Cluster Health Advisor
- 3.3 Using Cluster Health Advisor for Health Diagnosis
- 3.4 Calibrating an Oracle Cluster Health Advisor Model for a Cluster Deployment
- 3.5 Viewing the Details for an Oracle Cluster Health Advisor Model
- 3.6 Managing the Oracle Cluster Health Advisor Repository
- 3.7 Viewing the Status of Cluster Health Advisor
-
2
Analyzing Risks and Complying with Best Practices
- Part II Automatically Monitoring the Cluster
-
Part III Monitoring and Managing Database Workload Performance
-
6
Introduction to Oracle Database QoS Management
- 6.1 What Is Oracle Database QoS Management?
- 6.2 Benefits of Using Oracle Database QoS Management
-
6.3
Overview of Oracle Database QoS Management
- 6.3.1 How Does Oracle Database QoS Management Work?
- 6.3.2 Overview of Policy Sets
- 6.3.3 Overview of Server Pools
- 6.3.4 How Server Pools Are Used by Oracle Database QoS Management
- 6.3.5 Overview of Performance Classes
- 6.3.6 Overview of Performance Policies and Performance Objectives
- 6.3.7 How Oracle Database QoS Management Collects and Analyzes Performance Data
- 6.3.8 Overview of Recommendations
- 6.4 What Does Oracle Database QoS Management Manage?
- 6.5 Overview of Metrics
-
7
Supported Workloads and Strategies
- 7.1 Supported Configurations for Oracle Database QoS Management
- 7.2 Strategies for Creating Classifiers for Performance Classes
- 7.3 Configuration Strategies for Effective Resource Management
- 7.4 Sample Implementation of Oracle Database QoS Management
- 7.5 Creating Oracle Database QoS Management Performance Policies for the Demo System
- 7.6 Managing Service Levels with Oracle Database QoS Management
-
8
Installing and Enabling Oracle Database QoS Management
-
8.1
Configuring Oracle Database QoS Management to Manage Oracle Database Workloads
- 8.1.1 Installing and Configuring Oracle Grid Infrastructure for a Cluster
- 8.1.2 Creating and Configuring Server Pools
- 8.1.3 Creating and Configuring an Oracle RAC Database
- 8.1.4 Creating Oracle Database QoS Management Administrator Accounts
- 8.1.5 Enabling Oracle Database QoS Management
- 8.1.6 About Multi-CPU Binding on Solaris and Quality of Service Management
-
8.1
Configuring Oracle Database QoS Management to Manage Oracle Database Workloads
-
9
Administering the Oracle Database QoS Management System
- 9.1 Determining If Oracle Database QoS Management is Enabled
- 9.2 Monitoring Performance with Oracle Database QoS Management
-
9.3
Using the Oracle Database QoS Management Dashboard
- 9.3.1 Accessing the Oracle Database QoS Management Dashboard
- 9.3.2 Enabling Oracle Database QoS Management for a Cluster
- 9.3.3 Disabling Oracle Database QoS Management for a Cluster
- 9.3.4 Interpreting the Performance Overview Graphs
- 9.3.5 Viewing Recommendations
- 9.3.6 Viewing Recommendation Details
- 9.3.7 Implementing Recommendations
- 9.4 Administering the Policy Set
- 9.5 Managing Performance Classes
-
9.6
Managing Performance Policies
- 9.6.1 Creating a Performance Policy and Specifying Performance Objectives
- 9.6.2 Editing an Existing Performance Policy
- 9.6.3 Copying a Performance Policy
- 9.6.4 Setting the Current Performance Policy
- 9.6.5 Deleting a Performance Policy
- 9.6.6 Automatically Implementing Recommendations for a Performance Policy
- 9.6.7 Setting Server Pool Directive Overrides
- 9.7 Reviewing Performance Metrics
- 9.8 Creating Administrative Users for Oracle Database QoS Management
- 9.9 Editing the Resource Plan for Oracle Database QoS Management
-
10
Troubleshooting Oracle Database QoS Management
-
10.1
Common Problems
- 10.1.1 Cannot Enable Oracle Database Quality of Service Management
- 10.1.2 Cannot Enable Oracle Database QoS Management for a Database
- 10.1.3 Oracle Database Resource Manager Not Enabled and Resource Plan Errors
- 10.1.4 Do Not Have Access to a Server Pool
- 10.1.5 Server Pool Is Marked As Unmanageable
- 10.1.6 Metrics Are Missing For a Performance Class
- 10.1.7 Oracle Database QoS Management is not Generating Recommendations
- 10.1.8 Recently Added Server was Placed in the Wrong Server Pool
- 10.1.9 RMI Port Conflict Detected
- 10.2 Locating Log or Trace Files
- 10.3 Enabling Tracing
-
10.1
Common Problems
-
6
Introduction to Oracle Database QoS Management
- Part IV Automatic Problem Solving
-
Part V Collecting Diagnostic Data and Triaging, Diagnosing, and Resolving Issues
- 13 Oracle Trace File Analyzer
-
14
Getting Started with Oracle Trace File Analyzer
- 14.1 Supported Environments
- 14.2 Installing Oracle Trace File Analyzer on Linux or UNIX as root User in Daemon Mode
- 14.3 Installing Oracle Trace File Analyzer on Linux or UNIX as Non-root User in Non-Daemon Mode
- 14.4 Installing Oracle Trace File Analyzer on Microsoft Windows
- 14.5 Installing Oracle Trace File Analyzer on Microsoft Windows in Non-Daemon Mode
- 14.6 Oracle Trace File Analyzer Key Directories
- 14.7 Oracle Trace File Analyzer Command Interfaces
- 14.8 Masking Sensitive Data
- 14.9 Securing Access to Oracle Trace File Analyzer
- 14.10 Uninstalling Oracle Trace File Analyzer
- 15 Automatic Diagnostic Collections
-
16
On-demand Analysis and Diagnostic Collection
- 16.1 Collecting Diagnostics and Analyzing Logs On-Demand
- 16.2 Viewing System and Cluster Summary
- 16.3 Investigating Logs for Errors
- 16.4 Analyzing Logs Using the Included Tools
- 16.5 Collecting Diagnostic Data and Using One Command Service Request Data Collections
- 16.6 Uploading Collections to Oracle Support
- 16.7 Changing Oracle Clusterware Trace Levels
- 17 Maintaining Oracle Trace File Analyzer to the Latest Version
-
18
Performing Custom Collections
- 18.1 Adjusting the Diagnostic Data Collection Period
- 18.2 Collecting from Specific Nodes
- 18.3 Collecting from Specific Components
- 18.4 Collecting from Specific Directories
- 18.5 Changing the Collection Name
- 18.6 Preventing Copying Zip Files and Trimming Files
- 18.7 Performing Silent Collection
- 18.8 Preventing Collecting Core Files
- 18.9 Collecting Incident Packaging Service (IPS) Packages
- 19 Managing and Configuring Oracle Trace File Analyzer
- 20 Oracle Trace File Analyzer Service
- 21 Managing Oracle Database and Oracle Grid Infrastructure Diagnostic Data
-
22
Troubleshooting Oracle Trace File Analyzer
- 22.1 Cluster Nodes are Not Showing As One Cluster When Viewed by Running the tfactl status Command
- 22.2 Oracle Trace File Analyzer is Not Starting and the init.tfa script is Missing After Reboot
- 22.3 Error Message Similar to "Can't locate **** in @inc (@inc contains:....)"
- 22.4 Non-Release Update Revisions (RURs) Oracle Trace File Analyzer Patching Fails on Remote Nodes
- 22.5 Non-Root Access is Not Enabled After Installation
- 22.6 TFA_HOME and Repository Locations are Moved After Patching or Upgrade
- 22.7 Oracle Trace File Analyzer Fails with TFA-00103 After Applying the July 2015 Release Update Revision (RUR) or Later
- 22.8 OSWatcher Parameters are Different After a Reboot or Otherwise Unexpectedly Different
- 22.9 Oracle Trace File Analyzer Installation or Oracle Trace File Analyzer Discovery (tfactl rediscover) Fails on Linux 7
- 22.10 OSWatcher Analyzer Fails When OSWatcher is Not Running from the TFA_HOME
- 22.11 Oracle Trace File Analyzer Fails to Start with com.sleepycat.je.EnvironmentLockedException Java Exception
- 22.12 Oracle Trace File Analyzer Startup Fails When Solution-Soft Time Machine Software is Installed, but Not Running on the System
- 22.13 Non-privileged User is Not Able to Run tfactl Commands?
- 22.14 Oracle Trace File Analyzer Daemon is Not Starting or Not Running?
-
Part VI Appendixes
- Oracle ORAchk and Oracle EXAchk Command-Line Options
- OCLUMON Command Reference
- Managing the Cluster Resource Activity Log
- chactl Command Reference
-
Oracle Trace File Analyzer Command-Line and Shell Options
- Running Administration Commands
- Running Summary and Analysis Commands
-
Running Diagnostic Collection Commands
- tfactl diagcollect
- tfactl directory
-
tfactl ips
- tfactl ips ADD
- tfactl ips ADD FILE
- tfactl ips COPY IN FILE
- tfactl ips REMOVE
- tfactl ips REMOVE FILE
- tfactl ips ADD NEW INCIDENTS PACKAGE
- tfactl ips GET REMOTE KEYS FILE
- tfactl ips USE REMOTE KEYS FILE
- tfactl ips CREATE PACKAGE
- tfactl ips FINALIZE PACKAGE
- tfactl ips GENERATE PACKAGE
- tfactl ips DELETE PACKAGE
- tfactl ips GET MANIFEST FROM FILE
- tfactl ips GET METADATA
- tfactl ips PACK
- tfactl ips SET CONFIGURATION
- tfactl ips SHOW CONFIGURATION
- tfactl ips SHOW PACKAGE
- tfactl ips SHOW FILES PACKAGE
- tfactl ips SHOW INCIDENTS PACKAGE
- tfactl ips SHOW PROBLEMS
- tfactl ips UNPACK FILE
- tfactl ips UNPACK PACKAGE
- tfactl collection
- tfactl print
- tfactl purge
- tfactl managelogs
- Glossary
- Index