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?

• Changes in Installation Documentation
• Changes in the Install Options
• New Components Available for Installation
• Enhancements and New Features for Installation
• Deprecated Components in Oracle Database 11g Release 1 (11.1)

1 Preinstallation Checklist

• 1.1 Before You Start: Planning your Installation
  • 1.1.1 Check OracleMetaLink
  • 1.1.2 Check Oracle Technical Network
  • 1.1.3 Review How to Use Cluster Verification Utility
  • 1.1.4 Review and Back Up Existing Oracle Installations
  • 1.1.5 Review Globalization Requirements
  • 1.1.6 Review Documentation
• 1.2 Server Hardware, Network and Operating System Overview
  • 1.2.1 Review Server Hardware and Software Requirements
  • 1.2.2 Server Environment Configuration Overview
  • 1.2.3 Oracle Base Overview
  • 1.2.4 Network Connections Overview
  • 1.2.5 Secure Shell (SSH) Configuration Overview
  • 1.2.6 Browser Requirement Overview
  • 1.2.7 Platform-Specific Server Configuration Overview
• 1.3 Oracle RAC Storage Overview
  • 1.3.1 Overview of Oracle Database and Recovery File Options
  • 1.3.2 General Storage Considerations for Oracle RAC
• 1.4 Additional Information to Prepare for Installation
  • 1.4.1 Oracle Clusterware and Vendor Clusterware
  • 1.4.2 Shared Components of Oracle RAC Installations
  • 1.4.3 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 Verifying System Readiness for installing Oracle Database with CVU
• 2.2 Reviewing Oracle Application Express Requirements
  • 2.2.1 Browser Requirements for Oracle Application Express
  • 2.2.2 Installing APEX with Existing Oracle HTML Server Installations
  • 2.2.3 Oracle Text Requirement for Oracle Application Express
  • 2.2.4 Oracle XML DB Requirement for Oracle Application Express
• 2.3 Selecting a Configuration Option
• 2.4 Automatic Storage Management Configuration
• 2.5 Preparing for a Rolling Upgrade of Automatic Storage Management
• 2.6 Oracle Database Vault Configuration
  • 2.6.1 Oracle Database Vault Requirements
  • 2.6.2 Oracle Database Vault Accounts
    • 2.6.2.1 Database Vault Owner
    • 2.6.2.2 Database Vault Account Manager
  • 2.6.3 Multiple Oracle Data Vault Homes
  • 2.6.4 Starting the Listener with Oracle Database Vault Installations
• 2.7 Oracle Database Configuration Type Descriptions
  • 2.7.1 General Purpose, Transaction Processing, and Data Warehouse Configuration Types
  • 2.7.2 Using the Advanced Configuration Type
• 2.8 Oracle Configuration Manager Option
• 2.9 Database Security Options
• 2.10 Selecting Database Passwords
• 2.11 Actions of OUI, DBCA, and Other Assistants During Installation
• 2.12 Installing Oracle Database with Other Languages
• 2.13 Selecting a Database Name
• 2.14 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

4 Oracle Real Application Clusters Postinstallation Procedures

• 4.1 Required Post-Installation Tasks
  • 4.1.1 Download and Install Patch Updates
  • 4.1.2 Configure Oracle Products
  • 4.1.3 Relocate Instance-related Memory-mapped files from OCFS2 Using Symbolic Links
• 4.2 Recommended Post-Installation Tasks
  • 4.2.1 Recommended Database Post-Installation 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.2.2 Relocate Instance-related Memory-mapped files from OCFS Using Symbolic Links
  • 4.2.3 Logging in to Oracle Enterprise Manager Database Control
• 4.3 Oracle Configuration Manager Postinstallation Configuration for Oracle RAC
• 4.4 Oracle Database Vault Postinstallation with DVCA for Oracle RAC
• 4.5 Upgrading 10.2.0.3 Databases with Oracle Database Vault to Oracle Database 11g

5 Oracle Application Express Postinstallation Tasks

• 5.1 Restarting Application Express Processes After an Upgrade
• 5.2 Patching Oracle Application Express 3.0
• 5.3 Choosing an HTTP Server
  • 5.3.1 Selecting an HTTP Server in an Oracle RAC Environment
  • 5.3.2 About Oracle HTTP Server and mod_plsql
• 5.4 Copying the Images Directory
  • 5.4.1 Copying the Images Directory After an Upgrade
  • 5.4.2 Copying the Images Directory After a New Installation
• 5.5 Configuring Oracle HTTP Server in a New Installation
  • 5.5.1 Security Considerations for Oracle HTTP Server
  • 5.5.2 Configuring Oracle HTTP Server Release 9.0.3 in a New Installation
    • 5.5.2.1 Changing the Password for the ADMIN Account
    • 5.5.2.2 Changing the Password for the APEX_PUBLIC_USER Database User
    • 5.5.2.3 Modifying the wdbsvr.app File in a New Installation
    • 5.5.2.4 Modifying the Oracle9i httpd.conf File
  • 5.5.3 Configuring Oracle HTTP Server or Oracle Application Server in a New Installation
    • 5.5.3.1 Changing the Password for the ADMIN Account
    • 5.5.3.2 Changing the Password for the APEX_PUBLIC_USER Database User
    • 5.5.3.3 Edit the dads.conf File
  • 5.5.4 Stopping and Restarting Oracle HTTP Server
  • 5.5.5 Installing Oracle Application Express in Other Languages
  • 5.5.6 Managing JOB_QUEUE_PROCESSES
    • 5.5.6.1 Viewing the Number of JOB_QUEUE_PROCESSES
    • 5.5.6.2 Changing the Number of JOB_QUEUE_PROCESSES
  • 5.5.7 Obfuscating PlsqlDatabasePassword Parameter
    • 5.5.7.1 Obfuscating Passwords
  • 5.5.8 Logging In to Oracle Application Express
    • 5.5.8.1 Oracle Application Express User Roles
    • 5.5.8.2 Setting Up Your Local Environment
• 5.6 Enabling Network Services in Oracle Database 11g
  • 5.6.1 Granting Connect Privileges
• 5.7 Troubleshooting an Invalid ACL Error

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

• 6.1 Parameter Files and Oracle RAC
• 6.2 Using Server Parameter Files with Oracle RAC
  • 6.2.1 Location of the Server Parameter File
• 6.3 Parameter File Search Order in Oracle RAC
• 6.4 Migrating to the SPFILE in Oracle RAC Environments
  • 6.4.1 Server Parameter File Placement in Oracle RAC
  • 6.4.2 Procedures for Migrating to the Server Parameter File
• 6.5 Server Parameter File Errors in Oracle RAC

7 Understanding the Oracle Real Application Clusters Installed Configuration

• 7.1 Understanding the Configured Environment in Oracle RAC
• 7.2 Oracle Cluster Registry in Oracle RAC
• 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 Vault Default Audit Policy and Initialization Parameters
• 7.8 Configuring Service Registration-Related Parameters
• 7.9 Configuring the Listener File (listener.ora)
  • 7.9.1 Local Listeners
  • 7.9.2 Multiple Listeners
  • 7.9.3 How Oracle Database Uses the Listener (listener.ora File)
    • 7.9.3.1 Listener Registration and PMON Discovery
• 7.10 Net Service Names (tnsnames.ora File)
• 7.11 Net Services Profile (sqlnet.ora File)

8 Removing Oracle RAC and ASM Software

• 8.1 Overview of Deinstallation Procedures
• 8.2 Identifying All Instances On a Cluster
• 8.3 Deinstalling Oracle RAC Software
  • 8.3.1 Deinstalling Oracle RAC and ASM Using Configuration Assistants
  • 8.3.2 Deinstalling Oracle Clusterware
• 8.4 Removing Oracle Software

A Troubleshooting the Oracle Real Application Clusters Installation Process

• A.1 Troubleshooting the Oracle Real Application Clusters Installation
  • 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

B Using Scripts to Create Oracle Real Application Clusters Databases

• B.1 Using DBCA to generate Installation Scripts for Oracle RAC
• B.2 Using DBCA Noninteractive (Silent) Configuration for Oracle RAC

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 on a Cluster Running from a Cluster-Enabled Oracle Home
    • C.2.2.2 Single Instance on a Cluster Running from an Oracle RAC-Disabled Oracle Home
    • C.2.2.3 Single Instance on a Cluster Running from a Single-Instance Installed Oracle Home
  • C.2.3 Converting Single-Instance ASM to Cluster ASM Using DBCA
• 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 an rconfig XML Input File for ConvertToRAC
• C.6 Converting Single-Instance ASM to Oracle RAC Using RCONFIG
• C.7 Example of an rconfig XML Input File for ConvertToASM
• C.8 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 Clusterware or Cluster Ready Services Processes
  • E.3.2 Stopping Oracle Database Processes Before Adding Products or Upgrading

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 iSQL*Plus Ports
• F.7 Changing the Oracle Ultra Search Ports
• F.8 Changing the Oracle XML DB Ports

Index