Contents

Title and Copyright Information

List of Figures

List of Tables

Send Us Your Comments

Preface

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

Part I Setup and Configuration of Oracle9i Real Application Clusters

1 Introduction to Real Application Clusters Setup and Configuration

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 Components

Real Application Clusters Installation Overview

System Installation Requirements for Real Application Clusters

Hardware and Software Requirements for Oracle9i Real Application Clusters

Supported Interconnect Software

Version Compatibility in Real Application Clusters Databases

2 Configuring Shared Disks for Real Application Clusters

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

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 to Install Real Application Clusters

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 Cluster Databases with the Database Configuration Assistant

Using the Database Configuration Assistant in Real Application Clusters

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 Real Application Clusters Database with the DBCA

Upgrading to Release 2 (9.2)

Co-Existence of Oracle Versions on the Same Cluster

Rolling Upgrades

Multiple Oracle Homes

5 Manually Creating Real Application Clusters Databases

Setting Real Application Clusters CREATE DATABASE Options

Setting MAXINSTANCES

Setting MAXLOGFILES and MAXLOGMEMBERS

Setting MAXLOGHISTORY

Setting MAXDATAFILES

Setting ARCHIVELOG Mode

Changing Values for CREATE DATABASE Options

Database Objects to Support Clusters

Using Automatic Undo Management

Using Manual Undo Management

Configuring the Online Redo Log for Real Application Clusters

Creating a Database Manually

Install Oracle Products

Manually Create the Database

Create the Real Application Clusters Data Dictionary Views with CATCLUST.SQL

Database Password and Role Management in Real Application Clusters

6 Configuring the Server Parameter File in Real Application Clusters Environments

Parameter Files and Real Application Clusters

Using Server Parameter Files in Real Application Clusters

Location of The Server Parameter File

Parameter File Search Order in Real Application Clusters

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

Backing Up the Server Parameter File in Real Application Clusters

Part II Oracle Enterprise Manager Installation Highlights for Real Application Clusters

7 Configuration Highlights for Enterprise Manager in Real Application Clusters Environments

Server Management Architecture for Enterprise Manager in Real Application Clusters

Server Management Requirements for Enterprise Manager in Real Application Clusters

Understanding the Enterprise Manager Setup in Real Application Clusters

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 Real Application Clusters Installed Configuration

Understanding the Configured Environment in Real Application Clusters

Shared Configuration File in Real Application Clusters

Executing srvconfig on UNIX Platforms

Executing srvconfig on Windows Platforms

UNIX oratab Configurations for Real Application Clusters

Database Components Created Using the Database Configuration Assistant

Tablespaces and Datafiles

Control Files

Redo Log Files

Managing Undo Tablespaces in Real Application Clusters

Initialization Parameter Files

Configuring Service Registration-Related Parameters in Real Application Clusters

Configuring the Listener File (listener.ora)

Local 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 Clients and High Availability Features for Real Application Clusters

Configuring Clients for Real Application Clusters

Implementation of Client Configurations

Testing the Oracle Net Configuration

Transparent Application Failover in Real Application Clusters

FAILOVER_MODE Parameters

TAF Implementation in Real Application Clusters

Primary/Secondary Instance Feature in Real Application Clusters

Configuring the Primary/Secondary Instance Feature

Client Configuration in Primary/Secondary Instance Configurations

Listener Configuration in Primary/Secondary Instance Configurations

Connecting to Secondary Instances in Primary/Secondary Instance Configurations

Warming the Library Cache on the Secondary Instance

Real Application Clusters Guard II

Part IV Converting to Real Application Clusters

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

Considerations Before Converting

Deciding to Convert

Prerequisites for Conversion

Single-Instance to Cluster-Enabled Conversion Administrative Issues

Converting from Single-Instance to Real Application Clusters

Single Instance on a Non-Cluster Machine to Oracle9i Real Application Clusters

Single Instance on a Cluster to Oracle9i Real Application Clusters

Post-Conversion Steps

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 Homes in Real Application Clusters

B Troubleshooting Oracle Enterprise Manager in Real Application Clusters

Resolving Service Discovery Failures in Real Application Clusters

Understanding Discovery in Real Application Clusters

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

Troubleshooting Discovery in Real Application Clusters

Glossary

Index