Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Oracle Real Application Clusters Guard Architecture

Overview of Oracle Real Application Clusters Guard Components

Oracle Real Application Clusters Guard Packs

PFSCTL Control Utility

Oracle Real Application Clusters Guard Monitors

Oracle Real Application Clusters Guard Configuration Templates

PFSSETUP Utility

Concepts of Oracle Real Application Clusters Guard

Instance Roles

Preferred Primary and Secondary Nodes

Home and Foreign Nodes

Architecture of Oracle Real Application Clusters Guard

Oracle Real Application Clusters Guard Packs

Oracle Real Application Clusters Guard Monitors

Additional Configurations of Oracle Real Application Clusters Guard

Hub Configuration

Ring Configuration

2 Oracle Real Application Clusters Guard Operation

Overview of Oracle Real Application Clusters Guard Operation

Failure of the Primary Instance

Restoring the Nodes to Their Original Roles

Failure of the Secondary Instance

Failure of Both Instances

3 Oracle Real Application Clusters Guard Configuration Parameters

Overview of the Oracle Real Application Clusters Guard Configuration File

Oracle Real Application Clusters Guard Configuration Parameters

Permanent Cluster and Database Parameters

Platform-Specific Configuration Parameters

Database and Oracle Real Application Clusters Guard Configuration Parameters

Oracle Real Application Clusters Guard Configuration Parameters

Network Configuration Parameters

Database Configuration Parameters

Changing Oracle Real Application Clusters Guard Configuration Parameters

Changing Permanent Cluster and Database Parameters

Changing Platform-Specific Configuration Parameters

Changing Database and Oracle Real Application Clusters Guard Configuration
Parameters

Changing Oracle Real Application Clusters Guard Configuration Parameters

Changing Network Configuration Parameters

Changing Database Configuration Parameters

4 Using Oracle Real Application Cluster Guard Commands

Overview of the Oracle Real Application Clusters Guard Command-Line Utility

Oracle Real Application Clusters Guard User Commands

Starting Oracle Real Application Clusters Guard

Displaying the Current Status of Oracle Real Application Clusters Guard

Restoring Oracle Real Application Clusters Guard After a Failure

Moving the Primary Role

Switching Roles in Oracle Real Application Clusters Guard

Halting Oracle Real Application Clusters Guard

Halting a Single Pack

Starting a Single Pack

Stopping the Secondary Role

Using Oracle Real Application Clusters Guard Commands for Planned Outages

Planned Outage on the Secondary Node

Planned Outage on the Primary Node

Testing the Call-Home Script

Listing the Oracle Real Application Clusters Guard Commands

Generating the Uptime Report

Exiting PFSCTL

5 Customizing Oracle Real Application Clusters Guard

Overview of Customizing Oracle Real Application Clusters Guard

Setting Up the Call-Home Feature

Setting Up the Customer Query

Setting Up Role Change Notification

Examples of Role Change Notification Messages

Setting Up Oracle Enterprise Manager for Oracle Real Application Clusters Guard

Modifying the ORATAB File for Oracle Real Application Clusters Guard

Warming the Library Cache on the Secondary Instance

Overview of Warming the Library Cache

Setting Up DBMS_LIBCACHE

Using DBMS_LIBCACHE

6 Administering Oracle Real Application Clusters Guard

Administering Planned Outages

Maintenance on the Primary Node

Maintenance on the Secondary Node

Recovering from an Unplanned Outage on One Node

Operate with Reversed Primary and Secondary Roles

Return to the Original Primary/Secondary Configuration

Choose a Less Critical Application to Restore

Recovering from Unplanned Outages on Both Nodes

Administering Failover of the Applications

Enhancing Application Failover with Role Change Notification

Changing the Configuration

Changing the Oracle Real Application Clusters Guard Configuration Parameters

Changing the Configuration of Both Instances of Oracle9i Real Application Clusters

Making Online Changes to the Configuration

Changing the PFS_KEEP_PRIMARY Parameter

Making Online Changes to the ORAPING_CONFIG Table

Managing the Oracle Real Application Clusters Guard Log Files

Recovering from a Failover While Datafiles Are in Backup Mode

7 Configuring the Network for Oracle Real Application Clusters Guard

Configuring the Oracle Network

Dedicated Server Connections

Shared Server Connections

Transparent Application Failover Dedicated Connections

TAF Basic Dedicated Connections

TAF Preestablished Dedicated Connections

8 Troubleshooting Oracle Real Application Clusters Guard

Interpreting Message Output in Oracle Real Application Clusters Guard

Identifying Types of Message Output for Oracle Real Application Clusters Guard

Identifying Error Codes in Oracle Real Application Clusters Guard Logs and Trace
Files

Interpreting Oracle Real Application Clusters Guard Error Messages

Enabling the Debugging Option for Oracle Real Application Clusters Guard

Troubleshooting Startup Problems for Oracle Real Application Clusters Guard

Example: pfsboot Command Fails Because Packs Are Already Running

Example: pfsboot Command Fails Because of an Invalid Initialization Parameter Value

Example: pfsboot Command Starts and Fails

Troubleshooting Command-Line Problems in Oracle Real Application Clusters Guard

Troubleshooting Oracle Real Application Clusters Guard Monitors

Troubleshooting the Heartbeat Monitor

Troubleshooting the Instance Monitor

Troubleshooting the Listener Monitor

Troubleshooting the System Outside of the Packs

Example: Enabling an IP Address on the HP Platform

Example: Enabling an IP Address on the Sun Platform

A Oracle Real Application Clusters Guard Error Messages

Glossary

Index