ORACLE RAC--webapps测试

ORACLE RAC--webapps测试

 

本实验将利用oracle clusterware 配置一个高可用的web网站集群系统,整个集群由两个节点组成,web网站使用apache搭建,环境如下图所示。集群的任何一节点出现宕机现象,都不会影响web站点的高可用性,web服务会自动转移到另外一个节点上运行。

ORACLE RAC--webapps测试

 

1.在两节点上使用yum安装httpd服务:

[[email protected] ~]# yum –y install httpd

[[email protected] ~]# yum –y install httpd

 

2.创建web_vip的profile:

[[email protected] ~]$ cd /u01/oracle/product/crs/crs/public 
[[email protected] public]$ ls 
action_scr.scr ora.rac1.LISTENER_RAC1.lsnr.cap ora.rac2.LISTENER_RAC2.lsnr.cap 
[[email protected] public]$ crs_profile -create racdb1_vip -t application -a /u01/oracle/product/crs/bin/usrvip -o oi=eth0,ov=172.21.1.82,on=255.255.255.0 
[[email protected] public]$ ll 
total 16 
-rw-rw---- 1 oracle oinstall 3396 Aug 3 2004 action_scr.scr 
-rw-r----- 1 oracle oinstall 828 Sep 20 16:57 ora.rac1.LISTENER_RAC1.lsnr.cap 
-rw-r----- 1 oracle oinstall 828 Sep 20 16:57 ora.rac2.LISTENER_RAC2.lsnr.cap 
-rw-r--r-- 1 oracle oinstall 788 Sep 26 05:07 racdb1_vip.cap 
[[email protected] public]$ strings racdb1_vip.cap 
NAME=racdb1_vip 
TYPE=application 
ACTION_SCRIPT=/u01/oracle/product/crs/bin/usrvip 
ACTIVE_PLACEMENT=0 
AUTO_START=restore 
CHECK_INTERVAL=60 
DESCRIPTION=racdb1_vip 
FAILOVER_DELAY=0 
FAILURE_INTERVAL=0 
FAILURE_THRESHOLD=0 
HOSTING_MEMBERS= 
OPTIONAL_RESOURCES= 
PLACEMENT=balanced 
REQUIRED_RESOURCES= 
RESTART_ATTEMPTS=1 
SCRIPT_TIMEOUT=60 
START_TIMEOUT=0 
STOP_TIMEOUT=0 
UPTIME_THRESHOLD=7d 
USR_ORA_ALERT_NAME= 
USR_ORA_CHECK_TIMEOUT=0 
USR_ORA_CONNECT_STR=/ as sysdba 
USR_ORA_DEBUG=0 
USR_ORA_DISCONNECT=false 
USR_ORA_FLAGS= 
USR_ORA_IF=eth0 
USR_ORA_INST_NOT_SHUTDOWN= 
USR_ORA_LANG= 
USR_ORA_NETMASK=255.255.255.0 
USR_ORA_OPEN_MODE= 
USR_ORA_OPI=false 
USR_ORA_PFILE= 
USR_ORA_PRECONNECT=none 
USR_ORA_SRV= 
USR_ORA_START_TIMEOUT=0 
USR_ORA_STOP_MODE=immediate 
USR_ORA_STOP_TIMEOUT=0 
USR_ORA_VIP=172.21.1.82 
 

3.注册web_vip:

[[email protected] public]$ crs_register racdb1_vip

4.设置权限,需要使用root身份: 
[[email protected] bin]# /u01/oracle/product/crs/bin/crs_setperm racdb1_vip -o root 
[[email protected] bin]# /u01/oracle/product/crs/bin/crs_setperm racdb1_vip -u user:oracle:r-x

5..测试这个vip创建是否成功: 
先查看VIP启动前的IP地址: 
[[email protected] public]$ /sbin/ip ad sh 
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue 
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 
inet 127.0.0.1/8 scope host lo 
inet6 ::1/128 scope host 
valid_lft forever preferred_lft forever 
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000 
link/ether 00:0c:29:ad:6e:57 brd ff:ff:ff:ff:ff:ff 
inet 172.21.1.30/24 brd 172.21.1.255 scope global eth0 
inet 172.21.1.80/24 brd 172.21.1.255 scope global secondary eth0:1
 
inet6 fe80::20c:29ff:fead:6e57/64 scope link 
valid_lft forever preferred_lft forever 
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000 
link/ether 00:0c:29:ad:6e:61 brd ff:ff:ff:ff:ff:ff 
inet 10.0.0.11/24 brd 10.0.0.255 scope global eth1 
inet6 fe80::20c:29ff:fead:6e61/64 scope link 
valid_lft forever preferred_lft forever 
4: sit0: <NOARP> mtu 1480 qdisc noop 
link/sit 0.0.0.0 brd 0.0.0.0

在启动VIP前,eth0上,只有两个地址,然后启动VIP: 
[[email protected] public]$ crs_start racdb1_vip 
Attempting to start `racdb1_vip` on member `rac2` 
Start of `racdb1_vip` on member `rac2` succeeded.

[[email protected] crsd]$ /sbin/ip ad sh 
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue 
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 
inet 127.0.0.1/8 scope host lo 
inet6 ::1/128 scope host 
valid_lft forever preferred_lft forever 
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000 
link/ether 00:0c:29:bd:02:cc brd ff:ff:ff:ff:ff:ff 
inet 172.21.1.31/24 brd 172.21.1.255 scope global eth0 
inet 172.21.1.81/24 brd 172.21.1.255 scope global secondary eth0:2 
inet 172.21.1.82/24 brd 172.21.1.255 scope global secondary eth0:1
 
inet6 fe80::20c:29ff:febd:2cc/64 scope link 
valid_lft forever preferred_lft forever 
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000 
link/ether 00:0c:29:bd:02:d6 brd ff:ff:ff:ff:ff:ff 
inet 10.0.0.12/24 brd 10.0.0.255 scope global eth1 
inet6 fe80::20c:29ff:febd:2d6/64 scope link 
valid_lft forever preferred_lft forever 
4: sit0: <NOARP> mtu 1480 qdisc noop 
link/sit 0.0.0.0 brd 0.0.0.0

在rac2节点上的eth0上多出来一个IP地址,使用 crs_stat racdb1_vip查看资源状态,输出说明资源状态ONLINE,运行在节点rac2上:

[[email protected] crsd]$ crs_stat racdb1_vip 
NAME=racdb1_vip 
TYPE=application 
TARGET=ONLINE 
STATE=ONLINE on rac2

测试资源转移:

[[email protected] public]$ crs_relocate racdb1_vip 
Attempting to stop `racdb1_vip` on member `rac2` 
Stop of `racdb1_vip` on member `rac2` succeeded. 
Attempting to start `racdb1_vip` on member `rac1` 
Start of `racdb1_vip` on member `rac1` succeeded.


[[email protected] public]$ crs_stat racdb1_vip 
NAME=racdb1_vip 
TYPE=application 
TARGET=ONLINE 
STATE=ONLINE on rac1

通过IE访问http://172.21.1.82/得到如下请求页面:

ORACLE RAC--webapps测试

[[email protected] public]$ crs_relocate racdb1_vip 
Attempting to stop `racdb1_vip` on member `rac1` 
Stop of `racdb1_vip` on member `rac1` succeeded. 
Attempting to start `racdb1_vip` on member `rac2` 
Start of `racdb1_vip` on member `rac2` succeeded. 
通过IE访问http://172.21.1.82/得到如下请求页面:

ORACLE RAC--webapps测试

[[email protected] public]$ crs_stat racdb1_vip 
NAME=racdb1_vip 
TYPE=application 
TARGET=ONLINE 
STATE=ONLINE on rac2







     本文转自vcdog 51CTO博客,原文链接:http://blog.51cto.com/255361/837520,如需转载请自行联系原作者