Contents

Title and Copyright Information

List of Figures

List of Tables

Send Us Your Comments

Preface

Intended Audience

Structure

Related Documents

Conventions

Documentation Accessibility

Documentation Sales

1 Introduction

1.1 Benefits of Oracle Real Application Clusters Guard

1.2 Components for Running Oracle Real Application Clusters Guard

1.2.1 Microsoft Cluster Server Software and Microsoft Cluster Hardware

1.2.2 Oracle Real Application Clusters Software

1.2.3 Oracle Real Application Clusters Guard Software

1.3 Oracle Real Application Clusters Guard Ease-of-Use Features

1.4 A Typical Oracle Real Application Clusters Guard Configuration

2 Concepts

2.1 Cluster Resources, Groups, and Virtual Addresses

2.1.1 Cluster Resources

2.1.2 Resource Types

2.1.3 Groups

2.1.3.1 Preferred Owner Node

2.1.3.2 Possible Owner Nodes

2.1.3.3 Resource Dependencies

2.1.4 Virtual Addresses

2.2 Monitoring the State of Cluster Components

2.2.1 How Cluster Nodes Are Monitored

2.2.2 How Cluster Resources Are Monitored

2.2.3 How Oracle Real Application Clusters Databases Are Monitored

2.3 Maintaining Availability When Components Fail

2.3.1 Listener, Virtual Address, or Cluster Node Failure

2.3.1.1 Connect-Time Failover

2.3.1.2 Group Failover Policy

2.3.1.3 Repeated Failovers

2.3.2 Instance Failure or Hang

2.3.2.1 Instance Restart Policy

2.3.2.2 Hang Detection

2.3.2.3 Terminating Hung Instances - Termination Policy

2.3.3 Client Reconnection After Failures

2.4 Considerations for Primary/Secondary Instance Deployment

2.4.1 Primary/Secondary Deployments and Instance Restart Policy

2.4.1.1 Failure of the Primary Instance

2.4.1.2 Failure of the Node Running the Primary Instance

2.4.1.3 Failure of the Secondary Instance

2.4.2 Managing Primary/Secondary Deployments

3 Configuring Oracle Real Application Clusters Databases

3.1 What Does It Mean to Configure a Database?

3.2 Discovering Unconfigured Oracle Real Application Clusters Databases

3.3 Configuring Oracle Real Application Clusters Databases

3.3.1 Configuration Data for Oracle Real Application Clusters Databases

3.3.1.1 Database Identity

3.3.1.2 Account

3.3.1.3 Password

3.3.1.4 Group

3.3.1.5 Instances

3.3.1.6 Virtual Addresses

3.3.1.7 Create Virtual Address Dialog Box

3.3.1.8 Finish Configuring the Database

3.3.1.9 Configuring Real Application Clusters Database

3.4 Configuring Additional Database Instances

3.5 Unconfiguring Oracle Real Application Clusters Database Instances

3.6 User-Specified Script for Database Instance State Change Events

3.7 Network Configuration for Configured Databases

3.7.1 The tnsnames.ora File

3.7.2 The listener.ora File

3.8 Client Connections to Configured Oracle Real Application Clusters Databases

3.8.1 Configuring Oracle Net on Nodes with Multiple Listeners

3.8.2 Using External Procedures with Configured Databases

3.8.3 Enabling the Use of Shared Sockets

3.9 Changing the Database Password

3.10 Performing Administrative Tasks on a Configured Database Instance

3.11 Clients and Cluster-Aware Applications

4 Cluster Management

4.1 Cluster Group and Cluster Alias

4.2 Allocating IP Addresses for Virtual Addresses

4.3 Managing Cluster Security

4.3.1 Oracle Services for MSCS

4.3.1.1 Account Updates Using the Oracle Services for MSCS Security Setup Tool

4.3.2 Oracle Real Application Clusters Guard Manager

4.4 Using a Multiple Oracle Homes Environment

5 The Command-Line Interface

ORACGCMD

6 Troubleshooting

6.1 Verify Operations

6.1.1 Verify Cluster

6.1.2 Verify Group

6.1.3 Verify Oracle Real Application Clusters Database

6.2 Dump Cluster

6.3 Handling Errors and Troubleshooting Problems with Configured Databases

6.3.1 Problems Placing a Group Online

6.3.2 Instance Group Fails Over During Processing-Intensive Operations

6.3.3 ORA-12500 Errors and the listener.log File

6.3.4 Problems Creating Listeners

6.3.5 Archived listener.ora or tnsnames.ora Files

6.3.6 Rollback Files

6.3.7 Clients Cannot Access an Oracle Real Application Clusters Database

6.4 Finding Additional Troubleshooting Information

A Network Configuration Requirements

A.1 Registering Host Names and IP Addresses

A.2 Validating Proper Name Resolution in the Cluster

A.3 Troubleshooting Problems with Improper Name Resolution

A.3.1 Recommended Solution for Windows NT Service Pack 5 and Higher

A.3.2 Recommended Solution for Windows 2000

B Contacting Oracle Support Services

B.1 Reporting a Problem

B.2 Finding Your Version Information

B.3 Tracing Oracle Real Application Clusters Guard Problems

Glossary

Index