签到成功

知道了

CNDBA社区CNDBA社区

DM到其他数据库的DBLINK配置

2023-05-23 10:36 1811 0 原创 达梦数据库
作者： franklin
本文链接：https://www.cndba.cn/franklin/article/121038

一、DM到Mysql的DMlink
1.安装unixODBC
tar -xvzf unixODBC-2.3.9.tar.gz
cd unixODBC-2.3.1
./configure —prefix=/usr/local/unixODBC
make
make installhttps://www.cndba.cn/franklin/article/121038

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

2.安装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 install

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

3.配置ODBC
cat /etc/odbc.ini
[DM8]
DRIVER=DM8 ODBC DRIVER
SERVER=192.168.0.142
UID=SYSDBA
PWD=SYSDBA
TCP_PORT=5236

[mysql8]
Driver = MySQL
SERVER = 192.168.0.1
PORT = 3306
USER = root
PASSWORD =123456
charset=UTF8
DATABASE= test
TRACE = OFF

cat /etc/odbcinst.ini
/#Example driver definitions
[MySQL]
Description = ODBC for MySQL
Driver64 = /opt/mysql-odbc/lib/libmyodbc5w.so
FileUsage = 1https://www.cndba.cn/franklin/article/121038

[DM8 ODBC DRIVER]
Description=DM ODBC DRIVER FOR DM8
Driver=/opt/dmdbms/bin/libdodbc.so

https://www.cndba.cn/franklin/article/121038

4.创建DBlink
CREATE or REPLACE PUBLIC LINK MYLINK1 CONNECT ‘ODBC’ WITH “root” IDENTIFIED BY “123456” USING ‘MYSQL’;

二、DM到PG的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

2.安装postgre-odbc
tar -xvzf psqlodbc-10.02.0000.tar.gz
cd psqlodbc-10.02.0000
./configure —prefix=/opt/psqlodbc/
make
make install

export LD_LIBRARY_PATH=/opt/psqlodbc/lib:$LD_LIBRARY_PATH

3.配置odbc
cat /etc/odbcinst.ini
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver64 = /opt/psqlodbc/lib/psqlodbcw.so
FileUsage = 1

https://www.cndba.cn/franklin/article/121038

cat /etc/odbc.ini
[PG10]
DRIVER=PostgreSQL
Database=postgres
Servername=192.168.0.142
Username=postgres
Password=123456
Port=5432
UsageCount=1

4.创建DBlink
达梦数据库创建dblink
create or replace public link pglink connect ‘ODBC’ with “postgres” identified by “123456” using ‘PG10’;
https://www.cndba.cn/franklin/article/121038

三、linux环境下DM到SQLserver的DBlink
略，已有现成的文档

四、windows环境下DM到SQLserver的DBlink
1.配置ODBC

配置链接SqlServer的ODBC

配置链接SqlServer的用户名密码

配置默认连接的数据库

完成

测试ODBC源

https://www.cndba.cn/franklin/article/121038

2.创建DBlink
create or replace link mssql connect ‘ODBC’ with “sa” identified by “123” using ‘SQLserver’;
select * from t1@mssql

五、SQLserver到DM的DBlink
1.Windws环境或者linux环境安装达梦客户端和驱动

2.配置ODBC
Windows环境下通过ODBC数据源管理程序进行配置ODBC

创建新数据源，这里可以直接选择DM8 ODBC DRIVER

填写DM服务端的IP地址、端口号、用户名、密码

测试连接

3.SQLserver创建DBlink
选择服务器对象—链接服务器，右键“新建链接服务器”

填写链接服务器名，访问接口，数据源名

select from openquery(dm8,’select from sysdba.t1’)

六、DM到Oracle的DBlink
1.安装客户端软件
oracle_instantclient11.2-basic-11.2.0.3.0-1.x86_64.tar.gz
oracle_instantclient11.2-odbc-11.2.0.3.0-1.x86_64.tar.gz
oracle_instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.tar.gz

配置dmdba用户的环境变量
export ORACLE_HOME=”/u01/app/oracle/product/11.2.0/db_1”
export LD_LIBRARY_PATH=”$LD_LIBRARY_PATH:/u01/app/oracle/product/11.2.0/db_1/lib”

2.安装ODBC
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

3.配置ODBC
cat /usr/local/unixODBC/etc/odbc.ini
[ORA11G]
DRIVER = Oracle in OraDb11g_home1
SERVER = 192.160.0.143
UserID = USER1
Password = USER1
Servername = ORADB
PORT = 1521

cat /usr/local/unixODBC/etc/odbcinst.ini
[Oracle in OraDb11g_home1]
Description = ODBC DRIVER FOR ORACLE
Driver = /u01/app/oracle/product/11.2.0/db_1/lib/libsqora.so.11.1 #客户端软件安装路径
Threading = 0

4.配置Oracle连接串
cat /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
ORADB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.143)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORADB)
)
)

https://www.cndba.cn/franklin/article/121038

5.测试库文件
ldd /u01/app/oracle/product/11.2.0/db_1/lib/libsqora.so.11.1

6.创建DBlink
create or replace public LINK oralink connect ‘ODBC’ with “USER1” identified by “USER123456” using ‘ORA11G’;

七、Oracle到DM的DBlinkhttps://www.cndba.cn/franklin/article/121038

1.安装ODBC
tar -xvzf unixODBC-2.3.9.tar.gz
cd unixODBC-2.3.1
./configure —prefix=/usr/local/unixODBC
make
make install

https://www.cndba.cn/franklin/article/121038

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

2.配置ODBC
cat /usr/local/unixODBC/etc/odbc.ini
[ORA11G]
DRIVER = Oracle in OraDb11g_home1
SERVER = 192.160.0.143
UserID = USER1
Password = USER1
Servername = ORADB
PORT = 1521

cat /usr/local/unixODBC/etc/odbcinst.ini
[Oracle in OraDb11g_home1]
Description = ODBC DRIVER FOR ORACLE
Driver = /u01/app/oracle/product/11.2.0/db_1/lib/libsqora.so.11.1 #客户端软件安装路径
Threading = 0

3.配置hs实例
cd /u01/app/oracle/product/11.2.0/db_1/hs

添加配置文件
initDMDB.ora
/##HS Configuration
HS_FDS_CONNECT_INFO = DMDB
HS_FDS_TRACE_LEVEL = debug
HS_FDS_SHAREABLE_NAME = /usr/local/unixODBC/lib/libodbc.so
set ODBCINI=/usr/local/unixODBC/odbc.ini
HS_FDS_SUPPORT_STATISTICS = FALSE
HS_LANGUAGE = AMERICAN_AMERICA.AL32UTF8
HS_NLS_NCHAR = UCS2

4.配置DM实例监听文件
vi /u01/app/oracle/product/11.2.0/db_1network/admin/listener.ora
(SID_DESC=
(PROGRAM = dg4odbc)
(SID_NAME = DMDB)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(ENVS=LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/lib)
)

https://www.cndba.cn/franklin/article/121038

重新加载监听文件
lsnrctl reload

5.配置Oracle连接串
cat /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
ORADB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.143)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORADB)
)
)

DM8DB =
(DESCRIPTION =
(ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.0.143)(PORT = 1521))
(CONNECT_DATA=
(SID = DMDB)
)
(HS = OK)
)

6.创建DBlink
create public database link DM8LINK connect to “SYSDBA” identified by “SYSDBA” using ‘DM8DB’;

7.查看DBLink
select owner,object_name from dba_objects where object_type=’DATABASE LINK’;

删除DBlink
drop public database link XXX;

达梦相关技术信息在达梦云适配中心
https://eco.dameng.com

版权声明：本文为博主原创文章，未经博主允许不得转载。

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
franklin

franklin

关注
  • 15
    原创
  • 0
    翻译
  • 1
    转载
  • 3
    评论
  • 访问：32935次
  • 积分：56
  • 等级：注册会员
  • 排名：第39名
精华文章


    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    热门文章
      友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
      Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

      QQ交流群

      注册联系QQ