Jdbc thin not suppot Rac TAF
support TAF. TAF is only supported by the
JDBC OCI driver.
Transparent Application Failover (TAF) is a feature of the Java Database
Connectivity (JDBC) Oracle Call Interface (OCI) driver. 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.
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.
That is, the connection properties are the same as that of the earlier
connection. This is true regardless of how the connection was lost.
大概意思就是說jdbc thin連線rac時,不支援rac failover 的TAF;只有 jdbc OCI支援rac failover
的TAF;如果是jdbc thin連線rac時建議FCF:
FCF 配置demo如下:
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL =
TCP)(HOST = rac1vip)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST =
rac2vip)(PORT = 1525)) (LOAD_BALANCE =
on)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ractest)
(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 2) (DELAY =
1))))
JDBC Thin cannot use FAILOVER_MODE. The
failover defined by FAILOVER_MODE is Transparent Application Failover (TAF).
JDBC Thin does not support TAF.
However JDBC Thin does support Fast
Connection Failover (FCF).
大概意思仍然說JDBC Thin不支援rac TAF failover
mode;而是支援fcf,
網友lunar:
failover預設就是yes,不帶mode的一堆就是FCF,帶了就是TAF,因此你的改為下面的,用FCF就行了吧:
jdbc:oracle:thin:(
DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 100.86.000.00*)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 100.10.000.00*)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac_taf)
)
)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13750068/viewspace-1143118/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 在JDBC連線池中啟動Oracle RAC的TAFJDBCOracle
- Oracle RAC TAF [zt]Oracle
- Feature Differences Between JDBC OCI and Thin DriversJDBC
- 轉載:Oracle jdbc thin driver三種格式OracleJDBC
- Oracle 10g RAC TAFOracle 10g
- 轉:ORACLE的JDBC連線方式:OCI和THINOracleJDBC
- 用JDBC THIN CLIENT能訪問oracle cluster嗎?JDBCclientOracle
- 【TAF】使用Oracle RAC的TAF技術之SESSION型別OracleSession型別
- Oracle RAC TAF 無縫failoverOracleAI
- RAC TAF 連線 (tnsnames.ora)
- Oracle RAC Failove 之二:TAFOracleAI
- jdbc:oracle:thin:@192.168.3.98:1521:orcl(詳解)JDBCOracle
- 9i jdbc thin drive不支援Load balanceJDBC
- ORACLE RAC TAF 配置(透明故障轉移)Oracle
- Oracle 10g RAC TAF介紹Oracle 10g
- rac 的Client-side TAF配置clientIDE
- Oracle RAC的TAF簡單測試Oracle
- 【TAF】使用Oracle RAC的TAF技術實現不間斷查詢Oracle
- Can the JDBC Thin Driver Do Failover by Specifying FAILOVER_MODE?JDBCAI
- oracle 11g rac TAF 測試方案Oracle
- TNSNAMES TAF TEMPLATE , LOCAL_LISTENER RAC FAILOVERAI
- 【RAC】RAC中的負載均衡和故障切換--TAF配置負載
- [轉載]Oracle 10g RAC TAF介紹Oracle 10g
- jdbc 連線 oracle racJDBCOracle
- jdbc連rac範例JDBC
- 11gr2 RAC配置Service-Side TAFIDE
- Linux平臺上Oracle Rac中的TAF配置LinuxOracle
- Oracle RAC Failove 之三:Server-Side TAFOracleAIServerIDE
- Oracle RAC 客戶端故障轉移(failover) TAFOracle客戶端AI
- Oracle 11gR2 RAC Service-Side TAF 配置示例OracleIDE
- unity .net8 suppot commingUnity
- JDBC 如何配置RAC 的Load Balance ?JDBC
- 關於Thin Clientclient
- oracle10g rac(rhel4)_load balancing_taf(一)Oracle
- oracle10g rac(rhel4)_load balancing_taf(二)Oracle
- oracle10g rac(rhel4)_load balancing_taf(三)Oracle
- oracle10g rac(rhel4)_load balancing_taf(四)Oracle
- 靈活實現RAC三節點的負載均衡及TAF配置(五)負載