鲲鹏麒麟上安装达梦数据库

@[TOC]鲲鹏麒麟上安装达梦数据库

下载安装文件

在达梦官网https://www.dameng.com/list_103.html下载最新的达梦8开发版，下载后文件名为：dm8_20231226_HWarm920_kylin10_sp1_64.zip，解压后得到dm8_20231226_HWarm920_kylin10_sp1_64.iso，然后再次解压得到DMInstall.bin，将该文件上传到系统。

创建用户

先创建用户组
groupadd dinstall
然后再创建用户
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
修改用户密码
passwd dmdba
连续输入两次即可
如果需要重新创建用户组和用户，先执行如下命令删除用户组和用户，然后重新创建
userdel -r dmdba
groupdel dinstall

安装

比如已经将DMInstall.bin上传到/home/dmdba/目录下，设置文件权限
chmod 777 DMInstall.bin
使用su dmda切换到dmdba，然后执行
./DMInstall.bin -i
一路默认选择即可
注意：默认安装目录为/opt/dmdbms，但不建议使用 root 系统用户来安装 DM，因此这里安装路径设置为/home/dmdba/dmdbms/

初始化数据库

./dminit PATH=/home/dmdba/dmdbms/dmData LOG_PATH=/home/dmdba/dmdbms/logs/dmData01.log LOG_PATH=/home/dmdba/dmdbms/logs/dmData02.log PAGE_SIZE=16 CHARSET=1 SYSDBA_PWD=test#2024 DB_NAME=DM INSTANCE_NAME=DMSERVER PORT_NUM=5236

启动

创建服务
./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdbms/dmData/DM/dm.ini -p DMSERVER
启动服务
systemctl start DmServiceDMSERVER.service
如果启动服务失败，可以尝试直接前台运行，执行如下命令：
/home/dmdba/dmdbms/bin/dmserver /home/dmdba/dmdbms/dmData/DM/dm.ini

[root@test bin]# ./dmserver /home/dmdba/dmdbms/dmData/DM/dm.ini
file dm.key not found, use default license!
version info: develop
DM Database Server 64 V8 03134284132-20231226-213242-20081 startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2024-12-26
file lsn: 0
ndct db load finished, code:0
ckpt2_exec_immediately begin.
checkpoint begin, used_space[4096], free_space[536858624]...
checkpoint end, 2 pages flushed, used_space[8192], free_space[536854528].
checkpoint begin, used_space[8192], free_space[536854528]...
checkpoint begin, used_space[0], free_space[536862720]...
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct fill fast pool finished
pseg_set_gtv_trxid_low next_trxid in mem:[2002]
pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs!
next_trxid in mem:[4004]
next_trxid = 6006.
pseg recv finished
nsvr_startup end.
uthr_pipe_create, create pipe[read:12, write:13]
uthr_pipe_create, create pipe[read:14, write:15]
uthr_pipe_create, create pipe[read:16, write:17]
uthr_pipe_create, create pipe[read:18, write:19]
uthr_pipe_create, create pipe[read:20, write:21]
uthr_pipe_create, create pipe[read:22, write:23]
uthr_pipe_create, create pipe[read:24, write:25]
uthr_pipe_create, create pipe[read:26, write:27]
uthr_pipe_create, create pipe[read:28, write:29]
uthr_pipe_create, create pipe[read:30, write:31]
uthr_pipe_create, create pipe[read:32, write:33]
uthr_pipe_create, create pipe[read:34, write:35]
uthr_pipe_create, create pipe[read:36, write:37]
uthr_pipe_create, create pipe[read:38, write:39]
uthr_pipe_create, create pipe[read:40, write:41]
uthr_pipe_create, create pipe[read:42, write:43]
aud sys init success.
aud rt sys init success.
trx: 6006 purged 1 pages
trx: 6025 purged 1 pages
trx: 6026 purged 1 pages
trx: 6027 purged 1 pages
trx: 6028 purged 1 pages
trx: 6029 purged 1 pages
trx: 6039 purged 1 pages
trx: 6162 purged 1 pages
trx: 6175 purged 1 pages
trx: 6176 purged 1 pages
trx: 6177 purged 1 pages
trx: 6178 purged 1 pages
trx: 6179 purged 1 pages
trx: 6181 purged 1 pages
trx: 6182 purged 1 pages
trx: 6184 purged 1 pages
trx: 6186 purged 1 pages
trx: 6193 purged 1 pages
trx: 6199 purged 1 pages
trx: 6209 purged 1 pages
trx: 6222 purged 1 pages
trx: 6223 purged 1 pages
trx: 6224 purged 1 pages
trx: 6225 purged 1 pages
trx: 6237 purged 1 pages
trx: 6239 purged 1 pages
trx: 6240 purged 1 pages
trx: 6241 purged 1 pages
trx: 6293 purged 1 pages
trx: 6294 purged 1 pages
trx: 6305 purged 1 pages
trx: 6323 purged 14 pages
trx: 6350 purged 1 pages
trx: 6351 purged 1 pages
trx: 6352 purged 1 pages
trx: 6353 purged 1 pages
trx: 6359 purged 1 pages
trx: 6361 purged 1 pages
trx: 6363 purged 1 pages
trx: 6368 purged 1 pages
trx: 6373 purged 1 pages
trx: 6378 purged 1 pages
trx: 6380 purged 1 pages
trx: 6383 purged 1 pages
trx: 6385 purged 1 pages
trx: 6391 purged 1 pages
trx: 6392 purged 1 pages
trx: 6541 purged 1 pages
trx: 6565 purged 1 pages
trx: 6570 purged 1 pages
trx: 6575 purged 1 pages
trx: 6594 purged 23 pages
trx: 6595 purged 1 pages
trx: 6603 purged 1 pages
trx: 6608 purged 1 pages
trx: 6612 purged 1 pages
trx: 6637 purged 1 pages
trx: 6641 purged 1 pages
trx: 6643 purged 1 pages
trx: 6645 purged 1 pages
trx: 6647 purged 1 pages
trx: 6649 purged 1 pages
trx: 6651 purged 1 pages
trx: 6653 purged 1 pages
trx: 6655 purged 1 pages
trx: 6657 purged 1 pages
trx: 6659 purged 1 pages
trx: 6661 purged 1 pages
trx: 6663 purged 1 pages
trx: 6665 purged 1 pages
trx: 6667 purged 1 pages
trx: 6669 purged 1 pages
trx: 6671 purged 1 pages
trx: 6673 purged 1 pages
trx: 6675 purged 1 pages
trx: 6677 purged 1 pages
trx: 6679 purged 1 pages
trx: 6681 purged 1 pages
trx: 6683 purged 1 pages
trx: 6685 purged 1 pages
trx: 6687 purged 1 pages
trx: 6689 purged 1 pages
trx: 6691 purged 1 pages
trx: 6693 purged 1 pages
trx: 6695 purged 1 pages
trx: 6697 purged 1 pages
trx: 6699 purged 1 pages
trx: 6701 purged 1 pages
trx: 6703 purged 1 pages
trx: 6705 purged 1 pages
trx: 6708 purged 4 pages
trx: 6717 purged 1 pages
trx: 6719 purged 1 pages
systables desc init success.
ndct_db_load_info finished, code:0.
nsvr_process_before_open begin.
nsvr_process_before_open success.
SYSTEM IS READY.

表明达梦服务已经正常启动，此时，可以将启动命令制作成后台服务启动，关闭刚才的服务，重新执行如下命令
/home/dmdba/dmdbms/bin/dmserver /home/dmdba/dmdbms/dmData/DM/dm.ini > /dev/null 2>&1 &

开放端口

开放端口执行如下命令：
firewall-cmd --zone=public --add-port=5236/tcp --permanent
firewall-cmd --reload

测试连接

在本地安装达梦客户端，执行测试连接

卸载

如果需要卸载达梦数据库，执行如下命令
/home/dmdba/dmdbms/uninstall.sh -i