To add a database instance to a target node with DBCA in interactive mode, perform the following steps:
Ensure that your existing nodes have the $ORACLE_HOME environment variable set to the Oracle RAC home.
Start DBCA by entering dbca at the system prompt from the Oracle_home/bin directory.
DBCA performs certain CVU checks while running. However, you can also run CVU from the command line to perform various verifications.
See Also:
Oracle Clusterware Administration and Deployment Guide for more information about CVU
DBCA displays the Welcome page for Oracle RAC. Click Help on any DBCA page for additional information.
Select Instance Management, click Next, and DBCA displays the Instance Management page.
Select Add Instance and click Next. 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 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 Next to add a new instance and 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 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. DBCA displays a progress dialog showing DBCA performing the instance addition operation.
After you terminate your DBCA session, run the following command to verify the administrative privileges on the target node and obtain detailed information about these privileges where nodelist consists of the names of the nodes on which you added database instances:
cluvfy comp admprv -o db_config -d Oracle_home -n nodelist [-verbose]
Perform any necessary service configuration procedures, as described in Workload Management with Dynamic Database Services.