Adding Oracle RAC to Nodes with Oracle Grid Infrastructure Installed
To add Oracle Real Application Clusters (Oracle RAC) with Oracle Grid Infrastructure 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).
- Navigate to the
Oracle_home /addnodedirectory onnode1and run theaddnode.shscript. If you want to perform a silent installation, run the
addnode.shscript using the following syntax:$ ./addnode.sh -silent "CLUSTER_NEW_NODES={node3}"- Run the
Oracle_home/root.shscript onnode3asroot. Manually copy the
tnsnames.orafile from your old node to the newly added node.$ cd $ORACLE_BASE_HOME/network/admin $ sftp tnsnames.ora new_node:$ORACLE_BASE_HOME/network/admin/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 AI Database Oracle home to node3:
Start the Oracle ACFS resource on the new node by running the following command as
rootfrom theGrid_home /bindirectory:# 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.
Run the following command as the user who installed Oracle RAC from the
Oracle_home /oui/bindirectory 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" -cfsNavigate to the
Oracle_home /addnodedirectory onnode1and run theaddnode.shscript as the user who installed Oracle RAC using the following syntax:$ ./addnode.sh -noCopy "CLUSTER_NEW_NODES={node3}"Note:
Use the
-noCopyoption because the Oracle home on the destination node is already fully populated with software.- Run the
Oracle_home /root.shscript onnode3asroot.
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:
- Run the
srvctl config database -db db_namecommand on an existing node in the cluster to obtain the mount point information. Run the following command as
rootonnode3to create the mount point:# mkdir -p mount_point_path- Mount the file system that hosts the Oracle RAC database home.
Run the following command as the user who installed Oracle RAC from the
Oracle_home /oui/bindirectory 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"- Update the Oracle Inventory as the user who installed Oracle RAC, as follows:
$ ./runInstaller -updateNodeList ORACLE_HOME=mount_point_path "CLUSTER_NODES= {node_list}"In the preceding command,
node_listrefers to a list of all nodes where the Oracle RAC database home is installed, including the node you are adding. - Run the
Oracle_home /root.shscript onnode3asroot.
You can now add an Oracle RAC database instance to the target node.
Note:
Oracle recommends that you back up the OCR after you complete the node addition process.
Related Topics