注册

Oracle Dblink 到达梦 无效的链接名

DM_301522 2026/07/29 329 2

【DM版本】: DM8
【操作系统】:CentOS7
【CPU】:
【问题描述】:

  1. Oracle Dblink 链接到达梦数据库中,执行SELECT * FROM DUAL@REST_TEST 提示
    [执行语句1]
    SELECT * FROM DUAL@REST_TEST;
    执行失败,失败原因:
    [-2131]:无效的链接名[REST_TEST]

2.后台日志显示
[INFO] database P0000000008 T0000000000000000144 LINK 201326626 EXEC SQL:ROLLBACK

3.达梦数据库本地已经安装
oracle-instantclient19.31-basic-19.31.0.0.0-2.x86_64
oracle-instantclient19.31-sqlplus-19.31.0.0.0-2.x86_64

4.在达梦数据库本地使用
sqlplus rems_00_test/rems_00_test@xxx.xxx.xxx.1:1521/kfdb01
可以正常查询

5.DBlink语句
CREATE OR REPLACE LINK REST_TEST CONNECT 'ORACLE' WITH rems_00_test IDENTIFIED BY rems_00_test USING '(DESCRIPTION =

(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.1)(PORT = 1521)))

(CONNECT_DATA = (SERVICE_NAME = kfdb01) )

)';

回答 0
暂无回答
扫一扫
联系客服