ORACLE_RAC_官方文档_part3_04

Part III

Installing Oracle Clusterware and Oracle Database 10g with Oracle Real Application Clusters,

Creating Oracle Real Application Clusters Databases,and Performing Post-Installation Tasks

Chapter 7:

Configuring the Server Parameter File in Oracle Real Application Clusters Environments

Parameter Files and RAC

Using Server Parameter Files in RAC

Parameter File Search Order in RAC

Migrating to the Server Parameter File in RAC Environments

Server Parameter File Errors in RAC

Location of the SPFILE:

The default location of the server parameter file is:

$ORACLE_HOME/dbs/spfile$ORACLE_sid.ora

The default location of the server parameter file is inappropriate for RAC databases

and ASM instances if you use raw devices,because all instances must use the same server

parameter file.

Instead ,Oracle recommends that you use a PFILE in this directory:

$ORACLE_HOME/dbs/init$ORACLE_sid.ora

This path is valid for each instance and it refers to a single,shared initialization

parameter file.If you use raw storage,then the file must contain the following entry:

SPFILE='/dev/vx/rdsk/oracle_dg/dbspfile'

However,if you use a cluster file system,then use one of the following file location:

SPFILE='$ORACLE_HOME/dbs/spfile.ora'

If you use ASM,then the SPFILE value will be:

SPFILE='+disk_group_name/dbunique_name/spfiledbname.ora'

eg:SPFILE='+DG1/devdb/spfiledevdb.ora'

Parameter File Search Order in RAC;

1,$ORACLE_HOME/dbs/spfilesid.ora

2,$ORACLE_HOME/dbs/spfile.ora

3,$ORACLE_HOME/dbs/initsid.ora

Procedured for Migrating to the SPFILE:

1,If you are using a cluster file system

CREATE SPFILE='?/dbs/spfile_dbname.ora' FROM PFILE='?/dbs/initdbname.ora'

2,If you use ASM

CREATE SPFILE='+disk_group_name/db_uniquename/spfiledbname.ora'

FROM PFILE='?/dbs/initdbname.ora'

3,If you use raw storage

CREATE SPFILE='/dev/vx/rdsk/oracle_dg/dbspfile'

FROM PFILE='?/dbs/initdbname.ora'

STARTUP PFILE=$ORACLE_HOME/dbs/initsid.ora

Note:

The SPFILE for ASM instance cannot be stored in ASM,as it is used to start the ASM instance.

You can place an ASM instance SPFILE on a shared raw device or in a cluster file system for 

ASM ,or you can have a traditional client-side parameter file for each ASM instance.

Server Parameter File Errors in RAC:

1,Shutdown the instance,recover the server parameter file,and start the instance

2,Enable the instance to continue running without regard for subsequent parameter updates