Oracle10g Rac Add Node

来源:互联网 发布:动态全景拼接软件 编辑:程序博客网 时间:2024/05/21 20:26
 

因为要作为第三节点的机器上已经安装了集群,所以要先把这些信息删除掉:
1.删除/etc/init.d/下 init.crs init.crsd init.cssd (这个目录下要全清,不然后面跑root.sh会出错)
rm init.crs init.crsd init.cssd
2.删除u01下的所有东西(安装数据库的目录)
3.删除/etc/*.ora
4.如果启动过单机asm服务,请先停止::$ORACLE_HOME/bin/localconfig delete
5.如果是4以上的版本,降低版本到4

开始加结点:
1.在新节点配置网络

2.配置/etc/hosts(将新节点加入)

3.配置信任关系和测试信任关系
new_node:10.1.1.92
su - oracle
ssh-keygen -t rsa
ssh-keygen -t dsa
cd .ssh
cat *.pub > authorized_keys
scp authorized_keys
oracle@10.1.1.132:/home/oracle/.ssh/keys_92       

node2:10.1.1.132
cat keys_92 >> authorized_keys
scp authorized_keys
oracle@10.1.1.135:/home/oracle/.ssh
scp authorized_keys oracle@10.1.1.92:/home/oracle/.ssh

测试:
在每个节点,用oracle用户测试
ssh xie1
ssh xie
ssh stu92
ssh xie1-vip
ssh xie-vip
ssh xie1-priv
ssh xie-priv
ssh stu92-priv

测试时间同步

4.配置内核挂起

配置hangcheck-timer:用于监视 Linux 内核是否挂起
vi /etc/modprobe.conf
options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180
自动加载hangcheck-timer
vi /etc/rc.local
modprobe hangcheck-timer
检查hangcheck-timer模块是否已经加载:
lsmod | grep hangcheck_timer

5.挂载公用存储

6.使用cvu测试集群安装可行性
./runcluvfy.sh stage -pre crsinst -n xie.uplooking.com,xie1.uplooking.com,stu92  -verbose

7.为新节点添加crs软件
  1.在现存节点运行:$CRS_HOME/oui/bin/addNode.sh
  2.在新节点运行:/u01/app/oracle/oraInventory/orainstRoot.sh (不一定要跑,根据前一步的提示跑就可以了)
  3.在现存节点运行: /u01/app/crs_1/install/rootaddnode.sh
>此文件是生成文件,由rootaddnode.sbs变化而来
  4.在新节点运行:/u01/app/crs_1/root.sh
   运行root.sh脚本成功后会自动添加ons资源

8.为新节点添加db软件
在现存节点运行:$ORACLE_HOME/oui/bin/addNode.sh

9.在现存节点添加新的监听

10.在现存节点添加,添加新的asm
  用dbca添加

11.在现存节点为新节点添加新的instance

----------------------------------------------------------------------------------------------------------------------
[oracle@xie bin]$ ./addNode.sh
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.

Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified

Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.
:0.0
:0.0
OUI-10025:Unable to start an interactive install session because of the following error:Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable. The DISPLAY environment variable should be set to <hostname or IP address>:<screen>, where the <screen> is usually '0.0'.
OUI-10026:Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
- For csh:                      % setenv DISPLAY 192.168.1.128:0.0
- For sh, ksh and bash:         $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
        echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
        echo $DISPLAY
- Make sure that client users are authorized to connect to the X Server.
OUI-10027:To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as 'xclock':
        % <full path to xclock... see below>
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for 'xclock': '/usr/X11R6/bin/xclock'

使用cvu测试集群安装可行性时
包新加的节点gid,uid 跟现有节点不同:

[root@stu92 /]# vi /etc/passwd
[root@stu92 /]# vi /etc/group
把有关oracle ,dba的设置
改成跟现有节点一致:

需要重新配置信任关系

配置信用关系之后要重新检查共享盘的状态,状态不对可以 start_udev