数据对比工具dmhs_veri部署方法（Oracle 客户端部署）

yr--heart

已于 2023-08-08 15:25:29 修改

阅读量338

点赞数

文章标签： oracle 数据库

于 2023-07-30 18:46:40 首次发布

本文链接：https://blog.csdn.net/2301_78312656/article/details/132008180

版权

前言：数据对比源端：oracle11g，目的端：mysql8，对比工具部署在目的端（mysql端），当前Oracle数据同步至mysql端同步正常（未开启DDL同步）。

在mysql端配置对比工具：需安装oracle客户端才能正常运行

oracle端操作系统版本：redhat 6.8 CPU架构：X86_64

mysql端操作系统版本：Kylin10 CPU架构：X86_64

（一）dmhs_veri对比工具配置

一、Oracle端配置agent.xml

[oracle@orcl-201 ~]$ cd $DMHS_HOME/bin

[oracle@orcl-201 bin]$ cat agent.xml
<?xml version="1.0" encoding="utf-8"?>
<agent>
<port>5547</port>
<lang>en</lang>
<max_session>100</max_session>
<mkde>0</mkde>

<database>
<type>ORACLE11G</type>
<server>orcl</server>
<uid>dmhs</uid>
<psw>DMHS1234</psw>
<port>1521</port>

</database>
</agent>

二、MySQL端配置agent.xml

[root@dm3 ~]# su - dmhs
Last login: Fri Jul 28 00:30:12 CST 2023 on pts/1
[dmhs@dm3 ~]$ cd $DMHS_HOME/bin
[dmhs@dm3 bin]$ cat agent.xml
<?xml version="1.0" encoding="utf-8"?>
<agent>
<port>5447</port>
<lang>en</lang>
<max_session>100</max_session>
<mkde>0</mkde>

<database>
<type>mysql</type> 
<server>192.168.72.13</server>
<uid>dmhs</uid>
<psw>DMHS1234</psw>
<port>3306</port>

</database>
</agent>

[dmhs@dm3 bin]$

【扩展知识（注意点）】

如果agent.xml中配置的<type>错误，启动agent服务时会出现如下报错：

[dmhs@dm3 bin]$ ./dmhs_veri_agent_mysql agent.xml
AGENT[INFO]: VERI AGENT start up, current version: V4.3.06-Build(2023.02.08-123650trunc)_64_2302
AGENT[WARN]: agent.xml configuration item is not found: lock_nowait, using default value : 1
AGENT[ERROR]: agent.xml configuration item is error: db_type

如果agent.xml中配置的<server>错误，启动dmhs_veri进行数据对比时会报错且无对比结果内容输出，具体显示报错如下：

[dmhs@dm3 bin]$ ./dmhs_veri "table=(DMHS.TEST1==mysql.test1)" mode=normal

.......此处省略中间对比过程显示

VERI[INFO]: veri get src agent bulk data (DMHS.TEST1, 1, 4)
VERI[ERROR]: VERI receive the abort msg from destination agent, then compare(DMHS.TEST1==mysql.test1) is abort
.......此处省略中间对比过程显示
VERI[INFO]: (DMHS.TEST1==mysql.test1) compare over, out_sync: 0, in_sync: 0, used time : 14.832(ms)
VERI[INFO]: Report folder path : /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_004
VERI[INFO]: Summary report file path : /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_004/veri_report_DMHS.TEST1==mysql.test1.txt
VERI[INFO]: Exit the Verify tool

查看对比报告，发现未返回数据对比后的结果：
[dmhs@dm3 bin]$ cat /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_004/veri_report_DMHS.TEST1==mysql.test1.txt
******************************************************
DM Verify Data Tool
version : V4.3.06-Build(2023.02.08-123650trunc)_64_2302
start : 2023-07-30 17:42:50
end : 2023-07-30 17:46:12
******************************************************
source tables or views more than dest as follow:
dest tables or views more than source as follow:
******************************************************
No rowid file table pair as follow:
******************************************************
Job Name : DMHS.TEST1==mysql.test1
execute mode : NORMAL
source agent ip : 192.168.72.201:5547
source agent database type : ORACLE11g
destination agent ip : 192.168.72.13:5447
destination agent database type : MYSQL
******************************************************
Notice:When nonkey compare, update show as insert and delete, so the sum of same and diff may be over total
Total compared 1 tables, list as follow:

DMHS.TEST1 == mysql.test1
sync abort
******************************************************
[dmhs@dm3 bin]$ ll

查看agent服务运行日志信息分析发现上述问题是因为mysql端agent.xml参数<server>配置错误导致，报错信息如下：

AGENT[INFO]: thread id: 140252705056512, SESS:0x7f8f1c008de8, table: mysql.test1, fetching data...
CPT[ERROR]: vid:0 state:HY000 errmsg:[MySQL][ODBC 5.3(a) Driver]Unknown MySQL server host 'mysql' (2)
PUB[ERROR]: unable to connect database!
AGENT[ERROR]: unable to connect database: server=mysql; user=dmhs, try again after 10 seconds, try times: 1

三、配置数据对比参数veri.xml（通过odbc驱动方式访问源端与目标端数据库）

[dmhs@dm3 bin]$ cat veri.xml

<?xml version="1.0" encoding="utf-8"?>
<veri>
<lang>en</lang>
<dmhs>
<server_name>192.168.72.13</server_name>
<port>5445</port>
<site_id>40</site_id>
</dmhs>
<src>
<driver>Oracle in OraDb11g_home1</driver>
<agent_server>192.168.72.201</agent_server>
<port>5547</port>
<db_type>ORACLE11G</db_type>
<odbc_str>
<db_server>ORCL</db_server>
<db_port>1521</db_port>
<db_user>DMHS</db_user>
<db_pwd>DMHS1234</db_pwd>
</odbc_str>
</src>
<dest>
<driver>MySQL ODBC 5.1 Driver</driver>
<agent_server>192.168.72.13</agent_server>
<port>5447</port>
<db_type>MYSQL</db_type>
<odbc_str>
<db_server>192.168.72.13</db_server>
<db_port>3306</db_port>
<db_user>dmhs</db_user>
<db_pwd>DMHS1234</db_pwd>
<db_name>mysql</db_name>
</odbc_str>
</dest>
</veri>

四、依次启动源端与目标端的agent服务

1、通过前端方式启动agent

（1）oracle端启动agent：

[oracle@orcl-201 ~]$ cd $DMHS_HOME/bin

[oracle@orcl-201 bin]$ ./dmhs_veri_agent_ora agent.xml
AGENT[INFO]: VERI AGENT start up, current version: V4.3.08-Build(2023.03.23-126685trunc)_64_2303_sp5
AGENT[INFO]: worker thread number: 4, max buf size: 64 MB
AGENT[WARN]: agent.xml configuration item is not found: lock_nowait, using default value : 1
AGENT[INFO]: AGENT data receiving thread created successfully, listening data port : 5547

（2）MySQL端启动agent

[dmhs@dm3 ~]$ cd $DMHS_HOME/bin

[dmhs@dm3 bin]$ ./dmhs_veri_agent_mysql agent.xml
AGENT[INFO]: VERI AGENT start up, current version: V4.3.06-Build(2023.02.08-123650trunc)_64_2302
AGENT[WARN]: agent.xml configuration item is not found: lock_nowait, using default value : 1
AGENT[WARN]: log flag do not open,reopen the log flag
AGENT[INFO]: AGENT data receiving thread created successfully, listening data port : 5447

2、后台启动agent服务

安装dmhs的bin目录下会有各种应用的Service脚本模板，直接复制到$DMHS_HOME/bin目录下配置以下参数即可：

[dmhs@dm3 service_template]$ pwd
/home/dmhs/dmhs/bin/service_template

[dmhs@dm3 service_template]$ cp AgentOraService $DMHS_HOME/bin

[dmhs@dm3 service_template]$ cd ..

（1）Oracle端配置agent服务：

[oracle@orcl-201 bin]$ vi AgentOraService #仅修改以下参数，其它参数默认不作更改

DMHS_HOME=/home/oracle/dmhs #DMHS安装目录
PROG_DIR=$DMHS_HOME/bin #agent.xml文件所在目录
CONF_PATH=$PROG_DIR/agent.xml #agent服务启动对应的配置文件
NEED_LIB_PATH=/home/oracle/dmhs/bin:/usr/local/lib:/usr/lib64 #环境变量
HS_NLS_LANG="AMERICAN_AMERICA.ZHS16GBK" #字符集
EXEC_PROG_NAME=dmhs_veri_agent_ora
SERVICE_TYPE_NAME="Veri agent for Oracler"

配置完成启动agent服务，注意赋权

chmod -R 775 AgentOraService

[oracle@orcl-201 bin]$ ./AgentOraService start

（2）MySQL端配置agent服务：

[dmhs@dm3 service_template]$ cp AgentMysqlService $DMHS_HOME/bin
[dmhs@dm3 service_template]$ cd ..
[dmhs@dm3 bin]$ vi AgentMysqlService
#仅修改以下参数配置，其它脚本内容保持默认即可

DMHS_HOME=/home/dmhs/dmhs
PROG_DIR=$DMHS_HOME/bin
CONF_PATH=$PROG_DIR/agent.xml
NEED_LIB_PATH=/home/dmhs/dmhs/bin:/usr/local/lib
HS_NLS_LANG="UTF8"
EXEC_PROG_NAME=dmhs_veri_agent_mysql
SERVICE_TYPE_NAME="Veri agent for MySQL"

[dmhs@dm3 bin]$ ./AgentMysqlService start
-bash: ./AgentMysqlService: Permission denied
[dmhs@dm3 bin]$ chmod -R 775 AgentMysqlService
[dmhs@dm3 bin]$ ./AgentMysqlService start
Starting AgentMysqlService: [ OK ]

（二）Oracle客户端安装

一、当前测试环境安装的oracle客户端包名称如下，必须先安装basic包，再安装odbc包

Oracle客户端rpm包名：

1、oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

2、oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm

[root@dm3 dmhs]# rpm oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm -ivh
Preparing... ################################# [100%]
Updating / installing...
1:oracle-instantclient11.2-basic-11################################# [100%]
[root@dm3 dmhs]# rpm oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm -ivh
Preparing... ################################# [100%]
Updating / installing...
1:oracle-instantclient11.2-odbc-11.################################# [100%]

二、安装后通过搜索Oracle odbc驱动文件libsqora.so.11.1查看Oracle客户端rpm安装所在路径

[root@dm3 dmhs]# find / -name libsqora.so.11.1
find: ‘/run/user/1000/gvfs’: Permission denied
/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1

[root@dm3 dmhs]# cd /usr/lib/oracle/11.2/client64
[root@dm3 client64]# ll
total 0
drwxr-xr-x 2 root root 33 Jul 30 15:25 bin
drwxr-xr-x 2 root root 195 Jul 30 15:25 lib
[root@dm3 client64]# cd lib
[root@dm3 lib]# ll
total 184236
-rw-r--r-- 1 root root 53865194 Aug 25 2013 libclntsh.so.11.1
-rw-r--r-- 1 root root 7996693 Aug 25 2013 libnnz11.so
-rw-r--r-- 1 root root 1973074 Aug 25 2013 libocci.so.11.1
-rw-r--r-- 1 root root 118738042 Aug 25 2013 libociei.so
-rw-r--r-- 1 root root 164942 Aug 25 2013 libocijdbc11.so
-rw-r--r-- 1 root root 1003582 Aug 25 2013 libsqora.so.11.1
-rw-r--r-- 1 root root 2091135 Aug 25 2013 ojdbc5.jar
-rw-r--r-- 1 root root 2739616 Aug 25 2013 ojdbc6.jar
-rw-r--r-- 1 root root 66779 Aug 25 2013 xstreams.jar

三、在mysql端配置oracle驱动参数

注意如果Oracle驱动名称不是Oracle in OraDb11g_home1会出现报错提示找不到该驱动，mysql驱动名称不是MySQL ODBC 5.1 Driver也会报错提示找不到该驱动。

[root@dm3 ~]# cat /usr/local/etc/odbcinst.ini
[MySQL ODBC 5.1 Driver] #驱动配置
Driver=/usr/lib64/libmyodbc5a.so
#Driver=/usr/lib64/libmyodbc8a.so
UsageCount=3
Threading=0

[Oracle in OraDb11g_home1]
Description=ODBC DRIVER FOR ORACLE
Driver=/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
Threading=0
[root@dm3 ~]# cat /usr/local/etc/odbc.ini
[ORACLE] #isql连接oracle数据库驱动配置
Description=ORACLE ODBC DSN
Driver=Oracle in OraDb11g_home1
SERVER=192.168.72.201
SERVERNAME=orcl
UID=DMHS
PWD=DMHS1234
PORT=1521

[DM8]
Description = DM ODBC DSN
Driver = DM8 ODBC DRIVER
server = 192.168.72.202
UID = SYSDBA
PWD = Dameng123
PORT = 5236

[MYSQL] #isql连接Mysql数据库驱动配置
Description = MySQL ODBC DSN
Driver = MySQL ODBC 5.1 Driver
#Driver = MySQL ODBC 8.1 Driver
database = mysql
server = 127.0.0.1
UID = dmhs
PWD = DMHS1234
PORT = 3306

[root@dm3 ~]#

四、测试isql连接Oracle出现无法连接报错，具体报错显示如下：

[root@dm3 ~]# isql ORACLE -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/product/11.2.0.4/db_1/libsqora.so.11.1' : file not found
[ISQL]ERROR: Could not SQLConnect

[root@dm3 ~]# ldd /home/oracle/product/11.2.0.4/db_1/libsqora.so.11.1
ldd: warning: you do not have execution permission for `/home/oracle/product/11.2.0.4/db_1/libsqora.so.11.1'
linux-vdso.so.1 => (0x00007ffc71ba0000)
libdl.so.2 => /usr/lib64/libdl.so.2 (0x00007fdd2d4f5000)
libm.so.6 => /usr/lib64/libm.so.6 (0x00007fdd2d1f3000)
libpthread.so.0 => /usr/lib64/libpthread.so.0 (0x00007fdd2cfd7000)
libnsl.so.1 => /usr/lib64/libnsl.so.1 (0x00007fdd2cdbd000)
libclntsh.so.11.1 => /home/oracle/product/11.2.0.4/db_1/libclntsh.so.11.1 (0x00007fdd2a44e000)
libodbcinst.so.1 => not found
libc.so.6 => /usr/lib64/libc.so.6 (0x00007fdd2a081000)
/lib64/ld-linux-x86-64.so.2 (0x00007fdd2d6f9000)
libnnz11.so => /home/oracle/product/11.2.0.4/db_1/libnnz11.so (0x00007fdd29cb4000)
libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007fdd29ab2000)

由上述显示结果可知是因为缺少libodbcinst.so.1依赖包，从根目录按名字搜索libodbcinst发现系统中有该依赖包，只是命名方式不同，可通过创建软链接方式解决，具体操作如下：

[root@dm3 client64]# find / -name libodbcinst*
find: ‘/run/user/1000/gvfs’: Permission denied
/usr/lib64/libodbcinst.so.2
/usr/local/lib/libodbcinst.so.2.0.0
/usr/local/lib/libodbcinst.so.2
/usr/local/lib/libodbcinst.so
/usr/local/lib/libodbcinst.la
/opt/unixODBC-2.3.11/odbcinst/.libs/libodbcinst.ver
/opt/unixODBC-2.3.11/odbcinst/.libs/libodbcinst.so.2.0.0
/opt/unixODBC-2.3.11/odbcinst/.libs/libodbcinst.so.2
/opt/unixODBC-2.3.11/odbcinst/.libs/libodbcinst.so
/opt/unixODBC-2.3.11/odbcinst/.libs/libodbcinst.lai
/opt/unixODBC-2.3.11/odbcinst/.libs/libodbcinst.la
/opt/unixODBC-2.3.11/odbcinst/.libs/libodbcinstlc.a
/opt/unixODBC-2.3.11/odbcinst/.libs/libodbcinstlc.la
/opt/unixODBC-2.3.11/odbcinst/libodbcinst.la
/opt/unixODBC-2.3.11/odbcinst/libodbcinstlc.la

创建软链接：

[root@dm3 client64]# ln -s /usr/local/lib/libodbcinst.so /usr/lib64/libodbcinst.so.1

五、配置监听tnsnames.ora，远程连接Oracle数据库

[root@dm3 ~]# cd /usr/lib/oracle/11.2/client64/
[root@dm3 client64]# ll
total 0
drwxr-xr-x 2 root root 33 Jul 30 15:25 bin
drwxr-xr-x 2 root root 195 Jul 30 15:25 lib
[root@dm3 client64]# mkdir -p network/admin
[root@dm3 client64]# cd network/admin
[root@dm3 admin]# vi tnsnames.ora
orcl =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.72.201)(PORT=1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

六、配置LD_LIBRARY_PATH与TNS_ADMIN环境变量

[root@dm3 admin]# cd
[root@dm3 ~]# vi .bash_profile
PATH=$PATH:$HOME/bin
export PATH
export MYSQL_HOME=/opt/mysql-8.0.30
export PATH=$PATH:$MYSQL_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib64/:$MYSQL_HOME/lib:/usr/lib/oracle/11.2/client64/lib
export TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
[root@dm3 ~]#
配置完成后要记得令环境变量生效
[root@dm3 ~]# source .bash_profile

七、验证isql连接ORACLE成功

[root@dm3 ~]# isql ORACLE DMHS DMHS1234
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| echo [string] |
| quit |
| |
+---------------------------------------+
SQL> quit

[root@dm3 ~]#

（三）运行dmhs_veri进行数据对比

[dmhs@dm3 bin]$ ./dmhs_veri "table=(DMHS.TEST1==mysql.test1)" mode=normal

提示不允许主机***连接mysql数据库服务
[dmhs@dm3 bin]$ ./dmhs_veri "table=(DMHS.TEST1==mysql.test1)" mode=normal
VERI[INFO]: VERI start up, current version: V4.3.06-Build(2023.02.08-123650trunc)_64_2302
VERI[INFO]: do not set max_out_sync,use the default value
PUB[WARN]: NLS_LANG user env cannot find, use default GBK default values:AMERICAN_AMERICA.ZHS16GBK
VERI[INFO]: CONNECT: DBQ=ORCL;DRIVER={Oracle in OraDb11g_home1};UID=DMHS;PWD=******;
VERI[INFO]: CONNECT: SERVER=192.168.72.13;DRIVER={MySQL ODBC 5.1 Driver};PORT=3306;DATABASE=mysql;USER=dmhs;PASSWORD==******;
VERI[WARN]: When get_raw_data is 3 , 4 or database is not ORACLE/DM7/DM8, report_buf_size be set 0.
MGR[WARN]: License will expire on 2023-12-25
VERI[INFO]: veri odbc connect str: DBQ=ORCL;DRIVER={Oracle in OraDb11g_home1};UID=DMHS;
VERI[INFO]: veri odbc connect str: SERVER=192.168.72.13;DRIVER={MySQL ODBC 5.1 Driver};PORT=3306;DATABASE=mysql;USER=dmhs;
VERI[ERROR]: state:HY000 errmsg:[MySQL][ODBC 5.3(a) Driver]Host 'dm3' is not allowed to connect to this MySQL server
VERI[ERROR]: connect to database fail: SERVER=192.168.72.13;DRIVER={MySQL ODBC 5.1 Driver};PORT=3306;DATABASE=mysql;USER=dmhs;, try again after 30 second.

经查询资料才知远程连接提示：Host 'xxx' is not allowed to connect to this MySQL server，是由于mysql未开启mysql远程访问权限导致，解决方法如下：
修改host字段的值，将localhost修改成需要远程连接数据库的ip地址，或者直接修改成%。修改成%表示，所有主机都可以通过root用户访问数据库。为了方便，我直接修改成%：

[root@dm3 ~]# mysql -uroot -p
Enter password:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> select host,user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | root |
| localhost | dmhs |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+------------------+
5 rows in set (0.00 sec)

再次查看user表, 修改成功，输入命令mysql> FLUSH PRIVILEGES; 回车使刚才的修改生效，再次远程连接数据库成功。

mysql> update user set host='%' where user='dmhs';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> GRANT ALL PRIVILEGES ON *.* TO 'dmhs'@'%' WITH GRANT OPTION;
ERROR 1410 (42000): You are not allowed to create a user with GRANT
#上述语法写错，with前面不能有空格
mysql> GRANT ALL PRIVILEGES ON *.* TO 'dmhs'@'%'WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

[dmhs@dm3 bin]$ ./dmhs_veri "table=(DMHS.TEST1==mysql.test1)" mode=normal
VERI[INFO]: VERI start up, current version: V4.3.06-Build(2023.02.08-123650trunc)_64_2302
VERI[INFO]: do not set max_out_sync,use the default value
PUB[WARN]: NLS_LANG user env cannot find, use default GBK default values:AMERICAN_AMERICA.ZHS16GBK
.......此处省略中间对比过程显示
VERI[INFO]: (DMHS.TEST1==mysql.test1) compare over, out_sync: 3, in_sync: 1, used time : 16.875(ms)
VERI[INFO]: Detail report : /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_006/detail_DMHS.TEST1==mysql.test1/DMHS.TEST1=mysql.test1.txt (Total print: 3)
VERI[INFO]: Destination delete detail ok!
VERI[INFO]: Report folder path : /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_006
VERI[INFO]: Summary report file path : /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_006/veri_report_DMHS.TEST1==mysql.test1.txt
VERI[INFO]: Detail report folder path : /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_006/detail_DMHS.TEST1==mysql.test1
VERI[INFO]: Exit the Verify tool

查看数据对比报告，如果存在数据不一致情况，会显示一个详细的数据对比报告：

[dmhs@dm3 bin]$ cat /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_006/veri_report_DMHS.TEST1==mysql.test1.txt
******************************************************
DM Verify Data Tool
version : V4.3.06-Build(2023.02.08-123650trunc)_64_2302
start : 2023-07-30 17:56:08
end : 2023-07-30 17:56:11
******************************************************
source tables or views more than dest as follow:
dest tables or views more than source as follow:
******************************************************
No rowid file table pair as follow:
******************************************************
Job Name : DMHS.TEST1==mysql.test1
execute mode : NORMAL
source agent ip : 192.168.72.201:5547
source agent database type : ORACLE11g
destination agent ip : 192.168.72.13:5447
destination agent database type : MYSQL
******************************************************
Notice:When nonkey compare, update show as insert and delete, so the sum of same and diff may be over total
Total compared 1 tables, list as follow:

[NO] DMHS.TEST1 == mysql.test1
in sync : 1
out sync : 3
detail file : /home/dmhs/dmhs/bin/report/DMHS.TEST1==mysql.test1_20230730_006/detail_DMHS.TEST1==mysql.test1/DMHS.TEST1=mysql.test1.txt

******************************************************

学习社区：达梦在线服务平台（https://eco.dameng.com）

yr--heart

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
数据对比工具dmhs_veri部署方法（Oracle 客户端部署）

数据对比源端：oracle11g，目的端：mysql8，对比工具部署在目的端（mysql端），当前Oracle数据同步至mysql端同步正常（未开启DDL同步）。在mysql端配置对比工具：需安装oracle客户端才能正常运行oracle端操作系统版本：redhat 6.8 CPU架构：X86_64mysql端操作系统版本：Kylin10 CPU架构：X86_64。
复制链接

扫一扫