2台windows2000server ,安装了2台oracle 10.1数据库,serviceName 一样tnsnames.ora 如下
108 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.108)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db01)
)
)
99 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.99)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db01)
)
)
taf =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.108)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.99)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = db01)
(
FAILOVER_MODE = (TYPE = )
(METHOD = BASIC)
(RETRIES = 30)
(DELAY = 5)
)
)
)2台数据库都存在相同的用户user1,密码也相同。user1的schema里面都有相同结构的表t1。一台数据库里有2条记录,另一台有3条数据。用sqlplus 能够连到2台数据库,并能成功检索 sqlplus user1/aaa@108 sqlplus user1/aaa@99实验taf,连入108,检索数据成功,不断开连接。新建一个dos窗口,用shutdown abort关闭108上的数据库,然后再用原来的窗口select,连接没有切换到99机器上,一段时间后报ora-03113错误,很显然是没有做taf切换。请问我哪里做错了?还是服务器需要再起一个进程?
108 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.108)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db01)
)
)
99 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.99)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db01)
)
)
taf =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.108)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.99)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = db01)
(
FAILOVER_MODE = (TYPE = )
(METHOD = BASIC)
(RETRIES = 30)
(DELAY = 5)
)
)
)2台数据库都存在相同的用户user1,密码也相同。user1的schema里面都有相同结构的表t1。一台数据库里有2条记录,另一台有3条数据。用sqlplus 能够连到2台数据库,并能成功检索 sqlplus user1/aaa@108 sqlplus user1/aaa@99实验taf,连入108,检索数据成功,不断开连接。新建一个dos窗口,用shutdown abort关闭108上的数据库,然后再用原来的窗口select,连接没有切换到99机器上,一段时间后报ora-03113错误,很显然是没有做taf切换。请问我哪里做错了?还是服务器需要再起一个进程?
解决方案 »
- 监听程序配置出错问题,请高手解答
- oracle查出的一行数据转成竖的
- 帮忙解决下这个orcale存储过程!!!!!!!!!!!!
- job 为何执行不了建立索引
- 出现错误提示:ORA-04031: 无法分配 8192 字节的共享内存 ("large pool","unknown object","cursor work he","get new buffer")
- 刚开始玩ORACLE,连怎么新建数据库都不知道,大家帮帮我
- 关于Oracle官方性能指标(如果查询效率,并发条件下模糊查询效率,压力测试,负荷),我要去哪找此类资料?
- imp和exp的简单问题
- 关于oracle面向对象编程的几个疑问?
- 哪裡可以下載Oracle8i的企業管理器
- 关于dbms_space.free_blocks?
- oracle的行级锁问题
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.108)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.99)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = db01)
(
FAILOVER_MODE = (TYPE = SELECT )
(METHOD = BASIC)
(RETRIES = 30)
(DELAY = 5)
)
)
)抱歉,taf配置串写错了,现在应该是这样子,还是不行