打开tnsnames.ora把服务名改成二个,同一个sid
如
JSGM01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.0.107)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jsgm)
)
)JSGM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.0.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jsgm)
)
)
如
JSGM01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.0.107)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jsgm)
)
)JSGM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.0.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jsgm)
)
)
解决方案 »
- distinct 和 group by 在查询多列数据去重复时的区别在哪?
- 如何在oracle PROCEDURE 中执行 sql文?
- oracle 连接 很慢
- Oracle10g不能像9i那样使用OEM吗?
- !!!急急急,有没有函数像sum一样,对varchar2进行累加呀,每一条记录用逗号分开
- 如何用游标删除多行数据
- 50分求救,在硬盘中删除了一个ybzf.ORA,现在启动数据库有问题了
- 连接到数据库以后,如何列出所有的表呢?sql语句能做到吗?
- 如何把二进制的源文件加载到数据库的目标表(空表)中?
- 新人问下简单的建表问题...
- 问一个简单问题:如何一次性修改多条记录?修改的值从其他表来
- 天哪这是怎么回事
不过我说过了
服务名为A SID为my 连接到192.168.0.8
服务名为B SID为my 连接到192.168.0.10
本来就不同
create database link link1 connect to user identified by password using 'A'
或
create database link link1 connect to user identified by password using 'B'
也不行
create database link link1 connect to user identified by password using 'my'
是连接到自己那个
平时都可以连两个其他的数据库
但是就是SID相同后不知道怎么连接了(假设两个SID都为my)
我也是这样,假设在数据库A中,建立
create database link link_toB connect to B的登陆名 identified by B的登陆密码 using 'B'
但不行啊
create database link link_toB connect to B的登陆名 identified by B的登陆密码 using 'my'
连接上,不过通过查询连接的是自己
select * from tmp@link_toB 的结果还是数据库A中的数据B =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID = my)
)
)A =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.8)(PORT = 1521))
)
(CONNECT_DATA =
(SID = my)
)
)不太记得tnsnames.ora的配置了,好像是上面吧
大家帮帮忙啊,怎么在A中连接到B