1.单机部署

2.环境优化

2.1优化调度算法、数据大页、numa、内核参数

vim /etc/default/grub       ------加的是 numa=off transparent_hugepage=never elevator=mq-deadline

GRUB_TIMEOUT=5
GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g' /etc/system-release)"
GRUB_DEFAULT=saved
GRUB_DISABLE_SUBMENU=true
GRUB_TERMINAL_OUTPUT="console"
GRUB_CMDLINE_LINUX="resume=/dev/mapper/klas-swap rd.lvm.lv=klas/root rd.lvm.lv=klas/swap rhgb quiet crashkernel=1024M,high audit=0 numa=off transparent_hugepage=never elevator=mq-deadline"
GRUB_DISABLE_RECOVERY="true"

检测：0KB则为正确

[root@SonarQube mnt]# grep HugePages /proc/meminfo
AnonHugePages:         0 kB
ShmemHugePages:        0 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0

2.2重启服务器 

reboot now

2.3内核参数

vi /etc/sysctl.d/99-sysctl.conf

        vm.swappiness = 1

        vm.overcommit_memory=0

执行sysctl -p 生效

vi /etc/systemd/system.conf

        DefaultLimitNOFILE=65536

        DefaultLimitNPROC=10240

3.基础目录

3.1创建组、用户

groupadd -g 12349 dinstall

useradd -u 12345 -g dinstall -m -d /home/dmdba -s /bin/bash dmdba

echo Dm@230714|passwd dmdba --stdin

3.2安装目录

cd /db

mkdir -p /db/soft

mkdir -p /db/dmdbms

mkdir -p /db/dmdb

mkdir -p /db/dmdb/data_$db_name

mkdir -p /db/dmdb/redo_$db_name

mkdir -p /db/dmdb/arch_$db_name

chown -R dmdba:dinstall /db/dmdbms

chown -R dmdba:dinstall /db/dmdb

说明：

dmdbms用于达梦数据库软件安装目录；

dmdb用于数据文件、redo文件、归档

3.3创建core目录

（1）创建目录 mkdir -p /db/dmdb/coredump chown -R dmdba:dinstall /db/dmdb （2）修改/etc/security/limits.conf添加 * soft core unlimited * hard core unlimited root soft core unlimited root hard core unlimited dmdba soft core unlimited dmdba hard core unlimited （3）修改/etc/systemd/system.conf添加 DefaultLimitCORE=unlimited 生效： systemctl daemon-reload systemctl daemon-reexec ulimit -c unlimited （4）修改/etc/sysctl.conf 添加两行 kernel.core_pattern=/db/dmdb/coredump/core-%t-%e-%p-%c.core kernel.core_uses_pid=1 保存退出 执行命令使其生效 sysctl -p /etc/sysctl.conf

vim /etc/security/limits.conf

# 原有配置保持不变
* - nofile 65535

# 达梦数据库要求的配置
* soft core unlimited
* hard core unlimited
* soft nproc 10240
* hard nproc 10240
* soft nofile 65536
* hard nofile 65536

# 特定用户配置
root soft core unlimited
root hard core unlimited
root soft nproc 10240
root hard nproc 10240
root soft nofile 65536

3.4安装镜像-----自己想办法弄--到/db/soft/

 mount -o loop /db/soft/dm8_20230703_x86_rh6_64.iso /mnt

su - dmdba

cd /mnt

 ./DMInstall.bin -i

安装--正常安装即可，取消key，其余yes

3.5用system管理：

cat > /usr/lib/systemd/system/DmAPService.service << 'EOF'
[Unit]
Description=DMAP Service
After=network.target
[Service]
Type=forking

ExecStart=/db/dmdbms/bin/service_template/DmAPService start
ExecStop=/db/dmdbms/bin/service_template/DmAPService stop
ExecReload=/db/dmdbms/bin/service_template/DmAPService restart
User=dmdba
Group=dinstall
[Install]
WantedBy=multi-user.target
EOF

/db/dmdbms/script/root/root_installer.sh

systemctl daemon-reload
systemctl enable DmAPService
 systemctl start DmAPService
systemctl status DmAPService

4.初始化

 su - dmdba

cd /db/dmdbms/bin

./dminit \
PATH=/db/dmdb/data_newoadb \
CTL_PATH=/db/dmdb/data_newoadb/control01.ctl \
LOG_PATH=/db/dmdb/redo_newoadb/redo01.log \
LOG_PATH=/db/dmdb/redo_newoadb/redo02.log \
LOG_PATH=/db/dmdb/redo_newoadb/redo03.log \
LOG_PATH=/db/dmdb/redo_newoadb/redo04.log \
PAGE_SIZE=32 \
EXTENT_SIZE=32 \
LOG_SIZE=2048 \
CHARSET=1 \
CASE_SENSITIVE=Y \
SYSDBA_PWD=Qwer#123com \
SYSAUDITOR_PWD=Qwer#123com \
DB_NAME=DMNEWOADB \
INSTANCE_NAME=DMNEWOADB \
PORT_NUM=5236 \
BUFFER=1024 \
BLANK_PAD_MODE=1

4.2修改

grep -E 'INI_PATH=|DCR_INI_PATH=|DPC_MODE=' DmServiceDMNEWOADBINI_PATH="/db/dmdb/data_newoadb/DMNEWOADB/dm.ini"
DCR_INI_PATH=""
DPC_MODE=""

[dmdba@SonarQube bin]$ ./DmServiceDMNEWOADB start
Starting DmServiceDMNEWOADB: 
                                                           [ OK ]
[dmdba@SonarQube bin]$ 
[dmdba@SonarQube bin]$  ./DmServiceDMNEWOADB status
DmServiceDMNEWOADB (pid 58783) is running.
[dmdba@SonarQube bin]$ ./disql
disql V8
用户名:sysdba
密码:
[-2501]:用户名或密码错误.
用户名:sysdba
密码:

5.测试

 select * from v$version;  

select * from v$instance

 select arch_mode from v$database;