1/20

Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Database 2 Day + Real Application Clusters Guide

• Changes in Oracle Database 12c Release 2 (12.2)
  • New Features for Oracle Database 12c Release 2 (12.2)
  • Deprecated Features
  • Desupported Features for Oracle Database 12c Release 2 (12.2)
• Changes in Oracle Database 12c Release 1 (12.1)
  • New Features
  • Desupported Features

1 Introduction to Deploying a Real Application Clusters Environment

• About the 2 Day + Real Application Clusters Guide
  • What This Guide Is Not
  • Related Materials
  • Overview of Oracle RAC Documentation
    • Useful Oracle RAC Guides
    • Other Useful Oracle Documentation
• About Oracle Grid Infrastructure for a Cluster and Oracle RAC
• About Oracle Automatic Storage Management
  • About Using Oracle ASM Disk Groups with Oracle RAC
  • Benefits of Using Oracle ASM
  • About Oracle Flex ASM
  • About Oracle ACFS
  • About Oracle ASM Running in an Oracle RAC Environment
• About Oracle Real Application Clusters
  • About Oracle RAC One Node
  • About Oracle Multitenant with Oracle RAC
  • About Server Pools
  • About Installing Oracle RAC on Different Operating Systems
• Tools for Installing, Configuring, and Managing Oracle RAC

2 Preparing Your Cluster

• Verifying System Requirements
  • Checking Operating System Certifications
  • About Hardware Requirements
  • About Shared Storage
  • About Network Hardware Requirements
  • About IP Address Requirements
  • Verifying Operating System and Software Requirements
    • About Operating System and Software Requirements
    • About Installation Fixup Scripts
    • Checking the Current Operating System Configuration
• Preparing the Server
  • About Operating System Users and Groups
    • Required Operating System Users and Groups
    • Separate Operating System Users and Groups for Oracle Software Installations on UNIX and Linux Systems
    • Separate Operating System Users and Groups for Oracle Software Installations on Windows Systems
    • Optional Operating System Users and Groups
  • Configuring Operating System Users and Groups on Linux Systems
  • Configuring Secure Shell on Linux Systems
  • About Configuring the Software Owner's Shell Environment on Linux Systems
• Configuring the Network
  • Verifying the Network Configuration
• Preparing the Operating System and Software
  • About Setting the Time on All Nodes
  • About Configuring Kernel Parameters
  • About Performing Platform-Specific Configuration Tasks
• Configuring Installation Directories and Shared Storage
  • About the Oracle Inventory Directory
  • Locating the Oracle Inventory Directory
  • Creating the Oracle Grid Infrastructure for a Cluster Home Directory
  • Creating the Oracle Base Directory
  • About the Oracle Home Directory
  • Configuring Shared Storage
  • Creating Files on a NAS Device for Use with Oracle Automatic Storage Management
  • About Oracle ASM with Oracle ASM Filter Driver
  • Using Oracle ASMFD to Configure Disks for Oracle ASM

3 Installing Oracle Grid Infrastructure

• Using Rapid Home Provisioning to Install Oracle Grid Infrastructure
• Installing Oracle Grid Infrastructure for a Cluster
  • About Cluster Verification Utility Fixup Scripts on Linux and UNIX
  • Installing Oracle Grid Infrastructure for a New Cluster
  • Completing the Oracle Clusterware Configuration
• About Verifying the Oracle Clusterware Installation
• Confirming Oracle ASM Function for Oracle Clusterware Files

4 Installing the Oracle Database Software and Creating a Database

• Using Rapid Home Provisioning to Install Oracle Database Software
• Using Oracle Enterprise Manager Cloud Control for Provisioning Operations
• Verifying My Oracle Support Credentials
• Configuring the Operating System Environment
• Creating Additional Oracle ASM Disk Groups
• Deciding Between Multitenant Container Databases and Non-CDBs in Oracle RAC
• Using Oracle Universal Installer to Install Oracle RAC Software
• Verifying Your Oracle RAC Database Installation
• Performing Postinstallation Tasks
  • About Downloading and Installing Oracle Database Patches
  • Recompiling All Invalid Objects
  • About Configuring User Accounts
  • Configuring Services on Oracle RAC and Oracle RAC One Node CDBs
  • Downloading and Installing the ORAchk Health Check Tool
• Creating an Oracle RAC Database Using DBCA

5 Converting an Existing Database to Oracle RAC or Oracle RAC One Node

• About Converting an Oracle Database to an Oracle RAC Database
  • About Preparing for Database Conversion
  • Overview of the Database Conversion Process Using Cloud Control
  • Overview of the Database Conversion Process Using rconfig
• Converting a Single Instance Database to Oracle RAC Using DBCA
• Converting an Oracle RAC Database into an Oracle RAC One Node Database
• Converting a Database from Oracle RAC One Node to Oracle RAC

6 Administering Database Instances and Cluster Databases

• About Oracle Real Application Clusters Database Management
• About Oracle RAC Management Using Enterprise Manager
• About Oracle RAC One Node Database Management
  • Online Database Relocation
• About Password Files for an Oracle RAC or Oracle RAC One Node Database
• Starting and Stopping Oracle RAC Databases and Database Instances
• Starting and Stopping PDBs in Oracle RAC
• Managing Oracle Real Application Clusters Initialization Parameters
  • About Configuring Initialization Parameters for an Oracle RAC Database
  • About Modifying the SERVICE_NAMES Parameter for Oracle RAC
  • About the Server Parameter File for Oracle Real Application Clusters
  • Editing Initialization Parameter Settings for an Oracle RAC Database
  • Example: Modifying the OPEN_CURSORS Parameter
• Limiting CPU Usage of Oracle RAC Database Instances
• About Administering Storage in Oracle RAC
  • About Automatic Undo Management in Oracle RAC
  • Oracle Automatic Storage Management in Oracle RAC
    • About Oracle ASM Components in Oracle RAC
    • About Disk Group Configurations for Oracle ASM in Oracle RAC
  • Administering Redo Logs in Oracle RAC
    • About Redo Log Groups and Redo Threads in Oracle RAC Databases
    • About Accessing Redo Log Files for an Oracle RAC Database
    • Using Enterprise Manager to View and Create Online Redo Log Files

7 Administering Oracle Clusterware Components

• About Oracle Clusterware
  • About the Voting Disks
  • About Oracle Cluster Registry
  • About High Availability of Oracle Clusterware Files
• Managing the Oracle Clusterware Stack
  • Starting Oracle Clusterware
  • Stopping Oracle Clusterware
• Administering Voting Disks for Oracle Clusterware
  • Adding and Removing Voting Disks
  • Backing Up and Recovering Voting Disks
    • Backing Up Voting Disks
    • Replacing Voting Disks
    • Restoring Voting Disks
  • Migrating Voting Disks to Oracle ASM Storage
• Backing Up and Recovering the Oracle Cluster Registry
  • Viewing Available OCR Backups
  • Manually Backing Up the OCR
  • Recovering the OCR
    • Checking the Status of the OCR
    • Restoring the OCR from Automatically Generated OCR Backups
• Changing the Oracle Cluster Registry Configuration
  • Adding an OCR Location
  • Migrating the OCR to Oracle ASM Storage
  • Replacing an OCR
  • Removing an OCR
  • Repairing an OCR Configuration on a Local Node
• Troubleshooting the Oracle Cluster Registry
  • About the OCRCHECK Utility
  • Common Oracle Cluster Registry Problems and Solutions

8 Client High Availability with Services, FAN, FCF, and Application Continuity

• About Continuous Service Availability with Database Services
  • About Oracle Database Services
    • About Service Failover in Administrator-Managed Databases
    • About Service Failover in Policy-Managed Databases
    • About Automatic Starting of Services
  • About the Database Resource Manager
  • About Oracle RAC High Availability Framework
  • About Fast Application Notification (FAN)
  • About FAN Callouts
  • About Application Continuity for Masking Outages
    • Preparing to Use Application Continuity
  • About the Load Balancing Advisory
  • About Connection Load Balancing
    • About Client-Side Load Balancing
    • About Server-Side Load Balancing
  • About Run-time Connection Load Balancing
• Creating Services
  • Creating Services Using Enterprise Manager
  • Creating Services Using SRVCTL
• Administering Services
  • About Service Administration Using Enterprise Manager
  • Using the Cluster Managed Database Services Page
  • Verifying Oracle Net Supports Newly Created Services
  • Managing Groups of Services
• Managing Planned Maintenance Without User Interruption
• Configuring Clients for High Availability
  • Configuring Oracle Net Services Parameters For Highly Available Connections
  • Configuring Application Clients for High Availability

9 Administering Backup and Recovery

• Overview of Oracle RAC Database Backup and Recovery
• About the Fast Recovery Area in Oracle RAC
• Archiving the Oracle Real Application Clusters Database Redo Logs
  • About Archived Redo Log Files for an Oracle RAC Database
  • About Parallelism and Backups Across Multiple RMAN Channels
  • Configuring Archiving for Your Oracle RAC Database
• About Preparing for Backup and Recovery Operations
  • About Credentials for Performing Backup and Recovery
  • About Configuring Backup Settings
• Performing Backups of Your Oracle Real Application Clusters Database
  • Backing Up Archived Redo Log Files
• Recovering Your Oracle Real Application Clusters Database
  • About Preparing to Restore and Recover Your Oracle RAC Database
    • About Configuring Access to the Archive Log
    • About Putting the Oracle RAC Database Instances into the Correct State
  • About Restoring Archived Redo Log File Files
  • About Performing Recovery Using Parallelism
  • Recovering the Oracle RAC Database Using Enterprise Manager
  • Recovering the Server Parameter File from an Automatic File Backup
• About Managing Your Database Backup Files
• Displaying Backup Reports for Your Oracle Real Application Clusters Database

10 Monitoring and Troubleshooting Your Cluster

• Autonomous Health Framework
  • Cluster Verification Utility (CVU)
    • Verifying the Existence of Node Applications
    • Verifying the Integrity of Oracle Clusterware Components
    • Verifying the Integrity of the Oracle Cluster Registry
    • Verifying the Integrity of Your Entire Cluster
    • Checking the Settings for the Interconnect
    • Enabling Tracing
  • ORAchk
    • Overview of Oracle ORAchk
    • Running ORAchk
    • ORAchk HTML Report Output
  • Cluster Health Monitor
  • Cluster Health Advisor
  • Trace File Analyzer Collector
    • About the Trace File Analyzer Collector (tafctl)
    • tfactl Command Summary
    • Using tfactl to Collect Diagnostic Logs for a Specific Time Period
  • Hang Manager
  • Managing Memory Pressure for Database Servers
  • Oracle Database Quality of Service Management
• Monitoring Oracle Clusterware Using Enterprise Manager
  • Accessing the Oracle Clusterware Information
  • Viewing the Cluster Topology Page
  • Viewing Cluster Health Monitor Data from Enterprise Manager
• Troubleshooting Configuration Problems in Oracle RAC Environments
  • About the Oracle Clusterware Alert Log
  • About the Oracle Clusterware Component Log Files
  • Using CRSCTL to Diagnose Cluster Issues
    • Checking the Status of the Oracle Clusterware Installation
    • Enabling Debugging of Oracle Clusterware Components
    • Enabling Debugging for an Oracle Clusterware Resource
    • Enabling Oracle Clusterware Daemons
    • Disabling Oracle Clusterware Daemons
  • Viewing Oracle RAC Database Alert Log Messages

11 Adding and Deleting Nodes and Instances

• Preparing the New Node
• Verifying the New Node Meets the Prerequisites for Installation
• Extending the Oracle Grid Infrastructure Home to the New Node
• Extending the Oracle RAC Home Directory
• Adding the New Node to the Cluster using Enterprise Manager
• Creating an Instance on the New Node
  • Adding a New Instance for a Policy-Managed Database
  • Adding a New Instance for an Administrator-Managed Database
• Deleting an Instance From the Cluster Database
  • Deleting an Instance From a Policy-Managed Database
  • Deleting an Instance From an Administrator-Managed Database
• Removing a Node From the Cluster

12 Managing Oracle Software and Applying Patches

• About Patches and Patch Sets
• Alternative Methods of Patching
  • Using Oracle Enterprise Manager Cloud Control for Patching Operations
  • Rapid Home Provisioning, Patching, and Upgrading
• Obtaining the Patch
• Preparing to Use OPatch
  • Checking the ORACLE_HOME Environment Variable
  • Performing a Backup Before Patching Software
  • Staging the Patch on Each Node
  • Updating the PATH Environment Variable
  • Configuring SSH User Equivalency
    • Testing SSH User Equivalency
    • Enabling SSH User Equivalency
• Applying Patches
  • Patching the Grid Home
  • All Node Patching
  • Out-of-Place Rolling Patching for Oracle RAC
  • Minimum Downtime Patching
• Applying Patch Sets
• Troubleshooting Patch Deployment
  • Updating the Node List for OPatch
  • About OPatch Log and Trace Files
  • Resolving the "Not a valid patch area" Error
  • Resolving the "Unable to remove a partially installed interim patch" Error
• Upgrading the Oracle Software

Glossary

Index