1 Star 0 Fork 42

Zeratul/DMShellInstall

forked from hnyuanzj/DMShellInstall 
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
两节点多链路聚合DSC集群(ASM镜像).log 139.60 KB
一键复制 编辑 原始数据 按行查看 历史
hnyuanzj 提交于 2024-04-21 22:18 . 提交日志更改
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402
sh /soft/DMShellInstall -di dm8_20231023_x86_rh6_64.iso -d /opt/dmdbms -rp 123456 -hn dsc -dpi 192.168.2.31,192.168.2.32 -dmi 172.16.2.31,172.16.2.32 -dcd /dev/sdk,/dev/sdl,/dev/sdo -ard /dev/sde,/dev/sdg,/dev/sdi -dad /dev/sdu -ar 3 -iso N -mtp Y -fmd N
达梦数据库安装部署类型: dscm

#==============================================================#
校验IP地址和磁盘
#==============================================================#

校验 192.168.2.31 192.168.2.32 地址,请等待!!!
校验 172.16.2.31 172.16.2.32 地址,请等待!!!
校验 /dev/sdk,/dev/sdl,/dev/sdo 磁盘,请等待!!!

校验 /dev/sde,/dev/sdg,/dev/sdi 磁盘,请等待!!!

校验 /dev/sdu 磁盘,请等待!!!

#==============================================================#
配置 OS 用户互信
#==============================================================#

Generating public/private rsa key pair.
Your identification has been saved in /root/.ssh/id_rsa.
Your public key has been saved in /root/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:deWD6YX7U/U6id3VRR72MIhw7o66zS2Qc8fu9fVvYdc root@centos7
The key's randomart image is:
+---[RSA 2048]----+
| .... .+o.|
| o. .*.=o|
| o = + =|
| o o o .=|
| .S.. o *|
| + .oo + BE|
| +.o. o O =|
| +.... . +o|
| o.ooo ..+|
+----[SHA256]-----+
#==============================================================#
拷贝脚本以及安装包到部署节点
#==============================================================#

拷贝脚本以及安装包到节点:192.168.2.32

#==============================================================#
配置节点: 192.168.2.31
#==============================================================#

节点 192.168.2.31 开始配置:

#==============================================================#
打印系统信息
#==============================================================#

服务器时间:

2024年 04月 21日 星期日 22:02:32 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"
内核信息:

Linux version 3.10.0-1160.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-44) (GCC) ) #1 SMP Mon Oct 19 16:18:59 UTC 2020
服务器属性:

vmware
cpu信息:

型号名称 :Intel(R) Core(TM) i7-8565U CPU @ 1.80GHz
物理 CPU 个数 :1
每个物理 CPU 的逻辑核数 :1
系统的 CPU 线程数 :1

内存信息:

total used free shared buff/cache available
Mem: 3770 303 2341 11 1125 3222
Swap: 8191 0 8191
total used free shared buff/cache available
Mem: 3.7G 303M 2.3G 11M 1.1G 3.1G
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 1.9G 0 1.9G 0% /dev
tmpfs 1.9G 0 1.9G 0% /dev/shm
tmpfs 1.9G 12M 1.9G 1% /run
tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup
/dev/mapper/centos-root 91G 2.6G 89G 3% /
/dev/sr0 4.4G 4.4G 0 100% /mnt/cdrom
/dev/sda1 1014M 151M 864M 15% /boot
tmpfs 378M 0 378M 0% /run/user/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)
4月 21 21:59:11 centos7 systemd[1]: Starting firewalld - dynamic firewall daemon...
4月 21 21:59:11 centos7 systemd[1]: Started firewalld - dynamic firewall daemon.
4月 21 21:59:12 centos7 firewalld[715]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.
4月 21 22:02:32 centos7 systemd[1]: Stopping firewalld - dynamic firewall daemon...
4月 21 22:02:33 centos7 systemd[1]: Stopped firewalld - dynamic firewall daemon.
#==============================================================#
禁用 SELinux
#==============================================================#

SELinux 正在强制执行,现在将其设置为禁用
SELinux 已被设置为禁用,请重启系统以使更改生效
#==============================================================#
调整 SWAP 分区
#==============================================================#

total used free shared buff/cache available
Mem: 3770 279 2365 11 1125 3246
Swap: 8191 0 8191
/dev/mapper/centos-swap swap swap defaults 0 0
#==============================================================#
禁用透明大页 & 禁用NUMA & 开启 I/0 schedule
#==============================================================#

args="ro crashkernel=auto spectre_v2=retpoline rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet LANG=zh_CN.UTF-8 transparent_hugepage=never elevator=deadline numa=off"
-crashkernel=auto
-args="ro
args="ro crashkernel=auto spectre_v2=retpoline rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet transparent_hugepage=never elevator=deadline numa=off"
-transparent_hugepage=never
-quiet
#==============================================================#
配置内核参数和资源
#==============================================================#

fs.aio-max-nr = 1048576
fs.file-max = 6815744
fs.nr_open = 20480000
kernel.core_pattern = /dmbak/core.%e.%p.%t
kernel.panic_on_oops = 1
kernel.numa_balancing = 0
kernel.randomize_va_space = 2
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.tcp_retries2 = 3
net.ipv4.tcp_fin_timeout = 5
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_timestamps = 1
net.ipv4.tcp_rmem = 8192 87380 16777216
net.ipv4.tcp_wmem = 8192 65536 16777216
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.swappiness = 10
vm.min_free_kbytes = 19306
vm.overcommit_memory = 0
vm.zone_reclaim_mode = 0
#==============================================================#
配置系统资源
#==============================================================#

# DMBegin
* hard core 0
* soft core 0
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft nproc 10240
dmdba hard nproc 10240
dmdba soft nofile 65536
dmdba hard nofile 65536
dmdba hard data unlimited
dmdba soft data unlimited
dmdba hard fsize unlimited
dmdba soft fsize unlimited
dmdba soft stack 65536
dmdba hard stack 65536
# DMEnd
# DMBegin
session required pam_limits.so
session required /lib64/security/pam_limits.so
# DMEnd
#==============================================================#
配置文件数和进程数限制
#==============================================================#

DefaultLimitCORE=infinity
DefaultLimitNOFILE=65536
DefaultLimitNPROC=10240
# DMBegin
dmdba soft nproc 65536
dmdba hard nproc 65536
# DMEnd
#==============================================================#
禁用 RemoveIPC
#==============================================================#

# DMBegin
RemoveIPC=no
# DMEnd
#==============================================================#
配置cache脚本
#==============================================================#

#!/bin/bash
sync
echo 1 > /proc/sys/vm/drop_caches
* 6 * * * root /root/drop_cache.sh
#==============================================================#
配置/etc/profile
#==============================================================#

export LANG=zh_CN.UTF-8
export MALLOC_ARENA_MAX=4
#==============================================================#
配置主机名
#==============================================================#

Static hostname: dsc01
Icon name: computer-vm
Chassis: vm
Machine ID: f4a41440d98d417dbb5516d46b966467
Boot ID: 49eed8b4b61a442b9f8213139b403235
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
#==============================================================#
创建 DMDBA 用户
#==============================================================#

dmdba:x:56781:56781::/home/dmdba:/bin/bash
uid=56781(dmdba) gid=56781(dinstall) 组=56781(dinstall),56782(dmdba)
#==============================================================#
配置用户环境变量
#==============================================================#

if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
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="[\u@\h:\w]$ "
alias dmbin="cd $DM_HOME/bin"
alias dmlog="cd $DM_HOME/log"
alias dmdata="cd /dmdata/DSC"
alias ds="disql -L SYSDBA/'\"SYSDBA\"':5236"
alias dsql="disql -L -S SYSDBA/'\"SYSDBA\"':5236"
alias dssql="disql -L -S SYSDBA/'\"SYSDBA\"':5236"
#==============================================================#
挂载DMISO
#==============================================================#

总用量 834M
-r-xr-xr-x. 1 root root 2.5M 10月 23 09:55 DM8 Install.pdf
-r-xr-xr-x. 1 root root 832M 10月 23 09:58 DMInstall.bin
#==============================================================#
开始安装达梦数据库软件
#==============================================================#

解压安装程序[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25h
2024-04-21 22:03:15
[INFO] 安装达梦数据库...
2024-04-21 22:03:15
[INFO] 安装 基础 模块...
2024-04-21 22:03:23
[INFO] 安装 服务器 模块...
2024-04-21 22:03:24
[INFO] 安装 客户端 模块...
2024-04-21 22:03:30
[INFO] 安装 驱动 模块...
2024-04-21 22:03:33
[INFO] 安装 手册 模块...
2024-04-21 22:03:34
[INFO] 安装 服务 模块...
2024-04-21 22:03:34
[INFO] 移动日志文件。
2024-04-21 22:03:35
[INFO] 正在启动DmAPService服务...
2024-04-21 22:03:36
[INFO] 启动DmAPService服务成功。
2024-04-21 22:03:36
[INFO] 安装达梦数据库完成。
[?25h
#==============================================================#
创建UDEV规则文件,并启动UDEV
#==============================================================#

文件 /etc/multipath.conf 的内容为:
defaults {
polling_interval 30
failback immediate
no_path_retry 5
rr_min_io 100
path_checker tur
user_friendly_names yes
}
blacklist {
devnode "^(ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*"
devnode "^(hd|xvd|vd)[a-z]*"
}
multipaths {
multipath {
wwid "36001405716c01510c5c448f801989e89"
alias dmdcrv01
}
multipath {
wwid "36001405d0e3c3a9b2874cc6aad8ef901"
alias dmdcrv02
}
multipath {
wwid "3600140500b7852874dc402f8ff46337c"
alias dmdcrv03
}
multipath {
wwid "360014055454318b20a044448d2be00dc"
alias dmarch01
}
multipath {
wwid "360014056995ce6cb1d94084a72064522"
alias dmarch02
}
multipath {
wwid "360014051b4be89b555d48f58dabde17f"
alias dmarch03
}
multipath {
wwid "360014054acb36c500304a4f950e2ae95"
alias dmdata01
}
}
devices {
device {
path_grouping_policy group_by_prio
prio alua #failover
}
}
文件 /etc/udev/rules.d/12-dm-permissions.rules 的内容为:
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405716c01510c5c448f801989e89", SYMLINK+="asmdisk/dmdcrv01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405d0e3c3a9b2874cc6aad8ef901", SYMLINK+="asmdisk/dmdcrv02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600140500b7852874dc402f8ff46337c", SYMLINK+="asmdisk/dmdcrv03", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014055454318b20a044448d2be00dc", SYMLINK+="asmdisk/dmarch01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014056995ce6cb1d94084a72064522", SYMLINK+="asmdisk/dmarch02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014051b4be89b555d48f58dabde17f", SYMLINK+="asmdisk/dmarch03", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014054acb36c500304a4f950e2ae95", SYMLINK+="asmdisk/dmdata01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
#==============================================================#
查看multipath聚合磁盘
#==============================================================#

Apr 21 22:03:43 | dmarch03: map in use
Apr 21 22:03:43 | failed to remove multipath map dmarch03
mpathc (36001405b0ccc91e5cdd4c4b9ce6cc7d0) dm-4 LIO-ORG ,data3
size=9.3G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:2 sdp 8:240 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:2 sdr 65:16 active ready running
mpathb (36001405c3cbda6d685747b1a5b649ee3) dm-3 LIO-ORG ,data2
size=1.9G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:1 sds 65:32 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:1 sdt 65:48 active ready running
mpatha (36001405f5c51be3913d41f58ceb59dd5) dm-2 LIO-ORG ,data1
size=1.9G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:0 sdc 8:32 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:0 sdd 8:48 active ready running
dmdcrv03 (3600140500b7852874dc402f8ff46337c) dm-5 LIO-ORG ,data4
size=9.3G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:3 sdo 8:224 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:3 sdq 65:0 active ready running
dmarch03 (360014051b4be89b555d48f58dabde17f) dm-8 LIO-ORG ,data7
size=19G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=enabled
| `- 3:0:0:6 sdj 8:144 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:6 sdi 8:128 active ready running
dmdcrv02 (36001405d0e3c3a9b2874cc6aad8ef901) dm-6 LIO-ORG ,data5
size=9.3G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:4 sdl 8:176 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:4 sdn 8:208 active ready running
dmarch02 (360014056995ce6cb1d94084a72064522) dm-9 LIO-ORG ,data8
size=19G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:7 sdh 8:112 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:7 sdg 8:96 active ready running
dmdcrv01 (36001405716c01510c5c448f801989e89) dm-7 LIO-ORG ,data6
size=9.3G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:5 sdk 8:160 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:5 sdm 8:192 active ready running
dmarch01 (360014055454318b20a044448d2be00dc) dm-10 LIO-ORG ,data9
size=19G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:8 sde 8:64 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:8 sdf 8:80 active ready running
dmdata01 (360014054acb36c500304a4f950e2ae95) dm-11 LIO-ORG ,data10
size=113G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:9 sdu 65:64 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:9 sdv 65:80 active ready running
#==============================================================#
查看udev磁盘
#==============================================================#

总用量 0
lrwxrwxrwx. 1 root root 8 4月 21 22:03 dmarch01 -> ../dm-10
lrwxrwxrwx. 1 root root 7 4月 21 22:03 dmarch02 -> ../dm-9
lrwxrwxrwx. 1 root root 7 4月 21 22:03 dmarch03 -> ../dm-8
lrwxrwxrwx. 1 root root 8 4月 21 22:03 dmdata01 -> ../dm-11
lrwxrwxrwx. 1 root root 7 4月 21 22:03 dmdcrv01 -> ../dm-7
lrwxrwxrwx. 1 root root 7 4月 21 22:03 dmdcrv02 -> ../dm-6
lrwxrwxrwx. 1 root root 7 4月 21 22:03 dmdcrv03 -> ../dm-5
#==============================================================#
正在创建用于DSC的参数文件 DSC
#==============================================================#

总用量 16K
-rw-r--r--. 1 dmdba dinstall 268 4月 21 22:03 dmasvrmal.ini
-rw-r--r--. 1 dmdba dinstall 164 4月 21 22:03 dmcssm.ini
-rw-r--r--. 1 dmdba dinstall 895 4月 21 22:03 dmdcr_cfg.ini
-rw-r--r--. 1 dmdba dinstall 393 4月 21 22:03 dmdcr.ini
#==============================================================#
注册css和asm服务
#==============================================================#

创建服务(DmCSSServiceCss)完成
创建服务(DmASMSvrmServiceAsmsvr)完成
#==============================================================#
创建归档和备份脚本
#==============================================================#

创建数据库归档脚本:

-rw-r--r--. 1 dmdba dinstall 336 4月 21 22:03 /home/dmdba/scripts/conf_arch.sql
创建数据库备份脚本:

-rw-r--r--. 1 dmdba dinstall 1.5K 4月 21 22:03 /home/dmdba/scripts/conf_fullbackup.sql
-rw-r--r--. 1 dmdba dinstall 2.3K 4月 21 22:03 /home/dmdba/scripts/conf_incrbackup.sql
-rw-r--r--. 1 dmdba dinstall 1.5K 4月 21 22:03 /home/dmdba/scripts/check_backup.sql
创建 DMDBA 用户脚本,密码 SYSDBA :

-rw-r--r--. 1 dmdba dinstall 553 4月 21 22:03 /home/dmdba/scripts/create_user.sql
#==============================================================#
创建达梦数据库优化脚本
#==============================================================#

创建数据库参数配置脚本:

-rw-r--r--. 1 dmdba dinstall 20K 4月 21 22:03 /home/dmdba/scripts/conf_dmini.sql
创建数据库优化结果查询脚本:

-rw-r--r--. 1 dmdba dinstall 4.9K 4月 21 22:03 /home/dmdba/scripts/query_dmini.sql
创建数据库搜集统计信息脚本:

-rw-r--r--. 1 dmdba dinstall 1.8K 4月 21 22:03 /home/dmdba/scripts/conf_statistics.sql
#==============================================================#
配置节点: 192.168.2.32
#==============================================================#

节点 192.168.2.32 开始配置:

███████ ████ ████ ████████ ██ ██ ██ ██ ██ ██ ██
░██░░░░██ ░██░██ ██░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██
░██ ░██░██░░██ ██ ░██░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██
░██ ░██░██ ░░███ ░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██
░██ ░██░██ ░░█ ░██░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██
░██ ██ ░██ ░ ░██ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██
░███████ ░██ ░██ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███
░░░░░░░ ░░ ░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░
#==============================================================#
打印系统信息
#==============================================================#

服务器时间:

2024年 04月 21日 星期日 22:03:50 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"
内核信息:

Linux version 3.10.0-1160.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-44) (GCC) ) #1 SMP Mon Oct 19 16:18:59 UTC 2020
服务器属性:

vmware
cpu信息:

型号名称 :Intel(R) Core(TM) i7-8565U CPU @ 1.80GHz
物理 CPU 个数 :1
每个物理 CPU 的逻辑核数 :1
系统的 CPU 线程数 :1

内存信息:

total used free shared buff/cache available
Mem: 3770 295 2465 11 1009 3232
Swap: 8191 0 8191
total used free shared buff/cache available
Mem: 3.7G 295M 2.4G 11M 1.0G 3.2G
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 1.9G 0 1.9G 0% /dev
tmpfs 1.9G 0 1.9G 0% /dev/shm
tmpfs 1.9G 12M 1.9G 1% /run
tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup
/dev/mapper/centos-root 91G 2.5G 89G 3% /
/dev/sr0 4.4G 4.4G 0 100% /mnt/cdrom
/dev/sda1 1014M 151M 864M 15% /boot
tmpfs 378M 0 378M 0% /run/user/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)
4月 21 21:59:19 centos7 systemd[1]: Starting firewalld - dynamic firewall daemon...
4月 21 21:59:20 centos7 systemd[1]: Started firewalld - dynamic firewall daemon.
4月 21 21:59:20 centos7 firewalld[713]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.
4月 21 22:03:50 centos7 systemd[1]: Stopping firewalld - dynamic firewall daemon...
4月 21 22:03:50 centos7 systemd[1]: Stopped firewalld - dynamic firewall daemon.
#==============================================================#
禁用 SELinux
#==============================================================#

SELinux 正在强制执行,现在将其设置为禁用
SELinux 已被设置为禁用,请重启系统以使更改生效
#==============================================================#
调整 SWAP 分区
#==============================================================#

total used free shared buff/cache available
Mem: 3770 271 2489 11 1009 3256
Swap: 8191 0 8191
/dev/mapper/centos-swap swap swap defaults 0 0
#==============================================================#
禁用透明大页 & 禁用NUMA & 开启 I/0 schedule
#==============================================================#

args="ro crashkernel=auto spectre_v2=retpoline rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet LANG=zh_CN.UTF-8 transparent_hugepage=never elevator=deadline numa=off"
-crashkernel=auto
-args="ro
args="ro crashkernel=auto spectre_v2=retpoline rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet transparent_hugepage=never elevator=deadline numa=off"
-transparent_hugepage=never
-quiet
#==============================================================#
配置内核参数和资源
#==============================================================#

sysctl: cannot stat /proc/sys/vm/numa_stat: 没有那个文件或目录
fs.aio-max-nr = 1048576
fs.file-max = 6815744
fs.nr_open = 20480000
kernel.core_pattern = /dmbak/core.%e.%p.%t
kernel.panic_on_oops = 1
kernel.numa_balancing = 0
kernel.randomize_va_space = 2
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.tcp_retries2 = 3
net.ipv4.tcp_fin_timeout = 5
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_timestamps = 1
net.ipv4.tcp_rmem = 8192 87380 16777216
net.ipv4.tcp_wmem = 8192 65536 16777216
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.swappiness = 10
vm.min_free_kbytes = 19306
vm.overcommit_memory = 0
vm.zone_reclaim_mode = 0
#==============================================================#
配置系统资源
#==============================================================#

# DMBegin
* hard core 0
* soft core 0
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft nproc 10240
dmdba hard nproc 10240
dmdba soft nofile 65536
dmdba hard nofile 65536
dmdba hard data unlimited
dmdba soft data unlimited
dmdba hard fsize unlimited
dmdba soft fsize unlimited
dmdba soft stack 65536
dmdba hard stack 65536
# DMEnd
# DMBegin
session required pam_limits.so
session required /lib64/security/pam_limits.so
# DMEnd
#==============================================================#
配置文件数和进程数限制
#==============================================================#

DefaultLimitCORE=infinity
DefaultLimitNOFILE=65536
DefaultLimitNPROC=10240
# DMBegin
dmdba soft nproc 65536
dmdba hard nproc 65536
# DMEnd
#==============================================================#
禁用 RemoveIPC
#==============================================================#

# DMBegin
RemoveIPC=no
# DMEnd
#==============================================================#
配置cache脚本
#==============================================================#

no crontab for root
#!/bin/bash
sync
echo 1 > /proc/sys/vm/drop_caches
* 6 * * * root /root/drop_cache.sh
#==============================================================#
配置/etc/profile
#==============================================================#

export LANG=zh_CN.UTF-8
export MALLOC_ARENA_MAX=4
#==============================================================#
配置主机名
#==============================================================#

Static hostname: dsc02
Icon name: computer-vm
Chassis: vm
Machine ID: f4a41440d98d417dbb5516d46b966467
Boot ID: 0a32470efdd840b4b0da81601e478ff7
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
#==============================================================#
创建 DMDBA 用户
#==============================================================#

dmdba:x:56781:56781::/home/dmdba:/bin/bash
uid=56781(dmdba) gid=56781(dinstall) 组=56781(dinstall),56782(dmdba)
#==============================================================#
配置用户环境变量
#==============================================================#

if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
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="[\u@\h:\w]$ "
alias dmbin="cd $DM_HOME/bin"
alias dmlog="cd $DM_HOME/log"
alias dmdata="cd /dmdata/DSC"
alias ds="disql -L SYSDBA/'\"SYSDBA\"':5236"
alias dsql="disql -L -S SYSDBA/'\"SYSDBA\"':5236"
alias dssql="disql -L -S SYSDBA/'\"SYSDBA\"':5236"
#==============================================================#
挂载DMISO
#==============================================================#

总用量 834M
-r-xr-xr-x. 1 root root 2.5M 10月 23 09:55 DM8 Install.pdf
-r-xr-xr-x. 1 root root 832M 10月 23 09:58 DMInstall.bin
#==============================================================#
开始安装达梦数据库软件
#==============================================================#

解压安装程序[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l.[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l[?25l [?25l[?25l.[?25l.[?25l.[?25l.[?25h
2024-04-21 22:04:33
[INFO] 安装达梦数据库...
2024-04-21 22:04:34
[INFO] 安装 基础 模块...
2024-04-21 22:04:38
[INFO] 安装 服务器 模块...
2024-04-21 22:04:40
[INFO] 安装 客户端 模块...
2024-04-21 22:04:42
[INFO] 安装 驱动 模块...
2024-04-21 22:04:48
[INFO] 安装 手册 模块...
2024-04-21 22:04:49
[INFO] 安装 服务 模块...
2024-04-21 22:04:49
[INFO] 移动日志文件。
2024-04-21 22:04:50
[INFO] 正在启动DmAPService服务...
2024-04-21 22:04:50
[INFO] 启动DmAPService服务成功。
2024-04-21 22:04:50
[INFO] 安装达梦数据库完成。
[?25h
#==============================================================#
拷贝UDEV规则文件,并启动UDEV
#==============================================================#

文件 /etc/multipath.conf 的内容为:
defaults {
polling_interval 30
failback immediate
no_path_retry 5
rr_min_io 100
path_checker tur
user_friendly_names yes
}
blacklist {
devnode "^(ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*"
devnode "^(hd|xvd|vd)[a-z]*"
}
multipaths {
multipath {
wwid "36001405716c01510c5c448f801989e89"
alias dmdcrv01
}
multipath {
wwid "36001405d0e3c3a9b2874cc6aad8ef901"
alias dmdcrv02
}
multipath {
wwid "3600140500b7852874dc402f8ff46337c"
alias dmdcrv03
}
multipath {
wwid "360014055454318b20a044448d2be00dc"
alias dmarch01
}
multipath {
wwid "360014056995ce6cb1d94084a72064522"
alias dmarch02
}
multipath {
wwid "360014051b4be89b555d48f58dabde17f"
alias dmarch03
}
multipath {
wwid "360014054acb36c500304a4f950e2ae95"
alias dmdata01
}
}
devices {
device {
path_grouping_policy group_by_prio
prio alua #failover
}
}
文件 /etc/udev/rules.d/12-dm-permissions.rules 的内容为:
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405716c01510c5c448f801989e89", SYMLINK+="asmdisk/dmdcrv01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-36001405d0e3c3a9b2874cc6aad8ef901", SYMLINK+="asmdisk/dmdcrv02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600140500b7852874dc402f8ff46337c", SYMLINK+="asmdisk/dmdcrv03", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014055454318b20a044448d2be00dc", SYMLINK+="asmdisk/dmarch01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014056995ce6cb1d94084a72064522", SYMLINK+="asmdisk/dmarch02", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014051b4be89b555d48f58dabde17f", SYMLINK+="asmdisk/dmarch03", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-360014054acb36c500304a4f950e2ae95", SYMLINK+="asmdisk/dmdata01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
#==============================================================#
查看multipath聚合磁盘
#==============================================================#

Apr 21 22:04:56 | mpathc: map in use
Apr 21 22:04:59 | failed to remove multipath map mpathc
mpathc (36001405b0ccc91e5cdd4c4b9ce6cc7d0) dm-4 LIO-ORG ,data3
size=9.3G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=enabled
| `- 3:0:0:2 sds 65:32 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:2 sdp 8:240 active ready running
mpathb (36001405c3cbda6d685747b1a5b649ee3) dm-3 LIO-ORG ,data2
size=1.9G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:1 sdu 65:64 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:1 sdq 65:0 active ready running
mpatha (36001405f5c51be3913d41f58ceb59dd5) dm-2 LIO-ORG ,data1
size=1.9G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:0 sdd 8:48 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:0 sdc 8:32 active ready running
dmdcrv03 (3600140500b7852874dc402f8ff46337c) dm-5 LIO-ORG ,data4
size=9.3G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:3 sdr 65:16 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:3 sdm 8:192 active ready running
dmarch03 (360014051b4be89b555d48f58dabde17f) dm-8 LIO-ORG ,data7
size=19G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:6 sdl 8:176 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:6 sdi 8:128 active ready running
dmdcrv02 (36001405d0e3c3a9b2874cc6aad8ef901) dm-6 LIO-ORG ,data5
size=9.3G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:4 sdo 8:224 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:4 sdk 8:160 active ready running
dmarch02 (360014056995ce6cb1d94084a72064522) dm-9 LIO-ORG ,data8
size=19G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:7 sdh 8:112 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:7 sdf 8:80 active ready running
dmdcrv01 (36001405716c01510c5c448f801989e89) dm-7 LIO-ORG ,data6
size=9.3G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:5 sdn 8:208 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:5 sdj 8:144 active ready running
dmarch01 (360014055454318b20a044448d2be00dc) dm-10 LIO-ORG ,data9
size=19G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:8 sdg 8:96 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:8 sde 8:64 active ready running
dmdata01 (360014054acb36c500304a4f950e2ae95) dm-11 LIO-ORG ,data10
size=113G features='1 queue_if_no_path' hwhandler='0' wp=rw
|-+- policy='service-time 0' prio=1 status=active
| `- 3:0:0:9 sdv 65:80 active ready running
`-+- policy='service-time 0' prio=1 status=enabled
`- 4:0:0:9 sdt 65:48 active ready running
#==============================================================#
查看udev磁盘
#==============================================================#

总用量 0
lrwxrwxrwx. 1 root root 8 4月 21 22:05 dmarch01 -> ../dm-10
lrwxrwxrwx. 1 root root 7 4月 21 22:05 dmarch02 -> ../dm-9
lrwxrwxrwx. 1 root root 7 4月 21 22:05 dmarch03 -> ../dm-8
lrwxrwxrwx. 1 root root 8 4月 21 22:05 dmdata01 -> ../dm-11
lrwxrwxrwx. 1 root root 7 4月 21 22:05 dmdcrv01 -> ../dm-7
lrwxrwxrwx. 1 root root 7 4月 21 22:05 dmdcrv02 -> ../dm-6
lrwxrwxrwx. 1 root root 7 4月 21 22:05 dmdcrv03 -> ../dm-5
#==============================================================#
正在复制用于DSC的参数文件 DSC
#==============================================================#

总用量 16K
-rw-r--r--. 1 dmdba dinstall 268 4月 21 22:03 dmasvrmal.ini
-rw-r--r--. 1 dmdba dinstall 164 4月 21 22:05 dmcssm.ini
-rw-r--r--. 1 dmdba dinstall 895 4月 21 22:03 dmdcr_cfg.ini
-rw-r--r--. 1 dmdba dinstall 393 4月 21 22:05 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/DmASMSvrmServiceAsmsvr.service to /usr/lib/systemd/system/DmASMSvrmServiceAsmsvr.service.
创建服务(DmASMSvrmServiceAsmsvr)完成
#==============================================================#
创建归档和备份脚本
#==============================================================#

创建数据库归档脚本:

-rw-r--r--. 1 dmdba dinstall 336 4月 21 22:05 /home/dmdba/scripts/conf_arch.sql
创建数据库备份脚本:

-rw-r--r--. 1 dmdba dinstall 1.5K 4月 21 22:05 /home/dmdba/scripts/conf_fullbackup.sql
-rw-r--r--. 1 dmdba dinstall 2.3K 4月 21 22:05 /home/dmdba/scripts/conf_incrbackup.sql
-rw-r--r--. 1 dmdba dinstall 1.5K 4月 21 22:05 /home/dmdba/scripts/check_backup.sql
创建 DMDBA 用户脚本,密码 SYSDBA :

-rw-r--r--. 1 dmdba dinstall 553 4月 21 22:05 /home/dmdba/scripts/create_user.sql
#==============================================================#
创建达梦数据库优化脚本
#==============================================================#

创建数据库参数配置脚本:

-rw-r--r--. 1 dmdba dinstall 20K 4月 21 22:05 /home/dmdba/scripts/conf_dmini.sql
创建数据库优化结果查询脚本:

-rw-r--r--. 1 dmdba dinstall 4.9K 4月 21 22:05 /home/dmdba/scripts/query_dmini.sql
创建数据库搜集统计信息脚本:

-rw-r--r--. 1 dmdba dinstall 1.8K 4月 21 22:05 /home/dmdba/scripts/conf_statistics.sql
节点 192.168.2.32 配置完成.

#==============================================================#
初始化 ASM 磁盘
#==============================================================#

dmasmcmdm V8
ASM>create dcrvdisk '/dev/asmdisk/dmdcrv01' 'dmdcrv01'
[INFO]The ASM initialize dcrvdisk /dev/asmdisk/dmdcrv01 to name DMASMdmdcrv01
Used time: 31.269(ms).
ASM>create dcrvdisk '/dev/asmdisk/dmdcrv02' 'dmdcrv02'
[INFO]The ASM initialize dcrvdisk /dev/asmdisk/dmdcrv02 to name DMASMdmdcrv02
Used time: 14.890(ms).
ASM>create dcrvdisk '/dev/asmdisk/dmdcrv03' 'dmdcrv03'
[INFO]The ASM initialize dcrvdisk /dev/asmdisk/dmdcrv03 to name DMASMdmdcrv03
Used time: 8.144(ms).
ASM>create asmdisk '/dev/asmdisk/dmarch01' 'dmarch01'
[INFO]The ASM initialize asmdisk /dev/asmdisk/dmarch01 to name DMASMdmarch01
Used time: 10.510(ms).
ASM>create asmdisk '/dev/asmdisk/dmarch02' 'dmarch02'
[INFO]The ASM initialize asmdisk /dev/asmdisk/dmarch02 to name DMASMdmarch02
Used time: 9.990(ms).
ASM>create asmdisk '/dev/asmdisk/dmarch03' 'dmarch03'
[INFO]The ASM initialize asmdisk /dev/asmdisk/dmarch03 to name DMASMdmarch03
Used time: 10.230(ms).
ASM>create asmdisk '/dev/asmdisk/dmdata01' 'dmdata01'
[INFO]The ASM initialize asmdisk /dev/asmdisk/dmdata01 to name DMASMdmdata01
Used time: 17.820(ms).
ASM>
ASM>create system diskgroup asmdisk '/dev/asmdisk/dmdcrv01','/dev/asmdisk/dmdcrv02','/dev/asmdisk/dmdcrv03' attribute config='/dmdata/DSC/dmdcr_cfg.ini', passwd='Welcome1'
Used time: 00:00:01.847.
#==============================================================#
启动css和asm服务
#==============================================================#

Starting DmCSSServiceCss: [ OK ]
节点 192.168.2.31 启动成功

Starting DmCSSServiceCss: [ OK ]
节点 192.168.2.32 启动成功

Starting DmASMSvrmServiceAsmsvr: [ OK ]
节点 192.168.2.31 启动成功

Starting DmASMSvrmServiceAsmsvr: [ OK ]
节点 192.168.2.32 启动成功

#==============================================================#
创建ASM磁盘组
#==============================================================#

DMASMTOOLM V8
]0;DMASMTOOLM DCR_INI=/dmdata/DSC/dmdcr.iniASM>ASM>DMASMTOOLM V8
]0;DMASMTOOLM DCR_INI=/dmdata/DSC/dmdcr.iniASM>ASM>
#==============================================================#
初始化数据库实例
#==============================================================#

initdb V8
db version: 0x7000c
数据库初始化完成
#==============================================================#
注册服务并启动数据库
#==============================================================#

在节点 192.168.2.31 注册服务并启动数据库

Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDSC.service to /usr/lib/systemd/system/DmServiceDSC.service.
创建服务(DmServiceDSC)完成
Starting DmServiceDSC: connnect dmasmtool(dmasmtoolm) successfully.
[ OK ]
节点 192.168.2.31 启动成功

在节点 192.168.2.32 注册服务并启动数据库

Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDSC.service to /usr/lib/systemd/system/DmServiceDSC.service.
创建服务(DmServiceDSC)完成
Starting DmServiceDSC: connnect dmasmtool(dmasmtoolm) successfully.
[ OK ]
节点 192.168.2.32 启动成功

#==============================================================#
创建数据库归档
#==============================================================#

在节点 192.168.2.31 创建归档

操作已执行
已用时间: 3.160(毫秒). 执行号:0.
操作已执行
已用时间: 40.428(毫秒). 执行号:0.
操作已执行
已用时间: 50.950(毫秒). 执行号:0.
操作已执行
已用时间: 89.643(毫秒). 执行号:0.
操作已执行
已用时间: 316.182(毫秒). 执行号:0.
在节点 192.168.2.32 创建归档

操作已执行
已用时间: 3.577(毫秒). 执行号:0.
操作已执行
已用时间: 26.261(毫秒). 执行号:0.
操作已执行
已用时间: 48.904(毫秒). 执行号:0.
操作已执行
已用时间: 100.189(毫秒). 执行号:0.
操作已执行
已用时间: 30.755(毫秒). 执行号:0.
#==============================================================#
配置 glogin.sql
#==============================================================#

column expired_date new_value _edate
select to_char(expired_date,'yyyy-mm-dd') expired_date from v$license;
host echo "密钥过期时间:&_edate"
set serveroutput on size 1000000
set long 200
set linesize 500
set pagesize 5000
set trimspool on
set lineshow off
col name new_value _dname
select name from v$database;
col port_num new_value _port
select para_value port_num from v$dm_ini where para_name='PORT_NUM';
set SQLPROMPT "_USER'@'_dname':'_port SQL> "
set time on
#==============================================================#
在 192.168.2.32 创建备份
#==============================================================#

密钥过期时间:2024-10-20
NAME DESCRIBE
-------- -------------------------------------------------------------------------------
bak_arch 每天备份归档,删除30天之前的备份
bak_full 周六全量备份,并删除30天之前的备份。
bak_inc 周日到周五做增量备份,如果失败,清除8天前备份,做全量备份
NAME COMMAND
-------- ---------------------
bak_full 01000000/dmbak/DAMENG
#==============================================================#
配置搜集统计信息作业
#==============================================================#

密钥过期时间:2024-10-20
NAME DESCRIBE
---------- ----------------------------------------------------
statistics 每周六凌晨2点开始收集所有列统计信息
#==============================================================#
优化数据库基础参数
#==============================================================#

密钥过期时间:2024-10-20
MEMORY_TARGET+BUFFER+RECYCLE+HJ_BUF_GLOBAL_SIZE+HAGR_BUF_GLOBAL_SIZE+CACHE_POOL_SIZE+DICT_BUF_SIZE+SORT_BUF_GLOBAL_SIZE+RLOG_POO
--------------------------------------------------------------------------------------------------------------------------------
3126
#==============================================================#
开启操作系统认证
#==============================================================#

sp_set_para_value(2,'ENABLE_LOCAL_OSAUTH',1);
密钥过期时间:2024-10-20
#==============================================================#
开启SQLLOG日志
#==============================================================#

sp_set_para_value(2,'SVR_LOG',1);
密钥过期时间:2024-10-20
#==============================================================#
重启数据库,优化参数生效
#==============================================================#

关闭数据库

]0;DMCSSM INI_PATH=/dmdata/DSC/dmcssm.ini [monitor] 2024-04-21 22:07:52: CSS MONITOR V8
[monitor] 2024-04-21 22:07:52: CSS MONITOR SYSTEM IS READY.
[monitor] 2024-04-21 22:07:52: Wait CSS Control Node choosed...
[monitor] 2024-04-21 22:07:53: Wait CSS Control Node choosed succeed.
[monitor] 2024-04-21 22:07:53: 组(GRP_DSC)中节点对应的CSS自动拉起标记已经处于关闭状态
[monitor] 2024-04-21 22:07:53: 通知CSS(seqno:0)执行EP STOP(GRP_DSC)
[monitor] 2024-04-21 22:08:02: 通知当前活动的CSS执行清理操作
[monitor] 2024-04-21 22:08:03: 清理CSS(0)请求成功
]0; dsc01 [monitor] 2024-04-21 22:08:03: 清理CSS(1)请求成功
[monitor] 2024-04-21 22:08:03: 命令EP STOP GRP_DSC执行成功
启动数据库

]0;DMCSSM INI_PATH=/dmdata/DSC/dmcssm.ini [monitor] 2024-04-21 22:08:09: CSS MONITOR V8
[monitor] 2024-04-21 22:08:09: CSS MONITOR SYSTEM IS READY.
[monitor] 2024-04-21 22:08:09: Wait CSS Control Node choosed...
[monitor] 2024-04-21 22:08:10: Wait CSS Control Node choosed succeed.
[monitor] 2024-04-21 22:08:10: 通知CSS(seqno:0)执行EP STARTUP(DSC0)
[monitor] 2024-04-21 22:08:19: 通知CSS(seqno:0)执行EP STARTUP(DSC0)成功
[monitor] 2024-04-21 22:08:19: 通知CSS(seqno:1)执行EP STARTUP(DSC1)
[monitor] 2024-04-21 22:08:28: 通知CSS(seqno:1)执行EP STARTUP(DSC1)成功
[monitor] 2024-04-21 22:08:28: 当前不存在活动的CSS或者活动CSS不符合执行条件
[monitor] 2024-04-21 22:08:28: 通知当前活动的CSS执行清理操作
[monitor] 2024-04-21 22:08:29: 清理CSS(0)请求成功
]0; dsc01 [monitor] 2024-04-21 22:08:29: 清理CSS(1)请求成功
[monitor] 2024-04-21 22:08:29: 组(GRP_DSC)中的节点启动成功,但打开CSS的自动拉起功能失败
#==============================================================#
测试作业备份数据库
#==============================================================#

密钥过期时间:2024-10-20
备份集: /dmbak/DAMENG/DB_DSC_FULL_2024_04_21_22_08_36.
DMSQL 过程已成功完成
已用时间: 00:00:06.142. 执行号:605.
#==============================================================#
创建DMDBA用户,密码:SYSDBA
#==============================================================#

密钥过期时间:2024-10-20
USERNAME
----------
SYS
DMDBA
SYSDBA
SYSAUDITOR
SYSSSO
#==============================================================#
查询数据库优化结果:
#==============================================================#

密钥过期时间:2024-10-20
NAME PARA_VALUE FILE_VALUE
---------------------- ----------- -----------------------
MAX_OS_MEMORY 100 100
MEMORY_POOL 200 200
MEMORY_N_POOLS 2 2
MEMORY_TARGET 0 0
MEMORY_MAGIC_CHECK 1 1
BUFFER 1000 1000
BUFFER_POOLS 5 5
FAST_POOL_PAGES 10000 10000
FAST_ROLL_PAGES 3000 3000
RECYCLE 120 120
RECYCLE_POOLS 1 2
MULTI_PAGE_GET_NUM 1 1
PRELOAD_SCAN_NUM 0 0
PRELOAD_EXTENT_NUM 0 0
MAX_BUFFER 1000 1000
SORT_BUF_SIZE 10 10
SORT_BLK_SIZE 1 1
SORT_BUF_GLOBAL_SIZE 500 500
SORT_FLAG 0 0
HJ_BUF_GLOBAL_SIZE 1000 1000
HJ_BUF_SIZE 50 50
HAGR_BUF_GLOBAL_SIZE 1000 1000
HAGR_BUF_SIZE 50 50
DICT_BUF_SIZE 50 50
VM_POOL_TARGET 16384 16384
SESS_POOL_TARGET 16384 16384
WORKER_THREADS 1 1
TASK_THREADS 16 16
USE_PLN_POOL 1 1
ENABLE_INJECT_HINT 1 1
VIEW_PULLUP_FLAG 1 1
OPTIMIZER_MODE 1 1
ADAPTIVE_NPLN_FLAG 0 0
DIRECT_IO 1 1
IO_THR_GROUPS 8 8
MAX_SESSIONS 1500 1500
MAX_SESSION_STATEMENT 20000 20000
FAST_LOGIN 1 1
PK_WITH_CLUSTER 0 0
OLAP_FLAG 2 2
TEMP_SIZE 1024 1024
TEMP_SPACE_LIMIT 102400 102400
CACHE_POOL_SIZE 200 200
PARALLEL_POLICY 2 2
BTR_SPLIT_MODE 1 1
RLOG_POOL_SIZE 256 256
UNDO_EXTENT_NUM 16 16
PARALLEL_PURGE_FLAG 1 1
TRX_DICT_LOCK_NUM 5 5
ENABLE_ENCRYPT 0 0
SVR_LOG 1 1
ENABLE_MONITOR 1 1
ENABLE_FREQROOTS 0 0
ENABLE_MONITOR_BP 0 0
DSC_N_CTLS 50000 50000
DSC_N_POOLS 2 2
DSC_ENABLE_MONITOR 0 0
DSC_HALT_SYNC 0 0
MAL_CHECK_INTERVAL placeholder 30
MAL_CONN_FAIL_INTERVAL placeholder 10
MAL_BUF_SIZE placeholder 100
MAL_SYS_BUF_SIZE placeholder 0
MAL_COMPRESS_LEVEL placeholder 0
MAL_TEMP_PATH placeholder
MAL_VPOOL_SIZE placeholder 128
MAL_INST_NAME placeholder DSC0,DSC1
MAL_HOST placeholder 172.16.2.31,172.16.2.32
MAL_PORT placeholder 9461,9461
MAL_INST_HOST placeholder NULL
MAL_INST_PORT placeholder 0,0
MAL_DW_PORT placeholder 0,0
ARCH_DEST placeholder +DMARCH/dmarch/DSC/dsc0
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Shell
1
https://gitee.com/rookiecloud_us/DMShellInstall.git
git@gitee.com:rookiecloud_us/DMShellInstall.git
rookiecloud_us
DMShellInstall
DMShellInstall
master

搜索帮助