Oracle RAC 客户端故障转移（failover），当采用TFA方式时，对于已经建立连接的客户端，在连接的实例或节点出现故障时，客户端无需再次发出连接请求，仍然可以继续之前的数据库操作，此称之为透明故障转移。本文描述基于Oracle 10g rac，客户端TFA方式的故障转移并给出示例。下面是一些关于这方面的基础参考链接：有关负监听配置，载均衡（load balance）请参考ORACLE RAC 下非缺省端口监听配置（listener.ora tnsnames.ora） http://www.linuxidc.com/Linux/2012-10/72042.htmOracle RAC 客户端连接负载均衡（Load Balance） http://www.linuxidc.com/Linux/2012-10/72158.htmOracle RAC 服务器端连接负载均衡（Load Balance） http://www.linuxidc.com/Linux/2012-10/72182.htmOracle RAC 负载均衡测试（结合服务器端与客户端） http://www.linuxidc.com/Linux/2012-10/72331.htm1、TFA描述 #下面关于TFA来自Oracle 的官方描述 ID 453293.1 Transparent Application Failover （TAF） is a feature of the Oracle Call Interface （OCI） driver at client side. It enables the application to automatically reconnect to a database, if the database instance to which the connection is made fails. In this case, the active transactions roll back. Tnsnames Parameter: FAILOVER_MODE When an instance to which a connection is established fails or is shutdown, the connection on the client side becomes stale and would throw exceptions to the caller trying to use it. TAF enables the application to transparently reconnect to a preconfigured secondary instance creating a fresh connection, but identical to the connection that was established on the first original instance.
易网时代-编程资源站