系统环境
主机:Window2003R2 SP2 VMWare Server1.0.5装了两台WINDOWS2008
每台机器768M内存
其上装了Oracle11g(11.1.0.6) For Windows32
在TNS中配置了TAF,如下所示:
RAWRAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.241)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.242)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = rawrac)
(FAILOVER_MODE =
(type = session)
(method = basic)
(RETRIES = 3)
(DELAY = 5)
)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.241)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.242)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = rawrac)
(FAILOVER_MODE =
(type = session)
(method = basic)
(RETRIES = 3)
(DELAY = 5)
)
)
)
测试时发现SYS无法进行TAF故障切换,但是使用其它普通用户可以。
创建了另一个SYSDBA用户,用SYSDBA模式登录也可以。
不知道这个ORACLE规定的还是什么原因,需要查一下官方文档。