Your database is not configured for session failover. Your tnsnames.ora file contains the following details:
test.us.oracle.com=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=off)
(FAILOVER=ON)
(ADDRESS= (PROTOCOL=tcp) (HOST=test1-server) (PORT=1521))
(ADDRESS= (PROTOCOL=tcp) (HOST=test2-server) (PORT=1521)))
(CONNECT_DATA= (SERVICE_NAME=test.us.oracle.com)))
Which feature is enabled in this case?
A) Load balancing
B) Instance failover
C) Database failover
D) Connect-time failover
E) Transparent Application Failover (TAF)
答案:D
Connect Time Failover,只是在发起连接时才去感知节点故障,如果发现节点没有响应,则自动尝试地址列表中的下一个地址。(在客户端tnsnames.ora中添加FAILOVER=ON)
TFA(Transparent Application Failover),就是建立连接以后,应用系统运行过程中,如果某个实例发生故障,连接到这个实例的用户会自动迁移到其他健康实例上,透明,不需用户介入。
(在客户端tnsnames.ora中添加FAILOVER_MODE
1:method选项用于定义何时创建到其他实例的连接,有basic和preconnect
2:type用于定义发生故障时对完成的
sql语句如何处理,有session和select
3:delay和retries代表重试间隔时间和重试次数)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/693532/viewspace-723530/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/693532/viewspace-723530/