Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 6 - Install, Configure and Database Creation

Creating RAC Database with DBCA

b) If you do not use a cluster file system and you are not creating a single-node RAC database, then you must enter a raw device name for the location of the server parameter file in the Server Parameter Filename field in the center of the Initialization Parameters page.

Next, you select the Archive tab on the Initialization Parameters page to see or check the archive log destination settings.

Now, click the Advanced Parameters tab and the DBCA will display the All Initialization Parameters dialog. You should carefully review the parameter settings displayed in this dialog because the DBCA will configure these settings in your server parameter file. Instance-specific parameter settings for your RAC database appear at the bottom of this dialog. The sid prefixes for these entries will appear in the left-hand column.

To review the instance-specific parameter settings, you scroll downward using the scroll bar on the right-hand side of the dialog box.

Note: Using the DBCA you cannot specify archive log destinations for each instance in the cluster.

You use the check box in the Included (Y/N) column of the dialog to indicate whether the DBCA should place the parameter setting in your server parameter file. The DBCA will only place a parameter entry into the server parameter file if the entry displays a check mark in the Included (Y/N) column on the All Initialization Parameters dialog. Also you should note the following about the All Initialization Parameters dialog: