Contents

Title and Copyright Information

List of Figures

List of Tables

Send Us Your Comments

Preface

What's New in Installation and Configuration?

Part I Installing Oracle9i Real Application Clusters

1 Introduction to Real Application Clusters Installation and Configuration

Real Application Clusters Software Components

The Oracle9i Enterprise Edition and Oracle9i Real Application Clusters

The Operating System-Dependent Clusterware

The Oracle Universal Installer and Real Application Clusters

Server Management and Performance Manager for Real Application Clusters

The Installed Real Application Clusters Storage Components

Installation Overview

System Installation Requirements

Hardware and Software Requirements for Oracle9i Real Application Clusters

Hardware

Software

Supported Interconnect Software

Version Compatibility

2 Configuring the Shared Disks

Configuring Shared Disk Subsystems for Real Application Clusters

The Configuration Raw Device

Additional Raw Devices Required by the DBCA

Planning Your Raw Device Creation Strategy

DBCA Database Configuration Options

Special Considerations for UNIX: Using Veritas Volume Manager

Recommended Tablespace and File Capacities

Configuring Logical Devices

Configuring Raw Volumes for Real Application Clusters on UNIX

UNIX Preinstallation Steps

Configuring Logical Drives on Windows NT and Windows 2000

3 Using the Oracle Universal Installer for Real Application Clusters

Starting the Oracle Universal Installer

Selecting a Database Configuration Type

Descriptions for Using the Configuration Types in Real Application Clusters

The General Purpose, Transaction Processing, and Data Warehouse Configuration Types

Using The Customized Configuration Type

Oracle Database Configuration Assistant Processing

Using the General Purpose, Transaction Processing, and Data Warehouse Database Configuration Types

Using the Customized Database Configuration Type

4 Creating Databases with the Oracle Database Configuration Assistant

Using the Database Configuration Assistant

Benefits of Using the Oracle Database Configuration Assistant

Creating the Database after Installation Using the Database Configuration Assistant

Creating a Real Application Clusters Database with the DBCA

UNIX Clusterware Diagnostics

Windows NT and Windows 2000 Clusterware Diagnostics

Deleting a Database with the Database Configuration Assistant

Migrating or Upgrading to Release 1 (9.0.1)

Co-Existence of Oracle Versions on the Same Cluster

Co-Existence of Operating System-Dependent Layers on Windows Platforms

Rolling Upgrades

Multiple Oracle Homes

5 Manually Creating Real Application Clusters Databases

Setting CREATE DATABASE Options for Cluster-Enabled Environments

Setting MAXINSTANCES

Setting MAXLOGFILES and MAXLOGMEMBERS

Setting MAXLOGHISTORY

Setting MAXDATAFILES

Setting ARCHIVELOG Mode

Changing Values for CREATE DATABASE Options

Database Objects to Support Clusters

Creating Additional Rollback Segments (Optional)

Using Private Rollback Segments

Using Public Rollback Segments

Configuring the Online Redo Log for Real Application Clusters

Creating Threads

Disabling Threads

Setting the Log Mode

Changing the Redo Log

Creating a Database Manually

Install Oracle Products

Manually Create the Database

Task 1: Back Up Existing Databases

Task 2: Specify the Database and Instance Settings

Task 3: Create the Real Application Clusters Configuration with SRVCTL

Task 4: Configure the oratab File on UNIX

Task 5: Set ORACLE_SID for Each Node

Task 6: Create the Persistent Initialization Parameter File

Task 7: Create the Password Files

Task 8: Prepare a Cluster CREATE DATABASE Script

Task 9: Create the Database

Task 10: Back Up the Database

Task 11: Configure Oracle Net on All Nodes

6 Configuring the Server Parameter File in Real Application Clusters Environments

Parameter Files and Real Application Clusters

Using The Server Parameter File in Real Application Clusters

Location of The Server Parameter File

Parameter File Search Order

Migrating to the Server Parameter File in Real Application Clusters Environments

Server Parameter File Placement in Real Application Clusters

Procedures for Migrating to the Server Parameter File

Server Parameter File Errors

Backing Up the Server Parameter File

Part II Oracle Enterprise Manager Installation Highlights

7 Installation and Configuration Highlights for Oracle Enterprise Manager in Real Application Clusters

Server Management Architecture

SRVM Requirements

Understanding the Oracle Enterprise Manager Setup

Console, Management Server, and Repository on Same Machine

Console, Management Server, and Repository on Separate Machines

Installing and Configuring Oracle Enterprise Manager in Real Application Clusters

Task 1: Oracle Enterprise Manager Installation

Task 2: Specify Preferred Credentials for Nodes and Database

Task 3: Create an Operating System Account

Task 4: Grant SYSDBA or SYSOPER Privileges to a Database User

Task 5: Set User Credentials in the Console

Configuring Oracle Performance Manager

Task 1: Start Oracle Performance Manager

Task 2: Accessing Statistical Charts

Instances Folder

Databases Folder

Additional Notes for Running the Console in Stand-Alone Mode

Part III Managing the Configuration

8 Understanding The Installed Configuration for Real Application Clusters

Understanding the Configured Environment

Raw Device Configuration

Executing srvconfig on UNIX Platforms

Executing srvconfig on Windows Platforms

UNIX Operating System Configurations

oratab File on UNIX

Database Components Created Using the Oracle Database Configuration Assistant

Tablespaces and Datafiles

Redo Log Files

Control Files

Managing Undo Tablespaces

Initialization Parameter Files

Shared Server Configuration

Dedicated Server Configuration

Configuring the Listener File (listener.ora)

Nondefault Listeners

Multiple Listeners

How Oracle Uses the Listener (listener.ora File)

Listener Registration and PMON Discovery

Directory Server Access (ldap.ora File)

Net Service Names (tnsnames.ora File)

Profile (sqlnet.ora File)

9 Configuring High Availability Features for Real Application Clusters

Transparent Application Failover

FAILOVER_MODE Parameters

TAF Implementation

Transparent Application Failover Verification

Primary and Secondary Instances

Overview of Primary and Secondary Instances

Initialization File Configuration

Client Configuration

Listener Configuration

Connecting to Secondary Instances

Warming the Library Cache on the Secondary Instance

Configuring Clients for Real Application Clusters

Implementation of Client Configurations

Testing the Oracle Net Configuration

Part IV Migration

10 Migrating to Real Application Clusters

Moving from a Single Instance to Real Application Clusters

Deciding to Migrate

Preparing to Migrate

Hardware and Software Requirements

Administrative Issues of Migrating Your Application from a Single Instance to a Cluster-Enabled Environment

Migrating Databases from Single Instance to Cluster-Enabled Environments

Task 1: Configure Hardware

Task 2: Create Raw Devices

Task 3: Evaluate Tablespaces and Log Files of Single Instance

Task 4: Export Data from Old Database

Task 5: Install Operating System-Dependent Cluster Software

Task 6: Install Oracle9i Enterprise Edition and Oracle9i Real Application Clusters

Task 7: Create the Database

Task 8: Import from Old Database into New Database

Task 9: Adjust Parameters

Task 9: Start the Database

Migrating to Real Application Clusters When Using Raw Devices or Shared File Systems

Migrating Oracle8i Configurations to Oracle9i

Part V Reference

A Directory Structure for Real Application Clusters Environments

Understanding the Real Application Clusters Directory Structure

UNIX Directory Structure for Real Application Clusters

Windows NT and Windows 2000 Directory Structure for Real Application Clusters

Shared Oracle Home

B Oracle Enterprise Manager in Real Application Clusters Reference

Resolving Service Discovery Failures

Understanding Discovery

oratab on UNIX and Registry on Windows NT/Windows 2000

tnsnames.ora

Discovery Results

Troubleshooting Discovery

Glossary

Index