FIGURE 1-7 A two-node Real Application Clusters (RAC) configuration
Chapter 1: Getting Started with the Oracle Architecture 43
Oracle Initialization Parameters
An Oracle database uses initialization parameters to configure memory settings, disk locations,
and so forth. There are two ways to store initialization parameters: using an editable text file and
using a server-side binary file. Regardless of the method used to store the initialization parameters,
there is a defined set of basic initialization parameters (as of Oracle 10g) that every DBA should
be familiar with when creating a new database.
As of Oracle 10g, initialization parameters fall into two broad categories: basic initialization
parameters and advanced initialization parameters. As Oracle becomes more and more self-managing,
the number of parameters that a DBA must be familiar with and adjust on a daily basis is reduced.
Basic Initialization Parameters
The list of Oracle 10g basic initialization parameters appears in Table 1-3 along with a brief
description of each. In the sections that follow, we will give some further explanation and advice
regarding how some of these parameters should be set, depending on the hardware and software
environment, the types of applications, and the number of users in the database.
Initialization Parameter Description
CLUSTER_DATABASE Enables this node to be a member of a cluster.
COMPATIBLE Allows a new database version to be installed while ensuring
compatibility with the release specified by this parameter.
Pages:
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129