openEuler 环境下安装 DM8 数据库 (单机)

1. 操作系统基本环境

[root@euler etc]# cat os-release

NAME=“openEuler”

VERSION=“21.09”

ID=“openEuler”

VERSION_ID=“21.09”

PRETTY_NAME=“openEuler 21.09”

ANSI_COLOR=“0;31”

[root@euler etc]# uname -a

Linux euler 5.10.0-5.10.0.24.oe1.x86_64 #1 SMP Wed Sep 29 19:53:50 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

1. 安装介质校验

[root@euler ~]# sha256sum dm8_20210712_x86_rh6_64_ent_8.1.2.38_pack1.iso

6508472e1d9f6534c1a744f1adce5114405255cef70845d05a1cc473ce1d1c7d dm8_20210712_x86_rh6_64_ent_8.1.2.38_pack1.iso

[root@euler ~]# cat dm8_20210712_x86_rh6_64_ent_8.1.2.38_pack1.iso_SHA256.txt | grep ^65

6508472e1d9f6534c1a744f1adce5114405255cef70845d05a1cc473ce1d1c7d

1. 安装介质挂载

[root@euler ~]# mount -o loop dm8_20210712_x86_rh6_64_ent_8.1.2.38_pack1.iso /media/

[root@euler ~]# cd /media/

[root@euler media]# ls

‘DM8 Install.pdf’ DMInstall.bin

1. 查看操作系统信息

3.1 获取系统位数

[root@euler ~]# getconf LONG_BIT

64

3.2 查询操作系统 release 信息

[root@euler ~]# lsb_release -a

LSB Version: n/a

Distributor ID: openEuler

Description: openEuler release 21.09

Release: 21.09

Codename: n/a

3.3 查看操作系统名称

[root@euler ~]# uname -a

Linux euler 5.10.0-5.10.0.24.oe1.x86_64 #1 SMP Wed Sep 29 19:53:50 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

1. 创建安装用户

4.1 创建安装用户组

[root@euler ~]# groupadd -g 12345 dinstall

4.2 创建安装用户

[root@euler ~]# useradd -u 12345 -g dinstall -m -d /home/dmdba -s /bin/bash dmdba

4.3 修改用户默认口令

[root@euler ~]# passwd dmdba

Changing password for user dmdba.

New password:

Retype new password:

passwd: all authentication tokens updated successfully.

1. 修改操作系统限制

5.1 修改dm8安装用户限制

[root@euler ~]# cd /etc/security/limits.d/

[root@euler limits.d]# vi dm-limit.conf

[root@euler limits.d]# cat dm-limit.conf

#########################################

#add for dm8 install

dmdba hard nofile 65536

dmdba soft nofile 65536

dmdba hard nproc 65536

dmdba soft nproc 65536

dmdba hard core unlimited

dmdba soft core unlimited

dmdba hard stack 10240

dmdba soft stack 10240

dmdba hard memlock unlimited

dmdba soft memlock unlimited

5.2 重新登录用户查看用户限制

[dmdba@euler ~]$ ulimit -a

real-time non-blocking time (microseconds, -R) unlimited

core file size (blocks, -c) unlimited

data seg size (kbytes, -d) unlimited

scheduling priority (-e) 0

file size (blocks, -f) unlimited

pending signals (-i) 126252

max locked memory (kbytes, -l) unlimited

max memory size (kbytes, -m) unlimited

open files (-n) 65536

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

real-time priority (-r) 0

stack size (kbytes, -s) 10240

cpu time (seconds, -t) unlimited

max user processes (-u) 65536

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

5.3 关闭selinux

[root@euler ~]# cd /etc/selinux/

[root@euler selinux]# vi config

SELINUX=disabled

[root@euler selinux]# setenforce 0

5.4 关闭防火墙

[root@euler selinux]# systemctl disable firewalld

Removed /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

Removed /etc/systemd/system/multi-user.target.wants/firewalld.service.

[root@euler selinux]# systemctl stop firewalld

1. 安装环境检查

6.1 检查操作系统至少 1GB 的可用内存

[dmdba@euler ~]$ free -g

          total        used        free      shared  buff/cache   available

复制

Mem: 30 0 29 0 1 30

Swap: 3 0 3

6.2 检查操作系统至少 1GB 的可用磁盘空间

[dmdba@euler ~]$ df -h

Filesystem Size Used Avail Use% Mounted on

devtmpfs 16G 0 16G 0% /dev

tmpfs 16G 0 16G 0% /dev/shm

tmpfs 6.2G 8.7M 6.2G 1% /run

tmpfs 4.0M 0 4.0M 0% /sys/fs/cgroup

/dev/mapper/openeuler-root 84G 3.9G 76G 5% /

tmpfs 16G 4.0K 16G 1% /tmp

/dev/mapper/openeuler-home 9.8G 37M 9.3G 1% /home

/dev/sda1 976M 84M 825M 10% /boot

tmpfs 3.1G 20K 3.1G 1% /run/user/0

/dev/loop0 727M 727M 0 100% /media

6.3 设置JAVA环境变量

[root@euler ~]# yum install java-1.8.0-openjdk.x86_64

[dmdba@euler ~]$ java -version

openjdk version “1.8.0_302”

OpenJDK Runtime Environment Bisheng (build 1.8.0_302-b07)

OpenJDK 64-Bit Server VM Bisheng (build 25.302-b07, mixed mode)

1. 执行安装程序

7.1 创建软件安装目录

[root@euler /]# mkdir /dm8

[root@euler /]# chown dmdba:dinstall /dm8/

7.2 执行安装程序

[dmdba@euler ~]$ cd /media/

[dmdba@euler media]$ ls

‘DM8 Install.pdf’ DMInstall.bin

[dmdba@euler media]$ export LANG=zh_CN.utf8

[dmdba@euler media]$ sh ./DMInstall.bin

解压安装程序…

7.3 执行root脚本

[root@euler /]# sh /dm8/dmdbms/script/root/root_installer.sh

Move /dm8/dmdbms/bin/dm_svc.conf to /etc

Modify the files’ mode of DM Server

Create the DmAPService service

Created symlink /etc/systemd/system/multi-user.target.wants/DmAPService.service → /usr/lib/systemd/system/DmAPService.service.

Finished to create the service (DmAPService)

Start the DmAPService service

1. 执行建库程序

8.1 执行建库程序

[dmdba@euler ~]$ cd /dm8/dmdbms/tool/

[dmdba@euler tool]$ ./dbca.sh

8.2 执行root脚本

mv /dm8/dmdbms/bin/DmServiceSKY.service /usr/lib/systemd/system/DmServiceSKY.service

systemctl enable DmServiceSKY.service

systemctl start DmServiceSKY.service

1. 登录数据库

9.1 设置环境变量

[dmdba@euler ~]$ cat .bash_profile

Source /root/.bashrc if user has one

[ -f ~/.bashrc ] && . ~/.bashrc

export LANG=zh_CN.UTF-8

export LD_LIBRARY_PATH=“$LD_LIBRARY_PATH:/dm8/dmdbms/bin”

export DM_HOME=“/dm8/dmdbms”

export PATH=$DM_HOME/bin:$PATH

9.2 执行SQL语句

[dmdba@euler ~]$ . .bash_profile

[dmdba@euler ~]$

[dmdba@euler ~]$ disql SYSDBA

密码:

服务器[LOCALHOST:5236]:处于普通打开状态

登录使用时间 : 1.272(ms)

disql V8

SQL> SELECT * FROM DUAL;

行号 DUMMY

---

1 X

已用时间: 0.742(毫秒). 执行号:55300.

1. 查看数据库进程及日志

10.1 查看数据库进程 (达梦数据库是单进程多线程架构)

[dmdba@euler bin]$ ps -ef | grep dmserver | grep -v grep

dmdba 1205 1 0 08:50 ? 00:00:04 /dm8/dmdbms/bin/dmserver path=/dm8/dmdata/SKYDB/dm.ini -noconsole

[dmdba@euler bin]$ top -H -p 1205

PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND

复制

1205 dmdba 20 0 8543124 650584 24888 S 0.0 2.0 0:00.23 dmserver

1247 dmdba 20 0 8543124 650584 24888 S 0.0 2.0 0:00.00 dm_quit_thd

1259 dmdba 20 0 8543124 650584 24888 S 0.0 2.0 0:00.02 dm_io_thd

1260 dmdba 20 0 8543124 650584 24888 S 0.0 2.0 0:00.01 dm_io_thd

1261 dmdba 20 0 8543124 650584 24888 S 0.0 2.0 0:00.01 dm_io_thd

1262 dmdba 20 0 8543124 650584 24888 S 0.0 2.0 0:00.01 dm_io_thd

1352 dmdba 20 0 8543124 650584 24888 S 0.0 2.0 0:00.03 dm_chkpnt_thd

1353 dmdba 20 0 8543124 650584 24888 S 0.0 2.0 0:00.12 dm_redolog_thd

10.2 查看达梦数据库日志

[dmdba@euler bin]$ lsof -p 1205 | grep log$

dmserver 1205 dmdba 1w REG 253,0 21462 4720484 /dm8/dmdbms/log/DmServiceDMSERVER.log

dmserver 1205 dmdba 2w REG 253,0 21462 4720484 /dm8/dmdbms/log/DmServiceDMSERVER.log

dmserver 1205 dmdba 7u REG 253,0 268435456 4720472 /dm8/dmdata/SKYDB/SKYDB01.log

dmserver 1205 dmdba 8u REG 253,0 268435456 4720473 /dm8/dmdata/SKYDB/SKYDB02.log

dmserver 1205 dmdba 9u REG 253,0 268435456 4720474 /dm8/dmdata/SKYDB/SKYDB03.log

[dmdba@euler bin]$ tail -f /dm8/dmdbms/log/DmServiceDMSERVER.log