1、
m1 m2 m3 source端
2、
在m1 m2 m3 上
/etc/hosts
172.16.10.140 source
source上
添加
#public network
172.16.15.101 m1
172.16.15.102 m2
172.16.15.103 m3
#private network
10.11.11.1 m1-pri
10.11.11.2 m2-pri
10.11.11.3 m3-pri
29
#VIP network
172.16.15.104 m1-vip
172.16.15.105 m2-vip
172.16.15.106 m3-vip
#GGVIP
172.16.15.107 qr01-vip
#racscan network
172.16.15.100 rac-scan
3、
[root@m2 ~]# cd /u01/app/11.2.3/grid/bin/
[root@m2 bin]# ./crsctl stat res -p | grep -ie .network -ie subnet | grep -ie name -ie subnet
NAME=ora.net1.network
USR_ORA_SUBNET=172.16.14.0
[root@m2 bin]# ./appvipcfg create -network=1 -ip=172.16.15.104 -vipname=gg_vip_trg -user=root
./crsctl setperm resource gg_vip_trg -u user:oracle:r-x
切换到oracle用户
[root@m2 bin]# su - oracle
[oracle@m2 ~]$ cd /u01/app/11.2.3/grid/bin/
[oracle@m2 bin]$ ./crsctl start resource gg_vip_trg
CRS-2672: Attempting to start 'gg_vip_trg' on 'm2'
CRS-5017: The resource action "gg_vip_trg start" encountered the following error:
CRS-5005: IP Address: 172.16.15.104 is already in use in the network 留意一下 vip 会不会由此信息提示
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.3/grid/log/m2/agent/crsd/orarootagent_root/orarootagent_root.log".
CRS-2674: Start of 'gg_vip_trg' on 'm2' failed
CRS-2679: Attempting to clean 'gg_vip_trg' on 'm2'
CRS-2681: Clean of 'gg_vip_trg' on 'm2' succeeded
CRS-2563: Attempt to start resource 'gg_vip_trg' on 'm2' has failed. Will re-retry on 'm3' now.
CRS-2672: Attempting to start 'gg_vip_trg' on 'm3'
CRS-2676: Start of 'gg_vip_trg' on 'm3' succeeded
这里定义一个试试
要么就是 VIP是自己设定的一个地址
要么就是 VIP是原来主机名字的虚拟VIP。----这里我安装的是虚拟VIP试试看不行就换
不用VIP自己设置一个IP地址也可以只要是同一个网段的。
单实例到RAC单向
前提条件:
1、源库:单实例安装了11.2.3数据库 有Grid、 Oracle 用户
2、目标库:安装了RAC。scan能连接通。
目标RAC:
oracle用户
vim .bash_profile
export OGG_HOME=$ORACLE_BASE/ogg
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
vim /etc/hosts
添加源库的IP地址
172.16.10.140 sdb
源:
vim /etc/hosts
添加 RAC节点下/etc/hosts下的所有内容。
就是主机名 VIP 等
oracle用户
vim .bash_profile
export OGG_HOME=$ORACLE_BASE/ogg
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib
添加虚拟VIP分别在RAC 源上
172.16.15.105 qr01-vip
RAC