Skip Headers
Oracle® Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide
10g Release 2 (10.2) for Solaris Operating System (SPARC 64-Bit)

Part Number B14205-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF

B Using Scripts to Create Real Application Clusters Databases

This chapter describes the steps required to create an Oracle Real Application Clusters (RAC) database from scripts. The topic in this appendix is:


The scripts generated by DBCA are for reference purposes only. Oracle strongly recommends that you use DBCA to create a database.

B.1 Creating a Database Using Scripts

To generate scripts to create a Real Application Clusters database, create a database using the scripts, and prepare the database for use, complete the following steps:

  1. Start Database Configuration Assistant (DBCA) and select your preferred options to build the RAC database. Note: you must select the Custom Database template on the Database Templates page for DBCA to provide the script generation option.

    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, you should note the path name for use in the next step.

    See Also:

    "Creating Real Application Clusters Databases with Database Configuration Assistant" for additional information about running a DBCA session.

  2. Navigate to the directory, which you noted in Step 1, 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.

  3. On each cluster node you identified during your DBCA session, run the script, where sid is the sid prefix that you entered on the DBCA Database Name page.

  4. Set the initialization parameter, cluster_database, to the value TRUE in your SPFILE by issuing an ALTER SYSTEM command, or by uncommenting it in your PFILE for each instance.

  5. Configure Net Services to support your new database and instances as described in Chapter 9, "Understanding the Oracle Real Application Clusters Installed Configuration".

  6. Set the local_listener and remote_listener parameters in your SPFILE by issuing an ALTER SYSTEM command, or by uncommenting it in your PFILE for each instance.

  7. Run SVRCTL to configure and start database and instance applications as described in Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide.