安装前准备
官方文档: https://eco.dameng.com/document/dm/zh-cn/start/dm-instance-linux.html
1 2 3
| groupadd dinstall -g 2001 useradd -G dinstall -m -d /home/dmdba -s /bin/bash -u 2001 dmdba passwd dmdba
|
root用户编辑
1
| vi /etc/security/limits.conf
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14
| dmdba soft nice 0 dmdba hard nice 0 dmdba soft as unlimited dmdba hard as unlimited dmdba soft fsize unlimited dmdba hard fsize unlimited dmdba soft nproc 65536 dmdba hard nproc 65536 dmdba soft nofile 65536 dmdba hard nofile 65536 dmdba soft core unlimited dmdba hard core unlimited dmdba soft data unlimited dmdba hard data unlimited
|
重启服务器
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| mkdir -p /dmdata/data
mkdir -p /dmdata/arch
mkdir -p /dmdata/dmbak mkdir -p /dmdata/data/DMTEST
chown -R dmdba:dinstall /dmdata/data chown -R dmdba:dinstall /dmdata/arch chown -R dmdba:dinstall /dmdata/dmbak
chmod -R 755 /dmdata/data chmod -R 755 /dmdata/arch chmod -R 755 /dmdata/dmbak
|
数据库的安装
1 2
| wget https://download.dameng.com/eco/adapter/DM8/202505/dm8_20250506_x86_rh7_64.zip unzip dm8_20250506_x86_rh7_64.zip
|
1 2 3 4 5 6
| mount -o loop dm8_20250506_x86_rh7_64.iso /mnt
useradd dmdba su - dmdba cd /mnt ./DMInstall.bin -i
|

显示安装完成

配置环境变量
1 2
| export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
|
1 2 3 4 5
| cd /home/dmdba/ vim .bash_profile
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
|

配置实例
1 2 3
| su - dmdba cd /home/dmdba/dmdbms/bin ./dminit path=/dmdata/data PAGE_SIZE=32 EXTENT_SIZE=32 CASE_SENSITIVE=y CHARSET=1 DB_NAME=DMTEST INSTANCE_NAME=DBSERVER PORT_NUM=5237 SYSDBA_PWD=xiamuLala123 SYSAUDITOR_PWD=xiamuLala123
|
启动停止服务
其实我找不到DmServiceDMTEST这个可执行文件在哪里, 直接忽略这种方式启动吧, 采用dmserver的方式前台启动
1 2 3 4 5 6 7 8 9
| cd /home/dmdba/dmdbms/bin
./DmServiceDMTEST start
./DmServiceDMTEST stop
./DmServiceDMTEST restart
./DmServiceDMTEST status
|
dmserver前台启动
1
| /home/dmdba/dmdbms/bin/dmserver /dmdata/data/DMTEST/dm.ini
|
因为是前台启动, 可以写个nohup挂起脚本
1 2 3
| #!/bin/bash
nohup /home/dmdba/dmdbms/bin/dmserver /dmdata/data/DMTEST/dm.ini > /home/dmdba/dmdbms/log/dmserver_output.log 2>&1 &
|
要关闭的话
idea连接达梦数据库
驱动下载: https://eco.dameng.com/download/
或者去 /home/dmdba/dmdbms/drivers/jdbc 目录下拷贝出来对应jar包
1 2 3 4 5 6 7
| /*************************************** * 达梦8 JDBC驱动版本说明 /*************************************** 1. DmJdbcDriver6 实现JDBC 4.0标准接口,已在JDK6上验证相关功能 2. DmJdbcDriver7 实现JDBC 4.1标准接口,已在JDK7上验证相关功能 3. DmJdbcDriver8 实现JDBC 4.2标准接口,已在JDK8,JDK11,JDK17上验证相关功能 4. DmJdbcDriver11 部分实现JDBC 4.3标准接口,已在JDK11,JDK17,JDK21上验证相关功能
|

添加驱动

1
| default jdbc:dm://127.0.0.1:5237/SYSDBA?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
|
添加data source
url
1
| jdbc:dm://192.168.31.48:5237/SYSDBA?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
|

参考: https://blog.csdn.net/oumuv/article/details/99960753
建表, 建库语句
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| CREATE SCHEMA "AST-SQL";
SET SCHEMA "AST-SQL";
CREATE TABLE "USER" ( "ID" BIGINT IDENTITY(1,1) PRIMARY KEY, "NAME" VARCHAR2(255) NOT NULL, "AGE" INTEGER );
|
todo:也许后面计划采用ast来替换成sql函数, 实现较为便捷的数据源迁移