Adding Administrator-Managed Oracle RAC Database Instances to Target Nodes

Learn about how to use Oracle DBCA to add Oracle RAC database instances.

To add Oracle RAC database instances to the target nodes. you can use either Oracle Enterprise Manager or Oracle DBCA. These topics describe using Oracle DBCA

About Using Oracle DBCA to Add Oracle RAC Instances

When you use Oracle DBCA to add Oracle Real Application Clusters instances to Oracle Clusterware, it helps you to complete more than only a database deployment.

Oracle DBCA guides you through the following tasks:

Creating a new Oracle AI 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.

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

In these procedures, you first use Oracle DBCA to add a database instance to a target node, and then create a service for Oracle Services for Microsoft Transaction Server (OraMTS).

Adding a Database Instance To Target Nodes

To add a database instance to a target node using Oracle DBCA in interactive mode, perform the following steps:

Ensure that your existing nodes have the Oracle home environment variable set correctly.
Start Oracle DBCA by entering dbca at the system prompt from the Oracle_home\bin directory on an existing node.
Oracle DBCA performs certain CVU checks while running. However, you can also run CVU from the command line to perform various verifications.
On the Database Operations page, 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. Then select the new node name from the list.

Note:
If you installed the Oracle home with the Oracle Home User
option, then Oracle DBCA prompts you for that password on this page.
Review the information on the Summary Page and click Finish to initiate instance addition operation. Oracle DBCA displays a progress dialog showing Oracle DBCA performing the instance addition operation.

Creating the OraMTS Service for Microsoft Transaction Server

Oracle Services for Microsoft Transaction Server (OraMTS) permits Oracle AI Database to be used as a resource manager in Microsoft application-coordinated transactions. OraMTS acts as a proxy for Oracle AI Database to the Microsoft Distributed Transaction Coordinator (MSDTC). As a result, OraMTS provides client-side connection pooling and allows client components that leverage Oracle to participate in promotable and distributed transactions. In addition, OraMTS can operate with Oracle AI Databases running on any operating system, given that the services themselves are run on Windows. You must use a configuration tool to create this service.

To create the OraMTS service after adding a node or performing a software-only installation for Oracle RAC, complete this procedure:

Open a command window.
Change directories to %ORACLE_HOME%\bin.
Run the OraMTSCtl utility to create the OraMTS Service, where host_name is a list of nodes on which the service should be created:
```
C:\..bin> oramtsctl.exe -new -host host_name
```

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

Add instances to nodes on which you have extended an Oracle Clusterware home and an Oracle AI Database home.

Use Oracle DBCA in silent mode with the following syntax:

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

Perform any necessary service configuration procedures.