【Database-01】达梦数据库Docker版下载安装

1、前往达梦数据库官网下载

https://www.dameng.com/

1.1、选择数据库 - 数据库产品系

1.2、选择 达梦数据库管理系统（DM8）

1.3、点击试用下载

1.4、注册达梦账户

1.5、选择DM8 Docker镜像

https://www.dameng.com/list_103.html

1.6、或者使用以下网址也行：

https://eco.dameng.com/download/

2、达梦数据库Docker版安装

2.1、导入安装包

拷贝安装包到/opt目录下，执行以下命令导入安装包：

docker load -i dm8_20220822_rev166351_x86_rh6_64_ctm.tar 

[root@localhost /]# docker load -i dm8_20220822_rev166351_x86_rh6_64_ctm.tar 
644879075e24: Loading layer [==================================================>]  117.9MB/117.9MB
d7ff1dc646ba: Loading layer [==================================================>]  15.87kB/15.87kB
686245e78935: Loading layer [==================================================>]  14.85kB/14.85kB
d73dd9e65295: Loading layer [==================================================>]  5.632kB/5.632kB
2de391e51d73: Loading layer [==================================================>]  3.072kB/3.072kB
5d3893664e8e: Loading layer [==================================================>]  42.94MB/42.94MB
86739628cd5d: Loading layer [==================================================>]  275.5MB/275.5MB
a8cca048a547: Loading layer [==================================================>]  4.608kB/4.608kB
8af79446e96a: Loading layer [==================================================>]   2.56kB/2.56kB
a28e591b0aad: Loading layer [==================================================>]  4.608kB/4.608kB
Loaded image: dm8_single:v8.1.2.128_ent_x86_64_ctm_pack4

2.2、导入完成后，可以使用 docker images 查看导入的镜像。结果显示如下：

[root@localhost /]# docker images
REPOSITORY                 TAG                               IMAGE ID       CREATED         SIZE
dm8_single                 v8.1.2.128_ent_x86_64_ctm_pack4   ccb727ce9dce   6 months ago    432MB

2.3、启动容器

镜像导入后，使用 docker run 启动容器，启动命令如下：

docker run -d -p 5236:5236 --restart=always --name dm8_01 --privileged=true -e PAGE_SIZE=16 -e LD_LIBRARY_PATH=/opt/dmdbms/bin -e INSTANCE_NAME=dm8_01 -v /data/dm8_01:/opt/dmdbms/data dm8_single:v8.1.2.128_ent_x86_64_ctm_pack4

2.4、查看启动情况

启动完成后，可通过日志检查启动情况，命令如下：

docker logs -f  dm8_01

[root@localhost opt]# docker logs -f  dm8_01
file dm.key not found, use default license!
License will expire on 2023-08-04
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLLlog file path: /opt/dmdbms/data/DAMENG/DAMENG01.loglog file path: /opt/dmdbms/data/DAMENG/DAMENG02.logwrite to dir [/opt/dmdbms/data/DAMENG].
create dm database success. 2023-02-23 14:27:30
initdb V8
db version: 0x7000c
Init DM success!
Start DmAPService...
Starting DmAPService:                                      [ OK ]
/opt/dmdbms/conf/dm.ini does not exist, use default dm.ini
Start DMSERVER success!
Dmserver is running.
DM Database is not OK, please wait...
DM Database is OK
Finished soft link DM current dm_DMSERVER_202302.log to dm_DMSERVER.log* Starting periodic command scheduler cron...done.
2023-02-23 14:27:52.532 [INFO] database P0000000048 T0000000000000000093  pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
2023-02-23 14:27:52.532 [INFO] database P0000000048 T0000000000000000093  pseg_crash_trx_rollback end
2023-02-23 14:27:52.532 [INFO] database P0000000048 T0000000000000000093  hpc_clear_active_trx adjust n_crash_active_trx from 0 to 0.
2023-02-23 14:27:52.532 [INFO] database P0000000048 T0000000000000000048  backup control file /opt/dmdbms/data/DAMENG/dm.ctl to file /opt/dmdbms/data/DAMENG/dm_20230223142752_532712.ctl
2023-02-23 14:27:52.531 [INFO] database P0000000048 T0000000000000000132  nsvr_lsnr_thread successfully created.
2023-02-23 14:27:52.536 [INFO] database P0000000048 T0000000000000000048  backup control file /opt/dmdbms/data/DAMENG/dm.ctl to file /opt/dmdbms/data/DAMENG/ctl_bak/dm_20230223142752_535402.ctl succeed
2023-02-23 14:27:52.536 [INFO] database P0000000048 T0000000000000000048  local instance name is DMSERVER, mode is NORMAL, status is OPEN.
2023-02-23 14:27:52.536 [INFO] database P0000000048 T0000000000000000048  SYSTEM IS READY.
2023-02-23 14:27:52.536 [INFO] database P0000000048 T0000000000000000048  set g_dw_stat from UNDEFINED to NONE success, g_dw_recover_stop is 0
2023-02-23 14:27:53.533 [INFO] database P0000000048 T0000000000000000098  trx4_min_tid_collect set min_active_id_opt, min_active_id: 3643, first_tid: 3006
2023-02-23 14:30:46.708 [INFO] database P0000000048 T0000000000000000131  checkpoint requested, rlog free space[527582720], used space[9280000]
2023-02-23 14:30:46.708 [INFO] database P0000000048 T0000000000000000131  checkpoint generate by ckpt_interval
2023-02-23 14:30:46.708 [INFO] database P0000000048 T0000000000000000087  checkpoint begin, used_space[9280000], free_space[527582720]...
2023-02-23 14:30:46.710 [INFO] database P0000000048 T0000000000000000087  ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2023-02-23 14:30:46.710 [INFO] database P0000000048 T0000000000000000087  ckpt2_log_adjust: ckpt_lsn(37717), ckpt_fil(0), ckpt_off(9254912), cur_lsn(37830), l_next_seq(4646), g_next_seq(4646), cur_free(9284608), total_space(536862720), used_space(29696), free_space(536833024), n_ep(1)
2023-02-23 14:30:46.710 [INFO] database P0000000048 T0000000000000000087  checkpoint end, 0 pages flushed, used_space[29696], free_space[536833024].

3、操作数据库

停止数据库命令如下：

docker stop  dm8_01

启动数据库命令如下：

docker start  dm8_01

重启命令如下：

docker restart  dm8_01

4、默认用户名、密码

新版本 Docker 镜像中数据库默认
用户名:SYSDBA
密码:SYSDBA001

4.1、验证

使用DM Manager管理工具连接数据库