尧图网站建设 
大家好我是早九晚十二目前是做运维相关的工作。写博客是为了积累希望大家一起进步我的主页早九晚十二目前国产化服务器越来越多操作系统的国产化使得大家对中间件都有了需求今天主要是使用银河麒麟搭建达梦数据库。文章目录环境版本获取安装步骤解压安装包对比安装包是否完整创建用户组修改用户密码系统参数优化挂载镜像创建数据目录数据库安装配置实例注册服务数据库启停启动停止重启查看状态查看版本环境[rootKylin10 ~]# uname -aLinux Kylin104.19.90-24.4.v2101.ky10.x86_64#1 SMP Mon May 24 12:14:55 CST 2021 x86_64 x86_64 x86_64 GNU/Linux[rootKylin10 ~]# cat /proc/cpuinfo |grep model namemodel name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz版本获取链接https://eco.dameng.com/download/?_blank根据自己环境选择对应版本下载服务器可直接使用wget https://download.dameng.com/eco/adapter/DM8/202208/dm8_20220720_x86_rh7_64_ent.zip安装步骤解压安装包[rootKylin10 ~]# unzip dm8_20220720_x86_rh7_64_ent.zip对比安装包是否完整[rootKylin10 ~]# sha256sum dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso387fa90ea26f6d096101af4496d70ee9909cd0abf4f41d4bc0dace625ae721e5 dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso[rootKylin10 ~]# cat dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso_SHA256.txtSHA256 µ dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso ¹þϣ: 387fa90ea26f6d096101af4496d70ee9909cd0abf4f41d4bc0dace625ae721e5 CertUtil:-hashfileļ®³ɹ¦Ϊ³ɡ£创建用户组[rootKylin10 ~]# groupadd dinstall[rootKylin10 ~]# useradd -g dinstall -m -d /home/dmadmin -s /bin/bash dmadmin修改用户密码修改密码为DMadm_123![rootKylin10 ~]# passwd dmadmin更改用户 dmadmin 的密码 。 新的 密码 重新输入新的 密码 passwd所有的身份验证令牌已经成功更新系统参数优化cat/etc/security/limits.confEOF dmadmin hard nofile 65536 dmadmin soft nofile 65536 dmadmin hard stack 32768 dmadmin soft stack 16384 EOF执行后关闭窗口重新打开切换到dmadmin查看是否成功[rootKylin10 ~]# su dmadmin[dmadminKylin10 root]$ulimit-acorefilesize(blocks, -c)unlimited data seg size(kbytes, -d)unlimited scheduling priority(-e)0filesize(blocks, -f)unlimited pending signals(-i)58803max locked memory(kbytes, -l)64max memory size(kbytes, -m)unlimitedopenfiles(-n)65536pipe size(512bytes, -p)8POSIX message queues(bytes, -q)819200real-time priority(-r)0stack size(kbytes, -s)16384cputime(seconds, -t)unlimited max user processes(-u)58803virtual memory(kbytes, -v)unlimitedfilelocks(-x)unlimited挂载镜像切换到root用户挂载镜像[rootKylin10 ~]# mkdir /mnt/dm8[rootKylin10 ~]# mount dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso /mnt/dm8/mount: /mnt/dm8: WARNING:sourcewrite-protected, mounted read-only.创建数据目录[rootKylin10 ~]# mkdir /DM8[rootKylin10 ~]# chown -R dmadmin:dinstall /DM8/数据库安装切换至dmadmin用户。执行脚本安装[rootKylin10 ~]# su dmadmin[dmadminKylin10 root]$cd/mnt/dm8/[dmadminKylin10 dm8]$lsDM8 Install.pdfDMInstall.bin选择中文安装不输入key路径设置时区选择典型安装输入刚刚创建的DM8数据库目录不建议使用默认路径根据提示切换到root目录执行脚本[dmadminKylin10 dm8]$exitexit[rootKylin10 ~]# /DM8/script/root/root_installer.sh移动 /DM8/bin/dm_svc.conf 到/etc目录 修改服务器权限 创建DmAPService服务 Created symlink /etc/systemd/system/multi-user.target.wants/DmAPService.service → /usr/lib/systemd/system/DmAPService.service. 创建服务(DmAPService)完成 启动DmAPService服务切换root用户设置对应环境变量[rootKylin10 ~]# cd /home/dmadmin/.mozilla/[rootKylin10 .mozilla]# cd /home/dmadmin/[rootKylin10 dmadmin]# cat .bash_profile -EOFexportPATH$PATH:$DM_HOME/bin:$DM_HOME/tool-EOF切换到dmadmin用户查看结果[rootKylin10 DM8]# su dmadmin[dmadminKylin10 DM8]$cd~[dmadminKylin10 ~]$source.bash_profile[dmadminKylin10 ~]$cat.bash_profile# Source /root/.bashrc if user has one[-f~/.bashrc].~/.bashrcexportLD_LIBRARY_PATH$LD_LIBRARY_PATH:/DM8/binexportDM_HOME/DM8exportPATH$PATH:$DM_HOME/bin:$DM_HOME/tool配置实例使用root用户创建实例存放路径[rootKylin10 DM8]# mkdir -p /DM8/data[rootKylin10 DM8]# chown -R dmadmin:dinstall /DM8/data/使用dmadmin用户配置实例进入到 DM 数据库安装(/DM8)目录下的 bin 目录中使用 dminit 命令初始化实例。[rootKylin10 DM8]# su dmadmin[dmadminKylin10 DM8]$lsbin bin2 data desktop doc drivers include jar jdk license_en.txt license_zh.txt log samples script tool uninstall uninstall.sh web[dmadminKylin10 DM8]$cd/DM8/bin[dmadminKylin10 bin]$ ./dminitpath/DM8/dataSYSDBA_PWDSYSdba#123 SYSAUDITOR_PWDSYSdba#123initdb V8 db version: 0x7000cfiledm.key not found, use default license!License will expire on2023-07-20 Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL logfilepath: /DM8/data/DAMENG/DAMENG01.log logfilepath: /DM8/data/DAMENG/DAMENG02.logwritetodir[/DM8/data/DAMENG]. create dm database success.2023-06-2715:04:53注册服务使用root用户注册[dmadminKylin10 bin]$exitexit[rootKylin10 DM8]# cd /DM8/script/root/[rootKylin10 root]# lsdm_service_installer.sh dm_service_uninstaller.sh root_installer.sh[rootKylin10 root]# ./dm_service_installer.sh -t dmserver -dm_ini /DM8/data/DAMENG/dm.ini -p DMSERVERCreated symlink /etc/systemd/system/multi-user.target.wants/DmServiceDMSERVER.service → /usr/lib/systemd/system/DmServiceDMSERVER.service. 创建服务(DmServiceDMSERVER)完成数据库启停需要使用root权限启动systemctl start DmServiceDMSERVER.service停止systemctl stop DmServiceDMSERVER.service重启systemctl restart DmServiceDMSERVER.service查看状态systemctl status DmServiceDMSERVER.service查看版本[rootKylin10 root]# cd /DM8/bin[rootKylin10 bin]# ./disql SYSDBA/SYSDBA服务器[LOCALHOST:5236]:处于普通打开状态 登录使用时间:3.607(ms)disql V8 SQLselect* fromv$version;行号 BANNER ---------- ---------------------------------1DM Database Server64V82DB Version: 0x7000c303134283890-20220720-165295-10045 已用时间:4.971(毫秒). 执行号:55200. SQL码字不易。如果文章对您有希望的话请三连支持一波。如有问题欢迎留言一起探讨感谢。也可关注下方公众号看到留言后会第一时间回复。 银河麒麟V10搭建达梦8数据库
大家好我是早九晚十二目前是做运维相关的工作。写博客是为了积累希望大家一起进步我的主页早九晚十二目前国产化服务器越来越多操作系统的国产化使得大家对中间件都有了需求今天主要是使用银河麒麟搭建达梦数据库。文章目录环境版本获取安装步骤解压安装包对比安装包是否完整创建用户组修改用户密码系统参数优化挂载镜像创建数据目录数据库安装配置实例注册服务数据库启停启动停止重启查看状态查看版本环境[rootKylin10 ~]# uname -aLinux Kylin104.19.90-24.4.v2101.ky10.x86_64#1 SMP Mon May 24 12:14:55 CST 2021 x86_64 x86_64 x86_64 GNU/Linux[rootKylin10 ~]# cat /proc/cpuinfo |grep model namemodel name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz model name:Intel(R)Xeon(R)CPU E5-2699 v4 2.20GHz版本获取链接https://eco.dameng.com/download/?_blank根据自己环境选择对应版本下载服务器可直接使用wget https://download.dameng.com/eco/adapter/DM8/202208/dm8_20220720_x86_rh7_64_ent.zip安装步骤解压安装包[rootKylin10 ~]# unzip dm8_20220720_x86_rh7_64_ent.zip对比安装包是否完整[rootKylin10 ~]# sha256sum dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso387fa90ea26f6d096101af4496d70ee9909cd0abf4f41d4bc0dace625ae721e5 dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso[rootKylin10 ~]# cat dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso_SHA256.txtSHA256 µ dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso ¹þϣ: 387fa90ea26f6d096101af4496d70ee9909cd0abf4f41d4bc0dace625ae721e5 CertUtil:-hashfileļ®³ɹ¦Ϊ³ɡ£创建用户组[rootKylin10 ~]# groupadd dinstall[rootKylin10 ~]# useradd -g dinstall -m -d /home/dmadmin -s /bin/bash dmadmin修改用户密码修改密码为DMadm_123![rootKylin10 ~]# passwd dmadmin更改用户 dmadmin 的密码 。 新的 密码 重新输入新的 密码 passwd所有的身份验证令牌已经成功更新系统参数优化cat/etc/security/limits.confEOF dmadmin hard nofile 65536 dmadmin soft nofile 65536 dmadmin hard stack 32768 dmadmin soft stack 16384 EOF执行后关闭窗口重新打开切换到dmadmin查看是否成功[rootKylin10 ~]# su dmadmin[dmadminKylin10 root]$ulimit-acorefilesize(blocks, -c)unlimited data seg size(kbytes, -d)unlimited scheduling priority(-e)0filesize(blocks, -f)unlimited pending signals(-i)58803max locked memory(kbytes, -l)64max memory size(kbytes, -m)unlimitedopenfiles(-n)65536pipe size(512bytes, -p)8POSIX message queues(bytes, -q)819200real-time priority(-r)0stack size(kbytes, -s)16384cputime(seconds, -t)unlimited max user processes(-u)58803virtual memory(kbytes, -v)unlimitedfilelocks(-x)unlimited挂载镜像切换到root用户挂载镜像[rootKylin10 ~]# mkdir /mnt/dm8[rootKylin10 ~]# mount dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso /mnt/dm8/mount: /mnt/dm8: WARNING:sourcewrite-protected, mounted read-only.创建数据目录[rootKylin10 ~]# mkdir /DM8[rootKylin10 ~]# chown -R dmadmin:dinstall /DM8/数据库安装切换至dmadmin用户。执行脚本安装[rootKylin10 ~]# su dmadmin[dmadminKylin10 root]$cd/mnt/dm8/[dmadminKylin10 dm8]$lsDM8 Install.pdfDMInstall.bin选择中文安装不输入key路径设置时区选择典型安装输入刚刚创建的DM8数据库目录不建议使用默认路径根据提示切换到root目录执行脚本[dmadminKylin10 dm8]$exitexit[rootKylin10 ~]# /DM8/script/root/root_installer.sh移动 /DM8/bin/dm_svc.conf 到/etc目录 修改服务器权限 创建DmAPService服务 Created symlink /etc/systemd/system/multi-user.target.wants/DmAPService.service → /usr/lib/systemd/system/DmAPService.service. 创建服务(DmAPService)完成 启动DmAPService服务切换root用户设置对应环境变量[rootKylin10 ~]# cd /home/dmadmin/.mozilla/[rootKylin10 .mozilla]# cd /home/dmadmin/[rootKylin10 dmadmin]# cat .bash_profile -EOFexportPATH$PATH:$DM_HOME/bin:$DM_HOME/tool-EOF切换到dmadmin用户查看结果[rootKylin10 DM8]# su dmadmin[dmadminKylin10 DM8]$cd~[dmadminKylin10 ~]$source.bash_profile[dmadminKylin10 ~]$cat.bash_profile# Source /root/.bashrc if user has one[-f~/.bashrc].~/.bashrcexportLD_LIBRARY_PATH$LD_LIBRARY_PATH:/DM8/binexportDM_HOME/DM8exportPATH$PATH:$DM_HOME/bin:$DM_HOME/tool配置实例使用root用户创建实例存放路径[rootKylin10 DM8]# mkdir -p /DM8/data[rootKylin10 DM8]# chown -R dmadmin:dinstall /DM8/data/使用dmadmin用户配置实例进入到 DM 数据库安装(/DM8)目录下的 bin 目录中使用 dminit 命令初始化实例。[rootKylin10 DM8]# su dmadmin[dmadminKylin10 DM8]$lsbin bin2 data desktop doc drivers include jar jdk license_en.txt license_zh.txt log samples script tool uninstall uninstall.sh web[dmadminKylin10 DM8]$cd/DM8/bin[dmadminKylin10 bin]$ ./dminitpath/DM8/dataSYSDBA_PWDSYSdba#123 SYSAUDITOR_PWDSYSdba#123initdb V8 db version: 0x7000cfiledm.key not found, use default license!License will expire on2023-07-20 Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL logfilepath: /DM8/data/DAMENG/DAMENG01.log logfilepath: /DM8/data/DAMENG/DAMENG02.logwritetodir[/DM8/data/DAMENG]. create dm database success.2023-06-2715:04:53注册服务使用root用户注册[dmadminKylin10 bin]$exitexit[rootKylin10 DM8]# cd /DM8/script/root/[rootKylin10 root]# lsdm_service_installer.sh dm_service_uninstaller.sh root_installer.sh[rootKylin10 root]# ./dm_service_installer.sh -t dmserver -dm_ini /DM8/data/DAMENG/dm.ini -p DMSERVERCreated symlink /etc/systemd/system/multi-user.target.wants/DmServiceDMSERVER.service → /usr/lib/systemd/system/DmServiceDMSERVER.service. 创建服务(DmServiceDMSERVER)完成数据库启停需要使用root权限启动systemctl start DmServiceDMSERVER.service停止systemctl stop DmServiceDMSERVER.service重启systemctl restart DmServiceDMSERVER.service查看状态systemctl status DmServiceDMSERVER.service查看版本[rootKylin10 root]# cd /DM8/bin[rootKylin10 bin]# ./disql SYSDBA/SYSDBA服务器[LOCALHOST:5236]:处于普通打开状态 登录使用时间:3.607(ms)disql V8 SQLselect* fromv$version;行号 BANNER ---------- ---------------------------------1DM Database Server64V82DB Version: 0x7000c303134283890-20220720-165295-10045 已用时间:4.971(毫秒). 执行号:55200. SQL码字不易。如果文章对您有希望的话请三连支持一波。如有问题欢迎留言一起探讨感谢。也可关注下方公众号看到留言后会第一时间回复。