Contents

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Real Application Clusters Installation?

• New Features for Release 2 (11.2.0.2)
• New Features for Release 2 (11.2)
• New Features for Release 1(11.1)

1 Preinstallation Checklist

• 1.1 Before You Start: Planning Your Installation
  • 1.1.1 Check My Oracle Support
  • 1.1.2 Consider Using Software Updates Option
  • 1.1.3 Check Oracle Technology Network
  • 1.1.4 Review Installation Steps for Oracle RAC
  • 1.1.5 Review How to Use Cluster Verification Utility (CVU)
  • 1.1.6 Review and Back Up Existing Oracle Installations
  • 1.1.7 Review Globalization Requirements
  • 1.1.8 Review Documentation
• 1.2 Overview of Server Hardware, Network and Operating System
  • 1.2.1 Review Server Hardware and Software Requirements
  • 1.2.2 Overview of Server Environment Configuration
  • 1.2.3 Overview of Oracle Base
  • 1.2.4 Overview of Network Connection Requirements
  • 1.2.5 Overview of Secure Shell (SSH) Configuration
  • 1.2.6 Overview of Browser Requirement
  • 1.2.7 Overview of Platform-Specific Server Configuration
• 1.3 Overview of Oracle RAC Storage
  • 1.3.1 Where to Review Storage System Requirements
  • 1.3.2 Overview of Oracle Automatic Storage Management Cluster File System
  • 1.3.3 Overview of Oracle Database and Recovery File Options
  • 1.3.4 General Storage Considerations for Oracle RAC
  • 1.3.5 Using Logical Volume Managers with Oracle Grid Infrastructure and Oracle RAC
• 1.4 Additional Information to Prepare for Installation
  • 1.4.1 Oracle ASM is Installed with Oracle Grid Infrastructure
  • 1.4.2 Obtain the Oracle ASM ASMSNMP Password for Oracle Enterprise Manager
  • 1.4.3 Oracle Clusterware and Vendor Clusterware
  • 1.4.4 Shared Components of Oracle RAC Installations
  • 1.4.5 Simplified Upgrade of TIMESTAMP WITH TIME ZONE Data
  • 1.4.6 Ensure an External Jobs User Is Created for HP-UX
  • 1.4.7 Oracle Database 11g Real Application Clusters Release Compatibility
• 1.5 Confirming Cluster Readiness for Oracle RAC Installation with CVU
• 1.6 Stopping Existing Oracle Processes for Upgrades or Coexisting Databases

2 Installing Oracle Database 11g with Oracle Real Application Clusters

• 2.1 Reviewing Oracle Application Express Requirements
  • 2.1.1 Browser Requirements for Oracle Application Express
  • 2.1.2 Installing with Existing Oracle HTML Server Installations
  • 2.1.3 Oracle Text Requirement for Oracle Application Express
  • 2.1.4 Oracle XML DB Requirement for Oracle Application Express
• 2.2 Selecting a Configuration Option
• 2.3 Oracle Database Vault Installation and Configuration
  • 2.3.1 Oracle Database Vault Requirements
  • 2.3.2 Oracle Database Vault Accounts
    • 2.3.2.1 Oracle Database Vault Owner
    • 2.3.2.2 Oracle Database Vault Account Manager
  • 2.3.3 Multiple Oracle Database Vault Homes
  • 2.3.4 Starting the Listener with Oracle Database Vault Installations
  • 2.3.5 Installing Oracle Database Vault
    • 2.3.5.1 Configuring Oracle Database Vault During Oracle RAC Installation
    • 2.3.5.2 Configuring Oracle Database Vault After Oracle RAC Installation
• 2.4 Oracle Database Configuration Type Descriptions
  • 2.4.1 General Purpose and Transaction Processing, and Data Warehouse Configuration Types
  • 2.4.2 Using the Advanced Install Type
• 2.5 Oracle Configuration Manager Option
• 2.6 Database Security Options
• 2.7 Selecting Database Passwords
• 2.8 Actions of OUI and DBCA During Installation
• 2.9 Installing Oracle Database with Other Languages
• 2.10 Selecting a Database Name
• 2.11 Using Oracle Universal Installer to Install Oracle RAC
• 2.12 Using Oracle Universal Installer to Install Oracle RAC One Node
• 2.13 Using DBCA to Configure Oracle RAC One Node

3 Creating Oracle Real Application Clusters Databases with Database Configuration Assistant

• 3.1 Using Database Configuration Assistant with Oracle RAC
• 3.2 Benefits of Using Database Configuration Assistant
• 3.3 Automatic Listener Migration from Earlier Releases
• 3.4 Setting Environment Variables for Enterprise Manager DB Control
• 3.5 Verifying Requirements for DBCA
• 3.6 Creating an Oracle RAC Database with DBCA
• 3.7 Deleting an Oracle RAC Database with DBCA

4 Oracle Real Application Clusters Postinstallation Procedures

• 4.1 Required Postinstallation Tasks
  • 4.1.1 Download and Install Patch Updates
  • 4.1.2 Set External Jobs Ownership for Installations on HP-UX
  • 4.1.3 Configure Oracle Products
  • 4.1.4 Relocate Instance-Related Memory-Mapped files from OCFS2 Using Symbolic Links
• 4.2 Recommended Postinstallation Tasks
  • 4.2.1 Recommended Database Postinstallation Tasks
    • 4.2.1.1 Back Up the root.sh Script
    • 4.2.1.2 Set the Oracle User Environment Variables
    • 4.2.1.3 Recompile all PL/SQL modules
    • 4.2.1.4 Set Up User Accounts
• 4.3 Oracle Configuration Manager Postinstallation Configuration for Oracle RAC
• 4.4 Enabling and Disabling Database Options After Installation

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

• 5.1 Parameter Files and Oracle RAC
• 5.2 Using Server Parameter Files with Oracle RAC
  • 5.2.1 About the Server Parameter File
• 5.3 Parameter File Search Order in Oracle RAC
• 5.4 Migrating to the SPFILE in Oracle RAC Environments
  • 5.4.1 Server Parameter File Placement in Oracle RAC
  • 5.4.2 Procedures for Migrating to the Server Parameter File
• 5.5 Server Parameter File Errors in Oracle RAC

6 Configuring Server Pools and Enterprise Manager Database Control

• 6.1 Understanding Server Pools
  • 6.1.1 Oracle RAC One Node and Server Pools
  • 6.1.2 Policy-Based Cluster and Capacity Management
• 6.2 Configuring Database Control During and After Installation
  • 6.2.1 Understanding Using EMCA with Oracle RAC
  • 6.2.2 Configuring Database Control During Installation
  • 6.2.3 Configuring Database Control with DBCA
  • 6.2.4 Configuring Database Control After Installation Using EMCA
  • 6.2.5 Using an Input File for EMCA Parameters
  • 6.2.6 Specifying the Ports Used by Database Control
  • 6.2.7 EMCA Troubleshooting Tips
    • 6.2.7.1 Using EMCA After Changing the Database Listener Port
    • 6.2.7.2 Upgrading 11g Release 2 Grid Control Agents
    • 6.2.7.3 Using EMCA When Database Host Name or IP Address Changes
    • 6.2.7.4 Using EMCA When the TNS Configuration Is Changed

7 Understanding the Oracle Real Application Clusters Installed Configuration

• 7.1 Understanding the Configured Environment in Oracle RAC
• 7.2 Understanding Time Zone Settings on Cluster Nodes
• 7.3 Oratab Configuration for Oracle RAC
• 7.4 Database Components Created Using Database Configuration Assistant
  • 7.4.1 Tablespaces and Data files
  • 7.4.2 Control Files
  • 7.4.3 Redo Log Files
• 7.5 Managing Undo Tablespaces in Oracle RAC
• 7.6 Initialization Parameter Files
• 7.7 Oracle Database Default Audit Policy and Initialization Parameters
• 7.8 Understanding Service Registration-Related Parameters
  • 7.8.1 Understanding Single Client Access Name (SCAN) and Load-balancing
  • 7.8.2 Understanding Load-Balancing, Failover, and High Availability
• 7.9 Configuring the Listener File (listener.ora)
  • 7.9.1 Grid Naming Service (GNS) and Listeners
  • 7.9.2 About Local Listeners
  • 7.9.3 About Multiple Listeners
  • 7.9.4 How Oracle Database Uses the Listener File (listener.ora)
    • 7.9.4.1 Listener Registration and PMON Discovery
• 7.10 Net Service Names (tnsnames.ora File)
  • 7.10.1 Net Service Names for Database Connections
  • 7.10.2 Net Service Name Instance Connections
  • 7.10.3 tnsnames.ora Example File
• 7.11 Net Services Profile (sqlnet.ora File)

8 Removing Oracle Real Application Clusters Software

• 8.1 Overview of Deinstallation Procedures
• 8.2 Identifying All Instances On a Cluster
• 8.3 Deinstalling Oracle RAC Software
  • 8.3.1 About the Deinstallation Tool
  • 8.3.2 Example of Running the Deinstall Command for Oracle RAC
  • 8.3.3 Example of a Deinstallation Parameter File for Oracle RAC

A Troubleshooting Oracle Real Application Clusters Installations

• A.1 Troubleshooting Oracle Real Application Clusters Installations
  • A.1.1 General Installation Issues
  • A.1.2 Oracle RAC Installation Error Messages
  • A.1.3 Performing Cluster Diagnostics During Oracle Clusterware Installations
  • A.1.4 Reviewing the Log of an Installation Session
  • A.1.5 Configuration Assistant Errors
    • A.1.5.1 Configuration Assistant Failures
    • A.1.5.2 Fatal Errors
• A.2 About Using CVU Cluster Healthchecks After Installation

B Using Scripts or Response Files to Create Oracle Real Application Clusters Databases

• B.1 Using DBCA to generate Installation Scripts for Oracle RAC
• B.2 About DBCA Noninteractive (Silent) Configuration for Oracle RAC
• B.3 Using DBCA Noninteractive (Silent) Configuration for Oracle RAC
• B.4 How Response Files Work
  • B.4.1 Reasons for Using Silent Mode or Response File Mode
  • B.4.2 Creating a Database Using Oracle ASM for Database Files
  • B.4.3 General Procedure for Using Response Files
• B.5 Preparing Response Files
  • B.5.1 Editing a Response File Template
  • B.5.2 Recording Response Files
• B.6 Running Oracle Universal Installer Using a Response File
• B.7 Running Net Configuration Assistant Using Response Files
• B.8 Running Configuration Assistants Using Response Files
  • B.8.1 About Database Configuration Assistant in Response File Mode
  • B.8.2 Running Database Configuration Assistant in Response File or Silent Mode
• B.9 Postinstallation Configuration Using Response Files
  • B.9.1 About the Postinstallation Configuration File
  • B.9.2 Running Postinstallation Configuration Using a Response File

C Converting to Oracle RAC and Oracle RAC One Node from Single-Instance Oracle Databases

• C.1 Administrative Issues for Converting Databases to Oracle RAC
• C.2 Converting to Oracle RAC and Oracle RAC One Node with DBCA
  • C.2.1 Converting Oracle Database 11g Installations to Oracle RAC Using DBCA
    • C.2.1.1 Back Up the Original Single-Instance Database
    • C.2.1.2 Complete Oracle Clusterware Installation
    • C.2.1.3 Validate the Cluster
    • C.2.1.4 Copy the Preconfigured Database Image
    • C.2.1.5 Install Oracle Database 11g Software with Oracle RAC
  • C.2.2 Converting Single Instance on a Cluster to Oracle RAC One Node Using DBCA
  • C.2.3 Converting Single Instance on a Cluster to Oracle RAC Using DBCA
    • C.2.3.1 Single Instance on a Cluster Running from a Cluster-Enabled Oracle Home
    • C.2.3.2 Single Instance on a Cluster Running from an Oracle RAC-Disabled Oracle Home
    • C.2.3.3 Single Instance on a Cluster Running from a Single-Instance Installed Oracle Home
  • C.2.4 Converting Oracle RAC One Node to Oracle RAC
• C.3 Preparing to Convert with rconfig and Oracle Enterprise Manager
  • C.3.1 Prerequisites for Converting to Oracle RAC Databases
  • C.3.2 Configuration Changes during Oracle RAC Conversion Using RCONFIG
  • C.3.3 Converting Databases to Oracle RAC Using RCONFIG or Oracle Enterprise Manager
  • C.3.4 Converting Databases to Oracle RAC Using Oracle Enterprise Manager
• C.4 Converting Databases to Oracle RAC Using RCONFIG
• C.5 Example of Rconfig XML Input Files for ConvertToRAC
• C.6 Post-Conversion Steps

D Directory Structure for Oracle Real Application Clusters Environments

• D.1 Understanding the Oracle RAC Directory Structure
• D.2 Directory Structures for Oracle RAC

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

• E.1 Backing Up the Oracle RAC Database
• E.2 Shutting Down Oracle RAC Databases
• E.3 Stopping All Oracle Processes
  • E.3.1 Stopping Oracle Database Processes Before Adding Products or Upgrading
  • E.3.2 Stopping Oracle Clusterware and Oracle ASM Instances
• E.4 Using CVU to Validate Readiness for Oracle RAC Upgrades
  • E.4.1 About the CVU Database Upgrade Validation Command Options
  • E.4.2 Example of Verifying System Upgrade Readiness for Oracle RAC Infrastructure
  • E.4.3 Verifying System Readiness for Oracle Database Upgrades

F Managing Oracle Database Port Numbers

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

Index