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 Oracle Clusterware and Oracle RAC Installation and Configuration?

• Oracle Database 10g Release 2 (10.2) New Features
• Oracle Database 10g Release 1 (10.1) 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

• Oracle Clusterware and Oracle Real Application Clusters Documentation Overview
• General System Installation Requirements for Oracle Real Application Clusters
  • Cluster Verification Utility
  • Hardware Requirements for Oracle Database 10g Real Application Clusters
  • Software Requirements for Oracle Database 10g Real Application Clusters
• Cluster Setup and Pre-Installation Configuration Tasks for Real Application Clusters
• Pre-Installation, Installation, and Post-Installation Overview
  • Pre-Installation Overview for Oracle Clusterware and Oracle Real Application Clusters
  • Installation Overview for Oracle Clusterware and Oracle Real Application Clusters
  • Post-Installation Overview for Oracle Database 10g Real Application Clusters
• Oracle Universal Installer and Real Application Clusters
• Storage Considerations for Installing Oracle Database 10g Real Application Clusters
  • Overview of Automatic Storage Management
  • Shared Storage for Database Recovery Area
• Additional Considerations for Using Oracle Database 10g Features in Oracle RAC
• Oracle Database 10g and Real Application Clusters Components
  • Oracle Clusterware
  • The Installed Real Application Clusters Components
• Oracle Database 10g Real Application Clusters Version Compatibility
• Cloning Oracle Clusterware and Oracle RAC in Grid Environments
  • Cloning Oracle Clusterware Homes
  • Cloning Real Application Clusters Homes

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

2 Server and Network Pre-Installation Tasks

• Understanding and Using Cluster Verification Utility
  • Entering Cluster Verification Utility Commands
  • Using Cluster Verification Utility Help
  • Verbose Mode and "Unknown" Output
• Installation Differences Between Windows and UNIX
• Checking Hardware and Software Certification
  • Web Browser Support
  • Telnet and Terminal Services Support
    • Windows Telnet Services Support
    • Windows Terminal Services and Remote Desktop Support
• Checking Hardware Requirements
  • Hard Disk Space Requirements
• Verifying Hardware Requirements
• Checking Software Requirements
• Checking the Hardware and Operating System Setup with CVU
• Checking Network Requirements
  • Network Hardware Requirements
  • IP Address Requirements
  • Checking Network Requirements
• Checking the Network Setup
• Checking Individual Component Requirements
  • Oracle Advanced Security Requirements
  • Oracle Enterprise Manager Requirements
• Stopping Existing Oracle Processes
• Verifying Cluster Privileges

3 Storage Pre-Installation Tasks

• Preliminary Shared Disk Preparation
  • Disabling Write Caching
  • Enabling Automounting for Windows 2003
• Reviewing Storage Options for Oracle Clusterware, Database, and Recovery Files
  • Overview of Storage Options
    • Overview of Oracle Clusterware Storage Options
    • Overview of Oracle Database and Recovery File Options
    • General Storage Considerations
    • Guidelines for Placing Oracle Datafiles on a File System
    • Guidelines for Placing Oracle Recovery Files on a File System
    • After You Have Selected Disk Storage Options
  • Checking for Available Shared Storage with CVU
• Storage Configuration Steps for Real Application Clusters
  • Configuring Storage for Oracle Clusterware Files on a Shared File System
  • Configuring Storage for Oracle Clusterware Files on Raw Devices
• Configuring Disks for Automatic Storage Management
  • General Steps for Configuring Automatic Storage Management
  • Step 1: Identifying Storage Requirements for Automatic Storage Management
  • Step 2 (Optional): Using an Existing Automatic Storage Management Disk Group
  • Step 3: Creating DAS or SAN Disk Partitions for Automatic Storage Management
  • Step 4: Manually Configuring Disks for Automatic Storage Management
    • Overview of asmtoolg and asmtool
    • Using asmtoolg (Graphical User Interface)
    • Using asmtool (Command Line)
• Configuring Raw Logical Volumes or Raw Partitions
  • Creating Partitions for Logical Volumes
  • Assigning Logical Names
  • Creating the DBCA Raw Device Mapping File
• Requirements for Files Managed by Oracle

Part III Installing Oracle Clusterware and Oracle Real Application Clusters

4 Installing Oracle Clusterware on Windows-Based Systems

• Verifying Oracle Clusterware Requirements with CVU
  • Troubleshooting Clusterware Setup for Windows
• Preparing to Install Oracle Clusterware with OUI
• Installing Oracle Clusterware with OUI
  • Starting OUI in Console Mode
  • Running OUI to Install Oracle Clusterware
  • Installing Oracle Clusterware Using a Cluster Configuration File
• Formatting Drives to Use Oracle Cluster File System after Installation

5 Installing Oracle Database 10g with Oracle Real Application Clusters

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

6 Creating Oracle RAC Databases with the Database Configuration Assistant

• Using Database Configuration Assistant with Oracle Real Application Clusters
• Benefits of Using Database Configuration Assistant
• Oracle Real Application Clusters High Availability Services
  • Service Configuration and Instance Preferences
  • Transparent Application Failover Policies
• Verifying Requirements for DBCA
• Creating the Database after Installation Using Database Configuration Assistant
• Creating an Oracle Real Application Clusters Database with DBCA
• Deleting a Real Application Clusters Database with DBCA

7 Oracle Real Application Clusters Post-Installation Procedures

• Required Post-Installation Tasks
  • Back Up the Voting Disk after Installation
  • Download and Install Patches
  • Configure Oracle Products
• Recommended Post-Installation Tasks
  • Verifying Enterprise Manager Operations
  • Using Oracle9i Language and Definition Files with Oracle Database 10g
  • Logging in to Oracle Enterprise Manager Database Control

Part IV Real Application Clusters Environment Configuration

8 Parameter Management for Real Application Clusters Databases

• Parameter Files and Real Application Clusters
• Using Server Parameter Files in Real Application Clusters
  • Location of the Server Parameter File
• Parameter File Search Order in Oracle Real Application Clusters
• Server Parameter File Errors in Real Application Clusters

9 Understanding the Oracle Real Application Clusters Installed Configuration

• Understanding the Configured Environment in Real Application Clusters
• The Oracle Cluster Registry in Real Application Clusters
• Database Components Created Using Database Configuration Assistant
  • Tablespaces and Datafiles
  • Control Files
  • Redo Log Files
• Managing Undo Tablespaces in Real Application Clusters
• Initialization Parameter Files
• Configuring Service Registration-Related Parameters in Real Application Clusters
• Configuring the Listener File (listener.ora)
  • Local Listeners
  • Multiple Listeners
  • How Oracle Uses the Listener (listener.ora File)
    • Listener Registration and PMON Discovery
• Directory Server Access (ldap.ora File)
• Net Service Names (tnsnames.ora File)
• Net Services Profile (sqlnet.ora File)

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

A Troubleshooting the Installation Process

• Troubleshooting the Oracle Clusterware and Oracle RAC Installation
  • General Installation Issues
  • Oracle Clusterware Install Actions Log Errors and Causes
    • The OCFS format is not recognized on one or more of the remote cluster nodes
    • Timing issue with start of the OracleCSService:
    • You are on a Windows 2003 system, and Automount of new drives is not enabled:
    • You have entered a period in one of the node names during CRS install
    • Node1 failed to startup service OracleEVMService, err(1053)
    • Ignoring upgrade failure of ocr(-1073740972)
  • Real Application Clusters Installation Error Messages
  • Performing Cluster Diagnostics During Real Application Clusters Installations

B Using Scripts to Create Oracle Real Application Clusters Databases

• Creating a Database Using Scripts

C Configuring Raw Devices for Oracle Real Application Clusters

• Support for Raw Devices on Windows Systems
• Raw Devices Required by Database Configuration Assistant
  • Planning Your Raw Device Creation Strategy

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

• Prerequisites for Conversion
• Single-Instance to Cluster-Enabled Conversion Administrative Issues
• Converting from Single-Instance to Real Application Clusters
  • Single Instance on a Non-Cluster computer to Oracle Database 10g with Oracle RAC
    • Back up the Original Single-Instance Database
    • Perform the Pre-Installation Steps
    • Set up the Cluster
    • Validate the Cluster
    • Copy the Preconfigured Database Image
    • Install Oracle Database 10g Software with Real Application Clusters
  • Single Instance on a Cluster to Oracle Database 10g RAC
    • Single Instance on a Cluster Running from a Cluster Enabled Oracle Home
• Post-Conversion Steps

E Directory Structure for Oracle RAC Environments

• Understanding the Real Application Clusters Directory Structure
• Directory Structures for Real Application Clusters

F Stopping Processes in Oracle RAC Databases and Performing Oracle Clusterware Rolling Upgrades

• Back Up the Oracle Software
• Verify System Readiness for Patches and Upgrades
• How to Stop Processes in an Existing Oracle Database
  • Shut Down Oracle Real Application Clusters Databases
  • Stop All Oracle Processes
    • Stop Oracle Clusterware or Cluster Ready Services Processes
    • Stop Oracle Database 10g Processes Before Adding Products or Upgrading
• How to Perform Oracle Clusterware Rolling Upgrades
  • Copy Patch Software to the Primary Upgrade Node
  • Shut Down Oracle Real Application Clusters Instances on Upgrade Nodes
  • Stop All Oracle Processes on Upgrade Nodes
  • Start OUI and Complete Upgrade Processes on Upgrade Nodes

G Managing Oracle Database Port Numbers

• About Managing Ports
• Viewing Port Numbers and Access URLS
• Port Numbers and Protocols of Oracle Components
• Changing the Oracle Enterprise Management Agent Port
• Changing the Oracle Enterprise Manager Database Console Ports
• Changing the iSQL*Plus Ports
• Changing the Oracle XML DB Ports

Index