WE PROVIDE ALL

How to extend an existing Oracle Real Application Clusters(Oracle RAC) home to other nodes and 

instances in the cluster, and delete Oracle RAC

      2. Using Oracle Enterprise Manager to add and delete nodes and instances is not supported on Windows.

      3.For all of the add node and delete node procedures, temporarydirectories such as %TEMP% or 

C:\Temp should not be shareddirectories. If your temporary directories are shared, then set your

temporary environment variable, such as %TEMP%, to a location ona local node. In addition, use a 

directory path that exists on all of the nodes.


Adding Oracle RAC to Nodes with Oracle Clusterware Installed

Before beginning this procedure, ensure that your existing nodes have the correct path

to the Grid_home and that the Oracle_home environment variables are set correctly.



To add Oracle RAC database instances to nodes that already have Oracle Clusterware

installed, you must extend the Oracle RAC home that is on an existing node (node1 in

this procedure) of the cluster to the target nodes.

1. Navigate to the Oracle_home\oui\bin directory on node1 and run the

addNode.bat script using the following syntax, where node2 is the name of the

node you are adding:

addNode.bat "CLUSTER_NEW_NODES={node2}"

2. If you store your policy-managed database on Oracle Automatic Storage

Management (Oracle ASM), Oracle Managed Files is enabled, and if there is space

in a server pool for node2, then crsd adds the Oracle RAC database instance to

node2 and no further action is necessary. If Oracle Managed Files is not enabled,

then you must manually add undo and redo logs.

If there is no space in a server pool, then node2 moves into the Free server pool.

Use the srvctl modify srvpool command to increase the cardinality of the

server pool to accommodate node2, after which time node2 moves out of the Free

server pool and into the modified server pool, and crsd adds the Oracle RAC



This section describes using DBCA to add Oracle RAC database instances under the

following topics:

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

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

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,Automatic Workload Management".

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

To add a database instance to a target node using DBCA in interactive mode, perform

the following steps:

1. Ensure that your existing nodes have the Oracle home environment variable set
correctly.

2. Start DBCA by entering dbca at the system prompt from the Oracle_home\bin
directory on an existing node.

DBCA performs certain CVU checks while running. However, you can also run
CVU from the command line to perform various verifications.

DBCA displays the Welcome page for Oracle RAC. Click Help on any DBCA page
for additional information.

3. Select Oracle Real Application Clusters database, click Next, and DBCA displays
the Operations page.

4. Select Instance Management, click Next, and DBCA displays the Instance
Management page.

5. 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.

6. From the List of Cluster Databases page, select the active Oracle RAC database to
which you want to add an instance. Enter the user name and password for a
database user that has SYSDBA privileges. 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.

7. Click Next to add a new instance and DBCA displays the Adding an Instance page

8. 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. Then select the new node name from the list, click Next,

and DBCA displays the Services Page.

9. Enter the services information for the new node's instance, click Next, and DBCA
displays the Instance Storage page.

10. If you are using Oracle ASM or a cluster file system, then click Finish on the
Instance Storage page.

11. Review the information on the Summary dialog and click OK or click Cancel to

end the instance addition operation. The DBCA displays a progress dialog

showing DBCA performing the instance addition operation. When DBCA

completes the instance addition operation, DBCA displays a dialog asking

whether you want to perform another operation.

12. After you terminate your DBCA session, run the following command to verify the

administrative privileges on the new node and obtain detailed information about

these privileges where nodelist consists of the newly added nodes:

cluvfy comp admprv -o db_config -d oracle_home -n nodelist [-verbose]

13. Perform any necessary service configuration procedures, as described in

Chapter 5, "Introduction to Automatic Workload Management".

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

You can use DBCA in silent mode to add instances to nodes on which you have

extended an Oracle Clusterware home and an Oracle Database home. Use the

following syntax:

dbca -silent -addInstance -nodeList node_name -gdbName gdb_name

[-instanceName instance_name -sysDBAUserName sysdba -sysDBAPassword password]

database instance to node2.

3. If you have an administrator-managed database, then add a new instance on

node2 as described in "Adding Administrator-Managed Oracle RAC Database

Instances to Target Nodes" Adding Administrator-Managed Oracle RAC Database Instances to Target

NodesBefore adding an Oracle RAC database instance, run the following command on an

existing node to configure Oracle Enterprise Manager on the node where you plan to

add the database instance:

C:\>emca -addNode db

The Oracle Enterprise Manager Configuration Assistant prompts you for database and
node information.

You can use either Oracle Enterprise Manager or DBCA to add Oracle RAC database

instances to the target nodes. To add a database instance to a target node with Oracle

Enterprise Manager,