DB:Oracle 12c
以下环境中,有一个2节点RAC,node1+node2,集群模式为flex集群且都是hub角色,现计划新增一个节点node3,角色为leaf。
先为node3做预先准备,与新安装时一样。完成后在node1上预检,以grid用户运行:
点击(此处)折叠或打开
-
$ cluvfy stage -pre nodeadd -n node3 -fixup -verbose
-
-
#出现以下输出表示成功
-
Checking Flex Cluster node role configuration...
-
Flex Cluster node role configuration check passed
-
- Pre-check for node addition was successful.
点击(此处)折叠或打开
- $GRID_HOME/addnode/addnode.sh -silent "CLUSTER_NEW_NODES={node3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3-vip}" "CLUSTER_NEW_NODE_ROLES={leaf}"
运行完后,会出现如下提示,按提示在新节点node3上以root用户运行:
点击(此处)折叠或打开
-
As a root user, execute the following script(s):
-
1. /u01/app/oraInventory/orainstRoot.sh
-
2. /u01/app/12.1.0/grid/root.sh
-
-
Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
-
[node3]
-
Execute /u01/app/12.1.0/grid/root.sh on the following nodes:
- [node3]
点击(此处)折叠或打开
-
cluvfy stage -post nodeadd -n node3
-
-
$ crsctl check cluster -all
-
**************************************************************
-
node1:
-
CRS-4537: Cluster Ready Services is online
-
CRS-4529: Cluster Synchronization Services is online
-
CRS-4533: Event Manager is online
-
**************************************************************
-
node2:
-
CRS-4537: Cluster Ready Services is online
-
CRS-4529: Cluster Synchronization Services is online
-
CRS-4533: Event Manager is online
-
**************************************************************
-
node3:
-
CRS-4537: Cluster Ready Services is online
-
CRS-4529: Cluster Synchronization Services is online
-
CRS-4533: Event Manager is online
-
**************************************************************
-
-
$ olsnodes -n
-
node1 1
-
node2 2
- node3 100
在node1上以oracle用户运行:
点击(此处)折叠或打开
- $ORACLE_HOME/addnode/addnode.sh -silent "CLUSTER_NEW_NODES={node3}"
点击(此处)折叠或打开
-
As a root user, execute the following script(s):
-
1. /u01/app/oracle/product/12.1.0/db_1/root.sh
-
-
Execute /u01/app/oracle/product/12.1.0/db_1/root.sh on the following nodes:
- [node3]
然后,node3还可能需要VIP。
确认当前node3有无VIP。无则添加一个。
点击(此处)折叠或打开
-
$ srvctl config vip -n node3
-
PRKO-2310 : VIP does not exist on node node3.
-
-
#添加VIP,以root用户运行
-
# /u01/app/12.1.0/grid/bin/srvctl add vip -node node3 -netnum 1 -address node3-vip.demo.com/255.255.255.0
- # /u01/app/12.1.0/grid/bin/srvctl start vip -n node3
如果是添加一个Hub节点,就需要新建实例了。新建实例使用DBCA->Instance Management。