日期:2014-05-17 浏览次数:20808 次
create public database link MYDBLINK1 connect to orange identified by orange using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =191.168.1.102)(PORT = 1521)) ) (CONNECT_DATA = #(SERVER = DEDICATED) (SERVICE_NAME = orcl.localdomain) ) )';
------解决方案--------------------
大致的看了一下 配置文件没有问题的情况下,应该是在你的liunx下的服务关闭了所以连接不上,或者你也可以tnsping一下你的服务器看能否ping通
------解决方案--------------------
create public database link MYDBLINK1
connect to orange identified by orange
using 'ORCL1';
这个方法不对,你要用A去link B,必须A能够识别ORCL1且指向B,你的ORCL1是在客户端上的,只有你的客户端和A在一台机器上才好使
具体办法用1楼的,把他里面#注释掉那行整个去掉 再不行就把这个字符串里面的空格回车什么空白字符删掉重新敲
create public database link MYDBLINK1
connect to orange identified by orange
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =191.168.1.102)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.localdomain)
)
)';
------解决方案--------------------
http://hi.baidu.com/fendy520/blog/item/2c538a2fc53069311f30890a.html,
可以看一下关于“ ORA-12541: TNS: no listener”的解答。