一．初始化一个数据库，放在/home/dmdba/dmdbms目录下，数据页page_size大小为16K
[dmdba@c7-01 ~]$ cd dmdbms/
bin/ desktop/ drivers/ jar/ log/ script/ uninstall/
bin2/ doc/ include/ jdk/ samples/ tool/
[dmdba@c7-01 ~]$ cd dmdbms/bin
[dmdba@c7-01 bin]$ ./dminit path=/home/dmdba/dmdbms page_size=16
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2025-07-03
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL

log file path: /home/dmdba/dmdbms/DAMENG/DAMENG01.log

log file path: /home/dmdba/dmdbms/DAMENG/DAMENG02.log

write to dir [/home/dmdba/dmdbms/DAMENG].
create dm database success. 2024-10-08 18:45:44
[dmdba@c7-01 bin]$

二．注册服务
1.查看数据库各种服务
[dmdba@c7-01 bin]$ ls Dm*Service
DmAPService DmAuditMonitorService DmInstanceMonitorService DmJobMonitorService
[dmdba@c7-01 bin]$ cd service_template/
[dmdba@c7-01 service_template]$ ls
DmAPService DmASMSvrmService DmASMSvrService DmCSSMonitorService DmCSSService DmGroupMonitorService DmMonitorService DmService DmWatcherService
[dmdba@c7-01 service_template]$ cd …
[dmdba@c7-01 bin]$ ./DmAPService start
DmAPService (pid 2608) is running.
[root@c7-01 ~]# ps -ef |grep dm
dmdba 2608 1 0 18:28 ? 00:00:01 /home/dmdba/dmdbms/bin/dmap
2.使用脚本注册服务：
[root@c7-01 bin]# find / -name dm_service_installer.sh
/home/dmdba/dmdbms/script/root/dm_service_installer.sh
[root@c7-01 bin]# cd /home/dmdba/dmdbms/script/root/
[root@c7-01 root]# ls
dm_service_installer.sh dm_service_uninstaller.sh root_installer.sh
[root@c7-01 root]# ./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdbms/DAMENG/dm.ini -p DMSERVER
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDMSERVER.service to /usr/lib/systemd/system/DmServiceDMSERVER.service.
创建服务(DmServiceDMSERVER)完成
或者 如果已存在修改完成的服务脚本模板即 DmServiceDMSERVER，可通过此服务脚本文件注册服务
[root@c7-01 root]# ./dm_service_installer.sh -s /home/dmdba/dmdbms/bin/DmServiceDMSERVER

3.服务的启动和关闭：

[root@c7-01 bin]# systemctl list-unit-files|grep DmServiceDMSERVER
DmServiceDMSERVER.service enabled

[root@c7-01 root]# systemctl stop DmServiceDMSERVER.service
[root@c7-01 root]# systemctl start DmServiceDMSERVER.service
[root@c7-01 root]# ps -ef |grep dm
dmdba 2608 1 0 18:28 ? 00:00:01 /home/dmdba/dmdbms/bin/dmap
dmdba 18501 1 88 23:35 ? 00:00:21 /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/DAMENG/dm.ini -noconsole
三．数据库的连接
1.windows使用

连接
SQL> LOGIN
服务名:10.12.21.104
用户名:SYSDBA
密码:
SSL路径:
SSL密码:
UKEY名称:
UKEY PIN码:
MPP类型:
是否读写分离(y/n):
协议类型:

服务器[10.12.21.104:5236]:处于普通打开状态
登录使用时间 : 947.833(ms)
2.linux使用DIsql工具
[dmdba@c7-01 bin]$ ./disql sysdba
密码:

服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 6.026(ms)
disql V8
SQL>

https://eco.dameng.com