Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
Changes in this Release for Autonomous Health Framework Users Guide 19c
- New Features for Oracle ORAchk and EXAchk 18.2.0
- New Features for Oracle ORAchk and EXAchk 18.3.0
-
New Features for Oracle ORAchk and EXAchk 18.4.0
- Automatically Run on Oracle Exadata User Domain (DomU)
- Support for Oracle Exadata 19.1.0
- Ensure That You Run Only the Up-To-Date Checks
- Performance Improvement through Caching Discovery Data
- Ability to Patch Between Releases
- Check Specific Timeouts to Reduce Skipped Checks
- New Oracle Stack Health Checks
- New Features for Oracle Trace File Analyzer 18.1.1
- New Features for Oracle Trace File Analyzer 18.2.0
- New Features for Oracle Trace File Analyzer 18.3.0
- New Features for Oracle Trace File Analyzer 18.4.1
-
1
Introduction to Oracle Autonomous Health Framework
- 1.1 Oracle Autonomous Health Framework Problem and Solution Space
-
1.2
Components of 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 Configuring Oracle REST Data Services (ORDS)
-
2.12
Using Oracle ORAchk or Oracle EXAchk over REST
- 2.12.1 Enabling REST
- 2.12.2 start_client
- 2.12.3 start_client
- 2.12.4 profile
- 2.12.5 check
- 2.12.6 status
- 2.12.7 download
- 2.12.8 checktfaupload
- 2.12.9 checktfafaileduploads
- 2.12.10 gettfaupload
- 2.12.11 unsettfaupload
- 2.12.12 uploadtfafailed
- 2.12.13 showrepair
- 2.12.14 getinfo
- 2.12.15 start_client
- 2.12.16 Removing ORDS Setup
- 2.13 Command-Line Options to Generate Password Protected Collection zip Files
- 2.14 Caching Discovery Data
- 2.15 Applying Patch Between Releases
- 2.16 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 Configuring the Databases
- 8.1.2 Installing and Configuring Oracle Grid Infrastructure for a Cluster
- 8.1.3 Creating and Configuring Server Pools
- 8.1.4 Creating and Configuring an Oracle RAC Database
- 8.1.5 Creating Oracle Database QoS Management Administrator Accounts
- 8.1.6 Enabling Oracle Database QoS Management
- 8.1.7 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
Getting Started with Oracle Trace File Analyzer
- 13.1 Oracle Trace File Analyzer
- 13.2 Supported Environments
- 13.3 Installing Oracle Trace File Analyzer on Linux or UNIX as root User in Daemon Mode
- 13.4 Installing Oracle Trace File Analyzer on Linux or UNIX as Non-root User in Non-Daemon Mode
- 13.5 Installing Oracle Trace File Analyzer on Microsoft Windows
- 13.6 Installing Oracle Trace File Analyzer on Microsoft Windows in Non-Daemon Mode
- 13.7 Oracle Trace File Analyzer Key Directories
- 13.8 Oracle Trace File Analyzer Command Interfaces
- 13.9 Masking Sensitive Data
- 13.10 Securing Access to Oracle Trace File Analyzer
- 13.11 Uninstalling Oracle Trace File Analyzer
- 14 Automatic Diagnostic Collections
-
15
On-demand Analysis and Diagnostic Collection
- 15.1 Collecting Diagnostics and Analyzing Logs On-Demand
- 15.2 Viewing System and Cluster Summary
- 15.3 Investigating Logs for Errors
- 15.4 Analyzing Logs Using the Included Tools
- 15.5 Searching Oracle Trace File Analyzer Metadata
- 15.6 Collecting Diagnostic Data and Using One Command Service Request Data Collections
- 15.7 Uploading Collections to Oracle Support
- 15.8 Changing Oracle Grid Infrastructure Trace Levels
- 16 REST Service
- 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
- 19.1 Querying Oracle Trace File Analyzer Status and Configuration
- 19.2 Managing the Oracle Trace File Analyzer Daemon
- 19.3 Managing the Repository
- 19.4 Managing Collections
- 19.5 Configuring the Host
- 19.6 Configuring the Ports
- 19.7 Configuring SSL and SSL Certificates
- 19.8 Configuring Email Notification Details
- 20 Managing Oracle Database and Oracle Grid Infrastructure Diagnostic Data
-
21
Troubleshooting Oracle Trace File Analyzer
- 21.1 Cluster Nodes are Not Showing As One Cluster When Viewed by Running the tfactl status Command
- 21.2 Oracle Trace File Analyzer is Not Starting and the init.tfa script is Missing After Reboot
- 21.3 Error Message Similar to "Can't locate **** in @inc (@inc contains:....)"
- 21.4 Non-Release Update Revisions (RURs) Oracle Trace File Analyzer Patching Fails on Remote Nodes
- 21.5 Non-Root Access is Not Enabled After Installation
- 21.6 TFA_HOME and Repository Locations are Moved After Patching or Upgrade
- 21.7 Oracle Trace File Analyzer Fails with TFA-00103 After Applying the July 2015 Release Update Revision (RUR) or Later
- 21.8 OSWatcher Parameters are Different After a Reboot or Otherwise Unexpectedly Different
- 21.9 Oracle Trace File Analyzer Installation or Oracle Trace File Analyzer Discovery (tfactl rediscover) Fails on Linux 7
- 21.10 OSWatcher Analyzer Fails When OSWatcher is Not Running from the TFA_HOME
- 21.11 Oracle Trace File Analyzer Fails to Start with com.sleepycat.je.EnvironmentLockedException Java Exception
- 21.12 Oracle Trace File Analyzer Startup Fails When Solution-Soft Time Machine Software is Installed, but Not Running on the System
- 21.13 Non-privileged User is Not Able to Run tfactl Commands?
- 21.14 Oracle Trace File Analyzer Daemon is Not Starting or Not Running?
-
13
Getting Started with Oracle Trace File Analyzer
-
Appendixes
- A Oracle ORAchk and Oracle EXAchk Command-Line Options
- B OCLUMON Command Reference
- C Managing the Cluster Resource Activity Log
-
D
chactl Command Reference
- D.1 chactl monitor
- D.2 chactl unmonitor
- D.3 chactl status
- D.4 chactl config
- D.5 chactl calibrate
- D.6 chactl query diagnosis
- D.7 chactl query model
- D.8 chactl query repository
- D.9 chactl query calibration
- D.10 chactl remove model
- D.11 chactl rename model
- D.12 chactl export model
- D.13 chactl import model
- D.14 chactl set maxretention
- D.15 chactl resize repository
-
E
Oracle Trace File Analyzer Installer, Command-Line and Shell Options
- E.1 Installing Oracle Trace File Analyzer
-
E.2
Running Administration Commands
- E.2.1 tfactl access
- E.2.2 tfactl availability
- E.2.3 tfactl diagnosetfa
- E.2.4 tfactl disable
- E.2.5 tfactl enable
- E.2.6 tfactl host
- E.2.7 tfactl print
- E.2.8 tfactl rest
- E.2.9 tfactl restrictprotocol
- E.2.10 tfactl sendmail
- E.2.11 tfactl set
- E.2.12 tfactl setupmos
- E.2.13 tfactl start
- E.2.14 tfactl status
- E.2.15 tfactl stop
- E.2.16 tfactl syncnodes
- E.2.17 tfactl uninstall
- E.2.18 tfactl upload
- E.3 Running Summary and Analysis Commands
-
E.4
Running Diagnostic Collection Commands
- E.4.1 tfactl collection
- E.4.2 tfactl dbglevel
- E.4.3 tfactl diagcollect
- E.4.4 tfactl diagcollect -srdc
- E.4.5 tfactl directory
-
E.4.6
tfactl ips
- E.4.6.1 tfactl ips ADD
- E.4.6.2 tfactl ips ADD FILE
- E.4.6.3 tfactl ips ADD NEW INCIDENTS
- E.4.6.4 tfactl ips CHECK REMOTE KEYS
- E.4.6.5 tfactl ips COPY IN FILE
- E.4.6.6 tfactl ips COPY OUT FILE
- E.4.6.7 tfactl ips CREATE PACKAGE
- E.4.6.8 tfactl ips DELETE PACKAGE
- E.4.6.9 tfactl ips FINALIZE PACKAGE
- E.4.6.10 tfactl ips GENERATE PACKAGE
- E.4.6.11 tfactl ips GET MANIFEST
- E.4.6.12 tfactl ips GET METADATA
- E.4.6.13 tfactl ips GET REMOTE KEYS
- E.4.6.14 tfactl ips PACK
- E.4.6.15 tfactl ips REMOVE
- E.4.6.16 tfactl ips REMOVE FILE
- E.4.6.17 tfactl ips SET CONFIGURATION
- E.4.6.18 tfactl ips SHOW CONFIGURATION
- E.4.6.19 tfactl ips SHOW FILES
- E.4.6.20 tfactl ips SHOW INCIDENTS
- E.4.6.21 tfactl ips SHOW PROBLEMS
- E.4.6.22 tfactl ips SHOW PACKAGE
- E.4.6.23 tfactl ips UNPACK FILE
- E.4.6.24 tfactl ips UNPACK PACKAGE
- E.4.6.25 tfactl ips USE REMOTE KEYS
- E.4.7 tfactl managelogs
- E.4.8 tfactl purge
- Glossary
- Index