add node - liamlamth/blog GitHub Wiki

reference:
i) https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/adding-and-deleting-cluster-nodes.html
ii) https://dbaclass.com/article/how-to-add-a-node-in-oracle-rac-19c/

prepare os step and stop at (4) install grid: building rac
verify the hardware and operating system installations
```
[grid@node1 ~]# cluvfy comp peer -n node2
```

extend grid home and add asm instance

[grid@node1 ~]# export DISPLAY=192.168.10.2:0.0
[grid@node1 ~]# $GRID_HOME/gridSetup.sh

extend oracle home

## to bypass ssh bug INS-06006, temporarily changing scp
  [root@node1 ~]# mv /usr/bin/scp /usr/bin/scp.orig
  [root@node1 ~]# echo "/usr/bin/scp.orig -T \$*" > /usr/bin/scp && chmod 555 /usr/bin/scp
[oracle@node1 ~]# export DISPLAY=192.168.10.2:0.0
[oracle@node1 ~]# export CV_ASSUME_DISTID=OEL7.8
[oracle@node1 ~]# $ORACLE_HOME/addnode/addnode.sh "CLUSTER_NEW_NODES={node2}"
  [root@node1 ~]# mv -f /usr/bin/scp.orig /usr/bin/scp

add database instance

[oracle@node1 ~]# export DISPLAY=192.168.10.2:0.0
[oracle@node1 ~]# export CV_ASSUME_DISTID=OEL7.8
[oracle@node1 ~]# dbca

error

CLSRSC-571

[root@node2 ~]# /u01/app/19.0.0/grid/root.sh
oracle.ops.mgmt.cluster.ClusterException: scp: /u01/app/19.0.0/grid/crs/install/crsgenconfig_params: No such file or directory

2022/01/01 12:00:00 CLSRSC-180: An error occurred while executing the command '/u01/app/19.0.0/grid/bin/cluutil 
                                 -copy -sourcefile /u01/app/19.0.0/grid/crs/install/crsgenconfig_params -fromnodesfile 
                                /tmp/umA1EWm82A -destfile /u01/app/19.0.0/grid/crs/install/crsgenconfig_params -nodelist node2'
2022/01/01 12:00:00 CLSRSC-571: failed to copy file '/u01/app/19.0.0/grid/crs/install/crsgenconfig_params' from node 'node1' 
                                to file '/u01/app/19.0.0/grid/crs/install/crsgenconfig_params' on local node
Died at /u01/app/19.0.0/grid/crs/install/crsutils.pm line 15907

solution: create crsgenconfig_params

  [root@node1 ~]$ crsctl query cluster site -all
  Site 'testrac-cluster' identified by GUID '9565d70f657a5f82bf72cd2851aaf48e' in state 'ENABLED'
  contains nodes 'node1' and no disks can be discovered from this site.
[grid@node1 ~]$ cat $GRID_HOME/crs/install/crsconfig_params | grep EXTENDED_CLUSTER_
  EXTENDED_CLUSTER_SITES=testrac-cluster
  EXTENDED_CLUSTER_SITE_GUIDS=
[grid@node1 ~]$ vi $GRID_HOME/crs/install/crsgenconfig_params
  EXTENDED_CLUSTER_SITE_GUIDS=lpd-cluster:9565d70f657a5f82bf72cd2851aaf48e

comment: likely abnormal behavior, subsequence action/management may lead to dead end

CRS-1705

CRS-1705: Found 0 configured voting files but 1 voting files are required, terminating to ensure data integrity

comment: Doc ID 2789052.1 does not work, this is a dead end

add node - liamlamth/blog GitHub Wiki

⚠️ **GitHub.com Fallback** ⚠️

⚠️ GitHub.com Fallback ⚠️