当前位置:Gxlcms > 数据库问题 > Oracle 学习之RAC(八) 向集群中添加节点

Oracle 学习之RAC(八) 向集群中添加节点

时间:2021-07-01 10:21:17 帮助过:6人阅读

  我们前面安装了两个节点的RAC。 我们现在将第三个节点11grac3,添加到我们集群中。第三个节点一定要按照集群环境准备一文描述,准备环境。请参考 http://lqding.blog.51cto.com/9123978/1684159 

  1. 安装前检查

11grac1-> pwd
/u01/app/11.2.0/grid/bin
11grac1-> ./cluvfy stage -pre nodeadd -n 11grac3 -fixup -verbose

检查结果

Performing pre-checks for node addition 

Checking node reachability...

Check: Node reachability from node "11grac1"
  Destination Node                      Reachable?              
  ------------------------------------  ------------------------
  11grac3                               yes                     
Result: Node reachability check passed from node "11grac1"


Checking user equivalence...

Check: User equivalence for user "grid"
  Node Name                             Status                  
  ------------------------------------  ------------------------
  11grac3                               passed                  
Result: User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...
  Node Name                             Status                  
  ------------------------------------  ------------------------
  11grac1                               passed                  
  11grac2                               passed                  
  11grac3                               passed                  

Verification of the hosts config file successful


Interface information for node "11grac1"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 eth0   192.168.199.10  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:53:75:BC 1500  
 eth0   192.168.199.30  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:53:75:BC 1500  
 eth0   192.168.199.20  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:53:75:BC 1500  
 eth1   192.168.10.10   192.168.10.0    0.0.0.0         192.168.199.1   00:0C:29:53:75:C6 1500  
 eth1   169.254.67.6    169.254.0.0     0.0.0.0         192.168.199.1   00:0C:29:53:75:C6 1500  


Interface information for node "11grac2"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 eth0   192.168.199.11  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:5A:86:53 1500  
 eth0   192.168.199.21  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:5A:86:53 1500  
 eth1   192.168.10.11   192.168.10.0    0.0.0.0         192.168.199.1   00:0C:29:5A:86:5D 1500  
 eth1   169.254.72.43   169.254.0.0     0.0.0.0         192.168.199.1   00:0C:29:5A:86:5D 1500  


Interface information for node "11grac3"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 eth0   192.168.199.12  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:8A:12:9A 1500  
 eth1   192.168.10.12   192.168.10.0    0.0.0.0         192.168.199.1   00:0C:29:8A:12:A4 1500  


Check: Node connectivity for interface "eth0"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  11grac1[192.168.199.10]         11grac1[192.168.199.30]         yes             
  11grac1[192.168.199.10]         11grac1[192.168.199.20]         yes             
  11grac1[192.168.199.10]         11grac2[192.168.199.11]         yes             
  11grac1[192.168.199.10]         11grac2[192.168.199.21]         yes             
  11grac1[192.168.199.10]         11grac3[192.168.199.12]         yes             
  11grac1[192.168.199.30]         11grac1[192.168.199.20]         yes             
  11grac1[192.168.199.30]         11grac2[192.168.199.11]         yes             
  11grac1[192.168.199.30]         11grac2[192.168.199.21]         yes             
  11grac1[192.168.199.30]         11grac3[192.168.199.12]         yes             
  11grac1[192.168.199.20]         11grac2[192.168.199.11]         yes             
  11grac1[192.168.199.20]         11grac2[192.168.199.21]         yes             
  11grac1[192.168.199.20]         11grac3[192.168.199.12]         yes             
  11grac2[192.168.199.11]         11grac2[192.168.199.21]         yes             
  11grac2[192.168.199.11]         11grac3[192.168.199.12]         yes             
  11grac2[192.168.199.21]         11grac3[192.168.199.12]         yes             
Result: Node connectivity passed for interface "eth0"


Check: TCP connectivity of subnet "192.168.199.0"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  11grac1:192.168.199.10          11grac1:192.168.199.30          passed          
  11grac1:192.168.199.10          11grac1:192.168.199.20          passed          
  11grac1:192.168.199.10          11grac2:192.168.199.11          passed          
  11grac1:192.168.199.10          11grac2:192.168.199.21          passed          
  11grac1:192.168.199.10          11grac3:192.168.199.12          passed          
Result: TCP connectivity check passed for subnet "192.168.199.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.199.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.199.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.199.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Checking CRS integrity...

Clusterware version consistency passed
The Oracle Clusterware is healthy on node "11grac1"
The Oracle Clusterware is healthy on node "11grac2"

CRS integrity check passed

Checking shared resources...

Checking CRS home location...
"/u01/app/11.2.0/grid" is shared
Result: Shared resources check for node addition passed


Checking node connectivity...

Checking hosts config file...
  Node Name                             Status                  
  ------------------------------------  ------------------------
  11grac1                               passed                  
  11grac2                               passed                  
  11grac3                               passed                  

Verification of the hosts config file successful


Interface information for node "11grac1"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 eth0   192.168.199.10  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:53:75:BC 1500  
 eth0   192.168.199.30  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:53:75:BC 1500  
 eth0   192.168.199.20  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:53:75:BC 1500  
 eth1   192.168.10.10   192.168.10.0    0.0.0.0         192.168.199.1   00:0C:29:53:75:C6 1500  
 eth1   169.254.67.6    169.254.0.0     0.0.0.0         192.168.199.1   00:0C:29:53:75:C6 1500  


Interface information for node "11grac2"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 eth0   192.168.199.11  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:5A:86:53 1500  
 eth0   192.168.199.21  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:5A:86:53 1500  
 eth1   192.168.10.11   192.168.10.0    0.0.0.0         192.168.199.1   00:0C:29:5A:86:5D 1500  
 eth1   169.254.72.43   169.254.0.0     0.0.0.0         192.168.199.1   00:0C:29:5A:86:5D 1500  


Interface information for node "11grac3"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 eth0   192.168.199.12  192.168.199.0   0.0.0.0         192.168.199.1   00:0C:29:8A:12:9A 1500  
 eth1   192.168.10.12   192.168.10.0    0.0.0.0         192.168.199.1   00:0C:29:8A:12:A4 1500  


Check: Node connectivity for interface "eth0"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  11grac1[192.168.199.10]         11grac1[192.168.199.30]         yes             
  11grac1[192.168.199.10]         11grac1[192.168.199.20]         yes             
  11grac1[192.168.199.10]         11grac2[192.168.199.11]         yes             
  11grac1[192.168.199.10]         11grac2[192.168.199.21]         yes             
  11grac1[192.168.199.10]         11grac3[192.168.199.12]         yes             
  11grac1[192.168.199.30]         11grac1[192.168.199.20]         yes             
  11grac1[192.168.199.30]         11grac2[192.168.199.11]         yes             
  11grac1[192.168.199.30]         11grac2[192.168.199.21]         yes             
  11grac1[192.168.199.30]         11grac3[192.168.199.12]         yes             
  11grac1[192.168.199.20]         11grac2[192.168.199.11]         yes             
  11grac1[192.168.199.20]         11grac2[192.168.199.21]         yes             
  11grac1[192.168.199.20]         11grac3[192.168.199.12]         yes             
  11grac2[192.168.199.11]         11grac2[192.168.199.21]         yes             
  11grac2[192.168.199.11]         11grac3[192.168.199.12]         yes             
  11grac2[192.168.199.21]         11grac3[192.168.199.12]         yes             
Result: Node connectivity passed for interface "eth0"


Check: TCP connectivity of subnet "192.168.199.0"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  11grac1:192.168.199.10          11grac1:192.168.199.30          passed          
  11grac1:192.168.199.10          11grac1:192.168.199.20          passed          
  11grac1:192.168.199.10          11grac2:192.168.199.11          passed          
  11grac1:192.168.199.10          11grac2:192.168.199.21          passed          
  11grac1:192.168.199.10          11grac3:192.168.199.12          passed          
Result: TCP connectivity check passed for subnet "192.168.199.0"


Check: Node connectivity for interface "eth1"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  11grac1[192.168.10.10]          11grac2[192.168.10.11]          yes             
  11grac1[192.168.10.10]          11grac3[192.168.10.12]          yes             
  11grac2[192.168.10.11]          11grac3[192.168.10.12]          yes             
Result: Node connectivity passed for interface "eth1"


Check: TCP connectivity of subnet "192.168.10.0"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  11grac1:192.168.10.10           11grac2:192.168.10.11           passed          
  11grac1:192.168.10.10           11grac3:192.168.10.12           passed          
Result: TCP connectivity check passed for subnet "192.168.10.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.199.0".
Subnet mask consistency check passed for subnet "192.168.10.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.199.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.199.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "192.168.10.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.10.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Check: Total memory 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  11grac3       1.9535GB (2048424.0KB)    1.5GB (1572864.0KB)       passed    
  11grac1       1.9535GB (2048424.0KB)    1.5GB (1572864.0KB)       passed    
Result: Total memory check passed

Check: Available memory 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  11grac3       1.7724GB (1858504.0KB)    50MB (51200.0KB)          passed    
  11grac1       671.7305MB (687852.0KB)   50MB (51200.0KB)          passed    
Result: Available memory check passed

Check: Swap space 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  11grac3       1.9531GB (2047996.0KB)    2.9303GB (3072636.0KB)    failed    
  11grac1       1.9531GB (2047996.0KB)    2.9303GB (3072636.0KB)    failed    
Result: Swap space check failed

Check: Free disk space for "11grac3:/u01/app/11.2.0/grid,11grac3:/tmp" 
  Path              Node Name     Mount point   Available     Required      Status      
  ----------------  ------------  ------------  ------------  ------------  ------------
  /u01/app/11.2.0/grid  11grac3       /             14.1611GB     7.5GB         passed      
  /tmp              11grac3       /             14.1611GB     7.5GB         passed      
Result: Free disk space check passed for "11grac3:/u01/app/11.2.0/grid,11grac3:/tmp"

Check: Free disk space for "11grac1:/u01/app/11.2.0/grid,11grac1:/tmp" 
  Path              Node Name     Mount point   Available     Required      Status      
  ----------------  ------------  ------------  ------------  ------------  ------------
  /u01/app/11.2.0/grid  11grac1       /             3.9131GB      7.5GB         failed      
  /tmp              11grac1       /             3.9131GB      7.5GB         failed      
Result: Free disk space check failed for "11grac1:/u01/app/11.2.0/grid,11grac1:/tmp"

Check: User existence for "grid" 
  Node Name     Status                    Comment                 
  ------------  ------------------------  ------------------------
  11grac3       passed                    exists(1100)            
  11grac1       passed                    exists(1100)            

Checking for multiple users with UID value 1100
Result: Check for multiple users with UID value 1100 passed 
Result: User existence check passed for "grid"

Check: Run level 
  Node Name     run level                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  11grac3       5                         3,5                       passed    
  11grac1       5                         3,5                       passed    
Result: Run level check passed

Check: Hard limits for "maximum open file descriptors" 
  Node Name         Type          Available     Required      Status          
  ----------------  ------------  ------------  ------------  ----------------
  11grac1           hard          65536         65536         passed          
  11grac3           hard          65536         65536         passed          
Result: Hard limits check passed for "maximum open file descriptors"

Check: Soft limits for "maximum open file descriptors" 
  Node Name         Type          Available     Required      Status          
  ----------------  ------------  ------------  ------------  ----------------
  11grac1           soft          1024          1024          passed          
  11grac3           soft          1024          1024          passed          
Result: Soft limits check passed for "maximum open file descriptors"

Check: Hard limits for "maximum user processes" 
  Node Name         Type          Available     Required      Status          
  ----------------  ------------  ------------  ------------  ----------------
  11grac1           hard          16384         16384         passed          
  11grac3           hard          16384         16384         passed          
Result: Hard limits check passed for "maximum user processes"

Check: Soft limits for "maximum user processes" 
  Node Name         Type          Available     Required      Status          
  ----------------  ------------  ------------  ------------  ----------------
  11grac1           soft          2047          2047          passed          
  11grac3           soft          2047          2047          passed          
Result: Soft limits check passed for "maximum user processes"

Check: System architecture 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  11grac3       x86_64                    x86_64                    passed    
  11grac1       x86_64                    x86_64                    passed    
Result: System architecture check passed

Check: Kernel version 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  11grac3       2.6.39-400.17.1.el6uek.x86_64  2.6.32                    passed    
  11grac1       2.6.39-400.17.1.el6uek.x86_64  2.6.32                    passed    
Result: Kernel version check passed

Check: Kernel parameter for "semmsl" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           250           250           250           passed          
  11grac3           250           250           250           passed          
Result: Kernel parameter check passed for "semmsl"

Check: Kernel parameter for "semmns" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           32000         32000         32000         passed          
  11grac3           32000         32000         32000         passed          
Result: Kernel parameter check passed for "semmns"

Check: Kernel parameter for "semopm" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           100           100           100           passed          
  11grac3           100           100           100           passed          
Result: Kernel parameter check passed for "semopm"

Check: Kernel parameter for "semmni" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           128           128           128           passed          
  11grac3           128           128           128           passed          
Result: Kernel parameter check passed for "semmni"

Check: Kernel parameter for "shmmax" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           1054472192    1054472192    1048793088    passed          
  11grac3           1054472192    1054472192    1048793088    passed          
Result: Kernel parameter check passed for "shmmax"

Check: Kernel parameter for "shmmni" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           4096          4096          4096          passed          
  11grac3           4096          4096          4096          passed          
Result: Kernel parameter check passed for "shmmni"

Check: Kernel parameter for "shmall" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           2097152       2097152       2097152       passed          
  11grac3           2097152       2097152       2097152       passed          
Result: Kernel parameter check passed for "shmall"

Check: Kernel parameter for "file-max" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           6815744       6815744       6815744       passed          
  11grac3           6815744       6815744       6815744       passed          
Result: Kernel parameter check passed for "file-max"

Check: Kernel parameter for "ip_local_port_range" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           between 9000.0 & 65500.0  between 9000.0 & 65500.0  between 9000.0 & 65500.0  passed          
  11grac3           between 9000.0 & 65500.0  between 9000.0 & 65500.0  between 9000.0 & 65500.0  passed          
Result: Kernel parameter check passed for "ip_local_port_range"

Check: Kernel parameter for "rmem_default" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           262144        262144        262144        passed          
  11grac3           262144        262144        262144        passed          
Result: Kernel parameter check passed for "rmem_default"

Check: Kernel parameter for "rmem_max" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           4194304       4194304       4194304       passed          
  11grac3           4194304       4194304       4194304       passed          
Result: Kernel parameter check passed for "rmem_max"

Check: Kernel parameter for "wmem_default" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           262144        262144        262144        passed          
  11grac3           262144        262144        262144        passed          
Result: Kernel parameter check passed for "wmem_default"

Check: Kernel parameter for "wmem_max" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           1048586       1048586       1048576       passed          
  11grac3           1048586       1048586       1048576       passed          
Result: Kernel parameter check passed for "wmem_max"

Check: Kernel parameter for "aio-max-nr" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  11grac1           1048576       1048576       1048576       passed          
  11grac3           1048576       1048576       1048576       passed          
Result: Kernel parameter check passed for "aio-max-nr"

Check: Package existence for "binutils" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  11grac3       binutils-2.20.51.0.2-5.36.el6  binutils-2.20.51.0.2      passed    
  11grac1       binutils-2.20.51.0.2-5.36.el6  binutils-2.20.51.0.2      passed    
Result: Package existence check passed for "binutils"

Check: Package existence for "compat-libcap1" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  11grac3       compat-libcap1-1.10-1     compat-libcap1-1.10       passed    
  11grac1       compat-libcap1-1.10-1     compat-libcap1-1.10       passed    
                    

人气教程排行