DMHSV4 搭建oracle11g到oracle 11g的实时同步之环境配置

原创已于 2022-06-05 11:05:57 修改 · 239 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库 #dba

于 2022-05-28 00:08:42 首次发布

达梦数据库专栏收录该内容

28 篇文章

订阅专栏

本文介绍如何通过编辑dmhs.hs文件或使用dmhs_hsca工具进行达梦数据库的数据同步配置，包括源端和目标端的具体配置步骤及示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

环境配置方式

1、文件：直接编辑安装目录bin下的dmhs.hs文件，无图像界面的情况下建议
2、图形化：使用dmhs_hsca来辅助dmhs.hs文件的编辑，编辑过程中也验证数据库连接情况，有图像界面的情况下建议

源端dmhs_hsca图形化配置

[oracle@oradb1 tool]$ pwd
/dm8/dmhs/tool
[oracle@oradb1 tool]$ 
[oracle@oradb1 tool]$ ./dmhs_hsca
Xlib:  extension "RANDR" missing on display "10.0.0.1:0.0".

在这里插入图片描述

含义：源端数据库的服务名，如果数据库不支持服务名，也可以填写 IP
在这里插入图片描述

在这里插入图片描述

源端生成的dmhs.hs文件内容

[oracle@oradb1 tool]$ cat /dm8/dmhs/bin/dmhs.hs
<?xml version="1.0" encoding="GB2312" standalone="no"?>
<dmhs>
    <base>
        <lang>ch</lang>
        <version>2.0</version>
        <mgr_port>5345</mgr_port>
        <chk_interval>3</chk_interval>
        <ckpt_interval>60</ckpt_interval>
        <name>local1</name>
        <siteid>1</siteid>
        <pwd_encipher>0</pwd_encipher>
        <mem_check>0</mem_check>
        <log_policy>0</log_policy>
    </base>
    <cpt>
        <name>cap1</name>
        <enable>1</enable>
        <db_type>ORACLE11g</db_type>
        <db_server>crm</db_server>
        <db_port>1521</db_port>
        <db_user>system</db_user>
        <db_pwd>abcd1234</db_pwd>
        <char_code>PG_GB18030</char_code>
        <ddl_mask>TABLE:OPERATION</ddl_mask>
        <jdbc from_password="abcd1234" from_type="Oracle" from_url="jdbc:oracle:thin:@10.0.0.21:1521:CRM" from_user="SYSTEM" to_password="abcd1234" to_type="Oracle" to_url="jdbc:oracle:thin:@10.0.0.22:1521:oa" to_user="SYSTEM"/>
        <arch>
            <clear_interval>600</clear_interval>
            <clear_flag>0</clear_flag>
        </arch>
        <send>
            <ip>10.0.0.22</ip>
            <mgr_port>5345</mgr_port>
            <data_port>5346</data_port>
            <filter>
                <enable>
                    <item>USERCRM.T01</item>
                    <item>USERCRM.T02</item>
                    <item>USERCRM.*</item>
                </enable>
                <disable/>
            </filter>
            <map>
                <item>USERCRM.T01==USERCRM.T01</item>
                <item>USERCRM.T02==USERCRM.T02</item>
                <item>USERCRM.*==USERCRM.*</item>
            </map>
        </send>
    </cpt>
</dmhs>
[oracle@oradb1 tool]$

目标端dmhs_hsca图形化配置

[oracle@oradb2 ~]$ cd /dm8/dmhs/tool
[oracle@oradb2 tool]$ 
[oracle@oradb2 tool]$ ./dmhs_hsca
Xlib:  extension "RANDR" missing on display "10.0.0.1:0.0".

在这里插入图片描述

含义：源端数据库的服务名，如果数据库不支持服务名，也可以填写 IP
EXE[INFO]: CONNECT: SERVER=oa;DRIVER={Oracle in OraDb11g_home1};UID=system;PWD=******;

/dm8/dmhs/odbc/bin
[oracle@oradb2 bin]$ /dm8/dmhs/odbc/bin//odbcinst -j
unixODBC 2.3.2
DRIVERS............: /dm8/dmhs/odbc/etc/odbcinst.ini
SYSTEM DATA SOURCES: /dm8/dmhs/odbc/etc/odbc.ini
FILE DATA SOURCES..: /dm8/dmhs/odbc/etc/ODBCDataSources
USER DATA SOURCES..: /home/oracle/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
[oracle@oradb2 bin]$ 
[oracle@oradb2 bin]$ 
[oracle@oradb2 bin]$ cat /dm8/dmhs/odbc/etc/odbcinst.ini
[Oracle in OraDb11g_home1]
Description=ODBC DRIVER FOR ORACLE
Driver=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libsqora.so.11.1
Threading=0

[Oracle 11g ODBC driver]
Description=Oracle ODBC driver for Oracle 11g
Driver=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libsqora.so.11.1
[oracle@oradb2 bin]$ 
[oracle@oradb2 bin]$ 
[oracle@oradb2 bin]$ cat /dm8/dmhs/odbc/etc/odbc.ini
[ora11g]
Description=ORACLE ODBC DSN
Driver=Oracle in OraDb11g_home1
SERVER= 10.0.0.21
UserID=system
Password=abcd1234
Servername=oa
PORT=1521
[oracle@oradb2 bin]$

[oracle@oradb2 ~]$ tnsping oa

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 29-MAY-2022 16:35:02

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oradb2)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oa)))
OK (0 msec)
[oracle@oradb2 ~]$

在这里插入图片描述

目标端生成的dmhs.hs文件内容

[oracle@oradb2 ~]$ cat /dm8/dmhs/bin/dmhs.hs
<?xml version="1.0" encoding="GB2312" standalone="no"?>
<dmhs>
    <base>
        <lang>ch</lang>
        <version>2.0</version>
        <mgr_port>5345</mgr_port>
        <chk_interval>3</chk_interval>
        <ckpt_interval>60</ckpt_interval>
        <name>local2</name>
        <siteid>2</siteid>
        <pwd_encipher>0</pwd_encipher>
        <mem_check>0</mem_check>
        <log_policy>0</log_policy>
    </base>
    <exec>
        <recv>
            <mgr_port>5345</mgr_port>
            <data_port>5346</data_port>
        </recv>
        <name>exec1</name>
        <enable>1</enable>
        <db_type>Oracle11g</db_type>
        <db_server>oa</db_server>
        <db_user>system</db_user>
        <db_pwd>abcd1234</db_pwd>
        <char_code>PG_GB18030</char_code>
        <recv_caches>8</recv_caches>
        <trxid_tables>1</trxid_tables>
        <case_sensitive>0</case_sensitive>
        <enable_rowid>0</enable_rowid>
        <toggle_case>0</toggle_case>
        <exec_policy>1</exec_policy>
        <commit_policy>1</commit_policy>
        <enable_merge>1</enable_merge>
        <affect_row>1</affect_row>
        <ddl_mode>0</ddl_mode>
        <is_kafka>0</is_kafka>
        <enable_ckpt_range>0</enable_ckpt_range>
        <update_duplicate>0</update_duplicate>
    </exec>
</dmhs>
[oracle@oradb2 ~]$