oracle单实例客户端连接的failover功能

今天测试了一下单实例数据库客户端连接的failover功能。
操作系统为red hat 5.5
[root@localhost ~]# cat /etc/issue
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Kernel \r on an \m
两块网卡，IP分别为eth0:172.16.60.133,eth1:172.16.60.135
[root@localhost ~]# ifconfig
eth0      Link encap:Ethernet  HWaddr 00:0C:29:0C:7C:31  
          inet addr:172.16.60.133  Bcast:172.16.60.255  Mask:255.255.255.0
          inet6 addr: fe80::20c:29ff:fe0c:7c31/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:7827260 errors:0 dropped:0 overruns:0 frame.:0
          TX packets:10006325 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:6847948221 (6.3 GiB)  TX bytes:11188870281 (10.4 GiB)

eth1      Link encap:Ethernet  HWaddr 00:0C:29:0C:7C:3B  
          inet addr:172.16.60.135  Bcast:172.16.60.255  Mask:255.255.255.0
          inet6 addr: fe80::20c:29ff:fe0c:7c3b/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:128213 errors:0 dropped:0 overruns:0 frame.:0
          TX packets:9932 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:19988596 (19.0 MiB)  TX bytes:2932008 (2.7 MiB)

数据库版本：11.2.0.1
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
单实例数据库
SQL> select instance_name,instance_number from v$instance;

INSTANCE_NAME    INSTANCE_NUMBER
---------------- ---------------
tengff11g      
                1
客户端tns配置
db_tengff11g =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.60.133)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = tengff11g)
    )
  )
1、将网卡0关闭
ifdown eth0
连接数据库测试
SQL> conn system/oracle@db_tengff11g
ERROR:
ORA-12170: TNS: 连接超时
2、将网卡1的IP添加到tns配置中,设置failover为on
客户端tns配置
db_tengff11g =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (FAILOVER = ON)
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.60.133)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.60.135)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = tengff11g)
    )
  )
连接数据库测试
SQL> conn system/oracle@db_tengff11g
已连接。
连接时间大约20秒左右
3、将网卡0重新启动
ifup eth0
重新连接数据库测试
SQL> conn system/oracle@db_tengff11g
已连接。
结论：数据库服务器可以配置多个网卡，客户端tnsnames.ora中将多个IP地址配置到ADDRESS_LIST中，可以实现failover。不过failover时间过长，连接超时重连的时间暂时不知道在哪里设置。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26276376/viewspace-717858/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26276376/viewspace-717858/