oracle11g RAC添加节点

OS:

[root@rac ~]# more /etc/oracle-release
Oracle Linux Server release 5.7

 

DB:

SQL> SELECT * FROM V$VERSION;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

 

目前拥有一套两节点RAC：node1为rac，node2为rac1。  添加的node3命令为rac2

 

准备工作：

1.首先，物理链路的准备。（存储，心跳线互联等）

2.根据前两个节点安装节点三的操作系统，安装依赖的包，配置核心参数，/etc/hosts

3.在node3创建相应的组，用户，目录 

  注意：创建的组、用户、ID要与前两节点相同

4.确保每个节点之间ssh互信

  注意：在oralce和grid用户下都要配置ssh互信

5.验证node1、node2与node3之间的连通性.

 

操作步骤：

1、配置ssh:   

在rac2:

su - oracle
mkdir ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa

 

在rac和rac1：

su - oracle

ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keys

 

在rac2：

su - grid

mkdir ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa

 

在rac和rac1：

su - grid

ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keys

 

配置完成后在每个节点互信验证

 

2、在11.2 GI中推出了octssd时间同步服务，使用octssd的话那么建议禁用ntpd事件服务

[root@rac2 ~]#service ntpd stop

[root@rac2 ~]#chkconfig ntpd off
[root@rac2 ~]#mv /etc/ntp.conf /etc/ntp.conf.bak

[root@rac2 ~]#rm /var/run/ntpd.pid

 

3、验证新添加的节点是否满足cluster要求：

在节点一或节点二运行：

su - grid

cluvfy stage -pre nodeadd -n

 

[grid@rac ~]$cluvfy stage -pre nodeadd -n rac2

Performing pre-checks for node addition

Checking node reachability...
Node reachability check passed from node "rac"

Checking user equivalence...
User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"

Node connectivity check passed

Checking CRS integrity...

CRS integrity check passed

Checking shared resources...

Checking CRS home location...
The location "/u01/app/grid" is not shared but is present/creatable on all nodes
Shared resources check for node addition passed

Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"

Check: Node connectivity for interface "eth1"
Node connectivity passed for interface "eth1"

Node connectivity check passed

Total memory check passed
Available memory check passed
Swap space check passed
Free disk space check passed for "rac2:/tmp"
Free disk space check passed for "rac:/tmp"
Check for multiple users with UID value 54322 passed
User existence check passed for "grid"
Run level check passed
Hard limits check failed for "maximum open file descriptors"
Check failed on nodes:
        rac2
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"