Parameter file management in RAC Environment

In the RAC environment, the initialization parameter file has some similarities and differences with the parameter files under the instance, mainly because the initialization parameter can be shared for multiple instances, or you can set the initial

In the RAC environment, the initialization parameter file has some similarities and differences with the parameter files under the instance, mainly because the initialization parameter can be shared for multiple instances, or you can set the initial

In the RAC environment, the initialization parameter file has some similarities and differences with the parameter files under the instance, mainly because the initialization parameter can be shared for multiple instances, or the initialization parameters of each instance can be set separately. For non-shared initialization parameters, they must be set separately. For shared parameters, they can be set separately. However, this is generally not recommended. This document describes how to manage the parameter files in the RAC environment.

For the description of important parameters in the RAC environment, see important parameters in the RAC environment.

1. parameter file location

SQL> show parameter instance_name

NAME TYPE VALUE
-----------------------------------------------------------------------------
Instance_name string ora10g1
SQL> show parameter spfile;

NAME TYPE VALUE
-----------------------------------------------------------------------------
Spfile string + DG1/ora10g/spfileora10g. ora

SQL> show parameter instance_name

NAME TYPE VALUE
-----------------------------------------------------------------------------
Instance_name string ora10g2
SQL> show parameter spfile

NAME TYPE VALUE
-----------------------------------------------------------------------------
Spfile string + DG1/ora10g/spfileora10g. ora

SQL> show parameter cluster

NAME TYPE VALUE
-----------------------------------------------------------------------------
Cluster_database boolean TRUE
Cluster_database_instances integer 2


Oracle @ bo2dbp: ~> Cd/u01/oracle/admin/ora10g
Oracle @ bo2dbp:/u01/oracle/admin/ora10g> ls
Adump bdump cdump dpdump hdump pfile udump
Oracle @ bo2dbp:/u01/oracle/admin/ora10g> cd pfile
Oracle @ bo2dbp:/u01/oracle/admin/ora10g/pfile> ls-hltr
Total 4.0 K
-Rw-r ----- 1 oracle oinstall 2.7 K init. ora.82720121245
Oracle @ bo2dbp:/u01/oracle/admin/ora10g/pfile> cd $ ORACLE_HOME/dbs
Oracle @ bo2dbp:/u01/oracle/db/dbs> ls *. ora
Init + ASM1.ora initdw. ora initGOBO1A_tmp.ora initGOBO4A. ora init. ora initora10g1. ora
Oracle @ bo2dbp:/u01/oracle/db/dbs> more initora10g1. ora
SPFILE = '+ DG1/ora10g/spfileora10g. ora'
Oracle @ bo2dbs:/u01/oracle/db/dbs> more initora10g2. ora
SPFILE = '+ DG1/ora10g/spfileora10g. ora'

# The preceding query shows that the parameter files in the RAC environment are usually stored in RAW or ASM. The default path is $ ORACLE_HOME/dbs/init {ORACLE_SID}. ora.
# Each instance only stores the pfile file. The content of the pfile file points to the position of the spfile file, that is, tell, brother, you should go to xx to find the spfile. Haha ,,,
# Note: When the Oracle database is started, spfile $ {ORACLE_SID.ora} is first found. If the corresponding spfile does not exist, spfile. ora is found.
# If spfile. ora cannot be found, find the corresponding pfile (init {ORACLE_SID}. ora)
# If none of them can be found, use the default init. ora to start the instance.