Contents

Title and Copyright Information

List of Figures

List of Tables

Send Us Your Comments

Preface

What's New in Real Application Clusters Setup and Configuration?

Part I Setup and Configuration of 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

The Installed Real Application Clusters Storage Components

Installation Overview

System Installation Requirements

Hardware and Software Requirements for Oracle9i Real Application Clusters

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

Recommended Tablespace and File Capacities

Configuring Logical Devices

Configuring Raw Volumes for Real Application Clusters on UNIX

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

Database Configuration Assistant Processing

Using the Pre-Configured Database Configuration Types

Using the Customized Database Configuration Type

Deinstalling Real Application Clusters with the Oracle Universal Installer

4 Creating Databases with the Database Configuration Assistant

Using the Database Configuration Assistant

Benefits of Using the Database Configuration Assistant

Creating the Database after Installation Using the Database Configuration Assistant

Creating a Real Application Clusters Database with the DBCA

Deleting a Database with the Database Configuration Assistant

Migrating or Upgrading to Release 2 (9.2)

Co-Existence of Oracle Versions on the Same Cluster

Co-Existence of Operating System-Dependent Clusterware 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 Undo Tablespaces

Configuring the Online Redo Log for Real Application Clusters

Creating a Database Manually

Install Oracle Products

Manually Create the Database

Creating Real Application Clusters Data Dictionary Views with CATCLUST.SQL

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 for Real Application Clusters

7 Configuration Highlights for Using Enterprise Manager in Real Application Clusters Environments

Server Management Architecture

Server Management Requirements

Understanding the Oracle Enterprise Manager Setup

Using the Console, Management Server, and Repository on the Same Machine

Using the Console, Management Server, and Repository on Separate Machines

Notes for Running the Console in Standalone Mode

Configuring Enterprise Manager for Real Application Clusters Management

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 Preferred Credentials in the Console

Using Oracle Performance Manager for Real Application Clusters Management

Task 1: Start Oracle Performance Manager

Task 2: Accessing Statistical Charts

Part III The Real Application Clusters Installed Configuration and High Availability

8 Understanding the Installed Configuration for Real Application Clusters

Understanding the Configured Environment

Shared Configuration File

Executing srvconfig on UNIX Platforms

Executing srvconfig on Windows Platforms

UNIX Operating System Configurations

Database Components Created Using the Database Configuration Assistant

Tablespaces and Datafiles

Redo Log Files

Control Files

Managing Undo Tablespaces

Initialization Parameter Files

Configuring Service Registration-Related Parameters in Real Application Clusters

Configuring the Listener File (listener.ora)

Nondefault Listeners

Multiple Listeners

How Oracle Uses the Listener (listener.ora File)

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

Primary/Secondary Instances

Overview of Primary and Secondary Instances

Initialization Parameter Configuration

Client Configuration

Listener Configuration

Connecting to Secondary Instances

Warming the Library Cache on the Secondary Instance

Real Application Clusters Guard II

Configuring Clients for Real Application Clusters

Implementation of Client Configurations

Testing the Oracle Net Configuration

Part IV Migrating to Real Application Clusters

10 Migrating to Real Application Clusters from Single-Instance Oracle Databases

Migrating from a Single Instance to Real Application Clusters

Deciding to Migrate

Preparing to Migrate

Migrating Databases from Single Instance to Cluster-Enabled Environments

Migrating with Raw Devices or Shared File Systems

Upgrading Oracle8i Configurations to Oracle9i Configurations

Part V Reference for Real Application Clusters Setup and Configuration

A Directory Structure for Real Application Clusters Environments

Understanding the Real Application Clusters Directory Structure

UNIX Directory Structures for Real Application Clusters

Windows Directory Structures for Real Application Clusters

Shared Oracle Home

B Troubleshooting Oracle Enterprise Manager in Real Application Clusters

Resolving Service Discovery Failures

Understanding Discovery

The UNIX oratab File and the Windows NT and Windows 2000 Registry

SRVM Configuration Repository

The listener.ora File

The tnsnames.ora File

The sqlnet.ora File

Discovery Results

Troubleshooting Discovery

Glossary

Index