Using DBCA to Generate Installation Scripts for Oracle RAC

A.1 Using DBCA to Generate Installation Scripts for Oracle RAC

You can generate scripts that create an Oracle RAC database and prepare the database for use.

Start Oracle Database Configuration Assistant (DBCA) and select your preferred options to build the Oracle RAC database.
1. On the Creation Options page of your DBCA session, deselect Create Database.
2. Select Generate Database Creation Scripts.
3. Click Finish.
You can accept the default destination directory for the scripts, or browse for a different location. In either case, note the path name for use in the next step.
Go to the directory where DBCA created the scripts, and review the SQL scripts to ensure that they contain the statements to build a database with the characteristics you require.
If the scripts do not contain the statements for the specific database characteristics you need, then Oracle recommends that you rerun DBCA to create scripts with the desired configuration rather than editing the scripts yourself.
On each cluster node you identified during your DBCA session, run the script sid.bat, where sid is the SID prefix that you entered on the DBCA Database Name page.
Set the initialization parameter, cluster_database, to the value TRUE in your SPFILE by entering an ALTER SYSTEM statement in SQL*Plus, or by uncommenting the parameter in the PFILE for each instance.
Configure Oracle Net Services to support your new database and instances.
Set the REMOTE_LISTENER parameter to the SCAN (using the Easy Connect Naming syntax scanname:scanport) in your SPFILE by entering an ALTER SYSTEM statement in SQL*Plus, or by uncommenting the parameter in the PFILE for each instance.
Run the Server Control Utility (SRVCTL) to configure and start database and instance applications as described in Oracle Real Application Clusters Administration and Deployment Guide.