【Oracle Real Application Cluster Database】集群增加节点
原创
©著作权归作者所有：来自51CTO博客作者dbprofessional的原创作品，请联系作者获取转载授权，否则将追究法律责任
[grid@node03 ~]$ ssh-keygen
[grid@node03 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub grid@node03
[grid@node03 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub grid@node01
[grid@node03 ~]$ (ssh node01 "date;hostname";ssh node03 "date;hostname")
Sat Aug 19 09:12:25 CST 2023
node01
Sat Aug 19 09:12:25 CST 2023
node03
[grid@node01 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub grid@node03
[grid@node01 ~]$ (ssh node01 "date;hostname";ssh node03 "date;hostname")
Sat Aug 19 09:12:44 CST 2023
node01
Sat Aug 19 09:12:44 CST 2023
node03
[grid@node01 ~]$ export IGNORE_PREADDNODE_CHECKS=Y
[grid@node01 ~]$ cd $ORACLE_HOME/oui/bin
[grid@node01 bin]$ ./addNode.sh -silent "CLUSTER_NEW_NODES={node03}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={node03-vip}"
......
/u01/app/oraInventory/orainstRoot.sh #On nodes node03
/u01/app/11.2.0.4/grid/root.sh #On nodes node03
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts in each cluster node
The Cluster Node Addition of /u01/app/11.2.0.4/grid was successful.
Please check '/tmp/silentInstall.log' for more details.
[root@node03 ~]# /u01/app/oraInventory/orainstRoot.sh
[root@node03 ~]# /u01/app/11.2.0.4/grid/root.sh
[oracle@node03 ~]$ ssh-keygen
[oracle@node03 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub oracle@node03
[oracle@node03 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub oracle@node01
[oracle@node03 ~]$ (ssh node01 "date;hostname";ssh node03 "date;hostname")
Sun May 5 10:12:58 CST 2019
node01
Sun May 5 10:12:58 CST 2019
node03
[oracle@node01 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub oracle@node03
[oracle@node01 ~]$ (ssh node01 "date;hostname";ssh node03 "date;hostname")
Sat Aug 19 09:18:06 CST 2023
node01
Sat Aug 19 09:18:06 CST 2023
node03
[oracle@node01 ~]$ cd $ORACLE_HOME/oui/bin
[oracle@node01 bin]$ ./addNode.sh -silent "CLUSTER_NEW_NODES={node03}"
......
/u01/app/oracle/product/11.2.0/db_1/root.sh #On nodes node03
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts in each cluster node
The Cluster Node Addition of /u01/app/oracle/product/11.2.0/db_1 was successful.
Please check '/tmp/silentInstall.log' for more details.
[root@node03 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
[grid@node03 ~]$ crsctl check cluster -all
**************************************************************
node01:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
node02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
node03:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@node03 ~]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE node03 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE node03
ora.crf
1 ONLINE ONLINE node03
ora.crsd
1 ONLINE ONLINE node03
ora.cssd
1 ONLINE ONLINE node03
ora.cssdmonitor
1 ONLINE ONLINE node03
ora.ctssd
1 ONLINE ONLINE node03 OBSERVER
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE node03
ora.gipcd
1 ONLINE ONLINE node03
ora.gpnpd
1 ONLINE ONLINE node03
ora.mdnsd
1 ONLINE ONLINE node03
[grid@node03 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node01
ONLINE ONLINE node02
ONLINE ONLINE node03
ora.FRA.dg
ONLINE ONLINE node01
ONLINE ONLINE node02
ONLINE ONLINE node03
ora.LISTENER.lsnr
ONLINE ONLINE node01
ONLINE ONLINE node02
ONLINE ONLINE node03
ora.OCRVDISK.dg
ONLINE ONLINE node01
ONLINE ONLINE node02
ONLINE ONLINE node03
ora.asm
ONLINE ONLINE node01 Started
ONLINE ONLINE node02 Started
ONLINE ONLINE node03 Started
ora.gsd
OFFLINE OFFLINE node01
OFFLINE OFFLINE node02
OFFLINE OFFLINE node03
ora.net1.network
ONLINE ONLINE node01
ONLINE ONLINE node02
ONLINE ONLINE node03
ora.ons
ONLINE ONLINE node01
ONLINE ONLINE node02
ONLINE ONLINE node03
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node01
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE node03
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE node02
ora.cvu
1 ONLINE ONLINE node02
ora.oc4j
1 ONLINE ONLINE node02
ora.scan1.vip
1 ONLINE ONLINE node01
ora.scan2.vip
1 ONLINE ONLINE node03
ora.scan3.vip
1 ONLINE ONLINE node02
ora.node.db
1 ONLINE ONLINE node01 Open
2 ONLINE ONLINE node02 Open
3 ONLINE ONLINE node03 Open
ora.node01.vip
1 ONLINE ONLINE node01
ora.node02.vip
1 ONLINE ONLINE node02
ora.node03.vip
1 ONLINE ONLINE node03
