单机转RAC,添加新节点

添加新节点GRID(用已有节点的GRID用户执行)
1、前期准备工作和已经安装的节点一样
2、在执行添加节点的脚本时候,如果检测报错:ntp可以mv resolv可以mv
3、如果还报如下问题
Checking CRS home location...
PRVG-1013 : The path "/u01/11.2.0/grid" does not exist or cannot be created on the nodes to be added
Shared resources check for node addition failed
解决方法:
grid@test:/oracle/11.2/grid/oui/bin> export IGNORE_PREADDNODE_CHECKS=Y
grid@test:/oracle/11.2/grid/oui/bin> ./addNode.sh -ignoreSysPrereqs -force "CLUSTER_NEW_NODES={test-bak}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={test-bak-vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={test-bak-priv}"

4、出现如下结果表示成功
/oracle/11.2/grid/root.sh #On nodes test-bak
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts in each cluster node

The Cluster Node Addition of /oracle/11.2/grid was successful.
Please check '/tmp/silentInstall.log' for more details.

5、在新加节点执行上面提示的脚本
/oracle/11.2/grid/root.sh

6、验证集群软件是否添加成功
[grid@test bin]$ cluvfy stage -post nodeadd -n test-bak -verbose

7、添加新节点数据库(用已有节点的ORACLE用户执行)
oracle@test:/oracle/app/oracle/product/11.2.0/db_1/oui/bin> ./addNode.sh -silent "CLUSTER_NEW_NODES={test-bak}"

8、出现如下结果表示成功
/oracle/app/oracle/product/11.2.0/db_1/root.sh #On nodes test-bak
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts in each cluster node

The Cluster Node Addition of /oracle/app/oracle/product/11.2.0/db_1 was successful.
Please check '/tmp/silentInstall.log' for more details.

9、在新节点上执行上面提示的脚本
test-bak:~ # /oracle/app/oracle/product/11.2.0/db_1/root.sh

10、添加实例
dbca -silent -addInstance -nodeList rac3 -gdbName orcl -instanceName orcl3 -sysDBAUserName sys -sysDBAPassword "***"

也可以通过dbca图形添加数据库

如果报如下错误:

在搭建oracle 11g r2环境的时候,用dbca创建数据库的是时候,检测提示rac1没有vip设置,提示信息如下:
Virtual IP address is not configured for cluster node “rac1”. Run “/u01/app/11.2.0/grid/bin/srvctl” as root user to configure
it before performing the “Create a Database” operation.
然后登陆到rac1 ,检测vip,并删除vip设置,当然这里是没有的,然后尝试添加vip
grid@rac1:/opt> srvctl stop vip -n rac1 -f
PRKO-2439 : VIP does not exist.
grid@rac1:/opt> srvctl remove vip -i rac1
Please confirm that you intend to remove the VIPs rac1 (y/[n]) y
PRCR-1001 : Resource ora.rac1.vip does not exist
grid@rac1:/opt> srvctl add vip -n rac1 -A 192.168.207.100/255.255.255.0/eth0 -k 2
PRCN-2049 : The network attributes specified (network number: 2, subnet: 192.168.207.0, adapters: eth0) conflict with an already registered network (network number: 1, subnet: 192.168.207.0, adapters: eth0)

grid@rac1:/opt> srvctl add vip -n rac1 -A 192.168.207.100/255.255.255.0/eth0 -k 1
PRCN-2018 : Current user grid is not a privileged user

  在添加的时候提示权限不够,切换至root用户执行:

rac1:~/Desktop # /opt/app/grid/11.2/bin/srvctl add vip -n rac1 -A 192.168.207.100/255.255.255.0/eth0 -k 1

  执行成功,然后检测,如果没有启动,则启动即可

grid@rac1:~> srvctl status vip -n rac1 
VIP 192.168.207.100 is enabled
VIP 192.168.207.100 is not running
grid@rac1:~> srvctl start vip -n rac1 
grid@rac1:~> srvctl status vip -n rac1 
VIP 192.168.207.100 is enabled
VIP 192.168.207.100 is running on node: rac1

  

posted @ 2017-06-28 15:45  要让熊猫飞上天  阅读(1522)  评论(0编辑  收藏  举报