Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Real Application Clusters Installation?

• New Features for Oracle RAC 11g Release 2 (11.2.0.2)
• New Features for Oracle RAC 11g Release 2 (11.2)
• New Features for Oracle RAC 11g 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 and Internet Configuration
    • 1.2.4.1 Overview of Network Interface Configuration
    • 1.2.4.2 Overview of Configuring Internode Communication
    • 1.2.4.3 Overview of Browser Requirements
  • 1.2.5 Overview of Platform-Specific Server Configuration
• 1.3 Overview of Oracle RAC Storage
  • 1.3.1 General Storage Considerations for Oracle RAC
  • 1.3.2 Overview of Oracle Database and Recovery File Options
• 1.4 Requirements for the Oracle Database Vault Option
• 1.5 Additional Information to Prepare for Installation
  • 1.5.1 Oracle ASM Is Installed with Oracle Grid Infrastructure
  • 1.5.2 Obtain the Oracle ASM ASMSNMP Password for Oracle Enterprise Manager
  • 1.5.3 Oracle Clusterware and Vendor Clusterware
  • 1.5.4 Shared Components of Oracle RAC Installations
  • 1.5.5 Simplified Upgrade of TIMESTAMP WITH TIME ZONE Data
  • 1.5.6 Oracle Database 11g Real Application Clusters Release Compatibility
• 1.6 Confirming Cluster Readiness Using Cluster Verification Utility
• 1.7 Installing Oracle Database 11g Release 2 on Systems with Existing Databases

2 Installing Oracle Database 11g with Oracle Real Application Clusters

• 2.1 Reviewing Oracle Application Express Requirements
• 2.2 Selecting an Installation Type
• 2.3 Selecting an Installation Option
• 2.4 Selecting an Oracle Database Configuration Type
  • 2.4.1 Preconfigured Database Types Supplied with Oracle Database
  • 2.4.2 Using the Advanced Database Configuration Type
  • 2.4.3 Installing Oracle Database with Other Languages
• 2.5 Selecting the Oracle Database Vault Option
  • 2.5.1 Overview of Oracle Database Vault Accounts
    • 2.5.1.1 Oracle Database Vault Owner
    • 2.5.1.2 Oracle Database Vault Account Manager
  • 2.5.2 Overview of Oracle Database Vault Installation
• 2.6 Selecting the Oracle Configuration Manager Option
• 2.7 Selecting a Database Name
• 2.8 Creating Database Passwords
• 2.9 Understanding the Actions of OUI and DBCA During Installation
  • 2.9.1 Managing Database Services After Installation
  • 2.9.2 Installing Earlier NLS Compatibility Definition Files
• 2.10 Using Oracle Universal Installer to Install Oracle RAC
• 2.11 Using Oracle Universal Installer to Install Oracle RAC One Node
• 2.12 Installing Oracle RAC and Oracle Database Vault
• 2.13 Using DBCA to Configure Oracle RAC One Node
• 2.14 Updating Environment Variables on Remote Nodes

3 Creating Oracle Real Application Clusters Databases with Oracle Database Configuration Assistant

• 3.1 Using Oracle Database Configuration Assistant with Oracle RAC
• 3.2 Optimizing Your Database Environment by Using DBCA
• 3.3 Updating the Listener Used By an Earlier Release
• 3.4 Verifying Requirements for DBCA
• 3.5 Creating an Oracle RAC Database with DBCA
  • 3.5.1 Configuring Disks for Use With Oracle ASM
  • 3.5.2 Starting DBCA
  • 3.5.3 Using DBCA to Create an Oracle RAC Database
• 3.6 Deleting an Oracle RAC Database with DBCA
• 3.7 Setting Environment Variables for Enterprise Manager DB Control

4 Oracle Real Application Clusters Postinstallation Procedures

• 4.1 Required Postinstallation Tasks
  • 4.1.1 Determine If Any Patches Are Required For Your New Software
  • 4.1.2 Types of Patches Available for Oracle Software
  • 4.1.3 Downloading and Installing Patch Updates
  • 4.1.4 Configuring Exceptions for the Windows Firewall
  • 4.1.5 Configuring Oracle Products
    • 4.1.5.1 Configuring Oracle Database Vault
    • 4.1.5.2 Configuring Oracle Database Security Settings
  • 4.1.6 Configuring Storage for External Tables, Shared Files, or Directory Objects
• 4.2 Recommended Postinstallation Tasks
  • 4.2.1 Setting the Oracle User Environment Variables
  • 4.2.2 Recompiling All PL/SQL modules
  • 4.2.3 Setting Up User Accounts
  • 4.2.4 Configuring Oracle Administration Assistant for Windows
  • 4.2.5 Using Oracle9i Database Language and Definition Files with Oracle Database 11g
  • 4.2.6 Logging in to Oracle Enterprise Manager Database Control
• 4.3 Oracle Configuration Manager Postinstallation Configuration for Oracle RAC
  • 4.3.1 Additional Step for Oracle Enterprise Manager Grid Control
• 4.4 Enabling and Disabling Database Options
• 4.5 Using Earlier Oracle Database Releases with Oracle Grid Infrastructure
  • 4.5.1 General Restrictions for Using Earlier Oracle Database Releases
  • 4.5.2 Required Patches for Earlier Oracle Database Releases or Databases Being Upgraded
  • 4.5.3 Pinning Cluster Nodes for Oracle Database Release 10.2 or 11.1

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

• 5.1 About Parameter Files and Oracle RAC
• 5.2 Creating Server Parameter Files for Oracle RAC
• 5.3 Storage Requirements for the Server Parameter File in Oracle RAC
• 5.4 Parameter File Search Order in Oracle RAC
• 5.5 Migrating to an SPFILE in Oracle RAC Environments
• 5.6 Server Parameter File Errors in Oracle RAC

6 Configuring Server Pools and Oracle 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 Understanding the Database Control Implementation for Oracle RAC
• 6.3 Understanding EMCA and Enterprise Manager Control with Oracle RAC
• 6.4 Configuring Database Control During Installation
• 6.5 Configuring Database Control with DBCA
• 6.6 Configuring Database Control After Installation Using EMCA
  • 6.6.1 Using EMCA in Interactive Mode
  • 6.6.2 Using EMCA in Silent Mode With an Input File
• 6.7 Managing Database Control Using EMCA
  • 6.7.1 Changing the Database Control Implementation for Your Oracle RAC Database
  • 6.7.2 Updating Database Control Configuration When Adding and Removing Nodes
    • 6.7.2.1 Using EMCA After Adding Nodes to the Cluster
    • 6.7.2.2 Using EMCA After Removing Nodes from the Cluster
  • 6.7.3 Changing the Ports Used by Database Control
• 6.8 Enterprise Manager and EMCA Troubleshooting Tips
  • 6.8.1 Updating Database Control After Changing the Database Listener Port
  • 6.8.2 Upgrading Grid Control Agents for Oracle Database 11g Release 2
  • 6.8.3 Updating Database Control After Changing the Host Name or IP Address
  • 6.8.4 Using EMCA After Changing the TNS_ADMIN Configuration

7 Understanding the Oracle Real Application Clusters Installed Configuration

• 7.1 Understanding the Oracle RAC Configuration
• 7.2 Understanding Time Zone Settings on Cluster Nodes
• 7.3 Working with Multiple Oracle Home Directories on Windows
• 7.4 Understanding the Database Components Created by DBCA
  • 7.4.1 Tablespaces and Data Files
  • 7.4.2 Control Files
  • 7.4.3 Online Redo Log Files
• 7.5 Managing Undo Tablespaces in Oracle RAC
• 7.6 Using Initialization Parameter Files
• 7.7 Oracle Database Vault Default Audit Policy and Initialization Parameters
• 7.8 Understanding Oracle Net Services Configuration Files
  • 7.8.1 Database Services for an Oracle RAC Database
  • 7.8.2 Configuring the Listener Configuration File (listener.ora)
    • 7.8.2.1 Grid Naming Service and Listeners
    • 7.8.2.2 Local Listeners
    • 7.8.2.3 How Oracle Database Uses the Listener File (listener.ora)
    • 7.8.2.4 Configuring Multiple Listeners for Your Database Using DBCA
  • 7.8.3 Net Service Names (tnsnames.ora File)
    • 7.8.3.1 Net Service Names for Database Connections
    • 7.8.3.2 Net Service Name for Instance Connections
  • 7.8.4 Net Services Profile (sqlnet.ora File)
• 7.9 Using SCAN with Oracle RAC Databases
  • 7.9.1 Understanding SCAN
  • 7.9.2 Understanding SCAN Listeners and Listener Registration
  • 7.9.3 Understanding Failover, Load Balancing, and SCAN
  • 7.9.4 Understanding Shared Server Use in an Oracle RAC Database

8 Removing Oracle Real Application Clusters Software

• 8.1 Overview of Deinstallation Tools Actions
• 8.2 Identifying All Instances On a Cluster
• 8.3 Deinstalling Oracle RAC Software
  • 8.3.1 About the Deinstallation Tool
  • 8.3.2 Using the Deinstallation Tool 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 RAC Installation Errors
  • A.1.1 Verifying Requirements
  • A.1.2 Understanding How To Resolve Installation Errors
  • A.1.3 Locating the Log File For an Installation Session
• A.2 Resolving Oracle RAC Installations Errors
  • A.2.1 General Installation Issues
  • A.2.2 Performing Cluster Diagnostics During Oracle RAC Installations
  • A.2.3 Reviewing the Log of an Installation Session
• A.3 Troubleshooting Configuration Assistant Errors
  • A.3.1 Reviewing Configuration Assistant Errors
  • A.3.2 Identifying Configuration Assistant Failures
  • A.3.3 Resolving Irrecoverable Errors Reported by Configuration Assistants
• A.4 Troubleshooting Silent or Noninteractive Installations
• A.5 About Using CVU Cluster Healthchecks After Installation
• A.6 Cleaning Up After a Failed 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 Understanding How Response Files are Used During Installation
  • B.4.1 Deciding to Use Silent Mode or Response File Mode
  • B.4.2 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.6.1 Viewing the Help Information for OUI
  • B.6.2 Running OUI Using a Response File for Input
• B.7 Running Configuration Assistants Using Response Files
  • B.7.1 Running Oracle Database Configuration Assistant in Response File or Silent Mode
  • B.7.2 Running Oracle Net Configuration Assistant Using Response Files
  • B.7.3 About the Postinstallation Configuration File
  • B.7.4 Creating a Password Response File
  • B.7.5 Performing 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 Using DBCA
  • C.2.1 Converting Oracle Database 11g Installations to Oracle RAC Using DBCA
    • C.2.1.1 Use DBCA to Create an Image of the Single-Instance Database
    • C.2.1.2 Complete the 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 Database an Oracle RAC-Enabled Home
    • C.2.3.2 Single-Instance Database Using an Oracle RAC-Disabled Home
  • C.2.4 Converting an Oracle RAC One Node Database to an Oracle RAC Database
• 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 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 Postconversion 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 Back Up the Oracle RAC Database
• E.2 Shut Down Oracle RAC Databases
• E.3 Stop All Oracle Processes
  • E.3.1 Stopping Oracle Database Processes
  • E.3.2 Stopping Oracle Clusterware and Oracle ASM Instances

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 Control Ports
• F.6 Changing the Oracle XML DB Ports
• F.7 Changing the Oracle Services for Microsoft Transaction Server Port

G Oracle Enterprise Manager Configuration Assistant Reference

• G.1 About EMCA
  • G.1.1 Overview
  • G.1.2 Operational Notes
    • G.1.2.1 Usage Information
    • G.1.2.2 EMCA Parameters
    • G.1.2.3 Using Tool/Utility Help
• G.2 EMCA Command Reference
  • G.2.1 addInst
    • G.2.1.1 Syntax
    • G.2.1.2 Parameters/Options
  • G.2.2 addNode
    • G.2.2.1 Syntax
    • G.2.2.2 Parameters
    • G.2.2.3 Examples
  • G.2.3 config all db
    • G.2.3.1 Syntax
    • G.2.3.2 Parameters
  • G.2.4 config centralAgent
    • G.2.4.1 Syntax
    • G.2.4.2 Parameters
  • G.2.5 config dbcontrol db
    • G.2.5.1 Syntax
    • G.2.5.2 Options
    • G.2.5.3 Examples
  • G.2.6 deconfig all db
    • G.2.6.1 Syntax
    • G.2.6.2 Parameters
  • G.2.7 deconfig centralAgent
    • G.2.7.1 Syntax
    • G.2.7.2 Parameters
    • G.2.7.3 Examples
  • G.2.8 deconfig dbcontrol db
    • G.2.8.1 Syntax
    • G.2.8.2 Parameters
    • G.2.8.3 Examples
  • G.2.9 deleteInst
    • G.2.9.1 Syntax
    • G.2.9.2 Parameters
  • G.2.10 deleteNode
    • G.2.10.1 Syntax
    • G.2.10.2 Parameters
    • G.2.10.3 Examples
  • G.2.11 displayConfig dbcontrol
    • G.2.11.1 Syntax
    • G.2.11.2 Parameters
  • G.2.12 reconfig dbcontrol
    • G.2.12.1 Syntax
    • G.2.12.2 Parameters
    • G.2.12.3 Examples
  • G.2.13 reconfig ports
    • G.2.13.1 Syntax
    • G.2.13.2 Parameters
    • G.2.13.3 Examples
  • G.2.14 restore
    • G.2.14.1 Syntax
    • G.2.14.2 Parameters
  • G.2.15 upgrade
    • G.2.15.1 Syntax
    • G.2.15.2 Parameters
  • G.2.16 version
    • G.2.16.1 Syntax

Index