You are managing RAC database with policy managed services. The database is started by using
an SPILE.
Which two statements are true regarding initialization parameters In a RAC environment?
A.
All initialization parameters must have identical settings on all instances.
B.
All instances in the cluster database use the same SPFILE.
C.
To change values for initialization parameters for an instance, you must log in to that instance.
D.
All initialization parameters for all instances can be changed from any instance In a RAC
database.
Explanation:
RAC Initialization Parameter Files
An SPFILE is created if you use the DBCA.
The SPFILE must be created in an ASM disk group or a cluster file system file.
All instances use the same SPFILE.
If the database is created manually, create an SPFILE from a PFILE.
SPFILE Parameter Values and RAC
You can change parameter settings using the ALTER SYSTEM SET command from any instance
D60488GC11Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 12 – 22, 23
A is wrong. obviously wrong
B is right. spfile is for sharing
C is wrong. use sid= to specify the instance you want to change.
D is right.
So B.D. are correct