RAC Node Addition Steps
At Present we are having 2 node Rac Environment , we are going to add Node3 ..
RAC – Node Addition
1)Assigning IP address in all Node1 and Node2 to configure Node3.
Adding below IP address into resvers zone / forward zone .. /var/named/localdomain.zone .. /var/named/4.38.10.in-addr.arpa
preparation task – Node 3
cat /etc/resolv.conf
cd /var/named/
0.168.192.in-addr.arpa
oracle@rac2# cat localdomain.zone
IN SOA oracle.localdomain.com. oracle.localdomain.com.
(
2022123110 ; serial
4200 ; refresh
3600 ; retry
320600 ; expire
52600 ; minimum
)
IN NS oracle.localdomain
localhost IN A 127.0.0.1
oracle1 IN A 192.168.0.21
oracle2 IN A 192.168.0.22
oracle1-priv IN A 192.168.11.3
oracle2-priv IN A 192.168.11.5
oracle1-vip IN A 192.168.0.22
oracle2-vip IN A 192.168.0.32
oracle-scan IN A 192.168.0.11
oracle-scan IN A 192.168.0.12
oracle-scan IN A 192.168.0.03
oracle@oracle2#
—create the grid and oracle users on Node3
rpm -qa|grep oracle
create the directores for oracle home, grid home , create the groups and add those to grid and oracle users
2) Install Oracle asm Librarys , Grid software , oracle software , create instance3 and attache the shared disks on node3.
oracleasm init
oracleasm configure -i grid , oinstall , y , y
oracleasm scandisks
oracleasm listdisks
GI Installation -> GI_HOME/gridSetup.sh (GUI)
Add new cluster nodes -> GI_HOME/gridSetup.sh (GUI) or GI_HOME/addnode/addnode.sh (Command line)
ORACLE_HOME Installation -> runInstaller (GUI)
Add OH on newly added nodes -> ORACLE_HOME/addnode/addnode.sh (GUI) or ORACLE_HOME/addnode/addnode.sh (Command line)
create database/create Instance -> ORACLE_HOME/bin/dbca (GUI)
add 3rd Insatnce -> ORACLE_HOME/bin/dbca (GUI) or srvctl add instance (Command line)
3) Enable the password less connectivity on all three nodes.
./sshUserSetup.sh -user oracle -hosts “oracle1 oracle2 oracle” -noPromptPassphrase -confirm -advanced
./sshUserSetup.sh -user grid -hosts “oracle1 oracle2 oracle” -noPromptPassphrase -confirm -advanced
./sshUserSetup.sh -user root -hosts “oracle1 oracle2 oracle” -noPromptPassphrase -confirm -advanced
4) Verify the Cluvfy Utility & Node pre-requisites – From Node1
/u01/app/19.0.0/grid_home/bin ## node to node comparison check
cd $G_H/bin/cluvfy comp peer -n oracle -refnode oracle1 -r 19
/u01/app/19.0.0/grid_home/bin ## pre-requisites check
cluvfy stage -pre nodeadd -n oracle -fixup -verbose
if any fixup.sh .. run from node3 … under root users
export IGNORE_PREADDNODE_CHECKS=Y
/u01/app/19.0.0/grid_home/addnode
./addnode.sh -silent “CLUSTER_NEW_NODES={oracle.localdomain.com}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={oracle-vip.localdomain.com}”
orainstRoot.sh
root.sh
5) Please verify the cluster status
crsctl stat res -t
crsctl check cluster -all
6) set the oracle home for oracle from oracle1 ..
set the environment
$ORACLE_HOME/addnode
./addnode.sh -silent “CLUSTER_NEW_NODES={oracle}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={oracle-vip}”
root.sh
7) Update the inventory for oracle
cd $ORACLE_HOME/oui/bin/runInstaller -updateNodeList -noClusterEnabled ORACLE_HOME=homepath CLUSTER_NODES=oracle1,oracle2,oracle CRS=false
“INVENTORY_LOCATION=/u01/app/oraInventory” LOCAL_NODE=3
cd $ORACLE_HOME/addnode
./addnode.sh “CLUSTER_NEW_NODES={oracle}”
cd $ORACLE_HOME/bin
./dbca
run the root.sh
adding instance to Cluster database for oracle node
srvctl add instance -d oracle -i oracle -n oracle ## by using dbca also we can add the node3 instance to cluster .
