Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 8 - RAC Administration

Overview

• The Global Database Name (db_name)
   

• Control Files name and location
   

• Database Block Sizes
   

• Initialization Parameters that affect the size of the SGA
   

• Maximum Number of Processes
   

• Method of Undo Space Management
   

• License Parameters

RAC and Initialization Parameters

The RAC system is a multi-instance single database system, and in general each of the instances can have its own parameter values. But certain parameters are common, such as db_name, etc. Since the RAC system can function on nodes that utilize different resources, such as CPUs and memory, database administrators can set appropriate values for the SGA configuration. Those values need not be the same for all the nodes and its instances. At the same time, there are certain parameters that are unique to each of the cluster instances.

There are three types of initialization parameters in the Real Application Clusters environment: