B Using Scripts to Create Oracle Real Application Clusters Databases

B.1 Using DBCA to generate Installation Scripts for Oracle RAC

To generate scripts to create an Oracle RAC 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 Oracle 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:

   Chapter 3, "Creating Oracle 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 sid.sh, 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 Oracle Net Services to support your new database and instances as described in Chapter 7, "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 SRVCTL to configure and start database and instance applications as described in Oracle Real Application Clusters Administration and Deployment Guide.

   See Also:

   Oracle Universal Installer and OPatch User's Guide for additional information about creating and using scripts to install Oracle software with OUI

B.2 Using DBCA Noninteractive (Silent) Configuration for Oracle RAC

You can perform a noninteractive, or "silent" configuration of Oracle RAC using DBCA. To perform a silent configuration, you must have completed an Oracle Clusterware installation, run the root.sh script from the Oracle Database or Oracle ASM homes, and defined the Oracle home and ASM home directory environment variables.

The following command syntax creates an ASM instance and one disk group:

# su oracle -c "$ORA_ASM_HOME/bin/dbca -silent -configureASM -gdbName NO -sid NO -emConfiguration NONE -diskList ASM_Disks -diskGroupName ASM_Group_Name -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo $NODE1,$NODE2 -obfuscatedPasswords false -asmSysPassword My_ASM_password -redundancy ASM_redundancy"

In the preceding syntax example:

• ASM_Disks represent disk addresses, such as /dev/sda1,/dev/sdb1

• ASM_Group_Name represents the name of an ASM disk group

• ASM_ Redundancy represents an ASM disk redundancy setting, such as 'NORMAL'.

• My_ASM_password represents the ASM SYS user password.

The following command syntax creates an Oracle RAC database on an existing ASM disk group, where the cluster nodes are node1 and node2, and where the disk group name is ASMgrp1, the passwords are my_password, and the ASM SYS password is My_ASM_Password:

# su oracle -c "$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName $DBNAME -sid $SID -sysPassword my_password -systemPassword my_password -sysmanPassword my_password -dbsnmpPassword my_password -emConfiguration LOCAL -storageType ASM -diskGroupName ASMgrp1 -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo node1,node2 -characterset WE8ISO8859P1 -obfuscatedPasswords false -sampleSchema false -asmSysPassword My_ASM_password"