Contents

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 Database 11g Release 2 (11.2)
• New Features for Oracle Database 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 Check Oracle Technical Network
  • 1.1.3 Review Installation Steps for Oracle RAC
  • 1.1.4 Review How to Use Cluster Verification Utility
  • 1.1.5 Review and Back Up Existing Oracle Installations
  • 1.1.6 Review Globalization Requirements
  • 1.1.7 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 Configuring Internode Communication
  • 1.2.5 Overview of Browser Requirements
  • 1.2.6 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 Additional Information to Prepare for Installation
  • 1.4.1 Oracle ASM is Installed with Oracle Grid Infrastructure
  • 1.4.2 Shared Components of Oracle RAC Installations
  • 1.4.3 Simplified Upgrade of TIMESTAMP WITH TIME ZONE Data
  • 1.4.4 Oracle Database 11g Real Application Clusters Release Compatibility
• 1.5 Confirming Cluster Readiness for Oracle RAC Installation with CVU
• 1.6 Installing Oracle RAC on Systems with Coexisting Databases
  • 1.6.1 Installing Oracle Database 11g on a System with Oracle Database 10g
  • 1.6.2 Installing Oracle 11g Database on a System with Oracle9i Database Release 2

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 Oracle Database Configuration Type Descriptions
  • 2.4.1 General Purpose and Transaction Processing, and Data Warehouse Configuration Types
  • 2.4.2 Using the Advanced Database Configuration Type
  • 2.4.3 Installing Oracle Database with Other Languages
• 2.5 Oracle Database Vault Option
• 2.6 Oracle Configuration Manager Option
• 2.7 Selecting a Database Name
• 2.8 Selecting Database Passwords
• 2.9 Database Security Options
• 2.10 Actions of OUI and DBCA During Installation
  • 2.10.1 Managing Database Services After Installation
  • 2.10.2 Installing Older NLS Compatibility Definition Files
• 2.11 Installing Oracle Database Vault
• 2.12 Using Oracle Universal Installer to Install Oracle RAC

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 Verifying Requirements for DBCA
• 3.5 Creating an Oracle RAC Database with DBCA
• 3.6 Deleting an Oracle RAC Database with DBCA
• 3.7 Configuring Database Control During Installation

4 Oracle Real Application Clusters Postinstallation Procedures

• 4.1 Required Postinstallation Tasks
  • 4.1.1 Download and Install Patch Updates
  • 4.1.2 Configure Exceptions for the Windows Firewall
  • 4.1.3 Configure Oracle Products
    • 4.1.3.1 Configuring Oracle Database Vault
    • 4.1.3.2 Configuring Oracle Database Security Settings
  • 4.1.4 Configure Storage for External Tables, Shared Files, or Directory Objects
• 4.2 Recommended Postinstallation Tasks
  • 4.2.1 Recompile all PL/SQL modules
  • 4.2.2 Set Up User Accounts
  • 4.2.3 Configuring Oracle Administration Assistant for Windows
  • 4.2.4 Using Oracle9i Language and Definition Files with Oracle Database 11g
• 4.3 Enabling and Disabling Database Options
• 4.4 Oracle Configuration Manager Postinstallation Configuration for Oracle RAC
  • 4.4.1 Additional Step for Oracle Enterprise Manager Grid Control

5 Configuring Server Parameter Files in Oracle RAC

• 5.1 About the Server Parameter File
• 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 the SPFILE in Oracle RAC Environments
• 5.6 Server Parameter File Errors in Oracle RAC

6 Configuring Server Pools and Enterprise Manager Database Control

• 6.1 Understanding Server Pools
  • 6.1.1 Policy-based Cluster and Capacity Management
• 6.2 Configuring Enterprise Manager Database Control
  • 6.2.1 Understanding EMCA with Oracle RAC
  • 6.2.2 Using DBCA to Configuring an Existing Database to Use Database Control
  • 6.2.3 Configuring Database Control After Installation Using EMCA
  • 6.2.4 Reconfiguring Existing Database Control Configurations on Remote Nodes
  • 6.2.5 Updating Database Control Configuration When Adding and Removing Nodes
  • 6.2.6 Using an Input File for EMCA Parameters
  • 6.2.7 Specifying the Ports Used By Database Control
  • 6.2.8 EMCA Troubleshooting Tips
    • 6.2.8.1 Using EMCA After Changing the Database Listener Port
    • 6.2.8.2 Upgrading Grid Control Agents for Oracle Database 11g Release 2
    • 6.2.8.3 Using EMCA After Changing the Database Host Name or IP Address
    • 6.2.8.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 Working with Multiple Oracle Home Directories on Windows
• 7.3 Database Components Created Using Database Configuration Assistant
  • 7.3.1 Tablespaces and Data files
  • 7.3.2 Control Files
  • 7.3.3 Redo Log Files
• 7.4 Managing Undo Tablespaces in Oracle RAC
• 7.5 Initialization Parameter Files
• 7.6 Oracle Database Default Audit Policy and Initialization Parameters
• 7.7 Understanding Service Registration-Related Parameters
  • 7.7.1 Understanding Single Client Access Name (SCAN) and Load-balancing
  • 7.7.2 Understanding Load-Balancing, Failover, and High Availability
• 7.8 Configuring the Listener File (listener.ora)
  • 7.8.1 Grid Naming Service (GNS) and Listeners
  • 7.8.2 Local Listeners
  • 7.8.3 Multiple Listeners
  • 7.8.4 How Oracle Database Uses the Listener File (listener.ora)
    • 7.8.4.1 Listener Registration and PMON Discovery
• 7.9 Net Service Names (tnsnames.ora File)
  • 7.9.1 Net Service Names for Database Connections
  • 7.9.2 Net Service Name Instance Connections
  • 7.9.3 tnsnames.ora Example File
• 7.10 Net Services Profile (sqlnet.ora File)

8 Removing Oracle Real Application Clusters Software

• 8.1 Overview of the Deinstall Tool
• 8.2 Deinstalling Oracle RAC Software
  • 8.2.1 About the Deinstallation Tool
  • 8.2.2 Example of Running the Deinstall Command for Oracle RAC
  • 8.2.3 Example of a Deinstallation Parameter File for Oracle RAC

A Troubleshooting the Oracle Real Application Clusters Installation

• A.1 General Installation Issues
• A.2 Oracle RAC Installation Error Messages
• A.3 Performing Cluster Diagnostics During Oracle RAC Installations
• A.4 Resolving Oracle RAC Installation Errors
  • A.4.1 Verifying Requirements
  • A.4.2 Resolving Installation Errors
  • A.4.3 Reviewing the Log of an Installation Session
• A.5 Troubleshooting Configuration Assistant Errors
  • A.5.1 Configuration Assistant Failures
  • A.5.2 Fatal Errors Reported by Configuration Assistants
• A.6 Silent or Noninteractive Installation Response File Error Handling
• A.7 Cleaning Up After a Failed Installation

B Installing and Configuring Oracle Real Application Clusters Using Response Files

• B.1 Using DBCA to generate Installation Scripts for Oracle RAC
• B.2 Using DBCA Noninteractive (Silent) Configuration for Oracle RAC
• B.3 How Response Files Work
  • B.3.1 Deciding to Use Silent Mode or Response File Mode
  • B.3.2 General Procedure for Using Response Files
• B.4 Creating the inst_loc Registry Entry
• B.5 Preparing a Response File
  • B.5.1 Editing a Response File Template
  • B.5.2 Recording a Response File
• B.6 Running the Installer Using a Response File
• B.7 Running Net Configuration Assistant Using a Response File
• B.8 Running Configuration Assistants Using Response Files
  • B.8.1 About the 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 a Response File
  • B.9.1 About the Postinstallation Configuration File
  • B.9.2 Running Postinstallation Configuration Using a Response File

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

• C.1 Administrative Issues for Converting Databases to Oracle RAC
• C.2 Converting to Oracle RAC 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 using DBCA
    • C.2.2.1 Single Instance Database on a Cluster Running from a Cluster-Enabled Oracle Home
    • C.2.2.2 Single Instance Database on a Cluster Running from a Single-Instance Installed Oracle Home
• 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 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 Before Adding Products or Upgrading
  • E.3.2 Stopping Oracle Clusterware or Cluster Ready Services Processes

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 Enterprise Management Agent Port
• F.5 Changing the Oracle Enterprise Manager Database Console Ports
• F.6 Changing the Oracle XML DB Ports

G Enterprise Manager Configuration Assistant (EMCA) Reference

• About EMCA
  • Overview
  • Operational Notes
• EMCA Command Reference
  • addInst
  • addNode
  • config all db
  • config centralAgent
  • config dbcontrol db
  • deconfig all db
  • deconfig centralAgent
  • deconfig dbcontrol db
  • deleteInst
  • deleteNode
  • displayConfig dbcontrol
  • reconfig dbcontrol
  • reconfig ports
  • restore
  • upgrade
  • version

Index