部署
目的端(ORACLE环境)
- 编辑配置文件把libclnsh.so所在目录添加到共享库路径变量中
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
2.安装UNIXODBC
yum -y install unixODBC unixODBC-devel
3.检查是否安装成功
rpm -qa | grep ODBC
4.查看配置文件路径
odbcinst -j
5.配置odbcinst.ini(上面截图有路径)
6.配置odbc.ini
7.测试配置是否成功
isql -v ORACLE
8.进入ORACLE,创建用户、赋权
create user DMHS IDENTIFIED BY DMHS;
GRANT CONNECT, RESOURCE to DMHS;
8.配置数据库网络服务名
vi $ORACLE_HOME/network/admin/tnsnames.ora
LISTENER_HELOWIN =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
HELOWIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = helowin)
)
)
10.ORACLE开启归档,要进入ORACLE内操作,
以下操作依次进行:
shu immediate;
startup mount;
alter database archivelog;
alter system set db_recovery_file_dest='';
这里的路径每个人可能不同,没有就自己创建,可以自己填自己的
alter system set log_archive_dest='/home/oracle/app/oracle/arch';
alter database open;
archive log list;
11.查看字符集
// An highlighted block
select userenv('language') from dual;
12.安装DMHS(略)
13.编辑配置文件dmhs.hs
特别注意<mgr_port>、<data_port>、send里面的要根据自己的情况作出修改
<?xml version="1.0" encoding="GB2312"?>
<dmhs>
<base>
<lang>en</lang>
<mgr_port>5349</mgr_port>
<chk_interval>3</chk_interval>
<ckpt_interval>60</ckpt_interval>
<siteid>1</siteid>
<version>2.0</version>
</base>
<cpt>
<db_type>oracle11g</db_type>
<db_server>helowin</db_server>
<db_user>DMHS</db_user>
<db_pwd>DMHS</db_pwd>
<db_port>1521</db_port>
<idle_time>300</idle_time>
<ddl_mask>TABLE:VIEW:FUN:PRO:OP</ddl_mask>
<parse_thr>1</parse_thr>
<arch>
<clear_interval>600</clear_interval>
<clear_flag>1</clear_flag>
<bak_dir></bak_dir>
</arch>
<send>
<ip>192.168.78.134</ip>
<mgr_port>5349</mgr_port>
<data_port>5350</data_port>
<trigger>0</trigger>
<constraint>0</constraint>
<identity>0</identity>
<net_turns>0</net_turns>
<filter>
<enable>
<item>DMHS.*</item>
</enable>
<disable>
<item></item>
</disable>
</filter>
</send>
</cpt>
</dmhs>
源端
源端机地址IP:192.168.78.134
1.安装DMHS(略)
2.在达梦数据库中创建DMHS用户
2.编辑dmhs.hs
<?xml version="1.0" encoding="GB2312"?>
<dmhs>
<base>
<lang>en</lang>
<mgr_port>5349</mgr_port>
<chk_interval>3</chk_interval>
<ckpt_interval>60</ckpt_interval>
<siteid>5</siteid>
<version>2.0</version>
</base>
<exec>
<recv>
<data_port>5350</data_port>
</recv>
<db_type>dm8</db_type>
<db_server>192.168.78.134</db_server>
<db_user>DMHS</db_user>
<db_pwd>DMHS123456</db_pwd>
<db_port>5236</db_port>
<exec_mode>1</exec_mode>
<exec_thr>16</exec_thr>
<exec_sql>1024</exec_sql>
<exec_trx>5000</exec_trx>
<exec_rows>1000</exec_rows>
<exec_policy>2</exec_policy>
<ddl_continue>1</ddl_continue>
<msg_col_size>8000</msg_col_size>
<affect_row>0</affect_row>
<level>0</level>
</exec>
</dmhs>
4.开启最小附加日志
alter database add supplemental log data;
alter database add supplemental log data (all) columns;
select supplemental_log_data_min,supplemental_log_data_all from v$database
操作
源端
新建窗口:
有的可能start exec时会报错,可参考
https://blog.csdn.net/zjh982534314/article/details/119572650?spm=1001.2014.3001.5501
目的端
新建窗口:
新建窗口:
进入ORACLE
源端
再新建窗口:
进入dm数据库
成功!
更多资讯请上达梦技术社区了解: https://eco.dameng.com