Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Conventions

What's New in 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 Login
  • Configure Details for Upload of Collection Results
  • Viewing and Reattempting Failed Uploads
  • Purging Old Collections
• Track Changes to the Attributes of Important Files
• Quickly Find Health Checks that Require Privileged Users to Run
• Broader Stack Support
• Easier to Run Oracle EXAchk on Oracle Exadata Storage Servers
• New Health Checks

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 Prerequisites
    • 1.1.2.1 Bash Requirements
    • 1.1.2.2 SSH Connectivity and Access
    • 1.1.2.3 Handling of root Passwords
    • 1.1.2.4 Deciding Which User Should Run Oracle ORAchk or Oracle EXAchk
    • 1.1.2.5 Prerequisites for Running Oracle ORAchk and Oracle EXAchk
    • 1.1.2.6 Data Entry Terminal Considerations
  • 1.1.3 Installing Oracle ORAchk and Oracle EXAchk
  • 1.1.4 Configuring the Daemon Mode
  • 1.1.5 Email Notification and Report Overview
    • 1.1.5.1 First Email Notification
    • 1.1.5.2 Health Check Report
    • 1.1.5.3 Subsequent Email Notification
    • 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.2 Automating Daemon Mode Operations
  • 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 AUTORUN_INTERVAL
    • 1.2.1.7 Setting Multiple Option Profiles for the Daemon
    • 1.2.1.8 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 Auto 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 ORAchk and EXAchk 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 (Clusterware and Database Upgrade Checks)
    • 1.7.1.1 Clusterware and Database Pre-Upgrade Checks
    • 1.7.1.2 Clusterware and 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.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.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.9 Managing Oracle Health Check Collections Manager
  • 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 Browse Tab
    • 1.9.6.5 Compare Tab
    • 1.9.6.6 Report View Tab
    • 1.9.6.7 Upload Collections Tab
    • 1.9.6.8 Uploading Collections Automatically
    • 1.9.6.9 Viewing and Reattempting Failed Uploads
    • 1.9.6.10 Tracking Support Incidents
      • 1.9.6.10.1 Incidents Tab
    • 1.9.6.11 Authoring User-Defined Checks
  • 1.9.7 Oracle Health Check Collections Manager Application Uninstallation
    • 1.9.7.1 Deleting Oracle Health Check Collections Manager Application
    • 1.9.7.2 Deleting Workspace Admin
  • 1.9.8 Troubleshooting Oracle Health Check Collections Manager
• 1.10 Integrating Health Check Results with Other Tools
  • 1.10.1 Integrating Health Check Results with Enterprise Manager
  • 1.10.2 Integrating Health Check Results with Third-Party Tool
  • 1.10.3 Integrating Health Check Results with Custom Application
    • 1.10.3.1 Viewing and Reattempting Failed Uploads
• 1.11 Troubleshooting Oracle ORAchk and Oracle EXAchk
  • 1.11.1 How to Troubleshoot Oracle ORAchk and Oracle EXAchk Issues
  • 1.11.2 How to Capture Debug Output
  • 1.11.3 Error Messages or Unexpected Output
    • 1.11.3.1 Data Entry Terminal Considerations
    • 1.11.3.2 Tool Runs without Producing Files
    • 1.11.3.3 Messages similar to “line ****: **** Killed $perl_cmd 2>> $ERRFIL?”
    • 1.11.3.4 Messages similar to “RC-001- Unable to read driver files”
    • 1.11.3.5 Messages similar to “There are prompts in user profile on [hostname] which will cause issues in [tool] successful execution”
    • 1.11.3.6 Messages similar to “Syntax error near unexpected token $tag”
    • 1.11.3.7 Problems Related to Remote Login
    • 1.11.3.8 Messages similar to “Another instance of orachk/exachk is running”
    • 1.11.3.9 Other Error Messages in orachk_error.log or exachk_error.log
  • 1.11.4 Operating System Is Not Discovered Correctly
  • 1.11.5 Clusterware or Database is not Detected or Connected Issues
    • 1.11.5.1 Clusterware Software is Installed, but Cannot be Found
    • 1.11.5.2 Database Software Is Installed, but Cannot Be Found
    • 1.11.5.3 Database Software Is Installed, but Version cannot Be Found
    • 1.11.5.4 ASM Software is Installed, but Cannot be Found
    • 1.11.5.5 Database Discovery Issues on RAC Systems
    • 1.11.5.6 Database Login Problems
  • 1.11.6 Remote Connections
    • 1.11.6.1 Remote Login Problems
  • 1.11.7 Permission Problems
  • 1.11.8 Slow Performance, Skipped Checks and Timeouts

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.1.4 Cygwin Requirements
    • 2.1.4.1 How to Install Cygwin on Microsoft Windows Hosts
    • 2.1.4.2 Configuring SSH
• 2.2 Using Oracle ORAchk to Confirm System Readiness for Implementing Application Continuity
  • 2.2.1 Overview of Application Continuity
  • 2.2.2 Checks for Application Continuity
• 2.3 Oracle Identity and Access Management Health Checks
  • 2.3.1 Supported Platforms and Databases
  • 2.3.2 Supported Components and Topologies
  • 2.3.3 Introduction to IAM Health Checks
    • 2.3.3.1 Use Cases for IAM Healthcheck Tool
    • 2.3.3.2 Features of IAM Healthcheck Tool
    • 2.3.3.3 Auto-discovery of Oracle IAM Environment
  • 2.3.4 Running IAM Heath Checks
    • 2.3.4.1 Download Oracle ORAchk for IAM
    • 2.3.4.2 Prerequisites for Installing Oracle ORAchk for Oracle Identity and Access Management
    • 2.3.4.3 Inputs Required by Discovery Tool (First Time Only)
    • 2.3.4.4 IAM Health Checks
• 2.4 Oracle ZFS Storage Appliance Health Checks
• 2.5 Oracle ORAchk Specific Command Line Options
  • 2.5.1 Application Continuity Command Line Options
  • 2.5.2 IAM Command Line Options
  • 2.5.3 ZFS Storage Appliance Options
• 2.6 Troubleshooting Oracle ORAchk Specific Problems
  • 2.6.1 Troubleshooting Cygwin
    • 2.6.1.1 SSH Daemon does not Start
    • 2.6.1.2 Other Cygwin Issues
  • 2.6.2 Troubleshooting Oracle Identity and Access Management (IAM) Health Checks

3 Oracle EXAchk Specific Features and Tasks

• 3.1 Oracle Exadata and Zero Data Loss Recovery Appliance
  • 3.1.1 Supported Platforms
  • 3.1.2 Prerequisites for Running Oracle EXAchk on Oracle Exadata
  • 3.1.3 Installation Requirements
  • 3.1.4 Oracle EXAchk on Oracle Exadata and Zero Data Loss Recovery Appliance Usage
    • 3.1.4.1 Database Default Access on the Client Interface
    • 3.1.4.2 Virtualization Considerations
    • 3.1.4.3 Parallel Run
    • 3.1.4.4 Multiple Asymmetric Database Home Examples
    • 3.1.4.5 Using the root User ID in Asymmetric and Role Separated Environments
    • 3.1.4.6 Environment Variables for Specifying a Different User Than root
  • 3.1.5 Oracle EXAchk on Oracle Exadata and Zero Data Loss Recovery Appliance Command Line Options
  • 3.1.6 Troubleshooting Oracle EXAchk on Exadata and Zero Data Loss Recovery Appliance
• 3.2 Oracle Exalogic
  • 3.2.1 Scope and Supported Platforms
  • 3.2.2 Prerequisites for Running Oracle EXAchk on Oracle Exalogic
    • 3.2.2.1 Enable NFS on the /export/common/general Share
    • 3.2.2.2 Mount the /export/common/general Share
  • 3.2.3 Oracle Exalogic Prerequisite for Viewing
  • 3.2.4 Installation and Upgrade
    • 3.2.4.1 Install Oracle EXAchk on a Physical Oracle Exalogic Machine
    • 3.2.4.2 Install Oracle EXAchk on a Virtual Oracle Exalogic Machine
    • 3.2.4.3 Upgrade Oracle EXAchk
  • 3.2.5 Oracle EXAchk on Oracle Exalogic Usage
    • 3.2.5.1 Performing Health Checks for the Exalogic Infrastructure
    • 3.2.5.2 Performing Health Checks for Guest vServers
    • 3.2.5.3 About the Oracle EXAchk Health Check Process
    • 3.2.5.4 Running Oracle EXAchk in Silent Mode
    • 3.2.5.5 Overriding Discovered Component Addresses
    • 3.2.5.6 Setting Environment Variables for Local Issues
    • 3.2.5.7 External ZFS Storage Appliance
  • 3.2.6 Oracle EXAchk on Oracle Exalogic Output
  • 3.2.7 Oracle EXAchk on Oracle Exalogic Command Line Options
    • 3.2.7.1 Verifying and Enabling Passwordless SSH to the Oracle VM Manager CLI
  • 3.2.8 Troubleshooting Oracle EXAchk on Exalogic
• 3.3 Oracle SuperCluster
  • 3.3.1 Scope and Supported Platforms
  • 3.3.2 Installation and Deployment
  • 3.3.3 Oracle EXAchk on Oracle SuperCluster Usage
    • 3.3.3.1 Merging Collections
    • 3.3.3.2 Automated Daemon Mode Operation
  • 3.3.4 Oracle EXAchk on Oracle SuperCluster Command Line Options
  • 3.3.5 Troubleshooting Oracle EXAchk on SuperCluster
• 3.4 Oracle Exalytics
  • 3.4.1 Scope and Supported Platforms
  • 3.4.2 Prerequisites for Running Oracle EXAchk on Oracle Exalytics
  • 3.4.3 Installation
  • 3.4.4 Oracle EXAchk on Oracle Exalytics Usage
  • 3.4.5 Oracle EXAchk on Oracle Exalytics Output
  • 3.4.6 Running Subsets of Checks
  • 3.4.7 Troubleshooting Oracle EXAchk on Exalytics
• 3.5 Oracle Big Data
  • 3.5.1 Scope and Supported Platforms
  • 3.5.2 Installation
  • 3.5.3 Oracle EXAchk on Oracle Big Data Usage
  • 3.5.4 Oracle EXAchk on Oracle Big Data Output
  • 3.5.5 Troubleshooting Oracle EXAchk on Oracle BigData Appliance

Index