求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
