Add new node to the RAC

Pre node addition verification :
------------------------------------

 OS , Version and 32/bit bit must match , configuring network interconnects, configuring shared disk subsystem connections, Create Oracel users,Ensure that SSH is configured


$cluvfy stage -post hwos -n node_list | all [-verbose]

 [oracle@rac1 bin]$ $Grid_home/bin/cluvfy stage -pre nodeadd -n racnode3 -fixup -verbose



Extend the Gird Home on rac3 node :
--------------------------------------------


[oracle@rac1 bin]$ export IGNORE_PREADDNODE_CHECKS=Y
[oracle@rac1 bin]$ export ORACLE_HOME=/u01/app/11.2.0/grid
[oracle@rac1 bin]$ cd $ORACLE_HOME/oui/bin

[oracle@rac1 bin]$ ./addNode.sh -silent “CLUSTER_NEW_NODES={rac3}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac3-vip}” “CLUSTER_NEW_PRIVATE_NODE_NAMES={rac3-priv}”


[root@rac3 bin]$ /u01/app/oraInventory/orainstRoot.sh
[root@rac3 bin]$ /u01/app/11.2.0/grid/root.sh


Extend the Oracle Database Software on rac3 node :
--------------------------------------------------------------

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
[oracle@rac1 ~]$ cd $ORACLE_HOME/oui/bin
[oracle@rac1 bin]$ ./addNode.sh -silent "CLUSTER_NEW_NODES={rac3}"

[root@rac3 bin]$ /u01/app/11.2.0/dbhome_1/root.sh



[oracle@rac3 ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@rac3 ~]$ cd $ORACLE_HOME/dbs
[oracle@rac3 dbs]$ ls

hc_orcl1.dat  init.ora  initorcl1.ora  orapworcl1

[oracle@rac3 dbs]$ mv initorcl1.ora initorcl3.ora
[oracle@rac3 dbs]$ mv orapworcl1    orapworcl3
[oracle@rac3 dbs]$ echo "orcl3:$ORACLE_HOME:N" >> /etc/oratab



From rac1(existing node) create  log thread, undo tablespace, and init.ora entries for the new instance :
-------------------------------------------------------------------------------------------------------------------------

[oracle@rac1 bin]$ export ORACLE_SID=orcl1
[oracle@rac1 bin]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@rac1 bin]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@rac1 bin]$ sqlplus ‘/as sysdba’


SQL> alter database add logfile thread 3 group 5 ('+DATA') size 50M, group 6 ('+DATA') size 50M;
SQL> alter database enable public thread 3;

SQL> create undo tablespace undotbs3 datafile '+DATA' size 200M autoextend on;
SQL> alter system set undo_tablespace='undotbs3' scope=spfile sid='orcl3';

SQL> alter system set instance_number=3 scope=spfile sid='orcl3';
SQL> alter system set cluster_database_instances=3 scope=spfile sid='*';



Update Oracle Cluster Registry (OCR) :
-----------------------------------------------

[oracle@rac3 bin]$ ./srvctl add instance -d orcl -i orcl3 -n rac3
[oracle@rac3 bin]$ ./srvctl status database -d orcl -v
[oracle@rac3 bin]$ ./srvctl config database -d orcl



Start the Instance  :
-----------------------
[oracle@rac3 bin]$ ./srvctl config database -d orcl
[oracle@rac3 bin]$./srvctl start instance -d orcl -i orcl3
[oracle@rac3 bin]$ ./srvctl status database -d orcl -v