达梦通过dblink访问oracle数据库

1、下载对应版本的oracle轻量级数据库客户端链接：

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

2、解压 instantclient-basic-linux.x64-12.2.0.1.0.zip

[dmdba@localhost ~]$ unzip instantclient-basic-linux.x64-12.2.0.1.0.zip 
Archive:  instantclient-basic-linux.x64-12.2.0.1.0.zip
  inflating: instantclient_12_2/adrci  
  inflating: instantclient_12_2/BASIC_README  
  inflating: instantclient_12_2/genezi  
  inflating: instantclient_12_2/libclntshcore.so.12.1  
  inflating: instantclient_12_2/libclntsh.so.12.1  
  inflating: instantclient_12_2/libipc1.so  
  inflating: instantclient_12_2/libmql1.so  
  inflating: instantclient_12_2/libnnz12.so  
  inflating: instantclient_12_2/libocci.so.12.1  
  inflating: instantclient_12_2/libociei.so  
  inflating: instantclient_12_2/libocijdbc12.so  
  inflating: instantclient_12_2/libons.so  
  inflating: instantclient_12_2/liboramysql12.so  
  inflating: instantclient_12_2/ojdbc8.jar  
  inflating: instantclient_12_2/uidrvci  
  inflating: instantclient_12_2/xstreams.jar

3、将解压出来的so文件拷贝到达梦数据库所在的bin目录下：

[dmdba@localhost ~]$ cd instantclient_12_2/
[dmdba@localhost instantclient_12_2]$ ll
total 216688
-rwxrwxr-x. 1 dmdba dinstall     44220 Jan 26  2017 adrci
-rw-rw-r--. 1 dmdba dinstall       363 Jan 26  2017 BASIC_README
-rwxrwxr-x. 1 dmdba dinstall     57272 Jan 26  2017 genezi
-rwxrwxr-x. 1 dmdba dinstall   8033199 Jan 26  2017 libclntshcore.so.12.1
-rwxrwxr-x. 1 dmdba dinstall  71638263 Jan 26  2017 libclntsh.so.12.1
-r-xr-xr-x. 1 dmdba dinstall   2981501 Jan 26  2017 libipc1.so
-r-xr-xr-x. 1 dmdba dinstall    539065 Jan 26  2017 libmql1.so
-r-xr-xr-x. 1 dmdba dinstall   6568149 Jan 26  2017 libnnz12.so
-rwxrwxr-x. 1 dmdba dinstall   2218687 Jan 26  2017 libocci.so.12.1
-rwxrwxr-x. 1 dmdba dinstall 124771800 Jan 26  2017 libociei.so
-r-xr-xr-x. 1 dmdba dinstall    158543 Jan 26  2017 libocijdbc12.so
-r-xr-xr-x. 1 dmdba dinstall    380996 Jan 26  2017 libons.so
-rwxrwxr-x. 1 dmdba dinstall    116563 Jan 26  2017 liboramysql12.so
-r--r--r--. 1 dmdba dinstall   4036257 Jan 26  2017 ojdbc8.jar
-rwxrwxr-x. 1 dmdba dinstall    240476 Jan 26  2017 uidrvci
-rw-rw-r--. 1 dmdba dinstall     74230 Jan 26  2017 xstreams.jar
[dmdba@localhost instantclient_12_2]$ \cp -rf ./*.so*   /home/dmdba/dmdbms/bin/

将libclntsh.so.12.1文件复制一份命名为libclntsh.so 或者做一个软链接，并用ldd命令查看依赖库文件是否有未找到的，如果有，可用root用户执行 find / -name “库文件名”找到文件并拷贝到 /lib64目录下

[dmdba@localhost instantclient_12_2]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$ cp libclntsh.so.12.1 libclntsh.so
[dmdba@localhost bin]$ ldd libclntsh.so.12.1
	linux-vdso.so.1 =>  (0x00007ffeff324000)
	libmql1.so (0x00007fd4c03ec000)
	libipc1.so (0x00007fd4bffb8000)
	libnnz12.so (0x00007fd4bf86f000)
	libons.so (0x00007fd4bf621000)
	libdl.so.2 => /lib64/libdl.so.2 (0x00007fd4bf409000)
	libm.so.6 => /lib64/libm.so.6 (0x00007fd4bf107000)
	libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fd4beeeb000)
	libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fd4becd0000)
	librt.so.1 => /lib64/librt.so.1 (0x00007fd4beac8000)
	libaio.so.1 => /lib64/libaio.so.1 (0x00007fd4be8c6000)
	libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fd4be6ab000)
	libc.so.6 => /lib64/libc.so.6 (0x00007fd4be2dd000)
	/lib64/ld-linux-x86-64.so.2 (0x000055a2e5f04000)
	libclntshcore.so.12.1 (0x00007fd4bdd0f000)
	libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fd4bdaf8000)

4、重启达梦数据库，加载库文件

[dmdba@localhost bin]$ ./DmServiceDMSERVER restart
Stopping DmServiceDMSERVER:                                [ OK ]
Starting DmServiceDMSERVER:                                [ OK ]

5、连接数据库创建dblink,查询测试

[dmdba@localhost bin]$ ./disql SYSDBA/SYSDBA:15236

服务器[LOCALHOST:15236]:处于普通打开状态
登录使用时间 : 4.200(ms)
disql V8
SQL> create link "LINKTEST" connect 'oracle' with "SCOTT" identified by "tiger"  using '192.168.10.111:1521/orcl';
操作已执行
已用时间: 3.709(毫秒). 执行号:402.
SQL> select * from EMP@LINKTEST;

行号     EMPNO ENAME  JOB       MGR  HIREDATE            SAL     COMM    DEPTNO
---------- ----- ------ --------- ---- ------------------- ------- ------- ------
1          7369  SMITH  CLERK     7902 1980-12-17 00:00:00 800.00  NULL    20
2          7499  ALLEN  SALESMAN  7698 1981-02-20 00:00:00 1600.00 300.00  30
3          7521  WARD   SALESMAN  7698 1981-02-22 00:00:00 1250.00 500.00  30
4          7566  JONES  MANAGER   7839 1981-04-02 00:00:00 2975.00 NULL    20
5          7654  MARTIN SALESMAN  7698 1981-09-28 00:00:00 1250.00 1400.00 30
6          7698  BLAKE  MANAGER   7839 1981-05-01 00:00:00 2850.00 NULL    30
7          7782  CLARK  MANAGER   7839 1981-06-09 00:00:00 2450.00 NULL    10
8          7788  SCOTT  ANALYST   7566 1987-01-24 00:00:00 3000.00 NULL    20
9          7839  KING   PRESIDENT NULL 1981-11-17 00:00:00 5000.00 NULL    10
10         7844  TURNER SALESMAN  7698 1981-09-08 00:00:00 1500.00 0       30
11         7876  ADAMS  CLERK     7788 1987-04-02 00:00:00 1100.00 NULL    20

行号     EMPNO ENAME  JOB     MGR  HIREDATE            SAL     COMM DEPTNO
---------- ----- ------ ------- ---- ------------------- ------- ---- ------
12         7900  JAMES  CLERK   7698 1981-12-03 00:00:00 950.00  NULL 30
13         7902  FORD   ANALYST 7566 1981-12-03 00:00:00 3000.00 NULL 20
14         7934  MILLER CLERK   7782 1982-01-23 00:00:00 1300.00 NULL 10

14 rows got

已用时间: 52.186(毫秒). 执行号:403.

达梦云适配技术社区：https://eco.dameng.com