目录
2.2.3配置dmasvrmal.ini文件(两节点内容一致)
3.1.3创建DMASM磁盘组(新开一个终端,仅DSC01执行即可)
4.1配置dminit.ini文件(仅在DSC01上执行即可)
DMDSC安装部署报告
1. 环境准备:
在两台节点上部署dm数据库(暂时不需要初始化实例)
1.1添加共享磁盘(方案1 不建议使用)
关闭DSC01编辑虚拟机
DSC02在关机后进行同样操做,但选择已有磁盘
1.2方法二(使用vm工具创建):
"E:\VMware\vmware-vdiskmanager.exe" -c -s 20GB -a lsilogic -t 2 "D:\虚拟机\dsc共享存储\DCS-share-20G.vmdk"
2. 配置DSC
2.1划分共享磁盘上的裸设备(dsc01节点操作即可)
#Root/ fdisk /dev/sdb
依次输入:(输入m查看帮助)
n→p→1→回车→+100M→回车
n→p→2→回车→+100M→回车
n→p→3→回车→+2048M→回车
n→p→回车→回车(默认将剩余空间给分区4)
w→回车 (保存信息)
#root/ lsblk 查看分区情况
对节点进行裸设备绑定(都要执行)
#root vim /etc/udev/rules.d/70-raw.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"
进行裸设备绑定
#root/ partprobe /dev/sdb
#root/ udevadm control --reload-rules
#root/ udevadm trigger --type=devices --action=change
查看裸设备
#root/ ll /dev/raw/*
#root/ blockdev --getsize64 /dev/raw/raw[1/2/3/4]
2.2配置DCR
2.2.1两节点配置dmdcr_cfg.ini文件
#dmdba/ vim /home/dmdba/dmdbms/data/dmdcr_cfg.ini
添加内容:
具体参数信息数据参考:DM7 达梦 共享存储数据库集群 (5) -- DMDSC 配置文件说明 -- cnDBA.cn_中国DBA社区
DCR_N_GRP = 3 #磁盘内多少个组
DCR_VTD_PATH = /dev/raw/raw2 #表决磁盘路径
DCR_OGUID = 63635 #消息标识
[GRP] #组1 CSS
DCR_GRP_TYPE = CSS #组类型
DCR_GRP_NAME = GRP_CSS #组名
DCR_GRP_N_EP = 2 #组内节点个数N, 最大值16
DCR_GRP_DSKCHK_CNT = 60 #磁盘心跳时间默认60s
[GRP_CSS]
DCR_EP_NAME = CSS0
DCR_EP_HOST = 192.168.20.176#节点ip
DCR_EP_PORT = 9341 #节点监听端口号
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 192.168.50.175#节点ip
DCR_EP_PORT = 9343 #节点监听端口号
[GRP] #组2 ASM
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 #共享内存大小,单位m 10-1024
DCR_EP_HOST = 192.168.20.176
DCR_EP_PORT = 9349
DCR_EP_ASM_LOAD_PATH = /dev/raw #ASM扫扫描磁盘路径
[GRP_ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.20.175
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP] #组3 DB
DCR_GRP_TYPE = DB
DCR_GRP_NAME = GRP_DSC
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_DSC]
DCR_EP_NAME = DSC0
DCR_EP_SEQNO = 0
DCR_CHECK_PORT = 9741
DCR_EP_PORT = 5238
[GRP_DSC]
DCR_EP_NAME = DSC1
DCR_EP_SEQNO = 1
DCR_CHECK_PORT = 9742
DCR_EP_PORT = 5238
2.2.2初始化(在dsc01bin目录下执行)
#dmdba/ ./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/dmdba/dmdbms/data/dmdcr_cfg.ini' identified by '123'
ASM>init votedisk '/dev/raw/raw2' from '/home/dmdba/dmdbms/data/dmdcr_cfg.ini'
2.2.3配置dmasvrmal.ini文件(两节点内容一致)
#dmdba/ vim /home/dmdba/dmdbms/data/dmasvrmal.ini
[MAL_INST1]
MAL_INST_NAME = ASM0
MAL_HOST = 192.168.20.176
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM1
MAL_HOST = 192.168.20.175
MAL_PORT = 7237
传输文件
scp dmasvrmal.ini dmdba@192.168.50.145:/home/dmdba/dmdbms/data
2.2.4配置dmdcr.ini文件
【DSC01节点】
#dmdba/ vim /home/dmdba/dmdbms/data/dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/dmdbms/data/dmasvrmal.ini
#dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdbms/data/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/data/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdbms/data/dmdcr.ini
【DSC02节点】
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/dmdbms/data/dmasvrmal.ini
#dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 1
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdbms/data/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/data/dsc1_config/dm.ini dcr_ini=/home/dmdba/dmdbms/data/dmdcr.ini
3. 启动DSC集群
3.1启动DMCSS、DMASM服务程序
两个节点分别在$DM_HOME/bin目录下先后启动dmcss、dmasm服务
3.1.1启动DMCSS
#dmdba/ ./dmcss DCR_INI=/home/dmdba/dmdbms/data/dmdcr.ini
3.1.2开新的终端执行
#dmdba/ ./dmasmsvr DCR_INI=/home/dmdba/dmdbms/data/dmdcr.ini
3.1.3创建DMASM磁盘组(新开一个终端,仅DSC01执行即可)
#dmdba ./dmasmtool DCR_INI=/home/dmdba/dmdbms/data/dmdcr.ini
ASM> create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
ASM> create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
4. 初始化实例库
4.1配置dminit.ini文件(仅在DSC01上执行即可)
#dmdba/ vim /home/dmdba/dmdbms/data/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 = 256
dcr_path = /dev/raw/raw1
dcr_seqno = 0
auto_overwrite = 1
page_size = 16
[DSC0]
config_path = /home/dmdba/dmdata/dsc0_config
port_num = 5241
mal_host = 192.168.20.176
mal_port = 9340
log_path = +DMLOG/log/dsc0_log01.log
log_path = +DMLOG/log/dsc0_log02.log
[DSC1]
config_path = /home/dmdba/dmdata/dsc1_config
port_num = 5241
mal_host = 192.168.20.175
mal_port = 9341
log_path = +DMLOG/log/dsc1_log01.log
log_path = +DMLOG/log/dsc1_log02.log
4.2使用dminit初始化DB环境
#dmdba/ ./dminit control=/home/dmdba/dmdbms/data/dminit.ini
在/dmdba/dmdata文件下会生成实例服务的配置文件,将dsc02节点的文件传输到节点2上
scp -r dsc1_config/ dmdba@192.168.20.175:/home/dmdba/dmdata
5. 启动数据库服务
5.1进入bin目录启动dsc01和dsc02
#dmdba/ ./dmserver /home/dmdba/dmdata/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdbms/data/dmdcr.ini
查看CSS窗口日志:出现 system is ready、ep real open说明启动成功
Dsc01 CSS 窗口show命令查看sys_status 字段为 OPEN,vtd_status 字段为 WORKING,active 字段为 TRUE 说明 db 服务正常
5.2服务启动方式:
在数据库安装目录/script/root下注册服务:
#注册CSS服务(dsc02节点同理)
root# ./dm_service_installer.sh -t dmcss -dcr_ini /home/dmdba/dmdbms/data/dmdcr.ini -p DMCSS
#注册ASM服务(dsc02节点同理)
#root/ ./dm_service_installer.sh -t dmasmsvr -dcr_ini /home/dmdba/dmdbms/data/dmdcr.ini -y DmCSSServiceDMCSS -p DMASM
#注册dmserver服务
#root/ ./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdata/dsc0_config/dm.ini -dcr_ini /home/dmdba/dmdbms/data/dmdcr.ini -y DmASMSvrServiceDMASM -p DMSERVER
#root/ ./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdata/dsc1_config/dm.ini -dcr_ini /home/dmdba/dmdbms/data/dmdcr.ini -y DmASMSvrServiceDMASM -p DMSERVER
启动服务(bin目录下)
./DmCSSServiceDMCSS start 1
./DmASMSvrServiceDMASM start 2
./DmServiceDMSERVER start 3
设置开机自动启动:
[dmdba@dsc01 bin]$ vim /home/dmdba/dmdbms/data/dmdcr.ini
[dmdba@dsc02 bin]$ vim /home/dmdba/dmdbms/data/dmdcr.ini
DMDCR_ASM_RESTART_INTERVAL = 1 #自动拉起ASM
DMDCR_DB_RESTART_INTERVAL = 1 #自动拉起数据库实例
6. 问题报错
6.1报磁盘错误
dmcss startup failed:[CODE:-13218],error info:Check dcr disk: [/dev/raw/raw1] version mismatched ,disk_version:(6xG) cur_version : (0x1003), please reinit dcr.
此问题是因为共享磁盘设置错误
解决办法:删除磁盘采用cmd方式建立共享磁盘/重新初始化共享磁盘(使用dmasmcmd)
6.2报位置异常
原因:裸设备绑定未成功 重新划分后记得的保存
6.3报asm连接异常:查看日志、检查防火墙
6.4 创建日志文件失败
原因:磁盘组不存在
其他技术知识请参考:eco.dameng.com