Contents

List of Examples

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Intended Audience
• Documentation Accessibility
• Structure
• Related Documents
• Conventions

What's New in Oracle Database 10g Oracle Real Application Clusters Installation and Configuration?

• Oracle Database 10g Release 2 (10.2) New Features for RAC Installation and Configuration

Part I Oracle Clusterware and Oracle Real Application Clusters Installation Planning and Requirements

1 Introduction to Installing and Configuring Oracle Clusterware and Oracle Real Application Clusters

• 1.1 Oracle Clusterware and Oracle Real Application Clusters Documentation Overview
• • 1.1.1 Oracle Real Application Clusters Administration and Deployment Guide
• 1.2 General System Installation Requirements
• • 1.2.1 Overview of Cluster Verification Utility
  • 1.2.2 Overview of Oracle Universal Installer
  • 1.2.3 Overview of Upgrading and Multiple-release Systems
  • 1.2.4 Hardware Requirements for Oracle Clusterware and Oracle Real Application Clusters
  • 1.2.5 Software Requirements for Oracle Clusterware and Oracle Real Application Clusters
• 1.3 Configuration Tasks for Oracle Clusterware and Oracle Real Application Clusters
• 1.4 Pre-Installation, Installation, and Post-Installation Overview
• • 1.4.1 Pre-Installation Overview for Oracle Database 10g Real Application Clusters
  • 1.4.2 Installation Overview for Oracle Database 10g Real Application Clusters
  • 1.4.3 Post-Installation Overview for Oracle Database 10g Real Application Clusters
• 1.5 Oracle Universal Installer and Real Application Clusters
• 1.6 Storage Considerations for Installing Oracle Database 10g Real Application Clusters
• • 1.6.1 Overview of Automatic Storage Management
  • 1.6.2 Shared Storage for Database Recovery Area
• 1.7 Additional Considerations for Using Oracle Database 10g Features in RAC
• 1.8 Oracle Database 10g and Real Application Clusters Components
• • 1.8.1 Oracle Clusterware
  • 1.8.2 The Installed Real Application Clusters Components
• 1.9 Oracle Database 10g Real Application Clusters Release Compatibility
• 1.10 Required Operating System Groups
• 1.11 Cloning Oracle Clusterware and RAC in Grid Environments
• • 1.11.1 Cloning Oracle Clusterware Homes
  • 1.11.2 Cloning RAC Homes

Part II Oracle Clusterware and Oracle Real Application Clusters Pre-Installation Procedures

2 Pre-Installation Tasks

• 2.1 Understanding and Using Cluster Verification Utility
• • 2.1.1 Entering Cluster Verification Utility Commands
  • 2.1.2 Using CVU to Determine if Installation Prerequisites are Complete
  • 2.1.3 Using the Cluster Verification Utility Help
  • 2.1.4 Using Cluster Verification Utility with Oracle 10g Release 1
  • 2.1.5 Verbose Mode and "Unknown" Output
• 2.2 Logging In to the System as root
• 2.3 Creating Required Operating System Groups and User
• • 2.3.1 Creating the Oracle Inventory Group
  • 2.3.2 Creating the OSDBA Group
  • 2.3.3 Creating an OSOPER Group (Optional)
  • 2.3.4 Creating the Oracle Software Owner User
  • 2.3.5 Verifying That the User nobody Exists
  • 2.3.6 Creating Identical Users and Groups on Other Cluster Nodes
  • 2.3.7 Configuring SSH on All Cluster Nodes
  • • 2.3.7.1 Configuring SSH on Cluster Member Nodes
    • 2.3.7.2 Enabling SSH User Equivalency on Cluster Member Nodes
    • 2.3.7.3 Preventing Oracle Clusterware Installation Errors Caused by stty Commands
• 2.4 Configuring the oracle User's Environment
• 2.5 Checking the Hardware Requirements
• 2.6 Checking the Network Requirements
• 2.7 Checking the Network Setup with CVU
• 2.8 Checking the Software Requirements
• 2.9 Configure Kernel Parameters
• 2.10 Checking the Hardware and Operating System Setup with CVU
• 2.11 Checking the Operating System Requirements Setup with CVU
• 2.12 Identifying Required Software Directories
• • 2.12.1 Oracle Base Directory
  • 2.12.2 Oracle Inventory Directory
  • 2.12.3 Oracle Clusterware Home Directory
  • 2.12.4 Oracle Home Directory
• 2.13 Identifying or Creating an Oracle Base Directory
• • 2.13.1 Identifying an Existing Oracle Base Directory
  • 2.13.2 Creating an Oracle Base Directory
• 2.14 Creating the Oracle Clusterware Home Directory
• 2.15 Stopping Existing Oracle Processes for Upgrades or Co-existing Databases

3 Configuring Oracle Clusterware and Oracle Database Storage

• 3.1 Reviewing Storage Options for Oracle Clusterware, Database, and Recovery Files
• • 3.1.1 Overview of Storage Options
  • • 3.1.1.1 Overview of Oracle Clusterware Storage Options
    • 3.1.1.2 Overview of Oracle Database and Recovery File Options
    • 3.1.1.3 General Storage Considerations
    • 3.1.1.4 After You Have Selected Disk Storage Options
  • 3.1.2 Checking for Available Shared Storage with CVU
• 3.2 Configuring Storage for Oracle Clusterware Files on a Supported Shared File System
• • 3.2.1 Requirements for Using a File System for Oracle Clusterware Files
  • 3.2.2 Checking NFS Buffer Size Parameters
  • 3.2.3 Creating Required Directories for Oracle Clusterware Files on Shared File Systems
• 3.3 Configuring Storage for Oracle Clusterware Files on Raw Devices
• • 3.3.1 Identifying Required Raw Partitions for Clusterware Files
  • 3.3.2 Disabling Operating System Activation of Shared Volume Groups
  • 3.3.3 Configuring Raw Disk Devices Without HP ServiceGuard Extension
  • 3.3.4 Configuring Shared Raw Logical Volumes With HP ServiceGuard Extension
  • • 3.3.4.1 Create a Volume Group
    • 3.3.4.2 Create Raw Logical Volumes in the New Volume Group
    • 3.3.4.3 Export the Volume Group and Import It on the Other Cluster Nodes
    • 3.3.4.4 Activate the Volume Group in Shared Mode on All Cluster Nodes
  • 3.3.5 Create the Oracle Database Configuration Assistant Raw Device Mapping File
• 3.4 Choosing a Storage Option for Oracle Database Files
• 3.5 Configuring Disks for Automatic Storage Management
• • 3.5.1 Identifying Storage Requirements for Automatic Storage Management
  • 3.5.2 Using an Existing Automatic Storage Management Disk Group
  • 3.5.3 Configuring Disks for Automatic Storage Management
• 3.6 Configuring Disks for Database Files on Raw Devices
• • 3.6.1 Identifying Partitions and Configuring Raw Devices for Database Files
  • 3.6.2 Creating the Oracle Database Configuration Assistant Raw Device Mapping File

Part III Installing Oracle Clusterware and Oracle Database 10g with Oracle Real Application Clusters, Creating Oracle Real Application Clusters Databases, and Performing Post-Installation Tasks

4 Installing Oracle Clusterware

• 4.1 Verifying Oracle Clusterware Requirements with CVU
• • 4.1.1 Troubleshooting Oracle Clusterware Setup
• 4.2 Preparing to Install Oracle Clusterware with OUI
• 4.3 Installing Oracle Clusterware with OUI
• • 4.3.1 Running OUI to Install Oracle Clusterware
  • 4.3.2 Troubleshooting Oracle Clusterware Installation Verification
  • 4.3.3 Oracle Clusterware Background Processes

5 Installing Oracle Database 10g with Real Application Clusters

• 5.1 Verifying System Readiness for installing Oracle Database with CVU
• • 5.1.1 Troubleshooting Installation Setup for HP-UX
• 5.2 Selecting a Configuration Option
• • 5.2.1 Automatic Storage Management Configuration
  • 5.2.2 Database Configuration Type Descriptions
  • • 5.2.2.1 General Purpose, Transaction Processing, and Data Warehouse Configuration Types
    • 5.2.2.2 Using the Advanced Configuration Type
  • 5.2.3 Behavior of OUI, DBCA, and Other Assistants During Installation
• 5.3 Installation of Oracle Database 10g with RAC Using the Oracle Universal Installer
• 5.4 De-Installing Real Application Clusters Software
• • 5.4.1 De-Installing Oracle Database 10g RAC Software and ASM
  • 5.4.2 De-Installing Oracle Clusterware

6 Creating Real Application Clusters Databases with Database Configuration Assistant

• 6.1 Using Database Configuration Assistant in Real Application Clusters
• 6.2 Benefits of Using Database Configuration Assistant
• 6.3 Oracle Real Application Clusters High Availability Services
• • 6.3.1 Service Configuration and Instance Preferences
  • 6.3.2 Transparent Application Failover Policies
• 6.4 Automatic Listener Migration from Release 10.1 to 10.2
• 6.5 Verifying Requirements for DBCA
• 6.6 Creating an Oracle Real Application Clusters Database with DBCA
• 6.7 Deleting a Real Application Clusters Database with DBCA

7 Oracle Real Application Clusters Post-Installation Procedures

• 7.1 Required Post-Installation Tasks
• • 7.1.1 Back Up the Voting Disk After Installation
  • 7.1.2 Download and Install Patches
  • 7.1.3 Configure Oracle Products
  • 7.1.4 Verify Required Post-Installation is Completed
• 7.2 Recommended Post-Installation Tasks
• • 7.2.1 Verifying Enterprise Manager Operations
  • 7.2.2 Recommended Post-Installation Tasks
  • • 7.2.2.1 Back Up the root.sh Script
    • 7.2.2.2 Set Up Users Accounts
    • 7.2.2.3 Set the ORACLE_HOME and ORACLE_SID Environments

Part IV Oracle Real Application Clusters Environment Configuration

8 Configuring the Server Parameter File in Oracle Real Application Clusters Environments

• 8.1 Parameter Files and Oracle Application Clusters
• 8.2 Using Server Parameter Files in Real Application Clusters
• • 8.2.1 Location of The Server Parameter File
• 8.3 Parameter File Search Order in Real Application Clusters
• 8.4 Migrating to the Server Parameter File in Real Application Clusters Environments
• • 8.4.1 Server Parameter File Placement in Real Application Clusters
  • 8.4.2 Procedures for Migrating to the Server Parameter File
• 8.5 Server Parameter File Errors in Real Application Clusters

9 Understanding the Oracle Real Application Clusters Installed Configuration

• 9.1 Understanding the Configured Environment in Real Application Clusters
• 9.2 Oracle Cluster Registry in Oracle Real Application Clusters
• 9.3 Oratab Configurations for Oracle Real Application Clusters
• 9.4 Database Components Created Using Database Configuration Assistant
• • 9.4.1 Tablespaces and Data files
  • 9.4.2 Control Files
  • 9.4.3 Redo Log Files
• 9.5 Managing Undo Tablespaces in Real Application Clusters
• 9.6 Initialization Parameter Files
• 9.7 Configuring Service Registration-Related Parameters in Real Application Clusters
• 9.8 Configuring the Listener File (listener.ora)
• • 9.8.1 Local Listeners
  • 9.8.2 Multiple Listeners
  • 9.8.3 How Oracle Database Uses the Listener (listener.ora File)
  • • 9.8.3.1 Listener Registration and PMON Discovery
• 9.9 Directory Server Access (ldap.ora File)
• 9.10 Net Service Names (tnsnames.ora File)
• 9.11 Net Services Profile (sqlnet.ora File)

Part V Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Reference Information

A Troubleshooting the Oracle Clusterware and Oracle Real Application Clusters Installation Process

• A.1 Troubleshooting the Oracle Real Application Clusters Installation
• • A.1.1 General Installation Issues
  • A.1.2 Real Application Clusters Installation Error Messages
  • A.1.3 Performing Cluster Diagnostics During Real Application Clusters Installations

B Using Scripts to Create Oracle Real Application Clusters Databases

• B.1 Creating a Database Using Scripts

C Configuring Raw Devices for Oracle Real Application Clusters

• C.1 Raw Devices Required by DBCA
• • C.1.1 Planning Your Raw Device Creation Strategy

D Converting to Oracle Real Application Clusters from Single-Instance Oracle Databases

• D.1 Single-Instance to Cluster-Enabled Conversion Administrative Issues
• D.2 Converting with DBCA
• • D.2.1 Single Instance on a Non-Cluster Computer to Oracle Database 10g with RAC
  • • D.2.1.1 Back Up the Original Single-Instance Database
    • D.2.1.2 Perform the Pre-Installation Steps
    • D.2.1.3 Set Up the Cluster
    • D.2.1.4 Validate the Cluster
    • D.2.1.5 Copy the Preconfigured Database Image
    • D.2.1.6 Install Oracle Database 10g Software with Real Application Clusters
  • D.2.2 Single Instance on a Cluster to Oracle Database 10g RAC
  • • D.2.2.1 Single Instance on a Cluster Running from a Cluster-Enabled Oracle Home
    • D.2.2.2 Single Instance on a Cluster Running from a RAC-Disabled Oracle Home
    • D.2.2.3 Single Instance on a Cluster Running from a Single-Instance Installed Oracle Home
• D.3 Converting with rconfig and Oracle Enterprise Manager
• • D.3.1 Prerequisites for Converting to RAC Databases
  • D.3.2 Single-Instance to RAC Conversion Scenarios
  • D.3.3 Converting Single-Instance Databases to RAC Using rconfig
  • D.3.4 Example of an rconfig XML Input File
  • D.3.5 Converting Single-Instance Databases to RAC Using Oracle Enterprise Manager
  • D.3.6 Converting Single-Instance ASM to Cluster ASM
• D.4 Post-Conversion Steps

E Directory Structure for Oracle Database 10g Oracle Real Application Clusters Environments

• E.1 Understanding the Real Application Clusters Directory Structure
• E.2 Directory Structures for Real Application Clusters

F How to Stop Processes in an Existing Oracle Real Application Clusters Database

• F.1 Back Up the Oracle Real Application Clusters Database
• F.2 Shut Down Oracle Real Application Clusters Databases
• F.3 Stop All Oracle Processes
• • F.3.1 Stopping Oracle Clusterware or Cluster Ready Services Processes
  • F.3.2 Stopping Oracle Database 10g Processes Before Adding Products or Upgrading

Index