Oracle Real Application Clusters Guard. Administration and Reference Guide

Baird C.

This document is intended for database administrators and system administrators who need to administer an Oracle Real Application Clusters Guard environment. They are assumed to have a thorough understanding of the concepts of Oracle Real Application Clusters Guard, the administration of the Oracle server and OracIe 9i Real Application Clusters, and their platform-specific cluster technology

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 7
Preface……Page 9
1 Oracle Real Application Clusters Guard Configuration Parameters……Page 15
Overview of the Oracle Real Application Clusters Guard Configuration File……Page 16
Oracle Real Application Clusters Guard Configuration Parameters……Page 17
Permanent Cluster and Database Parameters……Page 18
Operating System Specific Configuration Parameters……Page 19
Database and Oracle Real Application Clusters Guard Configuration Parameters……Page 20
Oracle Real Application Clusters Guard Configuration Parameters……Page 22
Network Configuration Parameters……Page 25
Database Configuration Parameters……Page 26
Changing Oracle Real Application Clusters Guard Configuration Parameters……Page 27
Changing Permanent Cluster and Database Parameters……Page 28
Changing Operating System Specific Configuration Parameters……Page 33
Changing Database and Oracle Real Application Clusters Guard Configuration Parameters……Page 37
Changing Oracle Real Application Clusters Guard Configuration Parameters……Page 42
Changing Network Configuration Parameters……Page 46
Changing Database Configuration Parameters……Page 54
2 Using Oracle Real Application Cluster Guard Commands……Page 59
Oracle Real Application Clusters Guard User Commands……Page 60
Starting Oracle Real Application Clusters Guard……Page 62
Displaying the Current Status of Oracle Real Application Clusters Guard……Page 63
Moving the Primary Role……Page 64
Switching Roles in Oracle Real Application Clusters Guard……Page 65
Halting a Single Pack……Page 67
Starting a Single Pack……Page 68
Using Oracle Real Application Clusters Guard Commands for Planned Outages……Page 69
Planned Outage on the Primary Node……Page 70
Listing the Oracle Real Application Clusters Guard Commands……Page 71
Generating the Uptime Report……Page 72
Exiting PFSCTL……Page 73
3 Customizing Oracle Real Application Clusters Guard……Page 75
Setting Up the Call-Home Feature……Page 76
Setting Up the Customer Query……Page 77
Setting Up Role Change Notification……Page 79
Role Change Notification: PFSBOOT Command……Page 80
Role Change Notification: RESTORE Command……Page 81
The ORATAB File……Page 82
Overview of Warming the Library Cache……Page 83
Setting Up DBMS_LIBCACHE……Page 84
Using DBMS_LIBCACHE……Page 88
Example: Compiling All Cursors for All Users with Default Threshold Values……Page 90
Example: Compiling All Cursors for the Oracle GL Application with Default Threshold Values……Page 91
4 Administering Oracle Real Application Clusters Guard……Page 93
Maintenance on the Secondary Node……Page 94
Return to the Original Primary/Secondary Configuration……Page 95
Recovering from Unplanned Outages on Both Nodes……Page 96
Administering Failover of the Applications……Page 100
Enhancing Application Failover with Role Change Notification……Page 101
Changing the Configuration of Both Instances of Oracle9i Real Application Clusters……Page 102
Making Online Changes to the Configuration……Page 103
Changing the PFS_KEEP_PRIMARY Parameter……Page 104
Making Online Changes to the ORAPING_CONFIG Table……Page 106
Managing the Oracle Real Application Clusters Guard Log Files……Page 109
Recovering from a Failover While Datafiles are in Backup Mode……Page 110
5 Configuring the Network for Oracle Real Application Clusters Guard……Page 113
Dedicated Server Connections……Page 114
Example of an Oracle Real Application Clusters Guard Dedicated Network Configuration……Page 115
Example of an Oracle Real Application Clusters Guard Shared Server Connection……Page 117
Transparent Application Failover Dedicated Connections……Page 120
TAF Basic Dedicated Connections……Page 121
TAF Pre-Established Dedicated Connections……Page 122
6 Troubleshooting Oracle Real Application Clusters Guard……Page 125
Identifying Types of Message Output……Page 126
Oracle Real Application Clusters Guard Error Message Numbers……Page 128
Example: Interpreting Oracle Real Application Clusters Guard Errors……Page 129
Troubleshooting Start-Up Problems……Page 130
Example: PFSBOOT Command Fails……Page 131
Solution……Page 132
Diagnosis……Page 133
Example: PFSBOOT Starts and Fails……Page 134
Diagnosis……Page 135
Troubleshooting Command Line Problems……Page 139
Troubleshooting Oracle Real Application Clusters Guard Monitors……Page 140
Troubleshooting the Instance Monitor……Page 141
Troubleshooting the Listener Monitor……Page 142
Troubleshooting the System Outside of the Packs……Page 144
Example: Enabling an IP Address on the Sun Platform……Page 145
Example: Enabling an IP Address on the HP Platform……Page 146
Generic Messages : 0xxx……Page 147
Internal Library Messages: 2xxx……Page 148
Cluster Library Messages: 3xxx……Page 149
Run and Halt Script Messages: 4xxx……Page 151
PFSCTL Messages: 5xxx……Page 152
Instance Monitor Messages: 6xxx……Page 155
Listener Monitor Messages: 7xxx……Page 156
Heartbeat Monitor Messages: 8xxx……Page 157
PFS Internal Process and Role Change Messages: 9xxx……Page 161
PFS Setup Messages: 10xxx……Page 162
Index……Page 165