最近在安装达梦 dmhs 同步软件,由于第一次安装,步骤不太熟悉,所以安装过程产生了好多问题。经过达梦社区、百度、同事询问,终于安装成功,现将步骤分享给大家,供参考。
1、卸载 (可略过)
rm -rf /etc/init.d/Dmhs*
2、安装数据库环境 (源和目标)
mount -o loop /soft/dm8_20211028_x86_rh6_64_ent_7.6.1.112.iso /mnt
mkdir -p /dm8/dmdata
chown dmdba:dinstall /dm8 -R
su - dmdba
cd /mnt
./DMInstall.bin -i
dminit path=/dm8/dmdata page_size=32 db_name=DMHS instance_name=DMSOU PORT_NUM=5241
/dm8/dmdbms/script/root/dm_service_installer.sh -t dmserver -p HSSOU -dm_ini /dm8/dmdata/DMHS/dm.ini
dminit path=/dm8/dmdata page_size=32 db_name=DMHS instance_name=DMTAR PORT_NUM=5241
/dm8/dmdbms/script/root/dm_service_installer.sh -t dmserver -p HSTAR -dm_ini /dm8/dmdata/DMHS/dm.ini
–源端和目标
开启归档和附加日志 修改dm.ini RLOG_APPEND_SYSTAB_LOGIC 为 1 ARCH_INI 1
select arch_mode from v$database;
su - dmdba
disql SYSDBA/SYSDBA:5241
alter database mount;
alter database add archivelog 'dest=/dm8/dmdata/DMHS/arch, type=local,file_size=128,space_limit=1280';
alter database archivelog;
alter database open;
select * from v$dm_ini where para_name='RLOG_APPEND_LOGIC';
call sp_set_para_value(2,'RLOG_APPEND_LOGIC',1);
重启实例
su - root
systemctl restart DmServiceHSSOU --源库
systemctl restart DmServiceHSTAR --目标库
3、安装dmhs --源和目标
su - dmdba
vi .bash_profile
PATH=$PATH:$HOME/bin:/dm8/dmdbms/bin:/dm8/dmhs/bin
export PATH
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/dm8/dmdbms/bin:/dm8/dmhs/bin"
export DM_HOME="/dm8/dmdbms"
export DMHS_HOME=/dm8/dmhs
cd /soft
sh dmhs_V4.1.2_pack3_dm8_rev100999_rh6_64_veri_20210729.bin
–目标端
图形化下一步,选中key, 无key 安装完后 dmhs_server 服务启不来
–源端:步骤与上述类似,需注意以下:
1、内置数据库指向源端 192.168.1.102
2、此节点安装为简版
–源端与目标端启动服务
–源端 (192.168.1.102)
./DmServiceHSDB start
./DmhsWebService start
./DmhsAgentServiceHsAgent start
–目标端 (192.168.1.101)
./DmhsAgentServiceHsAgent start
注: 也可以图形化 选自动起动。
4、浏览器打开
http://192.168.1.102:8080/manager/
admin/888888
左上角"服务管理"
HsAgent(192.168.1.101)
HsAgent(192.168.1.102)
右击新建HS实例
源为 cpt
目为 exec
5、启动服务
1) 图形化 web
目标端:
先起动 HS-exec 再启动 exec
–源端:
在控制台或命令行:初始化 :COPY 0 “SCH.NAME=‘SYSDBA’” CREATE|INSERT|THREAD|8
再右键启动 cpt
**************首次启动DMHS服务,需要首先进行待同步模式或表的字典装载操作,否则无法启动源端捕获分析服务。
2)命令行
su - dmdba
cd /dm8/dmhs/bin
./dmhs_console
DMHS> start exec
DMHS> exec
dmhs_console
cd /dm8/dmhs/bin
DMHS> COPY 0 "SCH.NAME='SYSDBA'" CREATE|INSERT|THREAD|8
DMHS> start cpt
DMHS> cpt
---------------------------------------问题
1、目的端:start exec
报错:
2022-05-18 10:16:02 MGR[ERROR]: 库文件 libdmhs_exec.so 未找到, 出错: 0
2022-05-18 10:16:02 MGR[ERROR]: 日志执行启动失败
解决:将新的 libdmoci.so 复制到 /dm8/dmhs/INST_HS/exec/
cd /dm8/dmhs/INST_HS/exec/
ldd libdmhs_exec.so
[dmdba@dm1 exec0]$ ldd libcpt_dm8.so
linux-vdso.so.1 => (0x00007fff607ff000)
libc.so.6 => /lib64/libc.so.6 (0x00007fb3eb32c000)
libm.so.6 => /lib64/libm.so.6 (0x00007fb3eb0a7000)
librt.so.1 => /lib64/librt.so.1 (0x00007fb3eae9f000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb3eac82000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fb3eaa7d000)
libdmhs_pub.so => ./libdmhs_pub.so (0x00007fb3ea750000)
libdmhs_net.so => ./libdmhs_net.so (0x00007fb3ea4f4000)
libdmhs_ld_dm8.so => ./libdmhs_ld_dm8.so (0x00007fb3ea295000)
libdmhs_ucvt.so => ./libdmhs_ucvt.so (0x00007fb3e9d3a000)
/lib64/ld-linux-x86-64.so.2 (0x0000003a2d000000)
libdmoci.so => not found
libdmhs_bool_parse.so => ./libdmhs_bool_parse.so (0x00007fb3e9b29000)
libdmoci.so => not found
–修改权限
chown dmdba.dinstall /dm8/dmhs/INST_HS/exec/libdmoci.so
chmod 755 /dm8/dmhs/INST_HS/exec/libdmoci.so
重启dmhs
启动 exec
2、源端 :start cpt
报错:
2022-05-18 10:24:13 MGR[INFO]: 正在加载DM8日志分析模块...
2022-05-18 10:24:13 MGR[ERROR]: 库文件 libcpt_dm8.so 未找到, 出错: 0
2022-05-18 10:24:13 MGR[INFO]: 日志分析模块加载失败!
解决:
cd /dm8/dmhs/INST_HS/ecp0
[dmdba@dm1 ecp0]$ ldd libcpt_dm8.so
linux-vdso.so.1 => (0x00007fff607ff000)
libc.so.6 => /lib64/libc.so.6 (0x00007fb3eb32c000)
libm.so.6 => /lib64/libm.so.6 (0x00007fb3eb0a7000)
librt.so.1 => /lib64/librt.so.1 (0x00007fb3eae9f000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb3eac82000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fb3eaa7d000)
libdmhs_pub.so => ./libdmhs_pub.so (0x00007fb3ea750000)
libdmhs_net.so => ./libdmhs_net.so (0x00007fb3ea4f4000)
libdmhs_ld_dm8.so => ./libdmhs_ld_dm8.so (0x00007fb3ea295000)
libdmhs_ucvt.so => ./libdmhs_ucvt.so (0x00007fb3e9d3a000)
/lib64/ld-linux-x86-64.so.2 (0x0000003a2d000000)
libdmoci.so => not found
libdmhs_bool_parse.so => ./libdmhs_bool_parse.so (0x00007fb3e9b29000)
libdmoci.so => not found
chown dmdba.dinstall /dm8/dmhs/INST_HS/ecp0/libdmoci.so
chmod 755 /dm8/dmhs/INST_HS/ecp0/libdmoci.so
3、源端:start ecp
报错:
2022-05-18 10:32:33 CPT[INFO]: DM8 CPT is free.
2022-05-18 10:32:33 MGR[ERROR]: 无法启动分析模块
2022-05-18 10:32:33 MGR[ERROR]: ID号为4的日志分析模块启动失败!
解决:
首次启动DMHS服务,需要首先进行待同步模式或表的字典装载操作,否则无法启动源端捕获分析服务。
COPY 0 "SCH.NAME='SYSDBA'" CREATE|INSERT|THREAD|8
start cpt
-------测试
源:
disql SYSDBA/SYSDBA
create table DM_SUNN as select * from sysobjects;
select count(*) from DM_SUNN;
insert into DM_SUNN select * from DM_SUNN;
目的:
disql SYSDBA/SYSDBA
select count(*) from DM_SUNN;
到此文章结束,有不足地方,欢迎批正!
更多达梦技术资讯,请访问达梦技术社区:
达梦数据库 - 新一代大型通用关系数据库 | 达梦云适配中心
https://eco.dameng.com/