Oracle 11G RAC添加节点

（1）修改hosts文件,添加节点3的IP信息
（2）配置互信（grid和oracle）
节点3

mkdir ~/.ssh
chmod 700 ~/.ssh
cd .ssh/
ssh-keygen -t dsa
ssh-keygen -t rsa

节点1

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

（3）检查互信

ssh enmo01 date
ssh enmo02 date
ssh enmo03 date
ssh enmo01-priv1 date
ssh enmo02-priv1 date
ssh enmo03-priv1 date
ssh enmo01-priv2 date 
ssh enmo02-priv2 date
ssh enmo03-priv2 date

（4）添加节点前期检查

/u01/app/11.2.0.4/grid/bin/cluvfy stage -pre nodeadd -n enmo03 -fixup -verbose

（5）添加grid软件

cd /u01/app/11.2.0.4/grid/oui/bin
export IGNORE_PREADDNODE_CHECKS=Y
./addNode.sh -silent -ignoreSysPrereqs "CLUSTER_NEW_NODES={enmo03}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={enmo03-vip}"
#######如果添加失败，需使用如下命令重新更新产品清单列表，才能继续添加########
./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={enmo01,enmo02}"

On enmo03 as root：
/u01/app/oraInventory/orainstRoot.sh
/u01/app/11.2.0.4/grid/root.sh

（6）添加oracle软件

cd /u01/app/oracle/product/11.2.0.4/db_1/oui/bin/
./addNode.sh -silent "CLUSTER_NEW_NODES={enmo03}"

On enmo03 as root：
/u01/app/oracle/product/11.2.0.4/db_1/root.sh

（7）添加数据库实例

alter system set sga_target=64G scope=spfile sid='enmodb3';
cd /u01/app/oracle/product/11.2.0.4/db_1/oui/bin/
dbca -silent -addInstance -nodeList enmo03 -gdbName enmodb -instanceName enmodb3 -sysDBAUserName sys -sysDBAPassword xxxx

（8）确认结果

/u01/app/11.2.0.4/grid/bin/crsctl stat res -t

（9）调整节点3的redo日志以及thread、undo、local_listener等参数