Oracle 19C RAC Node Addition steps

 Dear All,

In this post i am going to share the rac node addition steps ..

Present we are having 2 node Rac setup , we are going to add Node3 ..

Before node addition : 

Node addtion :: RAC 

---------------

1)  Configure Node3 will all pre-requisites and add IP's into remain nodes.

>> Add these IPs into resvers zone / forward zone .. /var/named/localdomain.zone ..   /var/named/4.38.10.in-addr.arpa

node3 : preparation steps 

-------------------------

cat /etc/resolv.conf

cd /var/named/

0.168.192.in-addr.arpa

localdomain.zone

[root@racs2 named]# cat localdomain.zone

$TTL 86400

@ IN SOA racs2.localdomain.com. root.localdomain.com. (

2014051001 ; serial

3600 ; refresh

1800 ; retry

604800 ; expire

86400 ; minimum

)

@ IN NS racs2.localdomain.

localhost IN A 127.0.0.1

racs1 IN A 192.168.0.71

racs2 IN A 192.168.0.72

racs1-priv IN A 192.168.10.1

racs2-priv IN A 192.168.10.2

racs1-vip IN A 192.168.0.81

racs2-vip IN A 192.168.0.82

racs-scan IN A 192.168.0.91

racs-scan IN A 192.168.0.92

racs-scan IN A 192.168.0.93

[root@racs2 named]# 

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

>> OH 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 between all the nodes ..

./sshUserSetup.sh -user oracle -hosts "racs1 racs2 racs3" -noPromptPassphrase -confirm -advanced

./sshUserSetup.sh -user grid -hosts "racs1 racs2 racs3" -noPromptPassphrase -confirm -advanced

./sshUserSetup.sh -user root -hosts "racs1 racs2 racs3" -noPromptPassphrase -confirm -advanced

4) Verify the Cluvfy Utility & Node pre-requisites - From Node1 

/u02/app/19.0.0/grid_home/bin   ## node to node comparison check 

>> cd $G_H/bin/cluvfy comp peer -n racs3 -refnode racs1 -r 19

/u02/app/19.0.0/grid_home/bin   ## pre-requisites check 

cluvfy stage -pre nodeadd -n racs3 -fixup -verbose

if any fixup.sh .. run from node3 ... under root users 

export IGNORE_PREADDNODE_CHECKS=Y

/u02/app/19.0.0/grid_home/addnode

./addnode.sh -silent "CLUSTER_NEW_NODES={racs3.localdomain.com}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={racs3-vip.localdomain.com}"

orainstRoot.sh 

root.sh

5) Check the cluster status 

crsctl stat res -t 

crsctl check cluster -all 

6) set the oracle home for racs3 from racs1 ..

set the environment 

$ORACLE_HOME/addnode 

./addnode.sh -silent "CLUSTER_NEW_NODES={racs3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={racs3-vip}"

root.sh 

7) Update the inventory for Racs3 

cd $O_H/oui/bin/runInstaller -updateNodeList -noClusterEnabled ORACLE_HOME=homepath CLUSTER_NODES=racs1,racs2,racs3 CRS=false

"INVENTORY_LOCATION=/u02/app/oraInventory" LOCAL_NODE=3

cd $ORACLE_HOME/addnode

 ./addnode.sh "CLUSTER_NEW_NODES={racs3}"

cd $ORACLE_HOME/bin

./dbca 

>> run the root.sh

add instance to Cluster database for Racs3 node 

srvctl add instance -d RACS -i racs3 -n racs3  ## by using dbca also we can add the node3 instance to cluster .

After node addition : 

Thanks,

Srini