Adding Administrator-Managed Oracle RAC Database Instances to Target Nodes

Learn how to configure Administrator-Managed Oracle Real Application Clusters (Oracle RAC) instances.

About Adding Administrator-Managed Oracle RAC Database Instances

To add Oracle Real Application Clusters (Oracle RAC) database instances, you have several tools available.

You can use either Oracle Enterprise Manager or Oracle DBCA to add Oracle RAC database instances to the target nodes.

This section describes using Oracle DBCA to add Oracle RAC database instances.

These tools guide you through the following tasks:

Creating a new database instance on each target node
Creating and configuring high availability components
Creating the Oracle Net configuration for a non-default listener from the Oracle home
Starting the new instance
Creating and starting services if you entered services information on the Services Configuration page

After adding the instances to the target nodes, you should perform any necessary service configuration procedures, as described in "Workload Management with Dynamic Database Services".

Using Oracle DBCA in Interactive Mode to Add Database Instances to Target Nodes

To add a database instance to a target node with Oracle DBCA in interactive mode, perform the steps described here.

Ensure that your existing nodes have the $ORACLE_HOME environment variable set to the Oracle RAC home.
Start Oracle DBCA by entering dbca at the system prompt from the Oracle_home /bin directory.
Oracle DBCA performs certain CVU checks while running. However, you can also run CVU from the command line to perform various verifications.

Oracle DBCA displays the Welcome page for Oracle RAC. Click Help on any Oracle DBCA page for additional information.
Select Instance Management, click Next, and Oracle DBCA displays the Instance Management page.
Select Add Instance and click Next. Oracle DBCA displays the List of Cluster Databases page that shows the databases and their current status, such as ACTIVE or INACTIVE.
From the List of Cluster Databases page, select the active Oracle RAC database to which you want to add an instance. Click Next and Oracle DBCA displays the List of Cluster Database Instances page showing the names of the existing instances for the Oracle RAC database that you selected.
Click Nextto add a new instance and Oracle DBCA displays the Adding an Instance page.
On the Adding an Instance page, enter the instance name in the field at the top of this page if the instance name that Oracle DBCA provides does not match your existing instance naming scheme.
Review the information on the Summary dialog and click OK or click Cancel to end the instance addition operation. Oracle DBCA displays a progress dialog showing Oracle DBCA performing the instance addition operation.
After you terminate your Oracle DBCA session, run the following command to verify the administrative privileges on the target node and obtain detailed information about these privileges where node_list consists of the names of the nodes on which you added database instances:
```
cluvfy comp admprv -o db_config -d Oracle_home -n node_list [-verbose]
```
Perform any necessary service configuration procedures, as described in "Workload Management with Dynamic Database Services".

Using Oracle DBCA in Silent Mode to Add Database Instances to Target Nodes

You can use Oracle DBCA in silent mode to add instances to nodes on which you have extended an Oracle Clusterware home and an Oracle AI Database home.

Before you run the dbca command, ensure that you have set the ORACLE_HOME environment variable correctly on the existing nodes. Run Oracle DBCA, supplying values for the variables using the following syntax:

dbca -silent -addInstance -nodeName node_name -gdbName gdb_name
  [-instanceName instance_name -sysDBAUserName sysdba -sysDBAPassword
  password]

The following table describes the values that you need to supply for each variable.

Table: Variables in the Oracle DBCA Silent Mode Syntax

Variable	Description
`node_name`	The node on which you want to add (or delete) the instance.
`gdb_name`	Global database name.
`instance_name`	Name of the instance. Provide an instance name only if you want to override the Oracle naming convention for Oracle RAC instance names.
`sysdba`	Name of the Oracle user with `SYSDBA` privileges.
`password`	Password for the `SYSDBA` user.

Perform any necessary service configuration procedures, as described in "Workload Management with Dynamic Database Services".