Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documents
• Conventions

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

• New Features for Oracle Clusterware and RAC Installation

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 Overview of Installation Procedures
• • 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 Installation with Oracle Universal Installer
• 1.6 Storage Considerations for Installing Oracle Clusterware and RAC
• • 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 a HAGSUSER Group (Optional)
  • 2.3.5 Creating the Oracle Software Owner User
  • 2.3.6 Verifying That the User nobody Exists
  • 2.3.7 Creating Identical Users and Groups on Other Cluster Nodes
  • 2.3.8 Configuring SSH on All Cluster Nodes
  • • 2.3.8.1 Configuring SSH on Cluster Member Nodes
    • 2.3.8.2 Enabling SSH User Equivalency on Cluster Member Nodes
    • 2.3.8.3 Preventing Oracle Clusterware Installation Errors Caused by stty Commands
• 2.4 Configuring Shell Limits, System Configuration, and Network Tuning Parameters
• • 2.4.1 Configure Shell Limits
  • 2.4.2 Configure System Configuration Parameters
  • 2.4.3 Configure Network Tuning Parameters
• 2.5 Configuring the oracle User's Environment
• 2.6 Checking the Hardware Requirements
• 2.7 Checking the Network Requirements
• • 2.7.1 IP Address Requirements
  • 2.7.2 Node Time Requirements
  • 2.7.3 Configuring the Network Requirements
• 2.8 Checking the Network Setup with CVU
• 2.9 Checking the Software Requirements
• 2.10 Running the rootpre.sh Script
• 2.11 Checking the Hardware and Operating System Setup with CVU
• 2.12 Checking the Operating System Requirements Setup with CVU
• 2.13 Identifying Required Software Directories
• 2.14 Identifying or Creating an Oracle Base Directory
• 2.15 Creating the Oracle Clusterware Home Directory
• 2.16 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 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 Configuring Raw Disk Devices for Oracle Clusterware Without HACMP or GPFS
  • 3.3.3 Configuring Raw Logical Volumes for Oracle Clusterware
  • 3.3.4 Creating a Volume Group for Oracle Clusterware
  • 3.3.5 Configuring Raw Logical Volumes in the New Oracle Clusterware Volume Group
  • 3.3.6 Importing the Volume Group on the Other Cluster Nodes
  • 3.3.7 Activating the Volume Group in Concurrent Mode on All Cluster Nodes
• 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 Database File Storage for Automatic Storage Management and Raw Devices
• 3.6 Configuring Database File Storage on Raw Devices
• • 3.6.1 Identifying Required Raw Partitions for Database Files
  • 3.6.2 Configuring Raw Disk Devices for Database File Storage Without HACMP or GPFS
  • 3.6.3 Configuring Raw Logical Volumes for Database File Storage
  • 3.6.4 Creating a Volume Group for Database Files
  • 3.6.5 Creating Database File Raw Logical Volumes in the New Volume Group
  • 3.6.6 Importing the Database File Volume Group on the Other Cluster Nodes
  • 3.6.7 Activating the Database File Volume Group in Concurrent Mode on All Cluster Nodes
  • 3.6.8 Creating the 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 Installing Oracle Clusterware Using a Cluster Configuration File
  • 4.3.3 Troubleshooting Oracle Clusterware Installation Verification
  • 4.3.4 Oracle Clusterware Background Processes

5 Installing Oracle Database 10g with Oracle Real Application Clusters

• 5.1 Verifying System Readiness for installing Oracle Database with CVU
• • 5.1.1 Troubleshooting Installation Setup for AIX
• 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 Actions of OUI, DBCA, and Other Assistants During Installation
• 5.3 Installation of Oracle Database 10g with RAC Using Oracle Universal Installer
• 5.4 De-Installing Oracle 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 Oracle Real Application Clusters Databases with Database Configuration Assistant

• 6.1 Using Database Configuration Assistant in 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 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 Patch Updates
  • 7.1.3 Configure Oracle Products
• 7.2 Recommended Post-Installation Tasks
• • 7.2.1 Verifying Oracle 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
  • 7.2.3 Logging in to Oracle Enterprise Manager Database Control

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 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 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 Oracle Real Application Clusters
• 9.2 Oracle Cluster Registry in Oracle Real Application Clusters
• 9.3 Oratab Configuration 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 for Non-Cluster Environments
• • 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, and How to Perform Oracle Clusterware Rolling Upgrades

• F.1 Back Up the Oracle Software
• F.2 Verify System Readiness for Patches and Upgrades
• F.3 How to Stop Processes in an Existing Oracle Database
• • F.3.1 Shut Down Oracle Real Application Clusters Databases
  • F.3.2 Stop All Oracle Processes
  • • F.3.2.1 Stop Oracle Clusterware or Cluster Ready Services Processes
    • F.3.2.2 Stop Oracle Database 10g Processes Before Adding Products or Upgrading
• F.4 How to Perform Oracle Clusterware Rolling Upgrades
• • F.4.1 Copy Patch Software to the Primary Upgrade Node
  • F.4.2 Shut Down Oracle Real Application Clusters Instances on Upgrade Nodes
  • F.4.3 Stop All Oracle Processes on Upgrade Nodes
  • F.4.4 Start OUI and Complete Upgrade Processes on Upgrade Nodes

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 Ultra Search Ports
• G.8 Changing the Oracle XML DB Ports

Index