參考資料：
http://www.5ienet.com/note/html/sracnode/index.shtml

http://www.askmaclean.com/archives/add-node-to-11-2-0-2-grid-infrastructure.html

1.添加 rac節(jié)點：

使用GRID用戶：

在當前RAC環(huán)境中任意節(jié)點的$ORA_CRS_HOME，執(zhí)行oui/bin/addNode.sh腳本

[grid@rac1 bin]$ ./addNode.sh -pre? CLUSTER_NEW_NODES={rac3} CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac3-vip}

執(zhí)行 添加節(jié)點 的預檢查


"file-max" 的 內核參數 檢查失敗
在以下節(jié)點上檢查失敗:
?? ?rac3
"ip_local_port_range" 的 內核參數 檢查已通過
"rmem_default" 的 內核參數 檢查失敗
在以下節(jié)點上檢查失敗:
?? ?rac3
"rmem_max" 的 內核參數 檢查失敗
在以下節(jié)點上檢查失敗:
?? ?rac3
"wmem_default" 的 內核參數 檢查失敗
在以下節(jié)點上檢查失敗:
?? ?rac3
"wmem_max" 的 內核參數 檢查失敗
在以下節(jié)點上檢查失敗:
?? ?rac3
"aio-max-nr" 的 內核參數 檢查失敗
在以下節(jié)點上檢查失敗:
?? ?rac3

修改為：看到很多的配置是6815744，但一直不通過，一猛心，后面加個0.

fs.file-max = 68157440
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 4194304
net.core.wmem_default = 262144
net.core.rmem_max = 16777216
net.core.wmem_max = 16777216
fs.aio-max-nr = 1048576
kernel.sem = 250 32000 100 128




PRVF-5636 : 在以下節(jié)點上, 無法訪問的節(jié)點的 DNS 響應時間超過 "15000" 毫秒: rac1,rac3

使用命令，與RAC1進行數據同步
ntpdate -u rac1


PRVF-5436 : 在一個或多個節(jié)點上運行的 NTP 守護程序缺少快速定向選項 "-x"

修改了：vi /etc/sysconfig/ntpd
# Drop root to id 'ntp:ntp' by default.
OPTIONS=" -u ntp:ntp -x -p /var/run/ntpd.pid"


./addNode.sh?? CLUSTER_NEW_NODES={rac3} CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac3-vip} > add_node.log 2>&1

完成后執(zhí)行：

root@rac3 ~]# /opt/app/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
??? ORACLE_OWNER= grid
??? ORACLE_HOME=? /opt/app/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
?? Copying dbhome to /usr/local/bin ...
?? Copying oraenv to /usr/local/bin ...
?? Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /opt/app/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
OLR initialization - successful
Adding Clusterware entries to inittab
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac3'
CRS-2676: Start of 'ora.mdnsd' on 'rac3' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac3'
CRS-2676: Start of 'ora.gpnpd' on 'rac3' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac3'
CRS-2672: Attempting to start 'ora.gipcd' on 'rac3'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac3' succeeded
CRS-2676: Start of 'ora.gipcd' on 'rac3' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac3'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac3'
CRS-2676: Start of 'ora.diskmon' on 'rac3' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac3' succeeded

未能創(chuàng)建磁盤組CRS, 返回消息如下:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 2 regular failure groups, discovered only 0
ORA-15080: synchronous I/O operation to a disk failed


Configuration of ASM ... failed
see asmca logs at /opt/app/oracle/cfgtoollogs/asmca for details
Did not succssfully configure and start ASM at /opt/app/grid/crs/install/crsconfig_lib.pm line 6763.
/opt/app/grid/perl/bin/perl -I/opt/app/grid/perl/lib -I/opt/app/grid/crs/install /opt/app/grid/crs/install/rootcrs.pl execution failed


還是出這個錯誤，和安裝時第二個節(jié)點運行：/opt/app/grid/root.sh
時的是一樣的。

解決方法：

1. Modify the /etc/sysconfig/oracleasm with:
?????? ORACLEASM_SCANORDER="dm"
?????? ORACLEASM_SCANEXCLUDE="sd"
2. restart the asmlib by :
?????? # /etc/init.d/oracleasm restart

3. Run root.sh on the 2nd node

二、添加安裝新節(jié)點數據庫軟件：

完成新節(jié)點添加后，用oracle用戶在個$ORACLE_HOME/oui/bin路徑下，執(zhí)行如下命令:

./addNode.sh? CLUSTER_NEW_NODES={m3} CLUSTER_NEW_VIRTUAL_HOSTNAMES={m3-vip}

該命令執(zhí)行完成后，數據庫軟件在新節(jié)點上安裝完成。

（執(zhí)行時出現： 新添加節(jié)點m3不可訪問，

用ssh m3 date

ssh m3-private date 再測試了一次SSH 對等訪問后，問題解決。

）

三、為新節(jié)點添加數據庫實例：

RAC集群中的其中一個節(jié)點，用oracle用戶，運行dbca，選擇RAC database

Instance Management

Add an Instance

總結

以上是生活随笔為你收集整理的ORACLE11G RAC增加节点操作的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。