Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Conventions
• Third-Party License Information

Changes in this Release for Oracle ORAchk and EXAchk User’s Guide 18.2.0

• Only the Most Critical Checks Shown by Default
• REST Interface
• Remote Node Connection without Passwordless SSH
• Python 3 Compatibility
• Support for Oracle Autonomous Database
• New Oracle Stack Health Checks
• Command-Line Options to Generate Password Protected Collection zip Files

1 Oracle ORAchk and Oracle EXAchk Common Features and Tasks

• 1.1 Quick Start Guide
  • 1.1.1 Overview of Oracle ORAchk and Oracle EXAchk
  • 1.1.2 Installing Oracle ORAchk and Oracle EXAchk
  • 1.1.3 Common Oracle ORAchk and Oracle EXAchk Prerequisites
    • 1.1.3.1 SSH Connectivity and Access
      • 1.1.3.1.1 Storage Servers that are Configured to Deny SSH Access
    • 1.1.3.2 Handling of root Passwords
    • 1.1.3.3 Restricted Access to Oracle ORAchk and Oracle EXAchk Output Files
    • 1.1.3.4 Deciding Which User Should Run Oracle ORAchk or Oracle EXAchk
    • 1.1.3.5 Data Entry Terminal Considerations
    • 1.1.3.6 Specific Prerequisites for Running Oracle ORAchk and Oracle EXAchk
  • 1.1.4 Configuring the Daemon Mode
  • 1.1.5 Email Notification and Health Check Report Overview
    • 1.1.5.1 First Email Notification
    • 1.1.5.2 What does the Health Check Report Contain?
    • 1.1.5.3 Subsequent Email Notifications
    • 1.1.5.4 Diff Report
  • 1.1.6 Recommended On-Demand Usage
  • 1.1.7 Updating to the Latest Version of Oracle ORAchk and Oracle EXAchk
    • 1.1.7.1 Updating Oracle ORAchk and Oracle EXAchk in an Environment with an Internet Connection
    • 1.1.7.2 Updating Oracle ORAchk and Oracle EXAchk in an Environment without an Internet Connection
  • 1.1.8 Using Oracle ORAchk or Oracle EXAchk over REST
  • 1.1.9 Configuring Oracle REST Data Services (ORDS)
• 1.2 Using Oracle ORAchk and Oracle EXAchk to Automatically Check for Risks and System Health
  • 1.2.1 Setting and Getting Options for the Daemon
    • 1.2.1.1 AUTORUN_SCHEDULE
    • 1.2.1.2 AUTORUN_FLAGS
    • 1.2.1.3 NOTIFICATION_EMAIL
    • 1.2.1.4 collection_retention
    • 1.2.1.5 PASSWORD_CHECK_INTERVAL
    • 1.2.1.6 Setting Multiple Option Profiles for the Daemon
    • 1.2.1.7 Getting the Existing Options for the Daemon
  • 1.2.2 Starting and Stopping the Daemon
  • 1.2.3 Querying the Status and Next Planned Daemon Run
  • 1.2.4 Configuring the Daemon for Automatic Restart
• 1.3 Running Health Checks On-Demand
  • 1.3.1 Running On-Demand With or Without the Daemon
  • 1.3.2 Sending Results by Email
• 1.4 Running Health Checks in Silent Mode
  • 1.4.1 Including Health Checks that Require root Access
  • 1.4.2 Excluding Health Checks that Require root Access
• 1.5 Understanding and Managing Reports and Output
  • 1.5.1 Temporary Files and Directories
  • 1.5.2 Output Files and Directories
  • 1.5.3 HTML Report Output
    • 1.5.3.1 System Health Score and Summary
    • 1.5.3.2 HTML Report Table of Contents and Features
    • 1.5.3.3 HTML Report Findings
    • 1.5.3.4 Maximum Availability Architecture (MAA) Scorecard
    • 1.5.3.5 Findings Needing Further Review
    • 1.5.3.6 Platinum Certification
    • 1.5.3.7 Viewing Clusterwide Linux Operating System Health Check (VMPScan)
    • 1.5.3.8 "Systemwide Automatic Service Request (ASR) healthcheck" Section
    • 1.5.3.9 File Attribute Changes
    • 1.5.3.10 Skipped Checks
    • 1.5.3.11 Component Elapsed Times
    • 1.5.3.12 Top 10 Time Consuming Checks
    • 1.5.3.13 How to Find a Check ID
    • 1.5.3.14 How to Remove Checks from an Existing HTML Report
  • 1.5.4 Tagging Reports
  • 1.5.5 Tracking File Attribute Changes
  • 1.5.6 Comparing Two Reports
  • 1.5.7 Merging Reports
  • 1.5.8 Output File Maintenance
  • 1.5.9 Consuming Multiple Results in Other Tools
• 1.6 Health Check Catalog
• 1.7 Running Subsets of Checks
  • 1.7.1 Upgrade Readiness Mode (Oracle Clusterware and Oracle Database Upgrade Checks)
    • 1.7.1.1 Oracle Clusterware and Oracle Database Pre-Upgrade Checks
    • 1.7.1.2 Oracle Clusterware and Oracle Database Post-Upgrade Checks
  • 1.7.2 Running Checks on Subsets of the Oracle Stack
    • 1.7.2.1 Running Database Checks
    • 1.7.2.2 Running Cell Checks
    • 1.7.2.3 Running Switch Checks
    • 1.7.2.4 Running Checks on Other Elements of the Oracle Stack
    • 1.7.2.5 Oracle ORAchk Support for Oracle Grid Infrastructure with no Oracle Database
  • 1.7.3 Using Profiles with Oracle ORAchk and Oracle EXAchk
  • 1.7.4 Excluding Individual Checks
  • 1.7.5 Running Individual Checks
  • 1.7.6 Finding Which Checks Require Privileged Users
  • 1.7.7 Option to Run Only the Failed Checks
• 1.8 Oracle ORAchk and Oracle EXAchk Command-Line Options
  • 1.8.1 Running Generic Oracle ORAchk and Oracle EXAchk Commands
  • 1.8.2 Controlling the Scope of Checks
  • 1.8.3 Managing the Report Output
  • 1.8.4 Uploading Results to Database
  • 1.8.5 Controlling the Behavior of the Daemon
  • 1.8.6 Tracking File Attribute Differences
  • 1.8.7 Running Oracle Health Check Collections Manager Commands
  • 1.8.8 Command-Line Options to Generate Password Protected Collection zip Files
• 1.9 Oracle Health Check Collections Manager for Oracle Application Express 5.0
  • 1.9.1 Scope and Supported Platforms
  • 1.9.2 Prerequisites
  • 1.9.3 Installation
    • 1.9.3.1 Configuring Oracle Application Express and Creating a Workspace
      • 1.9.3.1.1 Log in to the Workspace
      • 1.9.3.1.2 Application Express User Accounts
    • 1.9.3.2 Install Oracle Health Check Collections Manager Application
    • 1.9.3.3 Log in to Oracle Health Check Collections Manager Application
  • 1.9.4 Upgrading Oracle Health Check Collections Manager Application
  • 1.9.5 Getting Started
    • 1.9.5.1 Incident Ticket System Lookup Lists and Seed Data
    • 1.9.5.2 Access Control System
    • 1.9.5.3 Oracle Health Check Collections Manager Application Administration
    • 1.9.5.4 Selectively Capturing Users During Login
    • 1.9.5.5 Configuring Email Notification System
    • 1.9.5.6 Bulk Mapping Systems to Business Units
    • 1.9.5.7 Purging Old Collections
  • 1.9.6 Oracle Health Check Collections Manager Application Features
    • 1.9.6.1 Global Select Lists
    • 1.9.6.2 Home Tab
    • 1.9.6.3 Collections Tab
    • 1.9.6.4 Collections > Browse Sub Tab
    • 1.9.6.5 Collections > Compare Sub Tab
    • 1.9.6.6 Report View Tab
    • 1.9.6.7 Upload Collections Sub Tab
    • 1.9.6.8 Tracking Support Incidents
      • 1.9.6.8.1 Incidents Tab
    • 1.9.6.9 Authoring User-Defined Checks
  • 1.9.7 Uploading Collections Automatically
  • 1.9.8 Viewing and Reattempting Failed Uploads
  • 1.9.9 Oracle Health Check Collections Manager Application Uninstallation
    • 1.9.9.1 Deleting Oracle Health Check Collections Manager Application
    • 1.9.9.2 Deleting Workspace Admin
  • 1.9.10 Troubleshooting Oracle Health Check Collections Manager
• 1.10 Oracle Health Check Collections Manager for Oracle Application Express 4.2
  • 1.10.1 Installation
    • 1.10.1.1 Configuring Oracle Application Express and Creating a Workspace
      • 1.10.1.1.1 Log in to the Workspace
      • 1.10.1.1.2 Application Express User Accounts
    • 1.10.1.2 Install Oracle Health Check Collections Manager Application
    • 1.10.1.3 Log in to Oracle Health Check Collections Manager Application
  • 1.10.2 Upgrading Oracle Health Check Collections Manager Application
  • 1.10.3 Getting Started
    • 1.10.3.1 Incident Ticket System Lookup Lists and Seed Data
    • 1.10.3.2 Access Control System
    • 1.10.3.3 Oracle Health Check Collections Manager Application Administration
    • 1.10.3.4 Selectively Capturing Users During Login
    • 1.10.3.5 Configuring Email Notification System
    • 1.10.3.6 Bulk Mapping Systems to Business Units
    • 1.10.3.7 Adjusting or Disabling Old Collections Purging
  • 1.10.4 Oracle Health Check Collections Manager Application Features
    • 1.10.4.1 Global Select Lists
    • 1.10.4.2 Home Tab
    • 1.10.4.3 Collections Tab
    • 1.10.4.4 Browse Tab
    • 1.10.4.5 Compare Tab
    • 1.10.4.6 Report View Tab
    • 1.10.4.7 Upload Collections Tab
    • 1.10.4.8 Tracking Support Incidents
      • 1.10.4.8.1 Creating or Editing Incidents Tickets
    • 1.10.4.9 Authoring User-Defined Checks
  • 1.10.5 Uploading Collections Automatically
  • 1.10.6 Viewing and Reattempting Failed Uploads
  • 1.10.7 Oracle Health Check Collections Manager Application Uninstallation
    • 1.10.7.1 Deleting Oracle Health Check Collections Manager Application
    • 1.10.7.2 Deleting Workspace Admin
  • 1.10.8 Troubleshooting Oracle Health Check Collections Manager
• 1.11 Integrating Health Check Results with Other Tools
  • 1.11.1 Integrating Health Check Results with Oracle Enterprise Manager
  • 1.11.2 Integrating Health Check Results with Third-Party Tool
  • 1.11.3 Integrating Health Check Results with Custom Application
    • 1.11.3.1 Viewing and Reattempting Failed Uploads
• 1.12 Troubleshooting Oracle ORAchk and Oracle EXAchk
  • 1.12.1 How to Troubleshoot Oracle ORAchk and Oracle EXAchk Issues
  • 1.12.2 How to Capture Debug Output
  • 1.12.3 Error Messages or Unexpected Output
    • 1.12.3.1 Data Entry Terminal Considerations
    • 1.12.3.2 Tool Runs without Producing Files
    • 1.12.3.3 Messages similar to “line ****: **** Killed $perl_cmd 2>> $ERRFIL?”
    • 1.12.3.4 Messages similar to “RC-001- Unable to read driver files”
    • 1.12.3.5 Messages similar to “There are prompts in user profile on [hostname] which will cause issues in [tool] successful execution”
    • 1.12.3.6 Problems Related to Remote Login
    • 1.12.3.7 Other Error Messages in orachk_error.log or exachk_error.log
  • 1.12.4 Operating System Is Not Discovered Correctly
  • 1.12.5 Oracle Clusterware or Oracle Database is not Detected or Connected Issues
    • 1.12.5.1 Oracle Clusterware Software is Installed, but Cannot be Found
    • 1.12.5.2 Oracle Database Software Is Installed, but Cannot Be Found
    • 1.12.5.3 Oracle Database Software Is Installed, but Version cannot Be Found
    • 1.12.5.4 Oracle ASM Software is Installed, but Cannot be Found
    • 1.12.5.5 Oracle Database Discovery Issues on Oracle Real Application Clusters (Oracle RAC) Systems
    • 1.12.5.6 Oracle Database Login Problems
  • 1.12.6 Remote Connections
    • 1.12.6.1 Remote Login Problems
  • 1.12.7 Permission Problems
  • 1.12.8 Slow Performance, Skipped Checks, and Timeouts
• 1.13 Uninstalling Oracle ORAchk and Oracle EXAchk

2 Oracle ORAchk Specific Features and Tasks

• 2.1 Oracle ORAchk Scope and Supported Environments
  • 2.1.1 Oracle ORAchk Scope of Oracle Stack Supported
  • 2.1.2 Oracle ORAchk Supported Platforms
  • 2.1.3 Oracle ORAchk Supported Database Releases
• 2.2 Automatic Start from Install
• 2.3 Using Oracle ORAchk to Confirm System Readiness for Implementing Application Continuity
  • 2.3.1 Overview of Application Continuity
  • 2.3.2 Checks for Application Continuity
• 2.4 Oracle ORAchk for Oracle Identity and Access Management Health Check Tool
  • 2.4.1 Supported Operating Systems and Oracle Database Releases
  • 2.4.2 Supported Components and Topologies
  • 2.4.3 Introduction to Oracle ORAchk for Oracle Identity and Access Management Health Checks
    • 2.4.3.1 Features of Oracle ORAchk for Oracle Identity and Access Management Health Check Tool
    • 2.4.3.2 Auto-discovery of Oracle Identity and Access Management Environment
  • 2.4.4 Running Oracle ORAchk for Oracle Identity and Access Management Heath Checks
    • 2.4.4.1 Downloading Oracle ORAchk for Oracle Identity and Access Management
    • 2.4.4.2 Prerequisites for Installing Oracle ORAchk for Oracle Identity and Access Management
    • 2.4.4.3 Inputs Required by Discovery Tool (First Time Only)
    • 2.4.4.4 Oracle ORAchk for Oracle Identity and Access Management Health Checks
• 2.5 Running Oracle ZFS Storage Appliance Health Checks
• 2.6 Oracle ORAchk Specific Command-Line Options
  • 2.6.1 Running Auto Start
  • 2.6.2 Application Continuity Command-Line Options
  • 2.6.3 Oracle ORAchk for Oracle Identity and Access Management Command-Line Options
  • 2.6.4 ZFS Storage Appliance Options
• 2.7 Troubleshooting Oracle ORAchk Specific Problems
  • 2.7.1 Troubleshooting Oracle ORAchk for Oracle Identity and Access Management Health Checks

3 Oracle EXAchk Specific Features and Tasks

• 3.1 Scope and Supported Platforms for Running Oracle EXAchk on Oracle Engineered Systems
• 3.2 Oracle Exadata and Zero Data Loss Recovery Appliance
  • 3.2.1 Prerequisites for Running Oracle EXAchk on Oracle Exadata and Zero Data Loss Recovery Appliance
    • 3.2.1.1 InfiniBand Switches
  • 3.2.2 Installation Requirements for Running Oracle EXAchk on Oracle Exadata and Zero Data Loss Recovery Appliance
    • 3.2.2.1 Shared Remote Versus Local Installation
    • 3.2.2.2 Recommended User and Local Installation Directory
    • 3.2.2.3 Recommended Oracle EXAchk Run Location
  • 3.2.3 Oracle EXAchk on Oracle Exadata and Zero Data Loss Recovery Appliance Usage
    • 3.2.3.1 Database Default Access on the Client Interface
    • 3.2.3.2 Virtualization Considerations
    • 3.2.3.3 Running Serial Data Collection
    • 3.2.3.4 Multiple Asymmetric Database Home Examples
    • 3.2.3.5 Using the root User ID in Asymmetric and Role Separated Environments
    • 3.2.3.6 Environment Variables for Specifying a Different User Than root
    • 3.2.3.7 Oracle EXAchk InfiniBand Switch Processing
  • 3.2.4 Troubleshooting Oracle EXAchk on Oracle Exadata and Zero Data Loss Recovery Appliance
• 3.3 Oracle Exalogic
  • 3.3.1 Scope and Supported Platforms for Running Oracle EXAchk on Oracle Exalogic
  • 3.3.2 Prerequisites for Running Oracle EXAchk on Oracle Exalogic
    • 3.3.2.1 Enable NFS on the /export/common/general Share
    • 3.3.2.2 Mount the /export/common/general Share
  • 3.3.3 Prerequisite for Viewing Oracle EXAchk HTML Report
  • 3.3.4 Installing and Upgrading Oracle EXAchk on Oracle Exalogic
    • 3.3.4.1 Installing Oracle EXAchk on a Physical Oracle Exalogic Machine
    • 3.3.4.2 Installing Oracle EXAchk on a Virtual Oracle Exalogic Machine
    • 3.3.4.3 Upgrading Oracle EXAchk on Oracle Exalogic
  • 3.3.5 Oracle EXAchk on Oracle Exalogic Usage
    • 3.3.5.1 Performing Health Checks for Oracle Exalogic Infrastructure
      • 3.3.5.1.1 Prerequisites for Running Health Checks on Oracle Exalogic Infrastructure
      • 3.3.5.1.2 Running Oracle EXAchk for Physical Racks
      • 3.3.5.1.3 Running Oracle EXAchk for Virtual Racks
      • 3.3.5.1.4 Running Oracle EXAchk for Hybrid Racks
    • 3.3.5.2 Performing Health Checks for Guest vServers
      • 3.3.5.2.1 Prerequisites for Running Health Checks on Guest vServers
      • 3.3.5.2.2 Installing IaaS CLI and API
      • 3.3.5.2.3 Additional Prerequisites for STIG-hardened vServers
      • 3.3.5.2.4 Running Oracle EXAchk for vServers That are Not STIG-hardened
      • 3.3.5.2.5 Running Oracle EXAchk for STIG-hardened vServers
    • 3.3.5.3 About the Oracle EXAchk Health Check Process
    • 3.3.5.4 Running Oracle EXAchk in Silent Mode
    • 3.3.5.5 Overriding Discovered Component Addresses
    • 3.3.5.6 Setting Environment Variables for Local Issues
    • 3.3.5.7 External ZFS Storage Appliance
  • 3.3.6 Oracle EXAchk on Oracle Exalogic Output
  • 3.3.7 Oracle EXAchk on Oracle Exalogic Command-Line Options
    • 3.3.7.1 Verifying and Enabling Passwordless SSH to the Oracle VM Manager CLI
  • 3.3.8 Troubleshooting Oracle EXAchk on Oracle Exalogic
• 3.4 Oracle SuperCluster
  • 3.4.1 Scope and Supported Platforms for Running Oracle EXAchk on Oracle SuperCluster
  • 3.4.2 Installing and Deploying Oracle EXAchk on Oracle SuperCluster
    • 3.4.2.1 Deploying Oracle EXAchk on Oracle SuperCluster
  • 3.4.3 Oracle EXAchk on Oracle SuperCluster Usage
    • 3.4.3.1 Merging Collections
    • 3.4.3.2 Automated Daemon Mode Operation
  • 3.4.4 Troubleshooting Oracle EXAchk on SuperCluster
• 3.5 Oracle Exalytics
  • 3.5.1 Scope and Supported Platforms for Running Oracle EXAchk on Oracle Exalytics
  • 3.5.2 Prerequisites for Running Oracle EXAchk on Oracle Exalytics
  • 3.5.3 Installing Oracle EXAchk on Oracle Exalytics
  • 3.5.4 Oracle EXAchk on Oracle Exalytics Usage
  • 3.5.5 Oracle EXAchk on Oracle Exalytics Output
  • 3.5.6 Running Subsets of Checks
  • 3.5.7 Troubleshooting Oracle EXAchk on Oracle Exalytics
    • 3.5.7.1 Runtime Command Timeouts
    • 3.5.7.2 Error Messages in exachk_error.log
• 3.6 Oracle Big Data Appliance
  • 3.6.1 Scope and Supported Platforms for Running Oracle EXAchk on Oracle Big Data Appliance
  • 3.6.2 Installing Oracle EXAchk on the Oracle Big Data Appliance
  • 3.6.3 Oracle EXAchk on Oracle Big Data Usage
  • 3.6.4 Oracle EXAchk on Oracle Big Data Output
  • 3.6.5 Troubleshooting Oracle EXAchk on Oracle BigData Appliance
    • 3.6.5.1 Timeouts Checking Switches

Index