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
