【DM版本】: DM8
【操作系统】:CentOS7
【CPU】:
【问题描述】:
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) )
)';
客户端的包有拷贝到数据库bin目录吗?

用户名大写试下:create or replace link "TEST2" connect 'ORACLE' with "TEST" identified by "test" using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.140)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl )
)
)';