DM dblink创建

达梦到达梦dblink

1. 源端和目标端都创建号数据库

源端：192.168.0.11

访问端：192.168.0.13

1. 配置服务名

达梦访问段配置服务名

1. 创建dblink

create or replace link ceshi connect 'DAMENG' with wzp identified by "oracle" using ‘wzp’

达梦数据库>Oracle数据库dblink

1. 达梦数据库端解压Oracle client

unzip LINUX.X64_193000_client_home.zip

1. 拷贝Oracle client下面lib里面的*.so*至达梦数据库bin目录下

Cp -rf ./*.so* /home/dmdba/dmdbms/bin

1. 在达梦数据库bin目录下创建libclntsh.so软连接

ln -s libclntsh.so.19.1 libclntsh.so

1. 创建dblink

create or replace link ceshi connect 'ORACLE' with wzp identified by "oracle" using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.13)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = wzp)))';

1. 测试dblink

报错

1、配置环境变量LD_LIBRARY_PATH

2、找libnsl.so.1文件位置拷贝到bin目录

Select  *  from  dual@ceshi;

SQL> select * from dual@ceshi;

行号     DUMMY

---------- -----

1          X

达梦数据库到MySQL数据库创建dblink

1. 安装unixODBC

tar -xvzf unixODBC-2.3.9.tar.gz

cd unixODBC-2.3.1

./configure --prefix=/usr/local/unixODBC

Make

Make install

export PATH=$PATH:/usr/local/unixODBC/bin

export LD_LIBRARY_PATH=/usr/local/unixODBC/lib:$LD_LIBRARY_PATH

1. 安装mysql-connector-odbc

tar -xvzf mysql-connector-odbc-5.3.9-linux-glibc2.12-x86-64bit.tar.gz

cd mysql-connector-odbc-5.3.9

./configure --prefix=/opt/mysql-odbc/

make

make instal

export PATH=$PATH:/opt/mysql-odbc/bin

export LD_LIBRARY_PATH=/opt/mysql-odbc/lib:$LD_LIBRARY_PATH

1. 配置odbc

[mysql8]

Driver = MySQL

SERVER = 192.168.0.13

PORT = 3306

USER = root

PASSWORD =123456

charset=UTF8

DATABASE= wzp

TRACE = OFF

cat /etc/odbcinst.ini

 # Example driver definitions

[MySQL]

Description= ODBC for MySQL

Driver64  = /opt/mysql-odbc/lib/libmyodbc5w.so

FileUsage  = 1

1. 创建dblink
2. CREATE or REPLACE PUBLIC LINK MYLINK1 CONNECT 'ODBC' WITH "root" IDENTIFIED BY "123456" USING 'MYSQL';

eco.dameng.com