VirtualBox下虚拟机Oracle 19C RAC与达梦8 DSC同机共存系列
之 达梦8 DSC推送安装
Fred.li 2022-10-31
目录
VirtualBox下虚拟机Oracle 19C RAC与达梦8 DSC共存
概述
在使用国产数据库DM8的过程中,学习、测试、部署的过程,对于熟悉Oracle 19c RAC的架构的工程师,搭建一套共存的环境, 使用相同的2个节点,使用绑定共享磁盘,都使用ASM ,都使用集群架构。 借鉴Oracle学习Dameng,同环境性能测试,部署测试,对比差异(两种ASM、两种数据库)等比异机更准确有效。
一、虚拟机设置
Kylin101
Kylin102
Dem
二、DEM 部署
参照文档配置DEM服务器, 参考文档在DM8安装目录的web目录内
[dmdba@dem web]$ ls
dem_init.sql DEM.pdf demsdk dem.war readme.txt
登陆DEM的web页面
Kylin101和Kylin101创建dmdba账户和dinstall组。
Kylin101和Kylin101创建/dm目录。
Kylin101和Kylin101已经在安装Oracle 19C RAC时绑定共享磁盘。
[root@kylin101 ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 100G 0 disk
├─sda1 8:1 0 1G 0 part /boot
└─sda2 8:2 0 99G 0 part
├─klas-root 253:0 0 61.2G 0 lvm /
├─klas-swap 253:1 0 7.9G 0 lvm [SWAP]
└─klas-backup 253:2 0 29.9G 0 lvm
sdb 8:16 0 50G 0 disk
sdc 8:32 0 50G 0 disk
sdd 8:48 0 1.2G 0 disk
sde 8:64 0 50G 0 disk
sdf 8:80 0 10G 0 disk
sdg 8:96 0 300M 0 disk
sdh 8:112 0 300M 0 disk
sr0 11:0 1 1024M 0 rom
root@kylin101 dm]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VBc9947097-05595839",RUN+="/bin/sh -c 'mknod /dev/asm-data01 b $major $minor; chown grid:asmadmin /dev/asm-data01; chmod 660 /dev/asm-data01'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VBfb7b2fe3-ab101384",RUN+="/bin/sh -c 'mknod /dev/asm-data02 b $major $minor; chown grid:asmadmin /dev/asm-data02; chmod 660 /dev/asm-data02'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VBeb6440e4-caa3b309",RUN+="/bin/sh -c 'mknod /dev/asm-ocr2 b $major $minor; chown grid:asmadmin /dev/asm-ocr2; chmod 660 /dev/asm-ocr2'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB661e9e75-f34401b2",RUN+="/bin/sh -c 'mkdir /dev/dmasm; chown dmdba:dinstall /dev/dmasm; mknod /dev/dmasm/dcr b $major $minor; chown dmdba:dinstall /dev/dmasm/dcr ; chmod 660 /dev/dmasm/dcr'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB64de2cb1-737887f3",RUN+="/bin/sh -c 'mkdir /dev/dmasm; chown dmdba:dinstall /dev/dmasm; mknod /dev/dmasm/vote b $major $minor; chown dmdba:dinstall /dev/dmasm/vote; chmod 660 /dev/dmasm/vote'"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VBce5500ab-9a704dbb",RUN+="/bin/sh -c 'mkdir /dev/dmasm; chown dmdba:dinstall /dev/dmasm; mknod /dev/dmasm/data001 b $major $minor; chown dmdba:dinstall /dev/dmasm/data001 ; chmod 660 /dev/dmasm/data001 '"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB70b281d6-c884d55c",RUN+="/bin/sh -c 'mkdir /dev/dmasm; chown dmdba:dinstall /dev/dmasm; mknod /dev/dmasm/log001 b $major $minor; chown dmdba:dinstall /dev/dmasm/log001 ; chmod 660 /dev/dmasm/log001 '
[root@kylin101 ~]# ls -l /dev/asm*
brw-rw---- 1 root root 8, 16 Nov 1 10:45 /dev/asm-data01
brw-rw---- 1 root root 8, 32 Nov 1 10:45 /dev/asm-data02
brw-rw---- 1 root root 8, 48 Nov 1 10:45 /dev/asm-ocr2
[root@kylin101 ~]# ls -l /dev/dmasm/*
brw-rw---- 1 dmdba dinstall 8, 64 Nov 1 10:45 /dev/dmasm/data001
brw-rw---- 1 dmdba dinstall 8, 96 Nov 1 10:46 /dev/dmasm/dcr
brw-rw---- 1 dmdba dinstall 8, 80 Nov 1 10:45 /dev/dmasm/log001
brw-rw---- 1 dmdba dinstall 8, 112 Nov 1 10:45 /dev/dmasm/vote
Agent 软件在DEM的 webapps/dem/dmagent下
/dm/tomcat9/webapps/dem/dmagent
[root@dem dmagent]# ls
agent.ini lib log log4j.xml readme.pdf resources service service.bat service.sh ssl start.bat start.sh tmp upload
Kylin101和Kylin101只配置agent并启动。
[root@kylin101 ~]# cd /dm
[root@kylin101 dm]# ls
dmagent dmbak dmdbms log
[root@kylin101 dm]# cd dmagent
[root@kylin101 dmagent]# ls
agent.ini +DMDATA lib log log4j.xml readme.pdf resources service service.bat service.sh ssl start.bat start.sh tmp upload
[root@kylin101 dmagent]# cat agent.ini
#general
id_policy = 0 #agent id generate policy, 0: mac & ip, 1: ip
center_url = http://192.168.100.168:8080/dem #center url location, eg: http://192.168.2.10:8080/dem
ip_list = [] #custom local ip list, auto collect if not config, example: [192.168.1.100, 192.168.2.100]
dm_bin_path = #dm bin path for jni call
upload_path = #path for temporarily uploading and downloading files(e.g. backupsets for deploy). It is suggested to hava much available space on this disk. Deafult value is agent_root/upload
collect_data_by_command = false #whether enable collect systeminfo data by operating system command, only available in Linux
deploy_umask = 0077 #set file mode creation mask in deployment function, only available in Linux(Unix)
#ap
[root@kylin101 dmagent]# ps -ef|grep agent
root 1887 1 1 10:45 ? 00:00:06 java -Xms64m -Xmx2048m -cp /dm/dmagent/lib/* -Dnoconsole=true -Ddameng.log.file=/dm/dmagent/log4j.xml -Dagent.home=/dm/dmagent -Dagent.pid.file=/dm/dmagent/service/DmAgentService.pid com.dameng.agent.Agent /dm/dmagent/agent.ini
两个节点识别并正常:
三、达梦8 DSC(共享存储集群)安装
集群管理选择创建集群dc001da
DSC自动部署脚本执行完成 :
DSC加入监控
四、达梦8 DSC(共享存储集群)验证
对象管理选择创建dc001da
五、达梦8 DSC(共享存储集群)卸载
集群管理选择集群搭建dc001da双击
选择回滚所有任务
回滚所有任务脚本结束: