系统环境
主机:Window2003R2 SP2VMWare 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规定的还是什么原因,需要查一下官方文档。
SYS TAF切换问题
本文描述了一个关于Oracle 11g环境下SYS用户无法实现TAF故障切换的问题,并指出使用普通用户或其他SYSDBA用户则可以正常切换。文章记录了具体的系统配置及TNS配置细节。
2138

被折叠的 条评论
为什么被折叠?



