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?

The correct answer is B. All instances in the cluster database use the same SPFILE. D. All initialization parameters for all instances can be changed from any instance In a RAC. 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…

Install and Administer Oracle RAC

Question

Options

AAll initialization parameters must have identical settings on all instances.
BAll instances in the cluster database use the same SPFILE.
CTo change values for initialization parameters for an instance, you must log in to that instance.
DAll initialization parameters for all instances can be changed from any instance In a RAC

How the community answered

(19 responses)

A
16% (3)
B
79% (15)
C
5% (1)

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 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 12 - 22, 23

Topics

#SPFILE in RAC#initialization parameters#instance-level settings#policy-managed database

Community Discussion

No community discussion yet for this question.

Full 1Z0-058 Practice