Review this topic to generate scripts to create an Oracle RAC database, create a database using the generated scripts, and prepare the database for use.
Complete the following steps:
- Start DBCA and select your preferred options to build the Oracle RAC database.
On the Creation Options page of your DBCA session, deselect Create Database and select Generate Database Creation Scripts before you 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 they do not, 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
sidis the SID prefix that you entered on the DBCA Database Name page.
- Set the initialization parameter,
cluster_database, to the value
TRUEin your SPFILE by running an
ALTER SYSTEMstatement in SQL*Plus, or by uncommenting the parameter in the SPFILE for each instance.
- Configure Oracle Net Services to support your new database and instances.
- Set the
REMOTE_LISTENERparameter to the SCAN (using the Easy Connect Naming syntax
scanname:scanport) in your SPFILE by entering an
ALTER SYSTEMstatement 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 the following document:
Oracle Universal Installer Installation Guide for additional information about creating and using scripts to install Oracle software with Oracle Universal Installer (OUI)