Oracle 10g RAC 添加节点

目前环境是一个版本为10.2.0.5的双节点RAC,hostname分别为racnode1,racnode2需要添加新节点racnode3。

OS版本是Oracle Linux 5.7 x86_64

保证RAC正常运行

配置public IP,private IP,VIP,将这些信息配置到/etc/hosts文件中

用root用户在racnode3上运行
/u01/app/oracle/oraInventory/orainstRoot.sh



在racnode3上安装Oracle Database software
在racnode1上使用oracle用户执行$ORACLE_HOME/oui/bin/addNode.sh









用root用户在racnode3上执行
/u01/app/oracle/product/10.2.0/db_1/root.sh




配置监听
















点击No



验证
C:\>sqlplus system@rac3SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 12月 24 16:44:50 2012Copyright (c) 1982, 2005, Oracle.  All rights reserved.输入口令:连接到:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> show parameter instance_nameNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------instance_name                        string      racdb3SQL> set linesize 400SQL> col host_name format a11SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;INSTANCE_NAME    HOST_NAME   VERSION           STARTUP_TIME   STATUS       ACTIVE_ST INSTANCE_ROLE   DATABASE_STATUS---------------- ----------- ----------------- -------------- ------------ --------- ------------------ ----------------racdb3           racnode3    10.2.0.5.0        24-12月-12     OPEN         NORMAL    PRIMARY_INSTANCE   ACTIVEracdb2           racnode2    10.2.0.5.0        20-12月-12     OPEN         NORMAL    PRIMARY_INSTANCE   ACTIVEracdb1           racnode1    10.2.0.5.0        20-12月-12     OPEN         NORMAL    PRIMARY_INSTANCE   ACTIVE