Centos7 installation of Dameng database tutorial

1 Ready to work

After installing the Linux operating system, Linux 7 is selected here:

[ root@slave1 software]# cat /etc/redhat-release
CentOS Linux release 7.6.1810(Core)

Turn off the firewall and Selinux:

[ root@slave1 software]# systemctl stop firewalld
[ root@slave1 software]# systemctl disable firewalld
[ root@slave1 software]# vi /etc/selinux/config
[ root@slave1 software]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted

Create DM user:

[ root@slave1 software]# groupadd dinstall
[ root@slave1 software]# useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
[ root@slave1 software]# passwd dmdba
Changing password for user dmdba.
New password: 
BAD PASSWORD: The password is shorter than 8 characters
Retype newpassword: 
passwd: all authentication tokens updated successfully.[root@slave1 software]# 

Create a directory: The space for storing dm database files needs to be planned and mounted in advance. I put it here in the /dm directory:

[ root@slave1 software]# mkdir -p /dm/dmdbms
[ root@slave1 software]# mkdir -p /dm/dmarch
[ root@slave1 software]# mkdir -p /dm/dmbak
[ root@slave1 software]# chown -R dmdba:dinstall /dm/[root@slave1 software]# chmod -R 775/dm/

To configure system limits, add the following to the /etc/security/limits.conf file:

[ root@slave1 software]# vim /etc/security/limits.conf
dmdba soft nofile 65536
dmdba hard nofile 65536

Configure environment variables: add the following content in ~/.bash_profile of dmdba user:

export DM_HOME="/dm/dmdbms"export LD_LIBRARY_PATH="/dm/dmdbms/bin:$LD_LIBRARY_PATH"export PATH="/dm/dmdbms/bin:$PATH"

Note that the DM_HOME and LD_LIBRARY_PATH variables will be automatically added when the DM software is installed, and you only need to add PATH here.

2 Install DM database

Copy the installation file: Upload the ISO of the DM to the Linux system and mount it:

[ root@slave1 software]#mount dm7 development version (rh7-64）20190917.iso /mnt/
mount:/dev/loop0 is write-protected, mounting read-only
[ root@slave1 software]# cd /mnt/[root@slave1 mnt]# ls
DMInstall.bin DM_Install_en.pdf DM_Install_zh.pdf release_en.txt release_zh.txt

Copy the installation file to the /dm directory and modify the installation file permissions:

[ root@slave1 mnt]# pwd
/mnt
[ root@slave1 mnt]# cp ./DMInstall.bin /dm/[root@slave1 mnt]# cd /dm
[ root@slave1 dm]# ll
total 573076
drwxrwxr-x 2 dmdba dinstall 6 Dec 923:08 dmarch
drwxrwxr-x 2 dmdba dinstall 6 Dec 923:08 dmbak
drwxrwxr-x 2 dmdba dinstall 6 Dec 923:08 dmdbms
- r-xr-xr-x 1 root root 586828259 Dec 923:14 DMInstall.bin
[ root@slave1 dm]# chown dmdba:dinstall DMInstall.bin
[ root@slave1 dm]# ll
total 573076
drwxrwxr-x 2 dmdba dinstall 6 Dec 923:08 dmarch
drwxrwxr-x 2 dmdba dinstall 6 Dec 923:08 dmbak
drwxrwxr-x 2 dmdba dinstall 6 Dec 923:08 dmdbms
- r-xr-xr-x 1 dmdba dinstall 586828259 Dec 923:14 DMInstall.bin

Use the dmdba user to execute the ./DMInstall.bin -i program to start the installation:

[ root@slave1 dm]$ pwd
/dm
[ root@slave1 dm]$ ./DMInstall.bin -i
Please select the installer's language(E/e:English C/c:Chinese)[E/e]:c

Unzip the installation program...

core file size(blocks,-c)0
data seg size(kbytes,-d) unlimited
scheduling priority(-e)0
file size(blocks,-f) unlimited
pending signals(-i)3756
max locked memory(kbytes,-l)64
max memory size(kbytes,-m) unlimited
open files(-n)1024
pipe size(512 bytes,-p)8
POSIX message queues(bytes,-q)819200
real-time priority(-r)0
stack size(kbytes,-s)8192
cpu time(seconds,-t) unlimited
max user processes(-u)3756
virtual memory(kbytes,-v) unlimited
file locks(-x) unlimited

The number of open files is too small. It is recommended to set at least 65536 or more.

Welcome to use Dameng database installer

Enter the key file path? (Y/y: Yes N/n: No) [Y/y]: n

Do you want to set the time zone? (Y/y:YesN/n:No) [Y/y]:y

Set time zone:

[ 1]: GTM-12=West of the Sunshine Line
[ 2]: GTM-11=Samoa Islands
[ 3]: GTM-10=Hawaii
[ 4]: GTM-09=Alaska
[ 5]: GTM-08=Pacific Time (United States and Canada)
[ 6]: GTM-07=Arizona
[ 7]: GTM-06=Central Time (United States and Canada)
[ 8]: GTM-05=Eastern Time (United States and Canada)
[ 9]: GTM-04=Atlantic Time (United States and Canada)
[10]: GTM-03=Brasilia
[11]: GTM-02= Mid-Atlantic
[12]: GTM-01=Azores
[13]: GTM=Greenwich Mean Time
[14]: GTM+01= Sarajevo
[15]: GTM+02=Cairo
[16]: GTM+03=Moscow
[17]: GTM+04=Abu Dhabi
[18]: GTM+05=Islamabad
[19]: GTM+06=Dhaka
[20]: GTM+07=Bangkok, Hanoi
[21]: GTM+08=China Standard Time
[22]: GTM+09=Seoul
[23]: GTM+10=Guam
[24]: GTM+11=Solomon Islands
[25]: GTM+12=Fiji
[26]: GTM+13=Nuku'alfa
[27]: GTM+14=Kiribati

Please choose to set the time zone [21]:21

Installation type:

1 Typical installation
2 server
3 Client
4 customize

Please select the serial number of the installation type [1 typical installation]:1

Required space: 963M

Please select the installation directory[/opt/dmdbms]:/dm/dmdbms

Available space: 8G

Confirm the installation path (/dm/dmdbms)? (Y/y: Yes N/n: No) [Y/y]: y

Summary before installation

Installation location: /dm/dmdbms
Required space: 963M
Available space: 8G
Version Information:
Effective date:
Installation type: typical installation
Do you want to confirm the installation? (Y/y: Yes N/n: No): y
2019-12-09 23:17:21
[ INFO] Install Dameng database...
2019-12-09 23:17:22
[ INFO] Install base module...
2019-12-09 23:17:32
[ INFO] Install server module...
2019-12-09 23:17:33
[ INFO] Install the client module...
2019-12-09 23:17:44
[ INFO] Install the driver module...
2019-12-09 23:17:55
[ INFO] Installation manual module...
2019-12-09 23:17:55
[ INFO] Install service module...
2019-12-09 23:17:59
[ INFO] Move ant log files.
2019-12-09 23:17:59
[ INFO] Changing the permissions of the installation directory is complete.
2019-12-09 23:17:59
[ INFO] Starting DmAPService service...
2019-12-09 23:18:01
[ INFO] DmAPService started successfully.
2019-12-09 23:18:01
[ INFO] The installation of Dameng database is complete.

End of installation

3 Create a database instance

[ root@slave1 bin]$ pwd
/dm/dmdbms/bin
[ root@slave1 bin]$ ./dminit PATH=/dm/dmdbms/data DB_NAME=dmdba INSTANCE_NAME=DMDBA CTL_PATH=/dm/dmdbms/data/dmdba/dm.ctl CASE_SENSITIVE=N CHARSET=1
initdb V7.6.0.197-Build(2019.09.12-112648)ENT 
db version:0x7000a
file dm.key not found, use default license!
License will expire on 2020-09-12
 
 log file path:/dm/dmdbms/data/dmdba/dmdba01.log
 
 
 log file path:/dm/dmdbms/data/dmdba/dmdba02.log
 
write to dir [/dm/dmdbms/data/dmdba].
create dm database success.2019-12-0923:25:17

4 Register database service

The registered shell script dm_service_installer.sh is in the DM_HOME/script/root directory. The root user must be used to execute the registration.

[ root@slave1 bin]# cd /dm/dmdbms/script/root
[ root@slave1 root]# ./dm_service_installer.sh -t dmserver -i /dm/dmdbms/data/dmdba/dm.ini -p dmdba
Created symlink from/etc/systemd/system/multi-user.target.wants/DmServicedmdba.service to /usr/lib/systemd/system/DmServicedmdba.service.

Service creation (DmServicedmdba) completed

5 Start the database

[ root@slave1 root]# systemctl enable DmServicedmdba.service
[ root@slave1 root]# systemctl start DmServicedmdba

6 Client connection

The following screen appears, indicating that the installation is successful and it can be used normally.