1.裸设备搭建DSC
1.1环境介绍
服务器:
192.168.1.101 DSC1
192.168.1.102 DSC2
目录规划:
存放 dcr 信息 /dev/sdb1 1 GB /DCR
存放 vote 信息 /dev/sdb2 1 GB /VOTE
存放 redo 日志 /dev/sdb3 8 GB /LOG0
存放数据文件 /dev/sdb4 10 GB /DATA0
1.2.安装数据库软件
两台主机都需安装数据库软件。
1.2.1新建组、用户
groupadd dinstall
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
passwd dmdba
1.2.2修改资源限制
vi /etc/security/limits.conf
dmdba hard nofile 65536
dmdba soft nofile 65536
dmdba hard stack 32768
dmdba soft stack 16384
dmdba soft nproc 10240
dmdba hard nproc 10240
dmdba hard data unlimited
dmdba soft data unlimited
dmdba hard fsize unlimited
dmdba soft fsize unlimited
dmdba soft core unlimited
dmdba hard core unlimited
1.2.3创建文件夹
mkdir /dm8
chown dmdba:dinstall /dm8
1.2.4安装数据库软件
1.3创建共享磁盘
1.3.1进入vmware安装目录
cd C:\Program Files (x86)\VMware\VMware Workstation
1.3.2创建磁盘
.\vmware-vdiskmanager.exe -c -s 20G -a lsilogic -t 2 "F:\Virtual Machines\DM\DSC\SHARE.vmdk"
1.3.3两台虚机添加磁盘
1.3.4修改虚机配置文件
添加:
disk.locking = "false"
disk.EnableUUID="TRUE"
1.3.5磁盘分区
输入 fdisk /dev/sdb
依次输入 n-->p-->1 回车 +1G 回车,完成第一块磁盘划分
依次输入 n-->p-->2 回车 +1G 回车,完成第二块磁盘划分
依次输入 n-->p-->3 回车 +8G 回车,完成第三块磁盘划分
依次输入 n-->p--> 回车 回车 回车,完成第四块磁盘划分
最后输入 w 保存分区设置
1.3.6配置udev
两台机器都需要配置
vim /etc/udev/rules.d/90-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"
partprobe /dev/sdb
udevadm trigger --action=add
udevadm trigger --type=devices --action=change
1.4配置 DCR 初始化配置文件
两台机器都需要配置
su - dmdba
cd /dm8/
mkdir config
vim /dm8/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 = CSS
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 10.10.10.101
DCR_EP_PORT = 9341
[CSS]
DCR_EP_NAME = CSS2
DCR_EP_HOST = 10.10.10.102
DCR_EP_PORT = 9341
[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = ASM
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93360
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 10.10.10.101
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/raw
[ASM]
DCR_EP_NAME = ASM2
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 10.10.10.102
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = DSC
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[DSC]
DCR_EP_NAME = DSC1
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9741
[DSC]
DCR_EP_NAME = DSC2
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9741
1.5创建 ASM 磁盘
在节点一执行:
[dmdba@DCS1 dm8]$ cd /dm8/bin
[dmdba@DCS1 bin]$ ./dmasmcmd
create dcrdisk '/dev/raw/raw1' 'dcr'
create votedisk '/dev/raw/raw2' 'vote'
create asmdisk '/dev/raw/raw3' 'LOG0'
create asmdisk '/dev/raw/raw4' 'DATA0'
init dcrdisk '/dev/raw/raw1' from '/dm8/config/dmdcr_cfg.ini' identified by 'abcd'
init votedisk '/dev/raw/raw2' from '/dm8/config/dmdcr_cfg.ini'
1.6配置ASM的MAL系统配置文件
两台机器都需要配置
vim /dm8/config/dmasvrmal.ini
[MAL_INST1]
MAL_INST_NAME = ASM1
MAL_HOST = 10.10.10.101
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM2
MAL_HOST = 10.10.10.102
MAL_PORT = 7236
[dmdba@DCS1 bin]$ vim /dm8/config/dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm8/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL =10
DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/dm8/config/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 30
DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/dm8/config/dsc1/dm.ini dcr_ini=/dm8/config/dmdcr.ini
[dmdba@DCS2 dm8]$ vim /dm8/config/dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm8/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 1
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL =10
DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/dm8/config/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 30
DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/dm8/config/dsc2/dm.ini dcr_ini=/dm8/config/dmdcr.ini
1.7启动DMCSS服务
两台机器都启动
[dmdba@DCS1 bin]$ ./dmcss dcr_ini=/dm8/config/dmdcr.ini
[dmdba@DCS2 bin]$ ./dmcss dcr_ini=/dm8/config/dmdcr.ini
1.8创建 ASM 磁盘组
./dmasmtool dcr_ini=/dm8/config/dmdcr.ini
create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
1.9初始化共享存储集群数据库实例
1.9.1添加配置文件
[dmdba@DCS1 bin]$ vim /dm8/config/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 = 1024
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 = /dm8/config/dsc1
port_num = 5236
mal_host = 10.10.10.101
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 = /dm8/config/dsc2
port_num = 5236
mal_host = 10.0.0.12
mal_port = 9236
log_path = +DMLOG/log/DSC2_log01.log
log_path = +DMLOG/log/DSC2_log02.log
1.9.2初始化实例
[dmdba@DCS1 bin]$ ./dminit control=/dm8/config/dminit.ini
1.9.3拷贝dsc2到节点2
[dmdba@DCS1 config]$ scp -pr dsc2 dmdba@192.168.1.102:/dm8/config/
[dmdba@DCS1 config]$ rm -rf dsc2/
1.10配置监视器
任意一台机器:
vi /dm8/config/dmcssm.ini
#和 dmdcr_cfg.ini 中的 DCR_OGUID 保持一致
CSSM_OGUID = 63635
#配置所有 CSS 的连接信息,
#和 dmdcr_cfg.ini 中 CSS 配置项的 DCR_EP_HOST 和 DCR_EP_PORT 保持一致
CSSM_CSS_IP = 192.168.1.101:9341
CSSM_CSS_IP = 192.168.1.102:9341
CSSM_LOG_PATH =/dm8/log #监视器日志文件存放路径
CSSM_LOG_FILE_SIZE = 256 #每个日志文件最大 1024 MB
CSSM_LOG_SPACE_LIMIT = 2048 #限定日志文件总占用空间
[dmdba@DCS1 bin]$ ./dmcssm ini_path=/dm8/config/dmcssm.ini
1.11配置dm_svc.conf
vi /etc/dm_svc.conf