New Features for Administrators - Question 080

How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database?

A. Include an SPFILE parameter in each instance-specific initialization file.

B. Create an SPFILE copy on each client from which the instance will be started.

C. Store the SPFILE in a raw partition with a vendor-specific location and name.

D. Use a single client to start the instances and create the SPFILE on this client.

Answer: A

Explanation:

You can make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database by including an SPFILE parameter in each instance-specific initialization file. You still have to store a copy of the initialization parameter file on each node to facilitate startup of the instances. You can avoid distributing copies by converting this initialization parameter file into a Server Parameter File (SPFILE). Then you put the one parameter, as shown here, in the initialization parameter file for each instance:

spfile = oracle/home:\config\spfile

Incorrect Answers

B: You don’t need to create an SPFILE copy on each client from which the instance will be started.

C: It is not required to store the SPFILE in a raw partition with a vendor-specific location and name.

D: You cannot create the SPFILE on the client.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 227-230 Chapter 4: Performance and Scalability Enhancements

Oracle 9i New Features, Robert Freeman, p. 188-192 Chapter 7: Oracle9i Real Application Clusters