2009年6月16日,重新测试了failover and balance,推翻了以前的原稿,以下看到的是修订版.
实际上在OCI客户端上的tnsname.ora中的配置,其实可以更简单,简单的不能再简单.
RAC相关信息:
RAC1:10.10.10.1(vip:10.10.10.11) devdb1
RAC2:10.10.10.2(vip:10.10.10.12) devdb2
racdb:devdb
创建的有CRM服务
1、在OCI客户端tnsname中配置如下,仅仅只需要如此添加即可:
RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = devdb)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
2、使用SQLPLUS连接:
C:\Documents and Settings\Administrator>sqlplus nam/nam@racdb
SQL*Plus: Release 11.1.0.6.0 - Production on 星期日 3月 15 13:04:11 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
devdb2
SQL>
目前我连接的是devdb2,现在我们验证failover:
登陆到rac2上,shutdown devdb2:
Last login: Fri Feb 27 21:28:08 2009 from 10.10.10.5
rac2-> sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 15 13:07:09 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
再回到OCI客户端的SQLPLUS中,测试:
INSTANCE_NAME
--------------------------------
devdb2
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
devdb1
SQL>
实现了无缝FAILOVER。
3、以下测试balance:
分别在rac1和rac2上配置一下参数,以避免ora-12545的错误:
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.11)(PORT=1521))' SID='devdb1';
System altered.
SQL>
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.12)(PORT=1521))' SID='devdb2';
System altered.
SQL>
在OCI客户端编写BAT脚本,脚本内容如下:
for /L %%G in (1,1,10) do start /b sqlplus nam/nam@racdb
目的,创造10个连接。
验证两台机器目前的连接数:
SQL> select count(*),machine from v$session group by machine;
COUNT(*) MACHINE
---------- ----------------------------------------------------------------
30 rac1
SQL> select count(*),machine from v$session group by machine;
COUNT(*) MACHINE
---------- ----------------------------------------------------------------
29 rac2
运行程序后再次验证:
SQL> select count(*),machine from v$session group by machine;
COUNT(*) MACHINE
---------- ----------------------------------------------------------------
30 rac1
5 WORKGROUP\WWW-CD2CAF03643
SQL>
SQL> /
COUNT(*) MACHINE
---------- ----------------------------------------------------------------
5 WORKGROUP\WWW-CD2CAF03643
29 rac2
SQL>
10个连接每台机器5个,实现了balance的目的。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16628454/viewspace-567384/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16628454/viewspace-567384/