求oracle创建DBLINK的方式

发布网友 发布时间:2022-04-24 01:52

我来回答

1个回答

热心网友 时间:2022-04-09 14:57

把Address_list 去掉试试:

create database link linkserver
connect to ssss identified by ssss
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.206.222)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = orcl)
)
)

就是用Oracle的 Net Configuration Assistant 配置一个 连接到Oracle服务器的 “本地网络服务名”

配置好后,在tnsnames.ora中有一段类似

orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.206.222)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
的内容

然后语法换成:

create database link linkserver
connect to ssss identified by ssss
using orcl

声明声明:本网页内容为用户发布,旨在传播知识,不代表本网认同其观点,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。E-MAIL:11247931@qq.com