代码拉取完成，页面将自动刷新
同步操作将从 hnyuanzj/DMShellInstall 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
[BEGIN] 2022/12/20 12:20:01
[root@centos7 soft]# ./DMShellInstall -di dm8_20221121_x86_rh6_64.iso -d /opt/dmdbms \
> -hn dsc -rp 123456 \
> -dpi 192.168.2.31,192.168.2.32 -dmi 172.16.2.31,172.16.2.32 \
> -ddn DMDSC -den DMDSC \
> -dcd asmdata01 -vod asmdata02 -ard asmdata03,asmdata04 -lod asmdata05,asmdata06 -dad asmdata07,asmdata08,asmdata09 \
> -cdp 12345 -adp 12346 -ddp 12347 -amp 9999 \
> -mtp Y -oi N
███████ ████ ████ ████████ ██ ██ ██ ██ ██ ██ ██
░██░░░░██ ░██░██ ██░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██
░██ ░██░██░░██ ██ ░██░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██
░██ ░██░██ ░░███ ░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██
░██ ░██░██ ░░█ ░██░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██
░██ ██ ░██ ░ ░██ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██
░███████ ░██ ░██ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███
░░░░░░░ ░░ ░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░
请选择达梦数据库部署类型：单机[si]/数据守护[dw]/dsc集群[dsc]
dsc
达梦数据库安装部署类型: dsc
校验 192.168.2.31,192.168.2.32 地址，请等待！！！
校验 172.16.2.31,172.16.2.32 地址，请等待！！！
校验 asmdata01 磁盘，请等待！！！
校验 asmdata02 磁盘，请等待！！！
校验 asmdata05,asmdata06 磁盘，请等待！！！
校验 asmdata03,asmdata04 磁盘，请等待！！！
校验 asmdata07,asmdata08,asmdata09 磁盘，请等待！！！
主库安装 expect 软件用于 root 用户互信：
已加载插件：fastestmirror
Loading mirror speeds from cached hostfile
正在解决依赖关系
--> 正在检查事务
---> 软件包 expect.x86_64.0.5.45-14.el7_1 将被 安装
--> 正在处理依赖关系 libtcl8.5.so()(64bit)，它被软件包 expect-5.45-14.el7_1.x86_64 需要
--> 正在检查事务
---> 软件包 tcl.x86_64.1.8.5.13-8.el7 将被 安装
--> 解决依赖关系完成
依赖关系解决
=====================================================================================================================================================================================================================
Package 架构 版本 源 大小
=====================================================================================================================================================================================================================
正在安装:
expect x86_64 5.45-14.el7_1 OS-YUM 262 k
为依赖而安装:
tcl x86_64 1:8.5.13-8.el7 OS-YUM 1.9 M
事务概要
=====================================================================================================================================================================================================================
安装 1 软件包 (+1 依赖软件包)
总下载量：2.1 M
安装大小：4.9 M
Downloading packages:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
总计 7.4 MB/s | 2.1 MB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在安装 : 1:tcl-8.5.13-8.el7.x86_64 1/2
正在安装 : expect-5.45-14.el7_1.x86_64 2/2
验证中 : 1:tcl-8.5.13-8.el7.x86_64 1/2
验证中 : expect-5.45-14.el7_1.x86_64 2/2
已安装:
expect.x86_64 0:5.45-14.el7_1
作为依赖被安装:
tcl.x86_64 1:8.5.13-8.el7
完毕！
所有节点 root 用户配置互信：
# 192.168.2.31:22 SSH-2.0-OpenSSH_7.4
# 192.168.2.31:22 SSH-2.0-OpenSSH_7.4
# 192.168.2.31:22 SSH-2.0-OpenSSH_7.4
# 192.168.2.32:22 SSH-2.0-OpenSSH_7.4
# 192.168.2.32:22 SSH-2.0-OpenSSH_7.4
# 192.168.2.32:22 SSH-2.0-OpenSSH_7.4
spawn scp -rq /root/.ssh root@192.168.2.31:~
send: spawn id exp6 not open
while executing
"send "123456\r""
spawn ssh-copy-id -i root@192.168.2.31
/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub"
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed
/usr/bin/ssh-copy-id: WARNING: All keys were skipped because they already exist on the remote system.
(if you think this is a mistake, you may want to use -f option)
send: spawn id exp6 not open
while executing
"send "123456\r""
spawn scp -rq /root/.ssh root@192.168.2.32:~
root@192.168.2.32's password:
spawn ssh-copy-id -i root@192.168.2.32
/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub"
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed
/usr/bin/ssh-copy-id: WARNING: All keys were skipped because they already exist on the remote system.
(if you think this is a mistake, you may want to use -f option)
send: spawn id exp6 not open
while executing
"send "123456\r""
拷贝脚本以及安装包到节点：192.168.2.32
dwnode.sh 100% 556 709.2KB/s 00:00
DMShellInstall 100% 134KB 27.0MB/s 00:00
dm8_20221121_x86_rh6_64.iso 100% 959MB 87.2MB/s 00:11
达梦数据库开始安装：
#==============================================================#
打印系统信息
#==============================================================#
服务器时间:
2022年 12月 20日 星期二 19:26:08 CST
操作系统版本:
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"
CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"
cpu信息:
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 1
On-line CPU(s) list: 0
Thread(s) per core: 1
Core(s) per socket: 1
座： 1
NUMA 节点： 1
厂商 ID： GenuineIntel
CPU 系列： 6
型号： 142
型号名称： Intel(R) Core(TM) i7-8565U CPU @ 1.80GHz
步进： 12
CPU MHz： 1992.001
BogoMIPS： 3984.00
超管理器厂商： VMware
虚拟化类型： 完全
L1d 缓存： 32K
L1i 缓存： 32K
L2 缓存： 256K
L3 缓存： 8192K
NUMA 节点0 CPU： 0
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp ibrs_enhanced fsgsbase tsc_adjust bmi1 avx2 smep bmi2 invpcid rdseed adx smap clflushopt xsaveopt xsavec xgetbv1 arat md_clear spec_ctrl intel_stibp flush_l1d arch_capabilities
内存信息:
total used free shared buff/cache available
Mem: 1819 256 343 9 1219 1401
Swap: 8191 0 8191
total used free shared buff/cache available
Mem: 1.8G 256M 343M 9.7M 1.2G 1.4G
Swap: 8.0G 0B 8.0G
挂载信息:
/dev/mapper/centos-root / xfs defaults 0 0
UUID=dc24af02-0269-4d90-88b9-c6fdb8c27470 /boot xfs defaults 0 0
/dev/mapper/centos-swap swap swap defaults 0 0
/dev/sr0 /mnt/cdrom iso9660 defaults 0 0
目录信息:
文件系统 容量 已用 可用 已用% 挂载点
devtmpfs 898M 0 898M 0% /dev
tmpfs 910M 0 910M 0% /dev/shm
tmpfs 910M 9.7M 901M 2% /run
tmpfs 910M 0 910M 0% /sys/fs/cgroup
/dev/mapper/centos-root 91G 2.7G 89G 3% /
/dev/sr0 4.4G 4.4G 0 100% /mnt/cdrom
/dev/sda1 1014M 151M 864M 15% /boot
tmpfs 182M 0 182M 0% /run/user/0
#==============================================================#
关闭 SWAP 功能
#==============================================================#
total used free shared buff/cache available
Mem: 1863004 256168 358212 9888 1248624 1441728
Swap: 0 0 0
#/dev/mapper/centos-swap swap swap defaults 0 0
#==============================================================#
禁用防火墙
#==============================================================#
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:firewalld(1)
12月 20 18:57:14 centos7 systemd[1]: Starting firewalld - dynamic firewall daemon...
12月 20 18:57:14 centos7 systemd[1]: Started firewalld - dynamic firewall daemon.
12月 20 18:57:14 centos7 firewalld[727]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.
12月 20 19:26:09 centos7 systemd[1]: Stopping firewalld - dynamic firewall daemon...
12月 20 19:26:09 centos7 systemd[1]: Stopped firewalld - dynamic firewall daemon.
#==============================================================#
禁用 selinux
#==============================================================#
SELINUX=disabled
SELINUXTYPE=targeted
#==============================================================#
配置主机名
#==============================================================#
Static hostname: dsc01
Icon name: computer-vm
Chassis: vm
Machine ID: f4a41440d98d417dbb5516d46b966467
Boot ID: 413981e65aa442298633b660f2fa4892
Virtualization: vmware
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-1160.el7.x86_64
Architecture: x86-64
#==============================================================#
配置时间同步
#==============================================================#
Removed symlink /etc/systemd/system/multi-user.target.wants/chronyd.service.
● chronyd.service - NTP client/server
Loaded: loaded (/usr/lib/systemd/system/chronyd.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:chronyd(8)
man:chrony.conf(5)
12月 20 18:57:13 centos7 systemd[1]: Starting NTP client/server...
12月 20 18:57:13 centos7 chronyd[705]: chronyd version 3.4 starting (+CMDMON +NTP +REFCLOCK +RTC +PRIVDROP +SCFILTER +SIGND +ASYNCDNS +SECHASH +IPV6 +DEBUG)
12月 20 18:57:14 centos7 chronyd[705]: Frequency 0.000 +/- 1000000.000 ppm read from /var/lib/chrony/drift
12月 20 18:57:14 centos7 systemd[1]: Started NTP client/server.
12月 20 19:26:09 dsc01 systemd[1]: Stopping NTP client/server...
12月 20 19:26:09 dsc01 systemd[1]: Stopped NTP client/server.
2022年 12月 20日 星期二 19:26:09 CST
no crontab for root
#==============================================================#
禁用透明大页 & 禁用NUMA & 开启 I/0 schedule
#==============================================================#
index=0
kernel=/boot/vmlinuz-3.10.0-1160.el7.x86_64
args="ro crashkernel=auto spectre_v2=retpoline rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet LANG=zh_CN.UTF-8 numa=off transparent_hugepage=never elevator=deadline"
--
index=1
kernel=/boot/vmlinuz-0-rescue-f4a41440d98d417dbb5516d46b966467
args="ro crashkernel=auto spectre_v2=retpoline rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"
#==============================================================#
创建 DMDBA 用户以及安装目录
#==============================================================#
更改用户 dmdba 的密码 。
passwd：所有的身份验证令牌已经成功更新。
dmdba:x:54321:54321::/home/dmdba:/bin/bash
uid=54321(dmdba) gid=54321(dinstall) 组=54321(dinstall),54322(dmdba)
#==============================================================#
配置系统参数
#==============================================================#
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.swappiness = 0
vm.dirty_background_ratio = 3
vm.dirty_ratio = 80
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
sysctl: cannot stat /proc/sys/vm/numa_stat: 没有那个文件或目录
vm.overcommit_memory = 0
#==============================================================#
配置用户限制
#==============================================================#
dmdba - nice 0
dmdba - as unlimited
dmdba - fsize unlimited
dmdba - nproc 131072
dmdba - nofile 131072
dmdba - core unlimited
dmdba - data unlimited
root - nice 0
root - as unlimited
root - fsize unlimited
root - nproc 131072
root - nofile 131072
root - core unlimited
root - data unlimited
[Manager]
DefaultLimitCORE=infinity
DefaultLimitNOFILE=65536
DefaultLimitNPROC=10240
auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so
auth substack system-auth
auth include postlogin
account required pam_nologin.so
account include system-auth
password include system-auth
session required pam_selinux.so close
session required pam_loginuid.so
session optional pam_console.so
session required pam_selinux.so open
session required pam_namespace.so
session optional pam_keyinit.so force revoke
session include system-auth
session include postlogin
-session optional pam_ck_connector.so
session required pam_limits.so
session required /lib64/security/pam_limits.so
#==============================================================#
禁用 RemoveIPC
#==============================================================#
[Login]
RemoveIPC=no
#==============================================================#
配置语言中文
#==============================================================#
export LANG=zh_CN.UTF-8
#==============================================================#
配置用户环境变量
#==============================================================#
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export MALLOC_ARENA_MAX=1
export DM_HOME=/opt/dmdbms
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DM_HOME/bin
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
export PS1="[`whoami`@`hostname`:"'\w]$ '
alias ds='disql SYSDBA/SYSDBA:5236 '
alias dsql='disql SYSDBA/SYSDBA:5236 \`'
alias dssql='disql -S SYSDBA/SYSDBA:5236 \`'
alias dmlog='cd $DM_HOME/log'
#==============================================================#
挂载达梦安装镜像
#==============================================================#
总用量 959M
-r-xr-xr-x. 1 root root 2.7M 11月 21 16:25 DM8 Install.pdf
-r-xr-xr-x. 1 root root 957M 11月 21 16:27 DMInstall.bin
#==============================================================#
安装达梦数据库软件
#==============================================================#
解压安装程序.........
2022-12-20 19:26:29
[INFO] 安装达梦数据库...
2022-12-20 19:26:30
[INFO] 安装 基础 模块...
2022-12-20 19:26:34
[INFO] 安装 服务器 模块...
2022-12-20 19:26:34
[INFO] 安装 客户端 模块...
2022-12-20 19:26:37
[INFO] 安装 驱动 模块...
2022-12-20 19:26:39
[INFO] 安装 手册 模块...
2022-12-20 19:26:39
[INFO] 安装 服务 模块...
2022-12-20 19:26:41
[INFO] 移动日志文件。
2022-12-20 19:26:41
[INFO] 更改安装目录权限完成。
2022-12-20 19:26:41
[INFO] 正在启动DmAPService服务...
2022-12-20 19:26:42
[INFO] 启动DmAPService服务成功。
2022-12-20 19:26:42
[INFO] 安装达梦数据库完成。
#==============================================================#
创建UDEV规则文件
#==============================================================#
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405f5c51be3913d41f58ceb59dd5", SYMLINK+="asmdisk/dmdcr01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405c3cbda6d685747b1a5b649ee3", SYMLINK+="asmdisk/dmvote01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405d0e3c3a9b2874cc6aad8ef901", SYMLINK+="asmdisk/dmlog01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405716c01510c5c448f801989e89", SYMLINK+="asmdisk/dmlog02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405b0ccc91e5cdd4c4b9ce6cc7d0", SYMLINK+="asmdisk/dmarch01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600140500b7852874dc402f8ff46337c", SYMLINK+="asmdisk/dmarch02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014051b4be89b555d48f58dabde17f", SYMLINK+="asmdisk/dmdata01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014056995ce6cb1d94084a72064522", SYMLINK+="asmdisk/dmdata02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014055454318b20a044448d2be00dc", SYMLINK+="asmdisk/dmdata03", OWNER="dmdba", GROUP="dinstall", MODE="0660"
#==============================================================#
查看udev磁盘
#==============================================================#
ls -lh /dev/asmdisk
总用量 0
lrwxrwxrwx. 1 root root 7 12月 20 19:26 dmarch01 -> ../dm-4
lrwxrwxrwx. 1 root root 7 12月 20 19:26 dmarch02 -> ../dm-5
lrwxrwxrwx. 1 root root 7 12月 20 19:26 dmdata01 -> ../dm-8
lrwxrwxrwx. 1 root root 7 12月 20 19:26 dmdata02 -> ../dm-9
lrwxrwxrwx. 1 root root 8 12月 20 19:26 dmdata03 -> ../dm-10
lrwxrwxrwx. 1 root root 7 12月 20 19:26 dmdcr01 -> ../dm-2
lrwxrwxrwx. 1 root root 7 12月 20 19:26 dmlog01 -> ../dm-6
lrwxrwxrwx. 1 root root 7 12月 20 19:26 dmlog02 -> ../dm-7
lrwxrwxrwx. 1 root root 7 12月 20 19:26 dmvote01 -> ../dm-3
#==============================================================#
创建dsc参数文件
#==============================================================#
ls -lh /dmdata/DMDSC/
总用量 16K
-rw-r--r--. 1 dmdba dinstall 258 12月 20 19:26 dmasvrmal.ini
-rw-r--r--. 1 dmdba dinstall 166 12月 20 19:26 dmcssm.ini
-rw-r--r--. 1 dmdba dinstall 1.1K 12月 20 19:26 dmdcr_cfg.ini
-rw-r--r--. 1 dmdba dinstall 413 12月 20 19:26 dmdcr.ini
#==============================================================#
注册css和asm服务
#==============================================================#
Created symlink from /etc/systemd/system/multi-user.target.wants/DmCSSServiceCss.service to /usr/lib/systemd/system/DmCSSServiceCss.service.
创建服务(DmCSSServiceCss)完成
Created symlink from /etc/systemd/system/multi-user.target.wants/DmASMSvrServiceAsmsvr.service to /usr/lib/systemd/system/DmASMSvrServiceAsmsvr.service.
创建服务(DmASMSvrServiceAsmsvr)完成
#==============================================================#
创建归档和备份脚本
#==============================================================#
创建数据库归档脚本：
-rw-r--r--. 1 dmdba dinstall 338 12月 20 19:26 /home/dmdba/scripts/conf_arch.sql
创建数据库备份脚本：
-rw-r--r--. 1 dmdba dinstall 778 12月 20 19:26 /home/dmdba/scripts/conf_fullbackup.sql
-rw-r--r--. 1 dmdba dinstall 1.5K 12月 20 19:26 /home/dmdba/scripts/conf_incrbackup.sql
创建 DMDBA 用户脚本，密码 SYSDBA ：
-rw-r--r--. 1 dmdba dinstall 696 12月 20 19:26 /home/dmdba/scripts/ct_dbuser.sql
#==============================================================#
创建达梦数据库优化脚本
#==============================================================#
创建数据库参数配置脚本：
-rw-r--r--. 1 dmdba dinstall 14K 12月 20 19:26 /home/dmdba/scripts/conf_para.sql
创建数据库优化结果查询脚本：
-rw-r--r--. 1 dmdba dinstall 2.2K 12月 20 19:26 /home/dmdba/scripts/query_dm.sql
#==============================================================#
配置节点：192.168.2.32
#==============================================================#
节点 192.168.2.32 开始执行配置：
███████ ████ ████ ████████ ██ ██ ██ ██ ██ ██ ██
░██░░░░██ ░██░██ ██░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██
░██ ░██░██░░██ ██ ░██░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██
░██ ░██░██ ░░███ ░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██
░██ ░██░██ ░░█ ░██░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██
░██ ██ ░██ ░ ░██ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██
░███████ ░██ ░██ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███
░░░░░░░ ░░ ░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░
达梦数据库开始安装：
#==============================================================#
打印系统信息
#==============================================================#
服务器时间:
2022年 12月 20日 星期二 19:29:20 CST
操作系统版本:
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"
CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"
cpu信息:
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 1
On-line CPU(s) list: 0
Thread(s) per core: 1
Core(s) per socket: 1
座： 1
NUMA 节点： 1
厂商 ID： GenuineIntel
CPU 系列： 6
型号： 142
型号名称： Intel(R) Core(TM) i7-8565U CPU @ 1.80GHz
步进： 12
CPU MHz： 1992.001
BogoMIPS： 3984.00
超管理器厂商： VMware
虚拟化类型： 完全
L1d 缓存： 32K
L1i 缓存： 32K
L2 缓存： 256K
L3 缓存： 8192K
NUMA 节点0 CPU： 0
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp ibrs_enhanced fsgsbase tsc_adjust bmi1 avx2 smep bmi2 invpcid rdseed adx smap clflushopt xsaveopt xsavec xgetbv1 arat md_clear spec_ctrl intel_stibp flush_l1d arch_capabilities
内存信息:
total used free shared buff/cache available
Mem: 1819 254 436 9 1127 1392
Swap: 8191 0 8191
total used free shared buff/cache available
Mem: 1.8G 254M 437M 9.7M 1.1G 1.4G
Swap: 8.0G 0B 8.0G
挂载信息:
/dev/mapper/centos-root / xfs defaults 0 0
UUID=dc24af02-0269-4d90-88b9-c6fdb8c27470 /boot xfs defaults 0 0
/dev/mapper/centos-swap swap swap defaults 0 0
/dev/sr0 /mnt/cdrom iso9660 defaults 0 0
目录信息:
文件系统 容量 已用 可用 已用% 挂载点
devtmpfs 898M 0 898M 0% /dev
tmpfs 910M 0 910M 0% /dev/shm
tmpfs 910M 9.7M 901M 2% /run
tmpfs 910M 0 910M 0% /sys/fs/cgroup
/dev/mapper/centos-root 91G 2.7G 89G 3% /
/dev/sr0 4.4G 4.4G 0 100% /mnt/cdrom
/dev/sda1 1014M 151M 864M 15% /boot
tmpfs 182M 0 182M 0% /run/user/0
#==============================================================#
关闭 SWAP 功能
#==============================================================#
total used free shared buff/cache available
Mem: 1863004 254020 453744 9888 1155240 1432760
Swap: 0 0 0
#/dev/mapper/centos-swap swap swap defaults 0 0
#==============================================================#
禁用防火墙
#==============================================================#
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:firewalld(1)
12月 20 18:59:44 centos7 systemd[1]: Starting firewalld - dynamic firewall daemon...
12月 20 18:59:44 centos7 systemd[1]: Started firewalld - dynamic firewall daemon.
12月 20 18:59:44 centos7 firewalld[727]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.
12月 20 19:29:20 centos7 systemd[1]: Stopping firewalld - dynamic firewall daemon...
12月 20 19:29:20 centos7 systemd[1]: Stopped firewalld - dynamic firewall daemon.
#==============================================================#
禁用 selinux
#==============================================================#
SELINUX=disabled
SELINUXTYPE=targeted
#==============================================================#
配置主机名
#==============================================================#
Static hostname: dsc02
Icon name: computer-vm
Chassis: vm
Machine ID: f4a41440d98d417dbb5516d46b966467
Boot ID: df45a062d6e44652ad4fdfd9ff1cfe90
Virtualization: vmware
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-1160.el7.x86_64
Architecture: x86-64
#==============================================================#
配置时间同步
#==============================================================#
Removed symlink /etc/systemd/system/multi-user.target.wants/chronyd.service.
● chronyd.service - NTP client/server
Loaded: loaded (/usr/lib/systemd/system/chronyd.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:chronyd(8)
man:chrony.conf(5)
12月 20 18:59:43 centos7 systemd[1]: Starting NTP client/server...
12月 20 18:59:44 centos7 chronyd[707]: chronyd version 3.4 starting (+CMDMON +NTP +REFCLOCK +RTC +PRIVDROP +SCFILTER +SIGND +ASYNCDNS +SECHASH +IPV6 +DEBUG)
12月 20 18:59:44 centos7 chronyd[707]: Frequency 0.000 +/- 1000000.000 ppm read from /var/lib/chrony/drift
12月 20 18:59:44 centos7 systemd[1]: Started NTP client/server.
12月 20 19:29:21 dsc02 systemd[1]: Stopping NTP client/server...
12月 20 19:29:21 dsc02 systemd[1]: Stopped NTP client/server.
2022年 12月 20日 星期二 19:29:21 CST
no crontab for root
#==============================================================#
禁用透明大页 & 禁用NUMA & 开启 I/0 schedule
#==============================================================#
index=0
kernel=/boot/vmlinuz-3.10.0-1160.el7.x86_64
args="ro crashkernel=auto spectre_v2=retpoline rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet LANG=zh_CN.UTF-8 numa=off transparent_hugepage=never elevator=deadline"
--
index=1
kernel=/boot/vmlinuz-0-rescue-f4a41440d98d417dbb5516d46b966467
args="ro crashkernel=auto spectre_v2=retpoline rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"
#==============================================================#
创建 DMDBA 用户以及安装目录
#==============================================================#
更改用户 dmdba 的密码 。
passwd：所有的身份验证令牌已经成功更新。
dmdba:x:54321:54321::/home/dmdba:/bin/bash
uid=54321(dmdba) gid=54321(dinstall) 组=54321(dinstall),54322(dmdba)
#==============================================================#
配置系统参数
#==============================================================#
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.swappiness = 0
vm.dirty_background_ratio = 3
vm.dirty_ratio = 80
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
sysctl: cannot stat /proc/sys/vm/numa_stat: 没有那个文件或目录
vm.overcommit_memory = 0
#==============================================================#
配置用户限制
#==============================================================#
dmdba - nice 0
dmdba - as unlimited
dmdba - fsize unlimited
dmdba - nproc 131072
dmdba - nofile 131072
dmdba - core unlimited
dmdba - data unlimited
root - nice 0
root - as unlimited
root - fsize unlimited
root - nproc 131072
root - nofile 131072
root - core unlimited
root - data unlimited
[Manager]
DefaultLimitCORE=infinity
DefaultLimitNOFILE=65536
DefaultLimitNPROC=10240
auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so
auth substack system-auth
auth include postlogin
account required pam_nologin.so
account include system-auth
password include system-auth
session required pam_selinux.so close
session required pam_loginuid.so
session optional pam_console.so
session required pam_selinux.so open
session required pam_namespace.so
session optional pam_keyinit.so force revoke
session include system-auth
session include postlogin
-session optional pam_ck_connector.so
session required pam_limits.so
session required /lib64/security/pam_limits.so
#==============================================================#
禁用 RemoveIPC
#==============================================================#
[Login]
RemoveIPC=no
#==============================================================#
配置语言中文
#==============================================================#
export LANG=zh_CN.UTF-8
#==============================================================#
配置用户环境变量
#==============================================================#
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export MALLOC_ARENA_MAX=1
export DM_HOME=/opt/dmdbms
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DM_HOME/bin
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
export PS1="[`whoami`@`hostname`:"'\w]$ '
alias ds='disql SYSDBA/SYSDBA:5236 '
alias dsql='disql SYSDBA/SYSDBA:5236 \`'
alias dssql='disql -S SYSDBA/SYSDBA:5236 \`'
alias dmlog='cd $DM_HOME/log'
#==============================================================#
挂载达梦安装镜像
#==============================================================#
总用量 959M
-r-xr-xr-x. 1 root root 2.7M 11月 21 16:25 DM8 Install.pdf
-r-xr-xr-x. 1 root root 957M 11月 21 16:27 DMInstall.bin
#==============================================================#
安装达梦数据库软件
#==============================================================#
解压安装程序.........
2022-12-20 19:29:43
[INFO] 安装达梦数据库...
2022-12-20 19:29:44
[INFO] 安装 基础 模块...
2022-12-20 19:29:48
[INFO] 安装 服务器 模块...
2022-12-20 19:29:48
[INFO] 安装 客户端 模块...
2022-12-20 19:29:52
[INFO] 安装 驱动 模块...
2022-12-20 19:29:53
[INFO] 安装 手册 模块...
2022-12-20 19:29:53
[INFO] 安装 服务 模块...
2022-12-20 19:29:55
[INFO] 移动日志文件。
2022-12-20 19:29:56
[INFO] 更改安装目录权限完成。
2022-12-20 19:29:56
[INFO] 正在启动DmAPService服务...
2022-12-20 19:29:56
[INFO] 启动DmAPService服务成功。
2022-12-20 19:29:56
[INFO] 安装达梦数据库完成。
#==============================================================#
拷贝UDEV规则文件
#==============================================================#
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405f5c51be3913d41f58ceb59dd5", SYMLINK+="asmdisk/dmdcr01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405c3cbda6d685747b1a5b649ee3", SYMLINK+="asmdisk/dmvote01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405d0e3c3a9b2874cc6aad8ef901", SYMLINK+="asmdisk/dmlog01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405716c01510c5c448f801989e89", SYMLINK+="asmdisk/dmlog02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405b0ccc91e5cdd4c4b9ce6cc7d0", SYMLINK+="asmdisk/dmarch01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600140500b7852874dc402f8ff46337c", SYMLINK+="asmdisk/dmarch02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014051b4be89b555d48f58dabde17f", SYMLINK+="asmdisk/dmdata01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014056995ce6cb1d94084a72064522", SYMLINK+="asmdisk/dmdata02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014055454318b20a044448d2be00dc", SYMLINK+="asmdisk/dmdata03", OWNER="dmdba", GROUP="dinstall", MODE="0660"
#==============================================================#
查看udev磁盘
#==============================================================#
ls -lh /dev/asmdisk
总用量 0
lrwxrwxrwx. 1 root root 7 12月 20 19:30 dmarch01 -> ../dm-3
lrwxrwxrwx. 1 root root 7 12月 20 19:30 dmarch02 -> ../dm-5
lrwxrwxrwx. 1 root root 7 12月 20 19:30 dmdata01 -> ../dm-8
lrwxrwxrwx. 1 root root 7 12月 20 19:30 dmdata02 -> ../dm-9
lrwxrwxrwx. 1 root root 8 12月 20 19:30 dmdata03 -> ../dm-10
lrwxrwxrwx. 1 root root 7 12月 20 19:30 dmdcr01 -> ../dm-2
lrwxrwxrwx. 1 root root 7 12月 20 19:30 dmlog01 -> ../dm-7
lrwxrwxrwx. 1 root root 7 12月 20 19:30 dmlog02 -> ../dm-6
lrwxrwxrwx. 1 root root 7 12月 20 19:30 dmvote01 -> ../dm-4
#==============================================================#
拷贝dsc参数文件
#==============================================================#
ls -lh /dmdata/DMDSC/
总用量 16K
-rw-r--r--. 1 dmdba dinstall 258 12月 20 19:30 dmasvrmal.ini
-rw-r--r--. 1 dmdba dinstall 166 12月 20 19:30 dmcssm.ini
-rw-r--r--. 1 dmdba dinstall 1.1K 12月 20 19:30 dmdcr_cfg.ini
-rw-r--r--. 1 dmdba dinstall 413 12月 20 19:30 dmdcr.ini
#==============================================================#
注册css和asm服务
#==============================================================#
Created symlink from /etc/systemd/system/multi-user.target.wants/DmCSSServiceCss.service to /usr/lib/systemd/system/DmCSSServiceCss.service.
创建服务(DmCSSServiceCss)完成
Created symlink from /etc/systemd/system/multi-user.target.wants/DmASMSvrServiceAsmsvr.service to /usr/lib/systemd/system/DmASMSvrServiceAsmsvr.service.
创建服务(DmASMSvrServiceAsmsvr)完成
#==============================================================#
创建归档和备份脚本
#==============================================================#
创建数据库归档脚本：
-rw-r--r--. 1 dmdba dinstall 338 12月 20 19:30 /home/dmdba/scripts/conf_arch.sql
创建数据库备份脚本：
-rw-r--r--. 1 dmdba dinstall 778 12月 20 19:30 /home/dmdba/scripts/conf_fullbackup.sql
-rw-r--r--. 1 dmdba dinstall 1.5K 12月 20 19:30 /home/dmdba/scripts/conf_incrbackup.sql
创建 DMDBA 用户脚本，密码 SYSDBA ：
-rw-r--r--. 1 dmdba dinstall 696 12月 20 19:30 /home/dmdba/scripts/ct_dbuser.sql
#==============================================================#
创建达梦数据库优化脚本
#==============================================================#
创建数据库参数配置脚本：
-rw-r--r--. 1 dmdba dinstall 14K 12月 20 19:30 /home/dmdba/scripts/conf_para.sql
创建数据库优化结果查询脚本：
-rw-r--r--. 1 dmdba dinstall 2.2K 12月 20 19:30 /home/dmdba/scripts/query_dm.sql
Connection to 192.168.2.32 closed.
节点 192.168.2.32 配置完成！
#==============================================================#
初始化asm磁盘
#==============================================================#
DMASMCMD V8
ASM>create dcrdisk '/dev/asmdisk/dmdcr01' 'dmdcr01'
[Trace]The ASM initialize dcrdisk /dev/asmdisk/dmdcr01 to name DMASMdmdcr01
Used time: 21.029(ms).
ASM>create votedisk '/dev/asmdisk/dmvote01' 'dmvote01'
[Trace]The ASM initialize votedisk /dev/asmdisk/dmvote01 to name DMASMdmvote01
Used time: 15.013(ms).
ASM>create asmdisk '/dev/asmdisk/dmlog01' 'dmlog01'
[Trace]The ASM initialize asmdisk /dev/asmdisk/dmlog01 to name DMASMdmlog01
Used time: 7.632(ms).
ASM>create asmdisk '/dev/asmdisk/dmlog02' 'dmlog02'
[Trace]The ASM initialize asmdisk /dev/asmdisk/dmlog02 to name DMASMdmlog02
Used time: 3.936(ms).
ASM>create asmdisk '/dev/asmdisk/dmarch01' 'dmarch01'
[Trace]The ASM initialize asmdisk /dev/asmdisk/dmarch01 to name DMASMdmarch01
Used time: 3.894(ms).
ASM>create asmdisk '/dev/asmdisk/dmarch02' 'dmarch02'
[Trace]The ASM initialize asmdisk /dev/asmdisk/dmarch02 to name DMASMdmarch02
Used time: 6.430(ms).
ASM>create asmdisk '/dev/asmdisk/dmdata01' 'dmdata01'
[Trace]The ASM initialize asmdisk /dev/asmdisk/dmdata01 to name DMASMdmdata01
Used time: 26.350(ms).
ASM>create asmdisk '/dev/asmdisk/dmdata02' 'dmdata02'
[Trace]The ASM initialize asmdisk /dev/asmdisk/dmdata02 to name DMASMdmdata02
Used time: 9.944(ms).
ASM>create asmdisk '/dev/asmdisk/dmdata03' 'dmdata03'
[Trace]The ASM initialize asmdisk /dev/asmdisk/dmdata03 to name DMASMdmdata03
Used time: 24.132(ms).
ASM>init dcrdisk '/dev/asmdisk/dmdcr01' from '/dmdata/DMDSC/dmdcr_cfg.ini'identified by 'Welcome1'
[Trace]DG 126 alloc one extent for inodes, addr(disk_id, disk_auno, extent_no):(0,0,1).
[Trace]DG 126 allocate 4 extents for file 0xfe000002.
[Trace]DG 126 alloc 4 extents for 0xfe000002, addr(disk_id, disk_auno, extent_no):(0, 0, 2)->(0, 0, 5), need_init = 1.
Used time: 605.772(ms).
ASM>init votedisk '/dev/asmdisk/dmvote01' from '/dmdata/DMDSC/dmdcr_cfg.ini'
[Trace]DG 125 alloc one extent for inodes, addr(disk_id, disk_auno, extent_no):(0,0,1).
[Trace]DG 125 allocate 4 extents for file 0xfd000002.
[Trace]DG 125 alloc 4 extents for 0xfd000002, addr(disk_id, disk_auno, extent_no):(0, 0, 2)->(0, 0, 5), need_init = 1.
Used time: 193.708(ms).
#==============================================================#
启动css和asm服务
#==============================================================#
Starting DmCSSServiceCss: [ OK ]
节点 192.168.2.31 启动成功
Starting DmCSSServiceCss: [ OK ]
节点 192.168.2.32 启动成功
Starting DmASMSvrServiceAsmsvr: [ OK ]
节点 192.168.2.31 启动成功
Starting DmASMSvrServiceAsmsvr: [ OK ]
节点 192.168.2.32 启动成功
#==============================================================#
创建ASM磁盘组
#==============================================================#
DMASMTOOL V8
Used time: 282.296(ms).
ASM>ASM>DMASMTOOL V8
Used time: 121.027(ms).
ASM>ASM>DMASMTOOL V8
Used time: 267.901(ms).
ASM>ASM>DMASMTOOL V8
Used time: 124.944(ms).
ASM>ASM>DMASMTOOL V8
Used time: 221.779(ms).
ASM>ASM>DMASMTOOL V8
Used time: 122.119(ms).
ASM>ASM>DMASMTOOL V8
Used time: 138.208(ms).
ASM>ASM>
#==============================================================#
初始化达梦数据库
#==============================================================#
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2023-11-21
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
log file path: +DMLOG/log/dmdsc0_log01.log
log file path: +DMLOG/log/dmdsc0_log02.log
log file path: +DMLOG/log/dmdsc1_log01.log
log file path: +DMLOG/log/dmdsc1_log02.log
write to dir [+DMDATA/data/DMDSC].
create dm database success. 2022-12-20 19:29:46
数据库初始化完成
#==============================================================#
注册服务并启动数据库
#==============================================================#
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDMDSC.service to /usr/lib/systemd/system/DmServiceDMDSC.service.
创建服务(DmServiceDMDSC)完成
Starting DmServiceDMDSC: connnect dmasmtool successfully.
[ OK ]
节点 192.168.2.31 启动成功
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDMDSC.service to /usr/lib/systemd/system/DmServiceDMDSC.service.
创建服务(DmServiceDMDSC)完成
Starting DmServiceDMDSC: connnect dmasmtool successfully.
[ OK ]
节点 192.168.2.32 启动成功
#==============================================================#
创建数据库归档
#==============================================================#
在节点 192.168.2.31 创建归档
密钥过期时间：2023-11-21
操作已执行
已用时间: 2.846(毫秒). 执行号:0.
操作已执行
已用时间: 123.302(毫秒). 执行号:0.
操作已执行
已用时间: 115.134(毫秒). 执行号:0.
操作已执行
已用时间: 214.685(毫秒). 执行号:0.
操作已执行
已用时间: 10.922(毫秒). 执行号:0.
在节点 192.168.2.32 创建归档
密钥过期时间：2023-11-21
操作已执行
已用时间: 3.013(毫秒). 执行号:0.
操作已执行
已用时间: 111.907(毫秒). 执行号:0.
操作已执行
已用时间: 102.287(毫秒). 执行号:0.
操作已执行
已用时间: 177.707(毫秒). 执行号:0.
操作已执行
已用时间: 52.341(毫秒). 执行号:0.
#==============================================================#
在 192.168.2.32 创建备份
#==============================================================#
密钥过期时间：2023-11-21
NAME DESCRIBE
-------- -------------------------------------------------------------------------------
bak_full 周六全量备份，并删除30天之前的备份。
bak_inc 周日到周五做增量备份,如果失败,清除8天前备份,做全量备份
NAME COMMAND
--------- --------------------------------------------------------------------------------------------------------
bak_clear CALL SF_BAKSET_BACKUP_DIR_ADD('DISK','/dmbak/DMDSC'); CALL SP_DB_BAKSET_REMOVE_BATCH('DISK',SYSDATE-30);
#==============================================================#
优化数据库基础参数
#==============================================================#
密钥过期时间：2023-11-21
DECLARE
mem_per INT := 80; --默认所有的内存归达梦数据库使用，如实际不能100%可用，可以调整此参数
v_mem_mb INT;
v_cpus INT;
memory_pool INT;
memory_n_pools INT;
memory_target INT;
buffer INT;
max_buffer INT;
recycle INT;
cache_pool_size INT;
buffer_pools INT;
recycle_pools INT;
sort_buf_size INT;
sort_buf_global_size INT;
dict_buf_size INT;
hj_buf_size INT;
hagr_buf_size INT;
hj_buf_global_size INT;
hagr_buf_global_size INT;
sort_flag INT;
sort_blk_size INT;
rlog_pool_size INT;
task_threads INT;
io_thr_groups INT;
fast_pool_pages INT := 3000;
fast_roll_pages INT := 1000;
cnt INT;
BEGIN
cnt := 0;
SELECT top 1 n_cpu,
total_phy_size / 1024 / 1024
INTO v_cpus,
v_mem_mb
FROM v$systeminfo;
v_mem_mb := v_mem_mb * (mem_per / 100.0);
v_mem_mb = round(v_mem_mb,-3);
IF v_mem_mb <= 999 THEN
GOTO return_999;
END IF;
IF v_mem_mb > 512000 THEN
v_mem_mb := v_mem_mb * 0.8;
END IF;
memory_target = round(CAST(v_mem_mb * 0.12 AS INT),-3);
task_threads := 4;
io_thr_groups := 4;
IF v_cpus < 8 THEN
task_threads := 4;
io_thr_groups := 2;
END IF;
IF v_cpus >= 64 THEN
v_cpus := 64;
task_threads := 16;
io_thr_groups := 8;
END IF;
buffer := round(CAST(v_mem_mb * 0.4 AS INT),
-3);
max_buffer := buffer;
recycle := CAST(v_mem_mb * 0.04 AS INT);
IF v_mem_mb < 70000 THEN
WITH t AS
(SELECT rownum rn
FROM dual
CONNECT BY LEVEL <= 100),
t1 AS
(SELECT *
FROM t
WHERE rn > 1
MINUS
SELECT ta.rn * tb.rn
FROM t ta,
t tb
WHERE ta.rn <= tb.rn
AND ta.rn > 1
AND tb.rn > 1)
SELECT top 1 rn
INTO buffer_pools
FROM t1
WHERE rn > v_mem_mb / 800
ORDER BY 1;
--设置根据内存情况RECYCLE_POOLS参数
WITH t AS
(SELECT rownum rn
FROM dual
CONNECT BY LEVEL <= 100),
t1 AS
(SELECT *
FROM t
WHERE rn > 1
MINUS
SELECT ta.rn * tb.rn
FROM t ta,
t tb
WHERE ta.rn <= tb.rn
AND ta.rn > 1
AND tb.rn > 1)
SELECT top 1 rn
INTO recycle_pools
FROM t1
WHERE rn > v_mem_mb / 800 / 3
ORDER BY 1;
ELSE
buffer_pools := 101;
recycle_pools := 41;
END IF;
--修改内存池
IF v_mem_mb >= 16000 THEN
IF v_mem_mb = 16000 THEN
memory_pool := 1500;
sort_buf_global_size := 1000;
memory_n_pools := 3;
cache_pool_size := 512;
ELSE
memory_pool := 2000;
sort_buf_global_size := 2000;
memory_n_pools := 11;
cache_pool_size := 1024;
END IF;
fast_pool_pages := 9999;
sort_flag = 0;
sort_blk_size = 1;
sort_buf_size := 10;
rlog_pool_size := 1024;
hj_buf_global_size := least(CAST(v_mem_mb * 0.0625 AS INT),10000);
hagr_buf_global_size := least(CAST(v_mem_mb * 0.0625 AS INT),10000);
hj_buf_size := 250;
hagr_buf_size := 250;
recycle := round(recycle,-3);
IF v_mem_mb >= 64000 THEN
fast_pool_pages := 99999;
fast_roll_pages := 9999;
buffer := buffer - 3000;
max_buffer := buffer;
cache_pool_size := 2048;
rlog_pool_size := 2048;
sort_flag = 1;
sort_blk_size = 1;
sort_buf_size = 50;
sort_buf_global_size = CAST(v_mem_mb * 0.02 AS INT);
hj_buf_global_size := CAST(v_mem_mb * 0.15625 AS INT);
hagr_buf_global_size := CAST(v_mem_mb * 0.04 AS INT);
hj_buf_size := 512;
hagr_buf_size := 512;
memory_n_pools := 59;
END IF;
dict_buf_size := 50;
hj_buf_global_size := round(hj_buf_global_size,-3);
hagr_buf_global_size := round(hagr_buf_global_size,-3);
sort_buf_global_size := round(sort_buf_global_size,-3);
recycle := round(recycle,-3);
ELSE
memory_pool := great(CAST(v_mem_mb * 0.0625 AS INT), 100);
memory_pool := round(memory_pool,-2);
memory_n_pools := 1;
cache_pool_size := 200;
rlog_pool_size := 256;
sort_buf_size := 10;
sort_buf_global_size := 500;
dict_buf_size := 50;
sort_flag = 0;
sort_blk_size = 1;
hj_buf_global_size := great(CAST(v_mem_mb * 0.0625 AS INT),500);
hagr_buf_global_size := great(CAST(v_mem_mb * 0.0625 AS INT),500);
hj_buf_size := great(CAST(v_mem_mb * 0.00625 AS INT),50);
hagr_buf_size := great(CAST(v_mem_mb * 0.00625 AS INT),50);
END IF;
IF NOT EXISTS (select 1 from dba_tables where table_name ='BAK_DMINI_INI') THEN
EXECUTE IMMEDIATE 'CREATE TABLE BAK_DMINI_INI as select *,sysdate uptime from v$dm_ini';
END IF;
--修改cpu相关参数
sp_set_para_value(2,'WORKER_THREADS',v_cpus);
sp_set_para_value(2,'TASK_THREADS',task_threads);
sp_set_para_value(2,'IO_THR_GROUPS',io_thr_groups);
--修改内存池相关参数
sp_set_para_value(2,'MAX_OS_MEMORY',mem_per);
sp_set_para_value(2,'MEMORY_POOL',memory_pool);
sp_set_para_value(2,'MEMORY_N_POOLS',memory_n_pools);
sp_set_para_value(2,'MEMORY_TARGET',memory_target);
--修改内存检测参数为1
sp_set_para_value(2,'MEMORY_MAGIC_CHECK',1);
--非DSC环境将ENABLE_FREQROOTS设置为1,注意DM7 V$instance视图没有dsc_role字段,DM7这部分可以删掉
IF EXISTS (SELECT 1
FROM v$instance
WHERE dsc_role = 'NULL') THEN
sp_set_para_value(2,'ENABLE_FREQROOTS',1);
END IF;
--修改缓冲区相关参数
sp_set_para_value(2,'BUFFER',buffer);
sp_set_para_value(2,'MAX_BUFFER',max_buffer);
sp_set_para_value(2,'BUFFER_POOLS',buffer_pools);
sp_set_para_value(2,'RECYCLE',recycle);
sp_set_para_value(2,'RECYCLE_POOLS',recycle_pools);
--修改fast_pool相关参数
sp_set_para_value(2,'FAST_POOL_PAGES',fast_pool_pages);
sp_set_para_value(2,'FAST_ROLL_PAGES',fast_roll_pages);
--修改HASH相关参数
sp_set_para_value(1,'HJ_BUF_GLOBAL_SIZE',hj_buf_global_size);
sp_set_para_value(1,'HJ_BUF_SIZE',hj_buf_size);
sp_set_para_value(1,'HAGR_BUF_GLOBAL_SIZE',hagr_buf_global_size);
sp_set_para_value(1,'HAGR_BUF_SIZE',hagr_buf_size);
--修改排序相关参数
sp_set_para_value(2,'SORT_FLAG',sort_flag);
sp_set_para_value(2,'SORT_BLK_SIZE',sort_blk_size);
sp_set_para_value(2,'SORT_BUF_SIZE',sort_buf_size);
sp_set_para_value(2,'SORT_BUF_GLOBAL_SIZE',sort_buf_global_size);
--修改其他内存参数
sp_set_para_value(2,'RLOG_POOL_SIZE',rlog_pool_size);
sp_set_para_value(2,'CACHE_POOL_SIZE',cache_pool_size);
sp_set_para_value(2,'DICT_BUF_SIZE',dict_buf_size);
sp_set_para_value(2,'VM_POOL_TARGET',16384);
sp_set_para_value(2,'SESS_POOL_TARGET',16384);
--修改实例相关参数
sp_set_para_value(2,'USE_PLN_POOL',1);
sp_set_para_value(2,'ENABLE_MONITOR',1);
sp_set_para_value(2,'TEMP_SIZE',1024);
sp_set_para_value(2,'TEMP_SPACE_LIMIT',102400);
sp_set_para_value(2,'MAX_SESSIONS',1500);
sp_set_para_value(2,'MAX_SESSION_STATEMENT',20000);
sp_set_para_value(2,'PK_WITH_CLUSTER',0);
sp_set_para_value(2,'ENABLE_ENCRYPT',0);
--修改优化器相关参数
sp_set_para_value(2,'OLAP_FLAG',2);
sp_set_para_value(2,'VIEW_PULLUP_FLAG',1);
sp_set_para_value(2,'OPTIMIZER_MODE',1);
sp_set_para_value(2,'ADAPTIVE_NPLN_FLAG',0);
--开启并行PURGE
sp_set_para_value(2,'PARALLEL_PURGE_FLAG',1);
--开启手动并行
sp_set_para_value(2,'PARALLEL_POLICY',2);
--UNDO_RETENTION如果放大，可以适当调大UNDO_EXTENT_NUM。负载高的时候，减少文件系统的申请/释放操作。
sp_set_para_value(2,'UNDO_EXTENT_NUM',16);
--开启SQL 注入HINT功能
sp_set_para_value(2,'ENABLE_INJECT_HINT',1);
--开启数据异步追踪
SP_SET_PARA_VALUE(1,'SVR_LOG',1);
--开启操作系统认证
sp_set_para_value(2,'ENABLE_LOCAL_OSAUTH',1);
-- 打印出来优化的参数
print ' ';
print '修改cpu相关参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''WORKER_THREADS'','||v_cpus||');';
print 'SP_SET_PARA_VALUE(2,''TASK_THREADS'','||task_threads||');';
print 'SP_SET_PARA_VALUE(2,''IO_THR_GROUPS'','||io_thr_groups||');';
print ' ';
print '修改内存池相关参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''MAX_OS_MEMORY'','||mem_per||');';
print 'SP_SET_PARA_VALUE(2,''MEMORY_POOL'','||memory_pool||');';
print 'SP_SET_PARA_VALUE(2,''MEMORY_N_POOLS'','||memory_n_pools||');';
print 'SP_SET_PARA_VALUE(2,''MEMORY_TARGET'','||memory_target||');';
print ' ';
print '修改缓冲区相关参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''BUFFER'','||buffer||');';
print 'SP_SET_PARA_VALUE(2,''MAX_BUFFER'','||max_buffer||');';
print 'SP_SET_PARA_VALUE(2,''BUFFER_POOLS'','||buffer_pools||');';
print 'SP_SET_PARA_VALUE(2,''RECYCLE'',' ||recycle||');';
print 'SP_SET_PARA_VALUE(2,''RECYCLE_POOLS'','||recycle_pools||');';
print ' ';
print '修改fast_pool相关参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''FAST_POOL_PAGES'','||fast_pool_pages||');';
print 'SP_SET_PARA_VALUE(2,''FAST_ROLL_PAGES'','||fast_roll_pages||');';
print ' ';
print '修改内存检测参数为1: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''MEMORY_MAGIC_CHECK'',1);';
print ' ';
print '非DSC环境将ENABLE_FREQROOTS设置为1,注意DM7 V$instance视图没有dsc_role字段,DM7这部分可以删掉: ';
print ' ';
IF EXISTS (SELECT 1
FROM v$instance
WHERE dsc_role = 'NULL') THEN
print 'SP_SET_PARA_VALUE(2,''ENABLE_FREQROOTS'',1);';
END IF;
print ' ';
print '修改HASH相关参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(1,''HJ_BUF_GLOBAL_SIZE'','||hj_buf_global_size||');';
print 'SP_SET_PARA_VALUE(1,''HJ_BUF_SIZE'','||hj_buf_size||');';
print 'SP_SET_PARA_VALUE(1,''HAGR_BUF_GLOBAL_SIZE'','||hagr_buf_global_size||');';
print 'SP_SET_PARA_VALUE(1,''HAGR_BUF_SIZE'','|| hagr_buf_size||');';
print ' ';
print '修改排序相关参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''SORT_FLAG'','||sort_flag||');';
print 'SP_SET_PARA_VALUE(2,''SORT_BLK_SIZE'','||sort_blk_size||');';
print 'SP_SET_PARA_VALUE(2,''SORT_BUF_SIZE'','||sort_buf_size||');';
print 'SP_SET_PARA_VALUE(2,''SORT_BUF_GLOBAL_SIZE'','||sort_buf_global_size||');';
print ' ';
print '修改其他内存参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''RLOG_POOL_SIZE'','||rlog_pool_size||');';
print 'SP_SET_PARA_VALUE(2,''CACHE_POOL_SIZE'','||cache_pool_size||');';
print 'SP_SET_PARA_VALUE(2,''DICT_BUF_SIZE'','||dict_buf_size||');';
print 'SP_SET_PARA_VALUE(2,''VM_POOL_TARGET'',16384);';
print 'SP_SET_PARA_VALUE(2,''SESS_POOL_TARGET'',16384);';
print ' ';
print '修改实例相关参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''USE_PLN_POOL'',1);';
print 'SP_SET_PARA_VALUE(2,''ENABLE_MONITOR'',1);';
print 'SP_SET_PARA_VALUE(2,''TEMP_SIZE'',1024);';
print 'SP_SET_PARA_VALUE(2,''TEMP_SPACE_LIMIT'',102400);';
print 'SP_SET_PARA_VALUE(2,''MAX_SESSIONS'',1500);';
print 'SP_SET_PARA_VALUE(2,''MAX_SESSION_STATEMENT'',20000);';
print 'SP_SET_PARA_VALUE(2,''PK_WITH_CLUSTER'',0);';
print 'SP_SET_PARA_VALUE(2,''ENABLE_ENCRYPT'',0);';
print ' ';
print '修改优化器相关参数: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''OLAP_FLAG'',2);';
print 'SP_SET_PARA_VALUE(2,''VIEW_PULLUP_FLAG'',1);';
print 'SP_SET_PARA_VALUE(2,''OPTIMIZER_MODE'',1);';
print 'SP_SET_PARA_VALUE(2,''ADAPTIVE_NPLN_FLAG'',0);';
print ' ';
print '开启并行PURGE: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''PARALLEL_PURGE_FLAG'',1);';
print ' ';
print '开启手动并行: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''PARALLEL_POLICY'',2);';
print ' ';
print 'UNDO_RETENTION如果放大，可以适当调大UNDO_EXTENT_NUM。负载高的时候，减少文件系统的申请/释放操作: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''UNDO_EXTENT_NUM'',16);';
print ' ';
print '开启SQL 注入HINT功能: ';
print ' ';
print 'SP_SET_PARA_VALUE(2,''ENABLE_INJECT_HINT'',1);';
print ' ';
print '开启数据异步追踪: ';
print ' ';
print 'SP_SET_PARA_VALUE(1,''SVR_LOG'',1);';
print ' ';
print '开启操作系统认证: ';
print ' ';
print 'sp_set_para_value(2,''ENABLE_LOCAL_OSAUTH'',1);';
print ' ';
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,substr(' 执行失败, ' || SQLCODE || ' ' || SQLERRM || ' ' || dbms_utility.format_error_backtrace,1,400));
<<return_999>>
NULL;
END;
[-20001]: 执行失败, -838 非法的配置参数值 -838: anonymous block line 188
.
重启数据库，优化参数生效
关闭数据库
[monitor] 2022-12-20 19:30:44: CSS MONITOR V8
[monitor] 2022-12-20 19:30:44: CSS MONITOR SYSTEM IS READY.
[monitor] 2022-12-20 19:30:44: Wait CSS Control Node choosed...
[monitor] 2022-12-20 19:30:45: Wait CSS Control Node choosed succeed.
[monitor] 2022-12-20 19:30:46: 组(GRP_DMDSC)中节点对应的CSS自动拉起标记已经处于关闭状态
[monitor] 2022-12-20 19:30:46: 通知CSS(seqno:0)执行EP STOP(GRP_DMDSC)
[monitor] 2022-12-20 19:30:53: 通知当前活动的CSS执行清理操作
[monitor] 2022-12-20 19:30:54: 清理CSS(0)请求成功
[monitor] 2022-12-20 19:30:54: 清理CSS(1)请求成功
[monitor] 2022-12-20 19:30:54: 命令EP STOP GRP_DMDSC执行成功
启动数据库
[monitor] 2022-12-20 19:31:00: CSS MONITOR V8
[monitor] 2022-12-20 19:31:00: CSS MONITOR SYSTEM IS READY.
[monitor] 2022-12-20 19:31:00: Wait CSS Control Node choosed...
[monitor] 2022-12-20 19:31:01: Wait CSS Control Node choosed succeed.
[monitor] 2022-12-20 19:31:01: 通知CSS(seqno:0)执行EP STARTUP(DMDSC0)
[monitor] 2022-12-20 19:31:10: 通知CSS(seqno:0)执行EP STARTUP(DMDSC0)成功
[monitor] 2022-12-20 19:31:10: 通知CSS(seqno:1)执行EP STARTUP(DMDSC1)
[monitor] 2022-12-20 19:31:19: 通知CSS(seqno:1)执行EP STARTUP(DMDSC1)成功
[monitor] 2022-12-20 19:31:19: 通知CSS(seqno:0)打开节点(DMDSC0)的自动拉起功能
[monitor] 2022-12-20 19:31:19: 通知CSS(seqno:0)打开节点(DMDSC0)的自动拉起功能成功
[monitor] 2022-12-20 19:31:19: 通知CSS(seqno:1)打开节点(DMDSC1)的自动拉起功能
[monitor] 2022-12-20 19:31:19: 通知CSS(seqno:1)打开节点(DMDSC1)的自动拉起功能成功
[monitor] 2022-12-20 19:31:19: 打开CSS自动拉起功能成功
[monitor] 2022-12-20 19:31:19: 通知当前活动的CSS执行清理操作
[monitor] 2022-12-20 19:31:19: 清理CSS(0)请求成功
[monitor] 2022-12-20 19:31:20: 清理CSS(1)请求成功
[monitor] 2022-12-20 19:31:20: 命令EP STARTUP GRP_DMDSC执行成功
#==============================================================#
创建DMDBA用户，密码：SYSDBA
#==============================================================#
密钥过期时间：2023-11-21
USERNAME
----------
SYSAUDITOR
SYSSSO
SYSDBA
DMDBA
SYS
#==============================================================#
查询数据库优化结果：
#==============================================================#
密钥过期时间：2023-11-21
PARA_NAME DEFAULT_VALUE PARA_VALUE
--------------------- ------------- ----------
MAX_OS_MEMORY 100 80
MAX_SESSION_STATEMENT 10000 10000
TRX_VIEW_MODE 1 1
MAX_SESSIONS 10000 10000
IO_THR_GROUPS 8 2
ADAPTIVE_NPLN_FLAG 3 3
OPTIMIZER_MODE 1 1
TOP_DIS_HASH_FLAG 1 1
TOP_ORDER_OPT_FLAG 0 0
VIEW_PULLUP_FLAG 0 0
USE_PLN_POOL 1 1
TASK_THREADS 16 16
WORKER_THREADS 16 1
SESS_POOL_TARGET 16384 16384
SESS_POOL_SIZE 64 64
VM_POOL_TARGET 16384 16384
DICT_BUF_SIZE 50 50
HAGR_BUF_SIZE 500 500
HAGR_BUF_GLOBAL_SIZE 5000 5000
HJ_BUF_SIZE 500 500
HJ_BUF_GLOBAL_SIZE 5000 5000
SORT_FLAG 0 0
SORT_BUF_GLOBAL_SIZE 1000 1000
SORT_BLK_SIZE 1 1
SORT_BUF_SIZE 20 20
MAX_BUFFER 1000 1000
RECYCLE_POOLS 3 3
RECYCLE 300 300
BUFFER_POOLS 9 9
BUFFER 1000 1000
MEMORY_MAGIC_CHECK 1 1
MEMORY_TARGET 15000 0
MEMORY_N_POOLS 1 1
MEMORY_POOL 500 200
PK_WITH_CLUSTER 0 0
ENABLE_MONITOR 1 1
SVR_LOG 0 0
DATETIME_FMT_MODE 0 0
COMPATIBLE_MODE 0 0
CLOB_LIKE_MAX_LEN 10240 10240
ENABLE_ENCRYPT 0 0
REDOS_PARALLEL_NUM 1 1
RLOG_POOL_SIZE 256 256
CACHE_POOL_SIZE 100 100
TEMP_SPACE_LIMIT 0 0
TEMP_SIZE 10 10
OLAP_FLAG 2 2
恭喜您，达梦数据库DMDSC已经安装完成！
[root@centos7 soft]# su - dmdba
[dmdba@dsc01:~]$ ls
scripts
[dmdba@dsc01:~]$ dmcssm /dmdata/DMDSC/dmcssm.ini
[monitor] 2022-12-20 19:32:06: CSS MONITOR V8
[monitor] 2022-12-20 19:32:06: CSS MONITOR SYSTEM IS READY.
[monitor] 2022-12-20 19:32:06: Wait CSS Control Node choosed...
[monitor] 2022-12-20 19:32:07: Wait CSS Control Node choosed succeed.
show
monitor current time:2022-12-20 19:32:09, n_group:3
=================== group[name = GRP_CSS, seq = 0, type = CSS, Control Node = 0] ========================================
[CSS0] auto check = TRUE, global info:
[ASM0] auto restart = FALSE
[DMDSC0] auto restart = TRUE
[CSS1] auto check = TRUE, global info:
[ASM1] auto restart = FALSE
[DMDSC1] auto restart = TRUE
ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts
2022-12-20 19:32:08 CSS0 0 12345 Control Node OPEN WORKING OK TRUE 614477 614741
2022-12-20 19:32:08 CSS1 1 12345 Normal Node OPEN WORKING OK TRUE 621934 622179
=================== group[name = GRP_ASM, seq = 1, type = ASM, Control Node = 0] ========================================
n_ok_ep = 2
ok_ep_arr(index, seqno):
(0, 0)
(1, 1)
sta = OPEN, sub_sta = STARTUP
break ep = NULL
recover ep = NULL
crash process over flag is TRUE
ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts
2022-12-20 19:32:08 ASM0 0 12346 Control Node OPEN WORKING OK TRUE 628990 629212
2022-12-20 19:32:08 ASM1 1 12346 Normal Node OPEN WORKING OK TRUE 636425 636626
=================== group[name = GRP_DMDSC, seq = 2, type = DB, Control Node = 0] ========================================
n_ok_ep = 2
ok_ep_arr(index, seqno):
(0, 0)
(1, 1)
sta = OPEN, sub_sta = STARTUP
break ep = NULL
recover ep = NULL
crash process over flag is TRUE
ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts
2022-12-20 19:32:08 DMDSC0 0 5236 Control Node OPEN WORKING OK TRUE 1445578 1445637
2022-12-20 19:32:08 DMDSC1 1 5236 Normal Node OPEN WORKING OK TRUE 1452749 1452799
==================================================================================================================
exit
[dmdba@dsc01:~]$ exit
登出
[END] 2022/12/20 12:27:45
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手