达梦数据库的dmhs数据实时同步软件的数据对比部署

将数据对比工具部署到DM端的步骤如下：

1. 安装odbc
   下载unixodbc2.3.2源码
   解压unixODBC-2.3.2.tar.gz
   tar -zxvf unixODBC-2.3.2.tar.gz
   cd unxiODBC-2.3.2
   ./configure --enable-iconv=yes --with-iconv-char-enc=GB18030
   make
   make install
   安装完毕后，odbcinst -j查看安装位置等信息。

2. 安装Oracle的驱动
   解压instantclient-basic-linux.x64-11.2.0.4.0.zip和instantclient-odbc-linux.x64-11.2.0.4.0.zip
   cd instantclient_11_2
   chmod 775 odbc_update_ini.sh
   ./odbc_update_ini.sh /usr/local
   没有提示就是安装成功
   odbc_update_ini.sh参数说明：
   参数1：unixODBC DM安装路径。
   参数2：驱动安装的绝对路径（可选）。默认为运行脚本的路径。
   参数3：驱动名（可选），默认为Oracle 11g ODBC driver。
   参数4：数据源名称（可选），默认为OracleODBC-11g。
   运行完成后将添加一个DNS条目到$HOME/.odbc.ini , <DriverManager_HOME>/etc/odbcinst.ini,名称为：OracleODBC-11g

3. 添加环境变量
   vi .bash_profile
   export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/opt/dmdbms/bin:/opt/oracle/instantclient_11_2:/usr/local/lib"
   export DM_HOME="/opt/dmdbms"
   export TNS_ADMIN="/opt/oracle"

4. 将oracle中的listener.ora 、sqlnet.ora 、tnsnames.ora拷贝到机器上来

配置listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle)#注意，这个是刚才配置的$ORACLE_HOME
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.233.132)(PORT = 1521))
)
)

配置tnsnames.ora
ora1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.233.132)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =192.168.233.132/ora1)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

5. 配置obdcinst.ini

[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /opt/dmdbms/bin/libdodbc.so
Setup = /lib/libdmOdbcSetup.so
threading = 0

[Oracle in OraDb11g_home1]
Description = Oracle 11g ODBC driver
Driver = /opt/oracle/instantclient_11_2/libsqora.so.11.1
Threading = 0

7. 测试
   
   
8. 配置veri.xml

<?xml version="1.0" encoding="utf-8"?>
<veri>
        <lang>ch</lang>
        <max_thr>40</max_thr>
        <dmhs>
                <server_name>127.0.0.1</server_name>
                <port>5345</port>
                <site_id>1</site_id>
        </dmhs>
        <src>
                <agent_server>127.0.0.1</agent_server>
                <port>5347</port>
                <db_type>dm8</db_type>
                <odbc_str>
                        <db_server>127.0.0.1</db_server>
                        <db_user>DMHS</db_user>
                        <db_pwd>1234567890</db_pwd>
                </odbc_str>
        </src>
        <dest>
                <agent_server>192.168.233.132</agent_server>
                <port>5347</port>
                <db_type>oracle11g</db_type>
                <odbc_str>
                        <db_server>192.168.233.132/ora1</db_server>
                        <db_user>DMHS</db_user>
                        <db_pwd>123456</db_pwd>
                        <db_port>1521</db_port>
                </odbc_str>
        </dest>
</veri>

9. 配置目的端agent.xml

<?xml version="1.0"encoding="utf-8"?>
<agent>
<port>5347</port>
        <lang>ch</lang>
        <max_session>100</max_session>
        <database>
                <type>dm8</type>
                <server>127.0.0.1</server>
                <uid>DMHS</uid>
                <psw>1234567890</psw>
       </database>
</agent>

10．配置源端agent.xml

<?xml version="1.0"encoding="utf-8"?>
<agent>
<port>5347</port>
        <lang>ch</lang>
        <max_session>100</max_session>
        <database>
                <type>oracle11g</type>
                <server>192.168.233.132/ora1</server>
                <uid>DMHS</uid>
                <psw>123456</psw>
       </database>
</agent>

10. 测试
    ./dmhs_veri_agent_ora
    
    ./dmhs_veri_agent_dm8
    
    比对
    ./dmhs_veri “table=(DMHS.T1==DMHS.T1)” mode=normal;
    
    数据比对功能安装部署完成，可以开始进行数据比对。