Table of Contents
- Title and Copyright Information
- Preface
-
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 Autonomous Health Framework Configuration Audit Tools
- 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 Compliance 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 Compliance Check (VMPScan)
- 2.9 Integrating Compliance Check Results with Other Tools
- 2.10 Using Oracle ORAchk to Confirm System Readiness for Implementing Application Continuity
- 2.11 Configuring Oracle REST Data Services (ORDS)
-
2.12
Using Oracle Autonomous Health Framework Compliance Over REST
- 2.12.1 check
- 2.12.2 checktfafaileduploads
- 2.12.3 checktfaupload
- 2.12.4 download
- 2.12.5 getinfo
- 2.12.6 listcollections
- 2.12.7 gettfaupload
- 2.12.8 profile
- 2.12.9 showrepair
- 2.12.10 start_client
- 2.12.11 start_client
- 2.12.12 start_client
- 2.12.13 status
- 2.12.14 unsettfaupload
- 2.12.15 uploadtfafailed
- 2.12.16 version
- 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 Creating, Modifying, and Deleting User-Defined Profiles
- 2.17 Sanitizing Sensitive Information in the Diagnostic Collections
- 2.18 Troubleshooting Compliance Framework (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 Deprecation of Policy-Managed Databases
- 6.3.5 How Server Pools Are Used by Oracle Database QoS Management
- 6.3.6 Overview of Performance Classes
- 6.3.7 Overview of Performance Policies and Performance Objectives
- 6.3.8 How Oracle Database QoS Management Collects and Analyzes Performance Data
- 6.3.9 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 Using Automatic Diagnostic Collections
-
14
Using On-Demand Diagnostic Collections
- 14.1 Collecting Diagnostics and Analyzing Logs On-Demand
- 14.2 Viewing System and Cluster Summary
- 14.3 Investigating Logs for Errors
- 14.4 Analyzing Logs Using the Oracle Database Support Tools
- 14.5 Searching Oracle Trace File Analyzer Metadata
- 14.6 Oracle Trace File Analyzer Service Request Data Collections (SRDCs)
- 14.7 Diagnostic Upload
- 14.8 Changing Oracle Grid Infrastructure Trace Levels
-
14.9
Performing Custom Collections
- 14.9.1 Adjusting the Diagnostic Data Collection Period
- 14.9.2 Collecting for Specific Events
- 14.9.3 Excluding Large Files from Diagnostic Collection
- 14.9.4 Collecting from Specific Nodes
- 14.9.5 Collecting from Specific Components
- 14.9.6 Collecting from Specific Directories
- 14.9.7 Changing the Collection Name
- 14.9.8 Preventing Copying Zip Files and Trimming Files
- 14.9.9 Performing Silent Collection
- 14.9.10 Collecting Core Files
- 14.9.11 Collecting Incident Packaging Service (IPS) Packages
- 15 Using REST Service
-
16
Managing and Configuring Oracle
Trace File Analyzer
- 16.1 Querying Oracle Trace File Analyzer Status and Configuration
- 16.2 Managing the Oracle Trace File Analyzer Daemon
- 16.3 Managing the Repository
- 16.4 Managing Collections
- 16.5 Configuring the Host
- 16.6 Configuring the Ports
- 16.7 Configuring SSL and SSL Certificates
- 16.8 Configuring Email Notification Details
- 16.9 Managing the Index
- 17 Managing Oracle Database and Oracle Grid Infrastructure Logs
-
Appendixes
-
A
Compliance Framework (Oracle ORAchk and Oracle EXAchk) Command-Line Options
- A.1 Compliance Framework (Oracle ORAchk and Oracle EXAchk) Command-Line Options
- A.2 Running Generic Compliance Framework (Oracle ORAchk and Oracle EXAchk) Commands
- A.3 Controlling the Scope of Checks
- A.4 Managing the Report Output
- A.5 Uploading Results to Database
- A.6 Controlling the Behavior of the Daemon
- A.7 Tracking File Attribute Differences
- A.8 Running Oracle Health Check Collections Manager Commands
- A.9 Command-Line Options to Generate Password Protected Collection zip Files
- A.10 Applying Patch Between Releases
- A.11 Caching Discovery Data
- A.12 Configuring REST
- A.13 Running Cluster Verification Utility (CVU) Compliance Checks
- A.14 Running Auto Start
- A.15 Application Continuity Command-Line Options
- A.16 ZFS Storage Appliance 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 Autonomous Health Framework Command-Line and Shell Options
- E.1 Oracle Autonomous Health Framework Installation Command-Line Options
-
E.2
Running Oracle Trace File Analyzer
Administration Commands
- E.2.1 tfactl access
- E.2.2 tfactl availability
- E.2.3 tfactl blackout
- E.2.4 tfactl cell
- E.2.5 tfactl checkupload
- E.2.6 tfactl diagnosetfa
- E.2.7 tfactl disable
- E.2.8 tfactl enable
- E.2.9 tfactl floodcontrol
- E.2.10 tfactl get
- E.2.11 tfactl getresourcelimit
- E.2.12 tfactl getupload
- E.2.13 tfactl host
- E.2.14 tfactl print
- E.2.15 tfactl rest
- E.2.16 tfactl restrictprotocol
- E.2.17 tfactl sendmail
- E.2.18 tfactl set
- E.2.19 tfactl setresourcelimit
- E.2.20 tfactl setupload
- E.2.21 tfactl showrepo
- E.2.22 tfactl start
- E.2.23 tfactl startahf
- E.2.24 tfactl status
- E.2.25 tfactl statusahf
- E.2.26 tfactl stop
- E.2.27 tfactl stopahf
- E.2.28 tfactl syncnodes
- E.2.29 tfactl uninstall
- E.2.30 tfactl upload
- E.2.31 tfactl unsetresourcelimit
- E.2.32 tfactl unsetupload
- E.2.33 tfactl version
- E.3 Running Oracle Trace File Analyzer Summary and Analysis Commands
-
E.4
Running Oracle Trace File Analyzer 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
-
A
Compliance Framework (Oracle ORAchk and Oracle EXAchk) Command-Line Options