一 环境准备
主机 IP地址 实例名 操作系统
DSC1 外部网络: 192.168.1.10 内部网络:172.16.1.10 RAC0 CentOS7
DSC2 外部网络: 192.168.1.20 内部网络:172.16.1.20 RAC1 CentOS7
二 安装达梦数据库软件:
2.1 计算节点和存储节点关闭防火墙:
[root@ DB0]# service iptables stop
[root@ DB0]# setup
2.2 计算节点修改系统参数:
[root@ DB0]# ulimit –n 65536
[root@ DB0]# vi /etc/security/limits.conf
* soft nofile 65536
* hard nofile 65536
[root@ DB0]# vi /etc/profile
ulimit -SHn 65536
[root@ DB0]# vi /etc/sysctl.conf
vm.swappiness=0
[root@ DB0]# sysctl -p /etc/sysctl.conf
[root@ DB0]# vi /etc/security/limits.d/90-nproc.conf
* soft nproc unlimited
2.3 建立用户并修改环境变量/创建路径
[root@DDB0 ~]# groupadd dinstall
[root@DDB0 ~]# useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
[root@DDB0 ~]# passwd dmdba
在dmdba 户~/.bash_profile 添加如下内容:
[dmdba@DDB0 ~]$ vim ~/.bash_profile
export DM_HOME="/dm/dmdbms"
export LD_LIBRARY_PATH="/dm/dmdbms/bin:$LD_LIBRARY_PATH"
export PATH="/dm/dmdbms/bin:$PATH"
[dmdba@DDB0 ~]$ source ~/.bash_profile
[root@DB0 ~]# mkdir -p /dm/dmdbms
#将dm目录指定给dmdba用户#
[root@DB0 ~]# chown -R dmdba:dinstall /dm
#给dm目录授权#
[root@DB0 ~]# chmod -R 775 /dm
2.4 上传并安装DM软件
./DMInstall.bin -i
... ...
三.配置共享存储:
for i in f g h i j;
do
echo "KERNEL==\"sd?\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\",RESULT==\"`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", SYMLINK+=\"dm-disk$i\",OWNER=\"dmdba\", GROUP=\"dinstall\",MODE=\"0660\""
done
vi /etc/udev/rules.d/99-dm-devices.rules
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="360003ff44dc75adcb2cc2715ed52f28f", SYMLINK+="dm-dcrdisk",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="360003ff44dc75adc88c552a08031a241", SYMLINK+="dm-votedisk",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="360003ff44dc75adc89af8575fae21ae8", SYMLINK+="dm-logdisk1",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="360003ff44dc75adc8a19a7ca93a6e8a1", SYMLINK+="dm-datadisk1",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="360003ff44dc75adc8b8fa622a23e0e2b", SYMLINK+="dm-datadisk2",OWNER="dmdba", GROUP="dinstall",MODE="0660"
[root@ DB0]# /sbin/udevadm control --reload-rules
[root@ DB0]# /sbin/udevadm trigger --type=devices --action=change
[root@ DB0]# ls /dev/dm
[root@DSC1 ~]# chmod +x /etc/rc.d/rc.local
[root@DSC1 ~]# vim /etc/rc.d/rc.local
#DCR
raw /dev/raw/raw1 /dev/asmdiskb
sleep 2
chown dmdba:dinstall /dev/raw/raw1
chmod 660 /dev/raw/raw1
#Votingdisk
raw /dev/raw/raw2 /dev/asmdiskc
sleep 2
chown dmdba:dinstall /dev/raw/raw2
chmod 660 /dev/raw/raw2
#LOG
raw /dev/raw/raw3 /dev/asmdiskd
sleep 2
chown dmdba:dinstall /dev/raw/raw3
chmod 660 /dev/raw/raw3
#Data
raw /dev/raw/raw4 /dev/asmdiske
sleep 2
chown dmdba:dinstall /dev/raw/raw4
chmod 660 /dev/raw/raw4
四.搭建DSC
4.1 配置 dmdcr_cfg.ini
DCR_N_GRP = 3
DCR_VTD_PATH = /dev/raw/raw2
DCR_OGUID = 63635
[GRP]
DCR_GRP_TYPE = CSS
DCR_GRP_NAME = GRP_CSS
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_CSS]
DCR_EP_NAME = CSS0
DCR_EP_HOST = 172.16.1.10
DCR_EP_PORT = 9541
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 172.16.1.20
DCR_EP_PORT = 9542
[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = GRP_ASM
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_ASM]
DCR_EP_NAME = ASM0
DCR_EP_SHM_KEY = 93360
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.1.10
DCR_EP_PORT = 9641
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP_ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.1.20
DCR_EP_PORT = 9642
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = GRP_RAC
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_RAC]
DCR_EP_NAME = RAC0
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9741
[GRP_RAC]
DCR_EP_NAME = RAC1
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9742
4.2 初始化磁盘组
在DB0机器上启动dmasmcmd工具,依次输入以下命令:
[root@ DB0]# cd /home/dm/dmdbms/bin
[root@ DB0]# ./dmasmcmd
ASM> create dcrdisk '/dev/raw/raw1' 'dcr'
ASM> create votedisk '/dev/raw/raw2' 'vote'
ASM> create asmdisk '/dev/raw/raw3' 'LOG0'
ASM> create asmdisk '/dev/raw/raw4' 'DATA0'
ASM> init dcrdisk '/dev/raw/raw1' from '/home/dscdata/dmdcr_cfg.ini' identified by 'abcd'
ASM> init votedisk '/dev/raw/raw2' from '/home/dscdata /config/dmdcr_cfg.ini'
4.3 配置 dmasvrmal.ini
在/home/dscdata下新建dmasvrmal.ini文件;
[MAL_INST1]
MAL_INST_NAME = ASM0
MAL_HOST = 172.16.1.10
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM1
MAL_HOST = 172.16.1.20
MAL_PORT = 7237
4.4 配置dmdcr.ini
计算一节点:
$ vim /dm/dmdbms/data/dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm/dmdbms/data/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /dm/dmdbms/bin/dmasmsvr dcr_ini=/dm/dmdbms/data/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /dm/dmdbms/bin/dmserver path=/dm/dmdbms/data/rac0_config/dm.ini dcr_ini=/dm/dmdbms/data/dmdcr.ini
计算二节点:
$ vim /dm/dmdbms/data/dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm/dmdbms/data/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 1
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /dm/dmdbms/bin/dmasmsvr dcr_ini=/dm/dmdbms/data/dmdcr.ini
五 启动DMCSS、DMASM 服务程序
分别在2个节点注册DMCSS和DMASM服务
以root用户执行:
节点DDB0
注册DMCSS服务
[root@DDB0 ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmcss -dcr_ini /dm/dmdbms/data/dmdcr.ini -p rac1
Created symlink from /etc/systemd/system/multi-user.target.wants/DmCSSServicerac1.service to /usr/lib/systemd/system/DmCSSServicerac1.service.
创建服务(DmCSSServicerac1)完成
注册DMASM服务
[root@DDB0 ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmasmsvr -dcr_ini /dm/dmdbms/data/dmdcr.ini -p rac1 -y DmCSSServicerac1
Created symlink from /etc/systemd/system/multi-user.target.wants/DmASMSvrServicerac1.service to /usr/lib/systemd/system/DmASMSvrServicerac1.service.
创建服务(DmASMSvrServicerac1)完成
节点DB1
注册DMCSS服务
[root@DB1 ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmcss -dcr_ini /dm/dmdbms/data/dmdcr.ini -p rac2
Created symlink from /etc/systemd/system/multi-user.target.wants/DmCSSServicerac2.service to /usr/lib/systemd/system/DmCSSServicerac2.service.
创建服务(DmCSSServicerac2)完成
注册DMASM服务
[root@DB1 ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmasmsvr -dcr_ini /dm/dmdbms/data/dmdcr.ini -p rac2 -y DmCSSServicerac2
Created symlink from /etc/systemd/system/multi-user.target.wants/DmASMSvrServicerac2.service to /usr/lib/systemd/system/DmASMSvrServicerac2.service.
创建服务(DmASMSvrServicerac2)完成
六 启动DMCSS和DMASM服务
#节点DDB0
[root@DDB0 ~]# service DmCSSServicerac1 start
Redirecting to /bin/systemctl start DmCSSServicerac1.service
[root@DDB0 ~]# service DmASMSvrServicerac1 start
Redirecting to /bin/systemctl start DmASMSvrServicerac1.service
#节点DB1
[root@DB1 ~]# service DmCSSServicerac2 start
[root@DB1 ~]# service DmASMSvrServicerac2 start
七 创建DMASM磁盘组
[dmdba@DDB0 ~]$ dmasmtool DCR_INI=/dm/dmdbms/data/dmdcr.ini
ASM>create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
ASM>create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
八 初始化数据库
8.1 写参数文件
[dmdba@DDB0 ~]$ vim /dm/dmdbms/data/dminit.ini
db_name = rac
system_path = +DMDATA/data
system = +DMDATA/data/rac/system.dbf
system_size = 128
roll = +DMDATA/data/rac/roll.dbf
roll_size = 128
main = +DMDATA/data/rac/main.dbf
main_size = 128
ctl_path = +DMDATA/data/rac/dm.ctl
ctl_size = 8
log_size = 256
dcr_path = /dev/raw/raw1
dcr_seqno = 0
auto_overwrite = 1
[RAC0]
config_path = /dm/dmdbms/data/rac0_config
port_num = 5236
mal_host = 172.16.1.10
mal_port = 9340
log_path = +DMLOG/log/rac0_log01.log
log_path = +DMLOG/log/rac0_log02.log
[RAC1]
config_path = /dm/dmdbms/data/rac1_config
port_num = 5236
mal_host = 172.16.1.20
mal_port = 9341
log_path = +DMLOG/log/rac1_log01.log
log_path = +DMLOG/log/rac1_log02.log
8.2 初始化数据库:
[dmdba@DDB0 data]$ dminit control=/dm/dmdbms/data/dminit.ini
[dmdba@DDB0 data]$ cd /dm/dmdbms/data/
[dmdba@DDB0 data]$ scp -r rac1_config/ 192.168.1.20:`pwd`
8.3 注册数据库服务:
#节点DDB0
[root@DDB0 ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmserver -dm_ini /dm/dmdbms/data/rac0_config/dm.ini -dcr_ini /dm/dmdbms/data/dmdcr.ini -p rac1 -y DmASMSvrServicerac1
#节点DB1
[root@DB1 ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmserver -dm_ini /dm/dmdbms/data/rac1_config/dm.ini -dcr_ini /dm/dmdbms/data/dmdcr.ini -p rac2 -y DmASMSvrServicerac2
[root@DB0 ~]# systemctl start DmServicerac1
[root@DB1 ~]# systemctl start DmServicerac2
社区地址:https://eco.dameng.com