欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

[达梦数据库]达梦DSC集群搭建

程序员文章站 2022-06-02 20:07:48
...

1 环境准备

主机 IP地址 实例名 操作系统
DSC1 外部⽹络:192.168.1.81 内部⽹络:172.16.1.81 RAC0 CentOS7
DSC2 外部⽹络:192.168.1.82 内部⽹络:172.16.1.82 RAC1 CentOS7

2 安装DM数据库(各节点都需要)

2.1 关闭防⽕墙

[[email protected] ~]# systemctl stop firewalld
[[email protected] ~]# systemctl disable firewalld
 Removed symlink /etc/systemd/system/multiuser.target.wants/firewalld.service.
 Removed symlink /etc/systemd/system/dbusorg.fedoraproject.FirewallD1.service.

Redhat6:

[[email protected] ~]# service iptables stop
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[[email protected] ~]# chkconfig iptables off
[[email protected] ~]# chkconfig --list iptables

2.2 关闭Selinux

[[email protected] ~]# vim /etc/selinux/config

2.3 创建DM⽤户

⽤户组为:dinstall,⽤户名为:dmdba,⽤户⽬录为:/home/dmdba,⽤户密码:123456

[[email protected] ~]# groupadd dinstall
[[email protected] ~]# useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
[[email protected] ~]# passwd dmdba

2.4 创建⽬录

用于存储dm数据库文件的空间,需要提前规划并挂载好

[[email protected] ~]# mkdir -p /dm/dmdbms
#将dm目录指定给dmdba用户#
[[email protected] ~]# chown -R dmdba:dinstall /dm
#给dm目录授权#
[[email protected] ~]# chmod -R 775 /dm

2.5 配置系统限制

2.5.1 修改ulimit参数

[[email protected] ~]# cp /etc/security/limits.conf /etc/security/limits.conf.bak
#在/etc/security/limits.conf ⽂件中添加如下内容:#
[[email protected] ~]# vim /etc/security/limits.conf
dmdba soft nofile 65546
dmdba hard nofile 65536

2.5.2 验证配置ulimit是否⽣效

重启操作系统,并切换⾄dmdba⽤户查看

[[email protected] ~]$ ulimit -a

2.6 配置环境变量

在dmdba⽤户~/.bash_profile ⾥添加如下内容:

[[email protected] ~]$ vim ~/.bash_profile
export DM_HOME="/dm/dmdbms"
export LD_LIBRARY_PATH="/dm/dmdbms/bin:$LD_LIBRARY_PATH"
export PATH="/dm/dmdbms/bin:$PATH"

使环境变量⽣效

[[email protected] ~]$ source ~/.bash_profile

2.7 上传DM安装程序到/dm

使⽤root⽤户给DMInstall.bin程序授权

[[email protected] dm8]# chmod 755 ./DMInstall.bin

2.8 运⾏DM安装程序

⽤dmdba⽤户运⾏DM安装程序进⾏命令⾏安装

[[email protected] dm8]$ ./DMInstall.bin -i

3 共享存储环境准备(虚拟化环境配置)

规划6个共享存储如下:
Dcr disk: 1G
Voting disk: 2G
Log disk: 3G
Data disk1: 4G
Data disk2: 5G
Data disk3: 6G

先在你本机的vmware安装目录上找到 vmware-vdiskmanager.exe 执行文件。D:\VMware\VMwareWorkstation\vmware-vdiskmanager.exe
C:\Users\Administrator>cd /d D:\VMware\VMwareWorkstation
D:\VMware\VMwareWorkstation>vmware-vdiskmanager.exe -c -s 1Gb -a lsilogic -t 2 “E:\VirtualMachines\Disk\SharedDiskDcr.vmdk”
Creating disk ‘E:\VirtualMachines\Disk\SharedDiskDcr.vmdk’
Create: 100% done.
Virtual disk creation successful.
D:\VMware\VMwareWorkstation>vmware-vdiskmanager.exe -c -s 2Gb -a lsilogic -t 2 “E:\VirtualMachines\Disk\SharedDiskVoting.vmdk”
D:\VMware\VMwareWorkstation>vmware-vdiskmanager.exe -c -s 3Gb -a lsilogic -t 2 “E:\VirtualMachines\Disk\SharedDiskLog.vmdk”
D:\VMware\VMwareWorkstation>vmware-vdiskmanager.exe -c -s 4Gb -a lsilogic -t 2 “E:\VirtualMachines\Disk\SharedDiskData1.vmdk”
D:\VMware\VMwareWorkstation>vmware-vdiskmanager.exe -c -s 5Gb -a lsilogic -t 2 “E:\VirtualMachines\Disk\SharedDiskData2.vmdk”
D:\VMware\VMwareWorkstation>vmware-vdiskmanager.exe -c -s 6Gb -a lsilogic -t 2 “E:\VirtualMachines\Disk\SharedDiskData3.vmdk”

4 绑定UDEV(各节点都需要)

4.1 查看创建好raw设备

[[email protected] ~]# fdisk -l|grep "/dev/sd*"

4.2 创建UDEV绑定脚本

由于划分了多个磁盘,这些盘符在每次系统启动后并不唯⼀,所以我先使⽤UDEV绑定后,再 绑定成raw设备。
在/dm⽬录下创建udev.sh并添加如下内容:

[[email protected] rules.d]# cd /dm/
[[email protected] dm]# vim udev.sh
for i in b c d e f g;
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+=\"asmdisk$i\",OWNER=\"dmdba\", GROUP=\"dinstall\",MODE=\"0660\"" >> /etc/udev/rules.d/99-dm-devices.rules
done

redhat6:

echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\""      >> /etc/udev/rules.d/99-dm-devices.rules

4.3 执⾏UDEV绑定脚本

给创建好的udev.sh加权限

[[email protected] dm8]# chmod +x udev.sh

执⾏绑定脚本

[[email protected] dm8]# ./udev.sh

4.4 查看执⾏脚本结果

[[email protected] dm]# cat /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=="1ATA_VBOX_HARDDISK_VBc8b95773-b5e7cd0e", SYMLINK+="asmdiskb",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VBd447f8dc-a465ceae", SYMLINK+="asmdiskc",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB59d5a474-db42a119", SYMLINK+="asmdiskd",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB26af17be-273062ba", SYMLINK+="asmdiske",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB1f1f4e1c-7202894c", SYMLINK+="asmdiskf",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB3b308365-65e3a776", SYMLINK+="asmdiskg",OWNER="dmdba", GROUP="dinstall",MODE="0660"

4.5 重启UDEV

[[email protected] ~]# /sbin/udevadm trigger --type=devices --action=change
[[email protected] ~]# /sbin/udevadm control --reload-rules

4.6 查看绑定

[[email protected] dm8]# ll /dev/asm*

5 配置raw设备(各节点都需要)

5.1 修改/etc/rc.local⽂件

在官⽅⽂档raw的配置是写⼊到/etc/udev/rules.d/60-raw.rules ⽂件,但因为我们之前的 UDEV 规则顺序⽐60-raw低,所以我们这⾥把raw配置直接写⼊到/etc/rc.local 中,以防映射失败。
在rc.local 中添加如下内容:

[[email protected] ~]# chmod +x /etc/rc.d/rc.local
[[email protected] ~]# 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

touch /var/lock/subsys/local

#注意这里必须放在最后一行,否则开机不会自动映射raw设备。

5.2 查看裸设备⼤⼩

[[email protected] ~]# reboot
[[email protected] ~]# blockdev --getsize64 /dev/raw/raw1
1073741824

6 配置dmdcr_cfg.ini ⽂件

在2个节点的/dm/dmdbms/data⽬录下创建配置⽂件dmdcr_cfg.ini,在⽂件中添加如下内容:

[[email protected] dmdbms]# su - dmdba
[[email protected] ~]$ mkdir /dm/dmdbms/data
[[email protected] ~]$ vim /dm/dmdbms/data/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.81
DCR_EP_PORT = 9541
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 172.16.1.82
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.81
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.82
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

7 使⽤ DMASMCMD ⼯具初始化

在任意⼀台节点上⽤dmasmcmd⼯具执⾏如下命令:

[[email protected] ~]$ dmasmcmd 
DMASMCMD V8
ASM>create dcrdisk '/dev/raw/raw1' 'dcr'
[Trace]The ASM initialize dcrdisk /dev/raw/raw1 to name DMASMdcr
Used time: 6.444(ms).
ASM>create votedisk '/dev/raw/raw2' 'vote'
[Trace]The ASM initialize votedisk /dev/raw/raw2 to name DMASMvote
Used time: 6.290(ms).
ASM>create asmdisk '/dev/raw/raw3' 'LOG0'
[Trace]The ASM initialize asmdisk /dev/raw/raw3 to name DMASMLOG0
Used time: 12.429(ms).
ASM>create asmdisk '/dev/raw/raw4' 'DATA0'
[Trace]The ASM initialize asmdisk /dev/raw/raw4 to name DMASMDATA0
Used time: 11.047(ms).
ASM>init dcrdisk '/dev/raw/raw1' from '/dm/dmdbms/data/dmdcr_cfg.ini' identified by 'dameng123'
[Trace]DG 126 allocate 4 extents for file 0xfe000002.
Used time: 130.824(ms).
ASM>init votedisk '/dev/raw/raw2' from '/dm/dmdbms/data/dmdcr_cfg.ini'
[Trace]DG 125 allocate 4 extents for file 0xfd000002.
Used time: 32.514(ms).

8 准备DMASM 的 MAL 配置⽂件(dmasvrmal.ini)

在2个节点的/dm/dmdbms/data⽬录下创建 DMASM 的 MAL 配置⽂件(命名为 dmasvrmal.ini),使⽤ DMASM 的所有节点都要配置,内容完全⼀样。

[[email protected] ~]$ vim /dm/dmdbms/data/dmasvrmal.ini

[MAL_INST1]
MAL_INST_NAME = ASM0
MAL_HOST = 172.16.1.81
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM1
MAL_HOST = 172.16.1.82
MAL_PORT = 7237

9 准备dmdcr.ini 配置⽂件

dmdcr.ini 是 dmcss、dmasmsvr、dmasmtool ⼯具的输⼊参数。记录了当前节点***以 及 DCR 磁盘路径。
在2个节点的/dm8/dmdbms/data⽬录下创建dmdcr.ini 配置⽂件,dmdcr_path 相同,dmasvrmal.ini ⽂件内容也相同,dmdcr_seqo 分别为 0 和 1。
节点DSC1

[[email protected] ~]$ 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
节点DSC2
[[email protected] ~]$ 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

#DB 重启参数,命令行方式启动

DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /dm/dmdbms/bin/dmserver path=/dm/dmdbms/data/rac1_config/dm.ini dcr_ini=/dm/dmdbms/data/dmdcr.ini

10 启动DMCSS、DMASM 服务程序

10.1 分别在2个节点注册DMCSS和DMASM服务

以root⽤户执⾏
节点DSC1
注册DMCSS服务

[[email protected] ~]# /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服务
[[email protected] ~]# /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)完成
节点DSC2
注册DMCSS服务
[[email protected] ~]# /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服务
[[email protected] ~]# /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)完成

10.2 启动DMCSS和DMASM 服务

#节点DSC1
[[email protected] ~]# service DmCSSServicerac1 start
Redirecting to /bin/systemctl start DmCSSServicerac1.service
[[email protected] ~]# service DmASMSvrServicerac1 start
Redirecting to /bin/systemctl start DmASMSvrServicerac1.service
#节点DSC2
[[email protected] ~]# service DmCSSServicerac2 start
[[email protected] ~]# service DmASMSvrServicerac2 start

10.3 ⼿⼯启动命令

⼿⼯启动命令如下,⼿⼯启动后窗⼝不能关闭,所以这⾥仅作了解,不运⾏:

#⼿动启动 dmcss 命令:
dmcss DCR_INI=/dm8/dmdbms/data/dmdcr.ini
#⼿动启动 dmasmsvr 命令:
dmasmsvr DCR_INI=/dm8/dmdbms/data/dmdcr.ini

11 创建DMASM磁盘组

在任意节点使⽤ dmasmtool ⼯具创建 DMASM 磁盘组。

[[email protected] ~]$ dmasmtool DCR_INI=/dm/dmdbms/data/dmdcr.ini
DMASMTOOL V8
ASM>create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
Used time: 111.881(ms).
ASM>create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
Used time: 119.307(ms).

12 准备dminit.ini 配置⽂件

在2个节点的/dm/dmdbms/data⽬录下创建 dminit.ini 配置⽂件,添加如下内容。 在2个节点都创建。

[[email protected] ~]$ 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 磁盘路径,目前不支持 asm,只能是裸设备
dcr_seqno = 0
auto_overwrite = 1

[RAC0] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /dm/dmdbms/data/rac0_config
port_num = 5236
mal_host = 172.16.1.81
mal_port = 9340
log_path = +DMLOG/log/rac0_log01.log
log_path = +DMLOG/log/rac0_log02.log

[RAC1] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /dm/dmdbms/data/rac1_config
port_num = 5236
mal_host = 172.16.1.82
mal_port = 9341
log_path = +DMLOG/log/rac1_log01.log
log_path = +DMLOG/log/rac1_log02.log

13 使⽤dminit 初始化 DB 环境

在任意节点启动 dminit ⼯具初始化数据库。dminit 执⾏完成后,会在 config_path ⽬录 (/dm/dmdbms/data/rac0_config 和/dm/dmdbms/data/rac1_config)下⽣成配置⽂件 dm.ini 和 dmmal.ini。

[[email protected] data]$ dminit control=/dm/dmdbms/data/dminit.ini
initdb V8
db version: 0x7000b
file dm.key not found, use default license!
License will expire on 2021-12-07

 log file path: +DMLOG/log/rac0_log01.log


 log file path: +DMLOG/log/rac0_log02.log


 log file path: +DMLOG/log/rac1_log01.log


 log file path: +DMLOG/log/rac1_log02.log

write to dir [+DMDATA/data/rac].
create dm database success. 2021-01-03 20:59:45
#将rac1的配置⽂件复制过去节点DSC2:
[[email protected] data]$ cd /dm/dmdbms/data/
[[email protected] data]$ scp -r rac1_config/ 192.168.1.82:`pwd`
The authenticity of host '192.168.1.82 (192.168.1.82)' can't be established.
ECDSA key fingerprint is SHA256:ODW+OT9h3hEMrTLxeZ9UXsGZZz1claHTGdSdx14+nAY.
ECDSA key fingerprint is MD5:aa:5a:7f:be:3d:56:4f:0f:7b:51:34:2a:dc:19:05:e7.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.1.82' (ECDSA) to the list of known hosts.
[email protected]'s password: 
dmmal.ini					100%  202    94.4KB/s   00:00    
dm.ini						100%   48KB   7.8MB/s   00:00    
sqllog.ini						100%  479   264.8KB/s   00:00

14 启动数据库服务器

14.1 注册服务

在2个节点分别注册DM 数据库服务:

#节点DSC1
[[email protected] ~]# /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
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServicerac1.service to /usr/lib/systemd/system/DmServicerac1.service.
创建服务(DmServicerac1)完成
#节点DSC2
[[email protected] ~]# /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
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServicerac2.service to /usr/lib/systemd/system/DmServicerac2.service.
创建服务(DmServicerac2)完成

14.2 启动数据库

#节点DSC1
[[email protected] ~]# systemctl start DmServicerac1
#节点DSC2
[[email protected] ~]# systemctl start DmServicerac2

如果 DMCSS 配置有⾃动拉起 dmserver 的功能,可以等待 DMCSS ⾃动拉起实例,不需要手动启动。

14.3 ⼿⼯启动命令

⼿⼯启动命令如下,⼿⼯启动后窗⼝不能关闭,所以…

./dmserver /dm8/dmdbms/data/rac0_config/dm.ini dcr_ini=/dm/dmdbms/data/dmdcr.ini
./dmserver /dm8/dmdbms/data/rac1_config/dm.ini dcr_ini=/dm/dmdbms/data/dmdcr.ini

15 连接数据库验证

15.1 配置dm_svc.conf服务名⽂件

[[email protected] ~]# vim /etc/dm_svc.conf
rac=(192.168.1.81:5236,192.168.1.82:5236)
SWITCH_TIME=(10000)
SWITCH_INTERVAL=(100)
TIME_ZONE=(480)
LANGUAGE=(cn)
[[email protected] ~]# chown dmdba:dinstall /etc/dm_svc.conf

15.2 连接RAC集群

[[email protected] ~]$ disql sysdba/[email protected]

服务器[192.168.1.82:5236]:处于普通打开状态
登录使用时间 : 9.221(ms)
disql V8
SQL> select instance_name from v$instance;

行号     INSTANCE_NAME
---------- -------------
1          RAC1

已用时间: 6.222(毫秒). 执行号:100.
SQL> select * from v$dsc_ep_info;

行号     EP_NAME EP_SEQNO    EP_GUID              EP_TIMESTAMP         EP_MODE      EP_STATUS
---------- ------- ----------- -------------------- -------------------- ------------ ---------
1          RAC0    0           808391232            808391691            Control Node OK
2          RAC1    1           808399522            808399956            Normal Node  OK

已用时间: 15.359(毫秒). 执行号:101.
SQL>

15.3 测试故障重连

SQL> select instance_name from v$instance;

行号     INSTANCE_NAME
---------- -------------
1          RAC1

已用时间: 1.027(毫秒). 执行号:102.

#此时连接的rac1,我们kill 进程:

[[email protected] ~]# ps -ef|grep dm.ini
dmdba     4465     1  0 21:09 ?        00:00:06 /dm/dmdbms/bin/dmserver /dm/dmdbms/data/rac1_config/dm.ini DCR_INI=/dm/dmdbms/data/dmdcr.ini -noconsole
root     31843  4086  0 21:20 pts/1    00:00:00 grep --color=auto dm.ini
[[email protected] ~]# kill -9 4465

#在查询,等了⼀分钟左右,故障重连成功:

SQL> select instance_name from v$instance;

行号     INSTANCE_NAME
---------- -------------
1          RAC1

已用时间: 1.027(毫秒). 执行号:102.
SQL> select instance_name from v$instance;
[-70019]:网络通讯失败.
SQL> select instance_name from v$instance;

服务器[192.168.1.81:5236]:处于普通打开状态
已连接

行号     INSTANCE_NAME
---------- -------------
1          RAC0

已用时间: 9.406(毫秒). 执行号:51200.

#启动rac0,节点0变成了normal:

[root@DSC2 ~]# service DmServicerac2 start
Redirecting to /bin/systemctl start DmServicerac2.service
SQL> select * from v$dsc_ep_info;

行号     EP_NAME EP_SEQNO    EP_GUID              EP_TIMESTAMP         EP_MODE      EP_STATUS
---------- ------- ----------- -------------------- -------------------- ------------ ---------
1          RAC0    0           808391232            808392157            Control Node OK
2          RAC1    1           808682009            808682033            Normal Node  OK