Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Database 10g RAC Installation and Configuration?

• Oracle Database 10g Release 1 (10.1) New Features
• Oracle Database 10g Release 2 (10.2) New Features

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

1 Introduction to Installing Oracle Clusterware and Oracle Real Application Clusters

• 1.1 Oracle Clusterware and Oracle Real Application Clusters Documentation Overview
• 1.2 General System Installation Requirements for Oracle Real Application Clusters
• • 1.2.1 Cluster Verification Utility
  • 1.2.2 Hardware Requirements for Oracle Database 10g Real Application Clusters
  • 1.2.3 Software Requirements for Oracle Database 10g Real Application Clusters
• 1.3 Cluster Setup and Pre-Installation Configuration Tasks for Real Application Clusters
• 1.4 Pre-Installation, Installation, and Post-Installation Overview
• • 1.4.1 Pre-Installation Overview for Oracle Clusterware and Oracle Real Application Clusters
  • 1.4.2 Installation Overview for Oracle Clusterware and Oracle 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 Version Compatibility
• 1.10 Cloning Oracle Clusterware and RAC in Grid Environments
• • 1.10.1 Cloning Oracle Clusterware Homes
  • 1.10.2 Cloning Real Application Clusters Homes

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

2 Server and Network Pre-Installation Tasks

• 2.1 Understanding and Using Cluster Verification Utility
• • 2.1.1 Entering Cluster Verification Utility Commands
  • 2.1.2 Using Cluster Verification Utility Help
  • 2.1.3 Verbose Mode and "Unknown" Output
• 2.2 Installation Differences Between Windows and UNIX
• 2.3 Checking Hardware and Software Certification
• • 2.3.1 Web Browser Support
  • 2.3.2 Telnet and Terminal Services Support
  • • 2.3.2.1 Windows Telnet Services Support
    • 2.3.2.2 Windows Terminal Services and Remote Desktop Support
• 2.4 Checking Hardware Requirements
• • 2.4.1 Hard Disk Space Requirements
• 2.5 Verifying Hardware Requirements
• 2.6 Checking Software Requirements
• 2.7 Checking the Hardware and Operating System Setup with CVU
• 2.8 Checking Network Requirements
• • 2.8.1 Network Hardware Requirements
  • 2.8.2 IP Address Requirements
  • 2.8.3 Checking Network Requirements
• 2.9 Checking the Network Setup
• 2.10 Checking Individual Component Requirements
• • 2.10.1 Oracle Advanced Security Requirements
  • 2.10.2 Oracle Enterprise Manager Requirements
• 2.11 Stopping Existing Oracle Processes
• 2.12 Verifying Cluster Privileges

3 Storage Pre-Installation Tasks

• 3.1 Preliminary Shared Disk Preparation
• • 3.1.1 Disabling Write Caching
  • 3.1.2 Enabling Automounting for Windows 2003
• 3.2 Reviewing Storage Options for Oracle Clusterware, Database, and Recovery Files
• • 3.2.1 Overview of Storage Options
  • • 3.2.1.1 Overview of Oracle Clusterware Storage Options
    • 3.2.1.2 Overview of Oracle Database and Recovery File Options
    • 3.2.1.3 General Storage Considerations
    • 3.2.1.4 Guidelines for Placing Oracle Datafiles on a File System
    • 3.2.1.5 Guidelines for Placing Oracle Recovery Files on a File System
    • 3.2.1.6 After You Have Selected Disk Storage Options
  • 3.2.2 Checking for Available Shared Storage with CVU
• 3.3 Storage Configuration Steps for Real Application Clusters
• • 3.3.1 Configuring Storage for Oracle Clusterware Files on a Shared File System
  • 3.3.2 Configuring Storage for Oracle Clusterware Files on Raw Devices
• 3.4 Configuring Disks for Automatic Storage Management
• • 3.4.1 General Steps for Configuring Automatic Storage Management
  • 3.4.2 Step 1: Identifying Storage Requirements for Automatic Storage Management
  • 3.4.3 Step 2 (Optional): Using an Existing Automatic Storage Management Disk Group
  • 3.4.4 Step 3: Creating DAS or SAN Disk Partitions for Automatic Storage Management
  • 3.4.5 Step 4: Manually Configuring Disks for Automatic Storage Management
  • • 3.4.5.1 Overview of asmtoolg and asmtool
    • 3.4.5.2 Using asmtoolg (Graphical User Interface)
    • 3.4.5.3 Using asmtool (Command Line)
• 3.5 Configuring Raw Logical Volumes or Raw Partitions
• • 3.5.1 Creating Partitions for Logical Volumes
  • 3.5.2 Assigning Logical Names
  • 3.5.3 Creating the DBCA Raw Device Mapping File
• 3.6 Oracle-Managed Files Requirements

Part III Installing Oracle Clusterware and Oracle Real Application Clusters

4 Installing Oracle Clusterware on Windows-Based Systems

• 4.1 Verifying Oracle Clusterware Requirements with CVU
• • 4.1.1 Troubleshooting Clusterware Setup for Windows
• 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 Installing Oracle Clusterware Using a Cluster Configuration File
• 4.4 Formatting Drives to Use Oracle Cluster File System after Installation

5 Installing Oracle Database 10g with Real Application Clusters

• 5.1 Verifying System Readiness for Installing the Oracle Database with CVU
• • 5.1.1 Troubleshooting Installation Setup for Windows
• 5.2 Selecting a Database Configuration Type
• • 5.2.1 Configuration Type Descriptions
  • • 5.2.1.1 General Purpose, Transaction Processing, and Data Warehouse Configuration Types
    • 5.2.1.2 Using the Advanced Configuration Type
  • 5.2.2 Behavior of OUI, DBCA, and Other Assistants During Installation
• 5.3 Installation of Oracle Database 10g with RAC Using Oracle Universal Installer
• 5.4 Installation on Windows-Based Systems with the Minimum Memory Requirements
• 5.5 De-Installing Real Application Clusters Software
• • 5.5.1 De-Installing Oracle Database 10g RAC Software
  • 5.5.2 De-Installing Oracle Clusterware from Windows Environments
  • • 5.5.2.1 De-Installing Oracle Clusterware with No Previous Cluster Software Versions
    • 5.5.2.2 De-Installing Oracle Clusterware, with Clusterware Downgrade to 9.2
  • 5.5.3 De-Installing Automatic Storage Management

6 Creating RAC Databases with Database Configuration Assistant

• 6.1 Using Database Configuration Assistant with Oracle 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 Verifying Requirements for DBCA
• 6.5 Creating the Database after Installation Using Database Configuration Assistant
• 6.6 Creating an Oracle Real Application Clusters Database with DBCA
• 6.7 Deleting a Real Application Clusters Database with DBCA

7 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.2 Recommended Post-Installation Tasks
• • 7.2.1 Verifying Enterprise Manager Operations
  • 7.2.2 Using Oracle9i Language and Definition Files with Oracle Database 10g

Part IV Real Application Clusters Environment Configuration

8 Parameter Management for Real Application Clusters Databases

• 8.1 Parameter Files and Real 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 Oracle Real Application Clusters
• 8.4 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 The Oracle Cluster Registry in Real Application Clusters
• 9.3 Database Components Created Using Database Configuration Assistant
• • 9.3.1 Tablespaces and Datafiles
  • 9.3.2 Control Files
  • 9.3.3 Redo Log Files
• 9.4 Managing Undo Tablespaces in Real Application Clusters
• 9.5 Initialization Parameter Files
• 9.6 Configuring Service Registration-Related Parameters in Real Application Clusters
• 9.7 Configuring the Listener File (listener.ora)
• • 9.7.1 Local Listeners
  • 9.7.2 Multiple Listeners
  • 9.7.3 How Oracle Uses the Listener (listener.ora File)
  • • 9.7.3.1 Listener Registration and PMON Discovery
• 9.8 Directory Server Access (ldap.ora File)
• 9.9 Net Service Names (tnsnames.ora File)
• 9.10 Net Services Profile (sqlnet.ora File)

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

A Troubleshooting the Installation Process

• A.1 Troubleshooting the Oracle Clusterware and RAC 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 Real Application Clusters Databases

• B.1 Creating a Database Using Scripts

C Configuring Raw Devices for Oracle Real Application Clusters

• C.1 Support for Raw Devices on Windows Systems
• C.2 Raw Devices Required by Database Configuration Assistant
• • C.2.1 Planning Your Raw Device Creation Strategy

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

• D.1 Prerequisites for Conversion
• D.2 Single-Instance to Cluster-Enabled Conversion Administrative Issues
• D.3 Converting from Single-Instance to Real Application Clusters
• • D.3.1 Single Instance on a Non-Cluster computer to Oracle Database 10g with RAC
  • • D.3.1.1 Back up the Original Single-Instance Database
    • D.3.1.2 Perform the Pre-Installation Steps
    • D.3.1.3 Set up the Cluster
    • D.3.1.4 Validate the Cluster
    • D.3.1.5 Copy the Preconfigured Database Image
    • D.3.1.6 Install Oracle Database 10g Software with Real Application Clusters
  • D.3.2 Single Instance on a Cluster to Oracle Database 10g RAC
  • • D.3.2.1 Single Instance on a Cluster Running from a Cluster Enabled Oracle Home
• D.4 Post-Conversion Steps

E Directory Structure for Oracle RAC 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

G Managing Oracle Database Port Numbers

• G.1 About Managing Ports
• G.2 Viewing Port Numbers and Access URLS
• G.3 Port Numbers and Protocols of Oracle Components
• G.4 Changing the Oracle Enterprise Management Agent Port
• G.5 Changing the Oracle Enterprise Manager Database Console Ports
• G.6 Changing the iSQL*Plus Ports
• G.7 Changing the Oracle XML DB Ports

Index