PS. This test is only for the needs of the project, but a series of errors occurred when deploying and starting the program, which were recorded for future reference
Install Damon database
1. Introduction to DM8 Database
Dameng database management system is a high-performance database management system with completely independent intellectual property rights launched by Wuhan Dameng Company, referred to as DM. The latest version of Dameng database management system is version 8.0, referred to as DM8.
DM8 is a new generation of self-developed database launched by Dameng Company on the basis of summarizing the R&D and application experience of DM series products, adhering to the concept of openness, innovation, simplicity and practicality. DM8 absorbs the advantages of current advanced new technology ideas and mainstream database products, integrates the advantages of distributed, elastic computing and cloud computing, and makes large-scale improvements in flexibility, ease of use, reliability, and high security. The diversified architecture fully meets the needs of different scenarios, supports ultra-large-scale concurrent transaction processing and transaction-analysis hybrid business processing, dynamically allocates computing resources, and achieves more refined resource utilization and lower-cost investment. A database that meets the various needs of users, allowing users to focus more on business development.
2 Preparation of operating system environment
The system version used this time is CentOS Linux release 7.5.1804 (Core)
3. Upload the required documents
4. Create installation user dmdba and group dinstall, and set user password
[root@localhost ~]# groupadd dinstall [root@localhost ~]# useradd -s /bin/bash -m -d /home/dmdba -g dinstall dmdba [root@blocalhost ~]# passwd dmdba //You need to set a password here, which can be set to Admin12345
Enter twice successfully
5. Turn off SELinux
The red part is changed to disabled
6. Configure system resource limits for dmdba
Put the following in it and save it
dmdba soft nofile 65536 dmdba hard nofile 65536 dmdba soft nproc 4096 dmdba hard nproc 63653 dmdba soft core unlimited dmdba hard core unlimited
Press esc, then :wq! to save and exit
Log in to the system with the dmdba user and check whether the ulimit parameter takes effect: ulimit -a (Note: switch to the dmdba user for viewing)
7. Install DM8
Switch back to the root account, and the password for switching accounts is su
mkdir -p /opt/db/dm chown -R dmdba:dinstall /opt/db/dm chmod -R 775 /opt/db/dm ll /opt/db
8. Unzip the file
unzip dm8_20220701_x86_rh6_64_ent.zip //If the error is reported here and no unzip is found, you need to use yum install unzip. If it is an offline environment, go to a binary package file for installation.
Mount the iso file, so that the iso image file can be accessed like a directory
mkdir -p /mnt/cdrom
mount /home/dm8/dm8_20220701_x86_rh6_64_ent/dm8_20220701_x86_rh6_64_ent_18.104.22.168.iso /mnt/cdrom
Copy the installer DMInstall.bin to the installation directory, and modify the user and group
cp /mnt/cdrom/DMInstall.bin /opt/db/dm/
Next, execute the installer to install the database. There are two installation methods, one is graphical interface installation, and the other is command line installation.
Because this demo environment does not install a graphical interface when installing Linux, the command line is used to install it.
The graphical installation method is to execute the command: ./DMInstall.bin
The command line installation method is to execute the command: ./DMInstall.bin -i
To install DM, you must first switch to the dmdba user.
su - dmdba
Start the installation, choose Chinese as the language, and do not enter the Key file first (there is no key file, it will expire after one year by default)
To set the time zone, select: : GTM+08=China Standard Time, which is also the default option.
9. Start the installation
The following address is /opt/db/dm/dmdbms
After the installation is complete, you are prompted to execute the script with the root user
switch root user
10. Create a database instance
./dminit PATH=/opt/db/dm/dmdbms/data DB_NAME=DMDB INSTANCE_NAME=DMDW PORT_NUM=5236
11 Script to register instance service
./dm_service_installer.sh -t dmserver -dm_ini /opt/db/dm/dmdbms/data/DMDB/dm.ini -p DMDW
12. Start the service
systemctl start DmServiceDMDW.service //It takes a while here
Check whether the service process has been started (the green below means the startup is successful)
systemctl status DmServiceDMDW.service
12. Create a soft link
Dameng database provides a command line client tool disql (similar to oracle's sqlplus) for connecting to the database.
The disql tool is in the bin directory of the installation directory, you can add the bin directory to the environment variable PATH, and view the configuration file under the dmdba user
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool plug this in
This way we can use the command to log in to the database anywhere
Switch root user to use soft connection
Insert the following data into the specified location
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/opt/db/dm/dmdbms/bin" export DM_HOME="/opt/db/dm/dmdbms" export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
So far the Dameng database installation is complete