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 Network Connections Overview
  • 1.2.3 Platform-Specific Server Configuration Overview
• 1.3 Shared Storage Overview
• 1.4 Additional Information to Prepare for Installation
  • 1.4.1 Oracle Clusterware and Vendor Clusterware
  • 1.4.2 Shared Components of Oracle Real Application Clusters Installations
  • 1.4.3 Oracle Database 11g Real Application Clusters Release Compatibility
  • 1.4.4 Preinstallation Requirements for Oracle Configuration Manager

2 Installing Oracle Database with Oracle Real Application Clusters

• 2.1 Verifying System Readiness for Installing the Oracle Database with CVU
  • 2.1.1 Troubleshooting Installation Setup for Windows
• 2.2 Oracle Database Configuration Type Descriptions
  • 2.2.1 General Purpose, Transaction Processing, and Data Warehouse Configuration Types
  • 2.2.2 Using the Advanced Configuration Type
• 2.3 Oracle Configuration Manager Option
• 2.4 Actions of OUI, DBCA, and Other Assistants During Installation
• 2.5 Database Security Options
• 2.6 Installation of Oracle RAC Using Oracle Universal Installer
• 2.7 Installation on Windows-Based Systems with the Minimum Memory Requirements
• 2.8 Deinstalling Oracle Real Application Clusters Software
  • 2.8.1 Deinstalling Oracle Database with Oracle RAC Software
  • 2.8.2 Deinstalling Automatic Storage Management

3 Creating Oracle RAC Databases with the Database Configuration Assistant

• 3.1 Using Database Configuration Assistant with Oracle RAC
• 3.2 Benefits of Using Database Configuration Assistant
• 3.3 Verifying DBCA Requirements
• 3.4 Creating an Oracle RAC Database with DBCA
• 3.5 Automatic Listener Migration from Earlier Releases
• 3.6 Deleting an Oracle Real Application Clusters Database with DBCA

4 Oracle Real Application Clusters Post-Installation Procedures

• 4.1 Required Post-Installation Tasks
  • 4.1.1 Back Up the Voting Disk after Installation
  • 4.1.2 Download and Install Patches
  • 4.1.3 Configure Oracle Products
• 4.2 Recommended Post-Installation Tasks
  • 4.2.1 Verifying Enterprise Manager Operations
  • 4.2.2 Logging in to Oracle Enterprise Manager Database Control
  • 4.2.3 Postinstallation Database Configuration for Oracle Configuration Manager
    • 4.2.3.1 Additional Step for E-Business Suites
    • 4.2.3.2 Additional Step for Oracle Enterprise Manager Grid Control

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 Unlocking the APEX_PUBLIC_USER Database User
    • 5.5.2.3 Changing the Password for the APEX_PUBLIC_USER Database User
    • 5.5.2.4 Modifying the wdbsvr.app File in a New Installation
    • 5.5.2.5 Modifying the Oracle9i httpd.conf
  • 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 Parameter Management for Oracle Real Application Clusters Databases

• 6.1 Parameter Files and Oracle Real Application Clusters
• 6.2 Using Server Parameter Files in Oracle Real Application Clusters
  • 6.2.1 Location of the Server Parameter File
• 6.3 Parameter File Search Order in Oracle Real Application Clusters
• 6.4 Server Parameter File Errors in Oracle Real Application Clusters

7 Understanding the Oracle Real Application Clusters Installed Configuration

• 7.1 Understanding the Configured Environment in Oracle Real Application Clusters
• 7.2 The Oracle Cluster Registry in Oracle Real Application Clusters
• 7.3 Database Components Created Using Database Configuration Assistant
  • 7.3.1 Tablespaces and Datafiles
  • 7.3.2 Control Files
  • 7.3.3 Redo Log Files
• 7.4 Managing Undo Tablespaces in Oracle Real Application Clusters
• 7.5 Initialization Parameter Files
• 7.6 Configuring Service Registration-Related Parameters in Oracle Real Application Clusters
• 7.7 Configuring the Listener File (listener.ora)
  • 7.7.1 Local Listeners
  • 7.7.2 Multiple Listeners
  • 7.7.3 How Oracle Uses the Listener (listener.ora File)
    • 7.7.3.1 Listener Registration and PMON Discovery
• 7.8 Net Service Names (tnsnames.ora File)
• 7.9 Net Services Profile (sqlnet.ora File)

8 Removing Oracle Database Software

• 8.1 Removing Oracle Configuration Manager
• 8.2 Removing Oracle Cluster Synchronization Services
• 8.3 Removing Oracle Application Express from the Database
• 8.4 Removing All Oracle Database Components
  • 8.4.1 Stopping Oracle Services
  • 8.4.2 Removing Components with Oracle Universal Installer
  • 8.4.3 Manually Removing the Remaining Oracle Database Components
    • 8.4.3.1 Removing an Automatic Storage Management Instance
    • 8.4.3.2 Updating the System Variable Path
    • 8.4.3.3 Removing Oracle from the Start Menu
    • 8.4.3.4 Removing Oracle Directories

A Troubleshooting the Installation Process

• A.1 Troubleshooting Oracle RAC Installations
  • A.1.1 General Installation Issues
  • A.1.2 Oracle Real Application Clusters Installation Error Messages
  • A.1.3 Performing Cluster Diagnostics During Oracle Real Application Clusters Installations
• A.2 Verifying Requirements
• A.3 Encountering Installation Errors
• A.4 Reviewing the Log of an Installation Session
• A.5 Silent or Noninteractive Installation Response File Error Handling
• A.6 Troubleshooting Oracle Configuration Manager
• A.7 Troubleshooting Configuration Assistants
  • A.7.1 Configuration Assistant Failures
  • A.7.2 Fatal Errors
• A.8 Cleaning Up After a Failed Installation
• A.9 Images Displaying Incorrectly in Oracle Application Express
• A.10 Online Help Not Working

B Stopping Processes in Oracle Real Application Clusters Databases

• B.1 Back Up the Oracle Real Application Clusters Database
• B.2 Shut Down Oracle Real Application Clusters Databases
• B.3 Stop All Oracle Processes
  • B.3.1 Stopping Oracle Clusterware or Cluster Ready Services Processes
  • B.3.2 Stopping Oracle Database 11g Processes Before Adding Products or Upgrading

C Managing Oracle Database Port Numbers

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

D Using Scripts to Create Oracle Real Application Clusters Databases

• D.1 Creating a Database Using Scripts

E Directory Structure for Oracle Real Application Clusters Environments

• E.1 Understanding the Oracle Real Application Clusters Directory Structure
• E.2 Directory Structures for Oracle Real Application Clusters

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

• F.1 Prerequisites for Conversion
• F.2 Single-Instance to Cluster-Enabled Conversion Administrative Issues
• F.3 Converting from Single-Instance to Oracle Real Application Clusters
  • F.3.1 Single Instance on a Non-Cluster computer to Oracle Database 11g with RAC
    • F.3.1.1 Back up the Original Single-Instance Database
    • F.3.1.2 Perform the Pre-Installation Steps
    • F.3.1.3 Set up the Cluster
    • F.3.1.4 Validate the Cluster
    • F.3.1.5 Copy the Preconfigured Database Image
    • F.3.1.6 Install Oracle Database 11g Software with Oracle Real Application Clusters
  • F.3.2 Single Instance on a Cluster to Oracle Database 11g RAC
    • F.3.2.1 Single Instance on a Cluster Running from a Cluster Enabled Oracle Home
• F.4 Post-Conversion Steps

G Optimal Flexible Architecture

• G.1 Overview of the Optimal Flexible Architecture Standard
• G.2 Changes to the Optimal Flexible Architecture for Oracle Database 11g
• G.3 Directory Tree Differences by Release
  • G.3.1 Top-Level Oracle Directory
  • G.3.2 Database File Names
  • G.3.3 Database File Name Extensions
• G.4 Optimal Flexible Architecture Directory Naming Conventions
  • G.4.1 ORACLE_BASE Directory
  • G.4.2 ORACLE_HOME Directory
  • G.4.3 ADMIN Directory
  • G.4.4 ORADATA Directory
  • G.4.5 FLASH_RECOVERY_AREA Directory
• G.5 Optimal Flexible Architecture and Multiple Oracle Home Configurations
  • G.5.1 Specifying an ORACLE_HOME Directory
  • G.5.2 Installing a Default Optimal Flexible Architecture Database: Example
  • G.5.3 Installing a Nondefault Optimal Flexible Architecture Database: Example 2
• G.6 Comparison Between Optimal Flexible Architecture on Windows and UNIX
  • G.6.1 Directory Naming
  • G.6.2 ORACLE_BASE Directory
  • G.6.3 Support for Symbolic Links on Windows

H Country Codes for Oracle Configuration Manager

• H.1 Valid Country Codes

I Troubleshooting and Removing Oracle Configuration Manager Software

• I.1 Troubleshooting Oracle Configuration Manager
• I.2 Removing Oracle Configuration Manager

Index