Go to main content
1/134
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 12
c
New Features for Oracle Database 12
c
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 Logon
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 Collector 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
Scripting on this page enhances content navigation, but does not change the content in any way.