1. Real Application Clusters Administration and Deployment Guide
  2. Adding and Deleting Oracle RAC from Nodes on Linux and Unix Systems

11 Adding and Deleting Oracle RAC from Nodes on Linux and Unix Systems

Extend an existing Oracle Real Application Clusters (Oracle RAC) home to other nodes and instances in the cluster, and delete Oracle RAC from nodes and instances in the cluster.

Note:

A multitenant container database is the only supported architecture in Oracle Database 21c. While the documentation is being revised, legacy terminology may persist. In most cases, "database" and "non-CDB" refer to a CDB or PDB, depending on context. In some contexts, such as upgrades, "non-CDB" refers to a non-CDB from a previous release.

About Adding and Deleting Nodes

Adding and deleting nodes is the process of adding or modifying your Oracle Real Application Clusters database cluster

If your goal is to clone an existing Oracle RAC home to create multiple new Oracle RAC installations across the cluster, then use the cloning procedures that are described in "Cloning Oracle RAC to Nodes in a New Cluster".

Note:

  • Ensure that you have a current backup of Oracle Cluster Registry (OCR) before adding or deleting Oracle RAC by running the ocrconfig -showbackup command.

  • The phrase "target node" in the context of configuring Oracle RAC nodes refers to the node to which you plan to extend the Oracle RAC environment.

Related Topics

Parent topic: Adding and Deleting Oracle RAC from Nodes on Linux and Unix Systems

Adding Oracle RAC to Nodes with Oracle Clusterware Installed

To add Oracle Real Application Clusters (Oracle RAC) with Oracle Clusterware installed, your procedure depends on the storage you use, and your Oracle home configuration,

Before beginning the procedure on your system, ensure that your existing nodes have the correct path to the Grid_home and that the $ORACLE_HOME environment variable is set to the Oracle RAC home.

Procedure for Local (Non-Shared) Oracle Home

If you are using a local (non-shared) Oracle home, then you must extend the Oracle RAC database home that is on an existing node (node1 in this procedure) to a target node (node3 in this procedure).

  1. Navigate to the Oracle_home/addnode directory on node1 and run the addnode.sh script.

  2. If you want to perform a silent installation, run the addnode.sh script using the following syntax: 

    $ ./addnode.sh -silent "CLUSTER_NEW_NODES={node3}"

  3. Run the Oracle_home/root.sh script on node3 as root.

  4. Manually copy the tnsnames.ora file from your old node to the newly added node. 

    $ cd $ORACLE_BASE_HOME/network/admin
$ scp tnsnames.ora new_node:$ORACLE_BASE_HOME/network/admin/

  5. Open the Pluggable Databases (PDBs) on the newly added node using the following commands in your SQL*Plus session:

    SQL> CONNECT / AS SYSDBA
SQL> ALTER PLUGGABLE DATABASE pdb_name OPEN;

Procedure for Shared Oracle Home Using Oracle ACFS

If you have a shared Oracle home that is shared using Oracle Advanced Cluster File System (Oracle ACFS), then do the following to extend the Oracle Database Oracle home to node3:

  1. Start the Oracle ACFS resource on the new node by running the following command as root from the Grid_home/bin directory: 

    # srvctl start filesystem -device volume_device [-node node_name]

    Note:

    Make sure the Oracle ACFS resources, including Oracle ACFS registry resource and Oracle ACFS file system resource where the Oracle home is located, are online on the newly added node.

  2. Run the following command as the user that installed Oracle RAC from the Oracle_home/oui/bin directory on the node you are adding to add the Oracle RAC database home: 

    $ ./runInstaller -attachHome ORACLE_HOME="ORACLE_HOME" "CLUSTER_NODES={node3}"
  LOCAL_NODE="node3" ORACLE_HOME_NAME="home_name" -cfs

  3. Navigate to the Oracle_home/addnode directory on node1 and run the addnode.sh script as the user that installed Oracle RAC using the following syntax: 

    $ ./addnode.sh -noCopy "CLUSTER_NEW_NODES={node3}"

    Note:

    Use the -noCopy option because the Oracle home on the destination node is already fully populated with software.

  4. Run the Oracle_home/root.sh script on node3 as root.

Procedure for Shared Oracle Home Not Using Oracle ACFS

If you have a shared Oracle home on a shared file system that is not Oracle ACFS, then you must first create a mount point for the Oracle RAC database home on the target node, mount and attach the Oracle RAC database home, and update the Oracle Inventory:

  1. Run the srvctl config database -db db_name command on an existing node in the cluster to obtain the mount point information.

  2. Run the following command as root on node3 to create the mount point: 

    # mkdir -p mount_point_path

  3. Mount the file system that hosts the Oracle RAC database home.

  4. Run the following command as the user that installed Oracle RAC from the Oracle_home/oui/bin directory on the node you are adding to add the Oracle RAC database home: 

    $ ./runInstaller -attachHome ORACLE_HOME="ORACLE_HOME" "CLUSTER_NODES=
  {local_node_name}" LOCAL_NODE="node_name" ORACLE_HOME_NAME="home_name"

  5. Update the Oracle Inventory as the user that installed Oracle RAC, as follows:

    $ ./runInstaller -updateNodeList ORACLE_HOME=mount_point_path "CLUSTER_NODES=
  {node_list}"

    In the preceding command, node_list refers to a list of all nodes where the Oracle RAC database home is installed, including the node you are adding.

  6. Run the Oracle_home/root.sh script on node3 as root.

You can now add an Oracle RAC database instance to the target node.

draf

Note:

Oracle recommends that you back up the OCR after you complete the node addition process.

Related Topics

Parent topic: Adding and Deleting Oracle RAC from Nodes on Linux and Unix Systems

Adding Administrator-Managed Oracle RAC Database Instances to Target Nodes

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

Parent topic: Adding and Deleting Oracle RAC from Nodes on Linux and Unix Systems

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 DBCA to add Oracle RAC database instances to the target nodes.

This section describes using 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".

Related Topics

Parent topic: Adding Administrator-Managed Oracle RAC Database Instances to Target Nodes

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

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

  1. Ensure that your existing nodes have the $ORACLE_HOME environment variable set to the Oracle RAC home.

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

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

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

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

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

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

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

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

  9. 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 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]

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

Related Topics

Parent topic: Adding Administrator-Managed Oracle RAC Database Instances to Target Nodes

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.

Before you run the dbca command, ensure that you have set the ORACLE_HOME environment variable correctly on the existing nodes. Run 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 11-1 Variables in the 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".

Related Topics

Parent topic: Adding Administrator-Managed Oracle RAC Database Instances to Target Nodes

Adding Policy-Managed Oracle RAC Database Instances to Target Nodes

To add policy-managed Oracle Real Application Clusters (Oracle RAC) instances, you must ensure that certain requirements are met.

Note:

Starting with Oracle Grid Infrastructure 21c, policy-managed databases are deprecated.

You can continue to use existing server pools, and create new pools and policies. Resources using existing server pools can continue to use them transparently.

The use of CRS configuration policies and the CRS policy set can be desupported in a future release. In place of server pools and policy-managed databases, Oracle recommends that you use the new "Merged" management style.

You must manually add undo and redo logs, unless you store your policy-managed database on Oracle Automatic Storage Management (Oracle ASM) and Oracle Managed Files is enabled.

If there is space in a server pool to add a node and the database has been started at least once, then Oracle Clusterware adds the Oracle RAC database instance to the newly added node and no further action is necessary.

Note:

The database must have been started at least once before you can add the database instance to the newly added node.

If there is no space in any server pool, then the newly added node moves into the Free server pool. Use the srvctl modify srvpool command to increase the cardinality of a server pool to accommodate the newly added node, after which the node moves out of the Free server pool and into the modified server pool, and Oracle Clusterware adds the Oracle RAC database instance to the node.

Parent topic: Adding and Deleting Oracle RAC from Nodes on Linux and Unix Systems

Deleting Oracle RAC from a Cluster Node

You can delete Oracle RAC from cluster nodes using this procedure.

To remove Oracle RAC from cluster nodes, delete the database instance and Oracle RAC before removing the node from the cluster.

Note:

If there are no database instances on the node you want to delete, then proceed to "Removing Oracle RAC".

Related Topics

Parent topic: Adding and Deleting Oracle RAC from Nodes on Linux and Unix Systems

Deleting Instances from Oracle RAC Databases

The procedures for deleting database instances are different for policy-managed and administrator-managed databases.

Deleting a policy-managed database instance involves reducing the number of servers in the server pool in which the database instance resides. Deleting an administrator-managed database instance involves using DBCA to delete the database instance.

Deleting Policy-Managed Databases

To delete a policy-managed database, reduce the number of servers in the server pool in which a database instance resides by relocating the server on which the database instance resides to another server pool. This effectively removes the instance without having to remove the Oracle RAC software from the node or the node from the cluster.

For example, you can delete a policy-managed database by running the following commands on any node in the cluster:

$ srvctl stop instance -db db_unique_name -node node_name
$ srvctl relocate server -servers "server_name_list" -serverpool Free

The first command stops the database instance on a particular node and the second command moves the node out of its current server pool and into the Free server pool.

Deleting Instances from Administrator-Managed Databases

Note:

Before deleting an instance from an Oracle RAC database using SRVCTL to do the following:

  • If you have services configured, then relocate the services

  • Modify the services so that each service can run on one of the remaining instances

  • Ensure that the instance to be removed from an administrator-managed database is neither a preferred nor an available instance of any service

Related Topics

Parent topic: Deleting Oracle RAC from a Cluster Node

Using DBCA in Interactive Mode to Delete Instances from Nodes

This procedure explains how to use DBCA in interactive mode to delete instances from Oracle RAC databases.

To delete an instance using DBCA in interactive mode, perform the following steps:

  1. Start DBCA.

    Start DBCA on a node other than the node that hosts the instance that you want to delete. The database and the instance that you plan to delete should be running during this step.

  2. On the DBCA Operations page, select Instance Management and click Next. DBCA displays the Instance Management page.

  3. On the DBCA Instance Management page, select the instance to be deleted, select Delete Instance, and click Next.

  4. On the List of Cluster Databases page, select the Oracle RAC database from which to delete the instance, as follows:

    1. On the List of Cluster Database Instances page, DBCA displays the instances that are associated with the Oracle RAC database that you selected and the status of each instance. Select the cluster database from which you will delete the instance.

    2. Click OK on the Confirmation dialog to proceed to delete the instance.

      DBCA displays a progress dialog showing that DBCA is deleting the instance. During this operation, DBCA removes the instance and the instance's Oracle Net configuration.

      Click No and exit DBCA or click Yes to perform another operation. If you click Yes, then DBCA displays the Operations page.

  5. Verify that the dropped instance's redo thread has been removed by using SQL*Plus on an existing node to query the GV$LOG view. If the redo thread is not disabled, then disable the thread. For example: 

    SQL> ALTER DATABASE DISABLE THREAD 2;

  6. Verify that the instance has been removed from OCR by running the following command, where db_unique_name is the database unique name for your Oracle RAC database: 

    $ srvctl config database -db db_unique_name

  7. If you are deleting more than one node, then repeat these steps to delete the instances from all the nodes that you are going to delete.

Using DBCA in Silent Mode to Delete Instances from Nodes

Learn how to use DBCA in silent mode to delete instances from nodes.

Run the following command, where the variables are the same as those shown in Table 11-1 for the DBCA command to remove an instance. Provide a node name only if you are deleting an instance from a node other than the one on where DBCA is running as shown in the following example where password is the password: 

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

At this point, you have accomplished the following:

  • Deregistered the selected instance from its associated Oracle Net Services listeners

  • Deleted the selected database instance from the instance's configured node

  • Removed the Oracle Net configuration

  • Deleted the Oracle Flexible Architecture directory structure from the instance's configured node.

Removing Oracle RAC

This procedure removes Oracle RAC from the node that you are deleting from a cluster and updates the inventories on the remaining nodes.

  1. If there is a listener in the Oracle RAC home on the node you are deleting, then you must disable and stop it before deleting the Oracle RAC software. Run the following commands on any node in the cluster, specifying the name of the listener and the name of the node you are deleting:

    $ srvctl disable listener -l listener_name -n name_of_node_to_delete
$ srvctl stop listener -l listener_name -n name_of_node_to_delete

  2. Deinstall the Oracle home—only if the Oracle home is not shared—from the node that you are deleting by running the following command from the Oracle_home\deinstall directory: 

    deinstall -local

    Caution:

    If the Oracle home is shared, then do not run this command because it will remove the shared software. Proceed to the next step instead.

Parent topic: Deleting Oracle RAC from a Cluster Node

Deleting Nodes from A Cluster

Use this procedure to delete nodes from a cluster.

After you delete the database instance and Oracle RAC, you can delete the node from the cluster. Do this by running scripts on the node that you want to delete to remove Oracle Clusterware. Then run scripts on the remaining nodes to update the node list.

Related Topics

Parent topic: Deleting Oracle RAC from a Cluster Node