DM数据库dsc四节点部署步骤

Dm8DSC四节点安装步骤
1:装好数据库之后
修改dmdba用户资源限制：vim /etc/security/limits.conf
在文件末尾加入：
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft nofile 65536
dmdba hard nofile 65536
dmdba soft nproc 65536
dmdba hard nproc 65536
dmdba soft stack 65536
dmdba hard stack 65536
2:添加用户变量
Vim /home/dmdba/.bash_profile
文件末尾添加如下内容：
export DM_HOME=/home/dmdba/dmdbms
export PATH=$PATH:$DM_HOME/bin
export LD_LIBRARY_PATH=$L{D}_{L}IBRAR{Y}_{P}ATH:$DM_HOME/bin
或：
export DM_HOME="/dm8"
export PATH=$PATH:$DM_HOME/bin
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/dm8/bin"
3：添加共享磁盘
添加完成后，虚拟机路径下的 .vmx 文件中会出现如下信息：
scsi1.virtualDev = “lsilogic”
scsi1.present = “TRUE”
scsi1:0.fileName = “E:\vmdk\test\Red Hat TEST RAC0-0.vmdk”
scsi1:0.present = “TRUE”
还需要手工在两台虚拟机 .vmx 文件中添加如下信息： diskLib.dataCacheMaxSize=0
diskLib.dataCacheMaxReadAheadSize=0
diskLib.dataCacheMinReadAheadSize=0
diskLib.dataCachePageSize=4096
diskLib.maxUnsyncedWrites = “0”
disk.locking = “FALSE” 注意：标红的信息必填，否则重启虚拟机操作系统时会提示磁盘被锁定

执行以下命令查看磁盘
[root@dm1 ~]# lsblk

节点二：进行裸设备划分
输入 fdisk /dev/sdb
依次输入 n → p → 1 →回车→ +100M →回车，完成第一块磁盘划分
依次输入 n → p → 2 →回车→ +100M →回车，完成第二块磁盘划分
依次输入 n → p → 3 →回车→ +2048M →回车，完成第三块磁盘划分
依次输入 n → p → 4 →回车→回车→回车，完成第四块磁盘划分
w保存配置并退出
[root@dm2 ~]# fdisk -l

4:新建udev规则文件-裸设备绑定
[root@dm1 ~]# vim /etc/udev/rules.d/70-persistent-ipoib.rules
添加以下内容
ACTION==“add”,KERNEL==“sdb1”,RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION==“add”,KERNEL==“sdb2”,RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION==“add”,KERNEL==“sdb3”,RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION==“add”,KERNEL==“sdb4”,RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION==“add”,KERNEL==“raw[1-4]”, OWNER=“dmdba”, GROUP=“dinstall”, MODE=“660”
执行以下命令使文件生效
udevadm trigger --type=devices --action=change
5:执行以下命令，检查是否配置成功
[root@dm1 ~]# ll /dev/raw/raw*

注意：如果查不到配置的裸设备，请重启服务器在验证。
6：配置DCR初始化配置文件-创建配置文件存放目录，两个节点用dmdba用户执行。
[dmdba@dm1 ~]$ mkdir -p /home/dmdba/config
[dmdba@dm2 ~]$ mkdir -p /home/dmdba/config
[dmdba@beijing ~]$ mkdir -p /home/dmdba/config
[dmdba@tianjin ~]$ mkdir -p /home/dmdba/config
7:新建dmdcr_cfg.ini文件，使用dmdba用户–两个节点都配置
[dmdba@dm1 ~]$ vim /home/dmdba/config/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 = 4
DCR_GRP_DSKCHK_CNT = 60
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 192.168.145.11
DCR_EP_PORT = 9340
[GRP_CSS]
DCR_EP_NAME = CSS2
DCR_EP_HOST = 192.168.145.22
DCR_EP_PORT = 9341
[GRP_CSS]
DCR_EP_NAME = CSS3
DCR_EP_HOST = 192.168.145.3
DCR_EP_PORT = 9342
[GRP_CSS]
DCR_EP_NAME = CSS4
DCR_EP_HOST = 192.168.145.4
DCR_EP_PORT = 9343

[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = GRP_ASM
DCR_GRP_N_EP = 4
DCR_GRP_DSKCHK_CNT = 60
[GRP_ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93360
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.145.11
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP_ASM]
DCR_EP_NAME = ASM2
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.145.22
DCR_EP_PORT = 9352
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP_ASM]
DCR_EP_NAME = ASM3
DCR_EP_SHM_KEY = 93362
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.145.3
DCR_EP_PORT = 9353
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP_ASM]
DCR_EP_NAME = ASM4
DCR_EP_SHM_KEY = 93363
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.145.4
DCR_EP_PORT = 9354
DCR_EP_ASM_LOAD_PATH = /dev/raw

[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = GRP_DSC
DCR_GRP_N_EP = 4
DCR_GRP_DSKCHK_CNT = 60
[GRP_DSC]
DCR_EP_NAME = DSC1
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5237
DCR_CHECK_PORT = 9741
[GRP_DSC]
DCR_EP_NAME = DSC2
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5237
DCR_CHECK_PORT = 9742
[GRP_DSC]
DCR_EP_NAME = DSC3
DCR_EP_SEQNO = 2
DCR_EP_PORT = 5237
DCR_CHECK_PORT = 9743
[GRP_DSC]
DCR_EP_NAME = DSC4
DCR_EP_SEQNO = 3
DCR_EP_PORT = 5237
DCR_CHECK_PORT = 9744
8：创建ASM磁盘
使用dmdba用户，到数据库软件安装的目录的bin目录执行以下命令（在一个节点执行）。
[dmdba@dm1 bin]$ ./dmasmcmd
DMASMCMD V8
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’

9：使用编辑好的dmdcr_dfg.ini配置文件初始化dcrdisk和votedisk，并在ASM提示符执行以下命令：
ASM> init dcrdisk ‘/dev/raw/raw1’ from ‘/home/dmdba/config/dmdcr_cfg.ini’ identified by ‘123456’
ASM>init votedisk ‘/dev/raw/raw2’ from ‘/home/dmdba/config/dmdcr_cfg.ini’

10：配置ASM的MAL系统配置文件–两个节点都需要配置，内容相同。
[dmdba@dm1 bin]$ vim /home/dmdba/config/dmasvrmal.ini
添加以下内容
[MAL_INST1]
MAL_INST_NAME = ASM1
MAL_HOST = 192.168.145.11
MAL_PORT = 7236

[MAL_INST2]
MAL_INST_NAME = ASM2
MAL_HOST = 192.168.145.22
MAL_PORT = 7237

[MAL_INST3]
MAL_INST_NAME = ASM3
MAL_HOST = 192.168.145.3
MAL_PORT = 7238

[MAL_INST4]
MAL_INST_NAME = ASM4
MAL_HOST = 192.168.145.4
MAL_PORT = 7239
11：配置DCR启动配置文件
[dmdba@dm1 bin]$ vim /home/dmdba/config/dmdcr.ini
节点一添加：
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM 重启参数，命令行方式启动
#DMDCR_ASM_RESTART_INTERVAL =10
#DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/home/dmdba/config/dmdcr.ini
#DB 重启参数，命令行方式启动
#DMDCR_DB_RESTART_INTERVAL = 30
#DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/home/dmdba/config/dsc1/dm.ini dcr_ini=/home/dmdba/config/dmdcr.ini
[dmdba@dm2 ~]$ vim /home/dmdba/config/dmdcr.ini
节点二添加：
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 1
#ASM 重启参数，命令行方式启动
#DMDCR_ASM_RESTART_INTERVAL =10
#DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/home/dmdba/config/dmdcr.ini
#DB 重启参数，命令行方式启动
#DMDCR_DB_RESTART_INTERVAL = 30
#DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/home/dmdba/config/dsc2/dm.ini dcr_ini=/home/dmdba/config/dmdcr.ini
[dmdba@beijing ~]$ vim /home/dmdba/config/dmdcr.ini
节点三添加：
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 2
#ASM 重启参数，命令行方式启动
#DMDCR_ASM_RESTART_INTERVAL =10
#DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/home/dmdba/config/dmdcr.ini
#DB 重启参数，命令行方式启动
#DMDCR_DB_RESTART_INTERVAL = 30
#DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/home/dmdba/config/dsc1/dm.ini dcr_ini=/home/dmdba/config/dmdcr.ini
[dmdba@tianjin ~]$ vim /home/dmdba/config/dmdcr.ini
节点四添加：
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 3
#ASM 重启参数，命令行方式启动
#DMDCR_ASM_RESTART_INTERVAL =10
#DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/home/dmdba/config/dmdcr.ini
#DB 重启参数，命令行方式启动
#DMDCR_DB_RESTART_INTERVAL = 30
#DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/home/dmdba/config/dsc1/dm.ini dcr_ini=/home/dmdba/config/dmdcr.ini

12：启动DMCSS服务
查看防火墙状态：关闭
两个节点启动dmcss，dmdba用户到数据库安装目录bin下执行
[dmdba@dm1 bin]$ ./dmcss dcr_ini=/home/dmdba/config/dmdcr.ini

Asm启动后，节点一使用dmdba用户启动dmasmtool工具------节点一
[dmdba@dm1 bin]$ ./dmasmtool dcr_ini=/home/dmdba/config/dmdcr.ini
创建redo日志磁盘组
ASM>create diskgroup ‘DMLOG’ asmdisk ‘/dev/raw/raw3’
创建数据文件磁盘组
ASM>create diskgroup ‘DMDATA’ asmdisk ‘/dev/raw/raw4’

13：初始化共享存储集群数据库实例
配置dminit控制文件，节点一使用dmdba用户执行以下命令：
[dmdba@dm1 config]$ vim dminit.ini
添加下列捏内容
db_name = DSC
system_path = +DMDATA/data/

system = +DMDATA/data/dsc/system.dbf
system_size = 128
roll = +DMDATA/data/dsc/roll.dbf
roll_size = 128
main = +DMDATA/data/dsc/main.dbf
main_size = 128
ctl_path = +DMDATA/data/dsc/dm.ctl
ctl_size = 8
log_size = 100
dcr_path = /dev/raw/raw1 #dcr 磁盘路径，目前不支持 asm，只能是裸设备
dcr_seqno = 0
auto_overwrite = 1
[DSC1] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /home/dmdba/config/dsc1
port_num = 5237
mal_host = 192.168.145.11
mal_port = 9236
log_path = +DMLOG/log/DSC1_log01.log
log_path = +DMLOG/log/DSC1_log02.log
[DSC2] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /home/dmdba/config/dsc2
port_num = 5237
mal_host = 192.168.145.22
mal_port = 9236
log_path = +DMLOG/log/DSC2_log01.log
log_path = +DMLOG/log/DSC2_log02.log
[DSC3] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /home/dmdba/config/dsc3
port_num = 5237
mal_host = 192.168.145.3
mal_port = 9236
log_path = +DMLOG/log/DSC3_log01.log
log_path = +DMLOG/log/DSC3_log02.log
[DSC4] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /home/dmdba/config/dsc4
port_num = 5237
mal_host = 192.168.145.4
mal_port = 9236
log_path = +DMLOG/log/DSC4_log01.log
log_path = +DMLOG/log/DSC4_log02.log
初始化实例，节点一使用dmdba用户执行
[dmdba@dm1 bin]$ ./dminit control=/home/dmdba/config/dminit.ini

14：将dsc2目录复制到节点二对应的目录下

[dmdba@dm1 config]$ scp -r dsc2 192.168.145.22:/home/dmdba/config/
[dmdba@dm1 config]$ scp -r dsc3 192.168.145.3:/home/dmdba/config/
[dmdba@dm1 config]$ scp -r dsc4 192.168.145.4:/home/dmdba/config/

15：启动css，asm，server—四个节点都需要
[dmdba@dm2 bin]./dmcss DCR_INI=/home/dmdba/config/dmdcr.ini
[dmdba@dm2 bin]$ ./dmasmsvr DCR_INI=/home/dmdba/config/dmdcr.ini
[dmdba@dm2 bin]$ ./dmserver /home/dmdba/config/dsc2/dm.ini dcr_ini=/home/dmdba/config/dmdcr.ini
16：配置监视器
[dmdba@dm1 config]$ vim dmcssm.ini
添加下列内容：
CSSM_OGUID = 63635
#配置所有 CSS 的连接信息，
#和 dmdcr_cfg.ini 中 CSS 配置项的 DCR_EP_HOST 和 DCR_EP_PORT 保持一致
CSSM_CSS_IP = 192.168.145.11:9340
CSSM_CSS_IP = 192.168.145.22:9341
CSSM_CSS_IP = 192.168.145.3:9342
CSSM_CSS_IP = 192.168.145.4:9343
CSSM_LOG_PATH =/home/dmdba/dmdbms/log #监视器日志文件存放路径
CSSM_LOG_FILE_SIZE = 32 #每个日志文件最大 32 MB
CSSM_LOG_SPACE_LIMIT = 0 #不限定日志文件总占用空间启动监视器，dmdba用户执行。
[dmdba@dm1 bin]$ ./dmcssm ini_path=/home/dmdba/config/dmcssm.ini

启动方式：
先启动css-再asm-最后server
[dmdba@dm1 bin]$ ./DmCSSServicedsc1 start

[dmdba@dm2 bin]$ ./dmasmsvr DCR_INI=/home/dmdba/config/dmdcr.ini
[dmdba@dm2 bin]$ ./dmserver /home/dmdba/config/dsc2/dm.ini dcr_ini=/home/dmdba/config/dmdcr.ini
启动监视器，dmdba用户执行。
[dmdba@dm1 bin]$ ./dmcssm ini_path=/home/dmdba/config/dmcssm.ini

17：注册服务–后台启动
节点一：
[root@dm1 root]# ./dm_service_installer.sh -t dmcss -p dsc1 -dcr_ini /home/dmdba/config/dmdcr.ini
[root@dm1 root]# ./dm_service_installer.sh -t dmasmsvr -p dsc1 -dcr_ini /home/dmdba/config/dmdcr.ini -y DmCSSServicedsc1
[root@dm1 root]# ./dm_service_installer.sh -t dmserver -p dsc1 -dm_ini /home/dmdba/config/dsc1/dm.ini -dcr_ini /home/dmdba/config/dmdcr.ini -y DmASMSvrServicedsc1

节点二：
[root@dm2 root]# ./dm_service_installer.sh -t dmcss -p dsc2 -dcr_ini /home/dmdba/config/dmdcr.ini
[root@dm2 root]# ./dm_service_installer.sh -t dmasmsvr -p dsc2 -dcr_ini /home/dmdba/config/dmdcr.ini -y DmCSSServicedsc2
[root@dm2 root]# ./dm_service_installer.sh -t dmserver -p dsc2 -dm_ini /home/dmdba/config/dsc2/dm.ini -dcr_ini /home/dmdba/config/dmdcr.ini -y DmASMSvrServicedsc2

节点三：
[root@beijing root]# ./dm_service_installer.sh -t dmcss -p dsc3 -dcr_ini /home/dmdba/config/dmdcr.ini
[root@tianjin root]# ./dm_service_installer.sh -t dmasmsvr -p dsc3 -dcr_ini /home/dmdba/config/dmdcr.ini -y DmCSSServicedsc3
[root@tianjin root]# ./dm_service_installer.sh -t dmserver -p dsc3 -dm_ini /home/dmdba/config/dsc3/dm.ini -dcr_ini /home/dmdba/config/dmdcr.ini -y DmASMSvrServicedsc3

节点四：
[root@tianjin root]# ./dm_service_installer.sh -t dmcss -p dsc4 -dcr_ini /home/dmdba/config/dmdcr.ini
[root@tianjin root]# ./dm_service_installer.sh -t dmasmsvr -p dsc4 -dcr_ini /home/dmdba/config/dmdcr.ini -y DmCSSServicedsc4
[root@tianjin root]# ./dm_service_installer.sh -t dmserver -p dsc4 -dm_ini /home/dmdba/config/dsc4/dm.ini -dcr_ini /home/dmdba/config/dmdcr.ini -y DmASMSvrServicedsc4

修改配置文件：–四个节点都需要
[dmdba@dm1 config]$ vim dmdcr.ini

DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM 重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL =10
DMDCR_ASM_STARTUP_CMD = /dm8/bin/DmASMSvrServicedsc1 start
#DB 重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 30
DMDCR_DB_STARTUP_CMD = /dm8/bin/DmServicedsc1 start

18：客户端验证
任意节点配置dm_scv.conf文件
[dmdba@dm1 bin]$ vim /etc/dm_svc.conf
添加：
dmdsc=(192.168.145.11:5237,192.168.145.22:5237，192.168.145.3:5237，192.168.145.4:5237)
登录数据库验证：

达梦云适配技术社区
https://eco.dameng.com/