DMDSC ansiable 脚本安装
一.Ansible环境安装手册
1.使用KylinV10 iso镜像配置光盘yum源
cd /etc/yum.repos.d
cat > /etc/yum.repos.d/cdrom.repo <<EOF
[cdrom]
name=linux7_cdrom
baseurl=file:///mnt
gpgcheck=0
enabled=1
EOF
挂载光盘iso镜像
mount /opt/Kylin-Server-10-SP1-Release-Build20-20210518-x86_64.iso /mnt -o loop
验证光盘yum源已生效
[root@localhost yum.repos.d]# yum makecache
cdrom 3.7 MB/s | 3.8 kB 00:00
Metadata cache created.
[root@localhost yum.repos.d]# yum repolist
repo id repo name
cdrom cdrom
yum list | grep vnc
2.安装 ansible
解压离线安装包
unzip ansible-offline-install-main.zip
cd ansible-offline-install-main
mv ansiable /etc
chmod +x install.sh
./install.sh
部署完成后在/etc/ansible目录下新建roles子目录
Mkdir -p /etc/ansible/roles
3.离线部署perl运行环境
unzip depend_lib.zip
mv depend_lib /etc/ansible/
cd depend_lib/
chmod +x install.sh
./install.sh
4.配置自动化部署脚本
unzip dsc自动化部署脚本1.0.zip
mv dsc自动化部署脚本1.0 dsc01
将脚本目录拷贝至roles目录下，如下显示将dsc_setup脚本拷贝到了roles目录下
cd dsc01/
mv ansiable /etc /etc/ansible/roles
把其他的文件都移动到/etc/ansible文件夹下
[root@localhost dsc_setup]# cd /tmp/dsc01/
[root@localhost dsc01]# ls
dsc_automation.yml dsc_env_config.pl get_uuid.pl replace_param_val.pl
[root@localhost dsc01]# mv dsc_automation.yml /etc/ansible/
[root@localhost dsc01]# mv dsc_env_config.pl /etc/ansible/
[root@localhost dsc01]# mv get_uuid.pl /etc/ansible/
[root@localhost dsc01]# mv replace_param_val.pl /etc/ansible/
5.安装前准备
在cd /etc/ansible 路径下
打开hosts文件，添加如下内容
[dmdsc]
192.168.111.141 node_seq=0
192.168.111.142 node_seq=1
192.168.111.143 node_seq=2
chmod +x dsc_env_config.pl
./dsc_evn_config.pl
把DM8安装包传到cd /etc/ansible/roles/dsc_setup/files 路径下
二.数据库脚本安装
1.安装前规划
1.1.IP 规划
公网IP: 192.168.159.236-238
私网IP: 176.16.159.236-238
1.2.磁盘规划
一块500G存储：dmasm_dcr、dmasm_vote、dmasm_log0，dmasm_arch0，dmasm_data0大小分别为2G、2G、100G、100G、200G
[root@dsc01-159-236 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sda
360014056561f6dbbb034067a8805dd23
parted
mklabel gpt
mkpart primary 0 2G
mkpart primary 2G 4G
mkpart primary 4G 104G
mkpart primary 104G 204G
mkpart primary 204G -1
1.3.按盘符进行磁盘绑定
在目录cd /etc/udev/rules.d 中新建文件vi 88-dm-asmdevices.rules
KERNEL==“sda1”,SUBSYSTEM==“block”,OWNER=“dmdba”,GROUP=“dinstall”,SYMLINK+=“CRM/dmasm_vote”,MODE=“0660”
KERNEL==“sda2”,SUBSYSTEM==“block”,OWNER=“dmdba”,GROUP=“dinstall”,SYMLINK+=“CRM/dmasm_dcr”,MODE=“0660”
KERNEL==“sda3”,SUBSYSTEM==“block”,OWNER=“dmdba”,GROUP=“dinstall”,SYMLINK+=“CRM/dmasm_log0”,MODE=“0660”
KERNEL==“sda4”,SUBSYSTEM==“block”,OWNER=“dmdba”,GROUP=“dinstall”,SYMLINK+=“CRM/dmasm_arch0”,MODE=“0660”
KERNEL==“sda5”,SUBSYSTEM==“block”,OWNER=“dmdba”,GROUP=“dinstall”,SYMLINK+=“CRM/dmasm_data0”,MODE=“0660”
/sbin/udevadm control --reload
/sbin/udevadm trigger --action change
/sbin/udevadm trigger --action add
1.4.关闭防火墙
systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld
vim /etc/selinux/config
2.安装开始
2.1. 执行 ./dsc_env_config.pl
在/etc/ansiable 目录下进行安装
[root@192-168-161-178 ansible]# ./dsc_env_config.pl
选择下面的菜单命令前的数字,执行集群安装前的准备.
(1)确定集群部署参数
(2)建立管理节点和集群节点间的互信
(3)配置共享存储
(4)配置集群网络
(5)传递配置文件
(6)查看配置参数
(7)手动建立互信
>>1
是否加载已存在的参数文件(y/n)>>n
---------------------------环境相关参数------------------------------
iso文件名[default: none]>>dm8_20220928_x86_kylin10_64_ent_8.1.2.138_pack3.iso
达梦软件安装家目录[default: /dm]>>
达梦共享集群计算节点数>>3
相同的用户登录密码>>Dameng@777
管理节点IP>>192.168.131.178
达梦共享集群外部访问ip,多个iP逗号分隔>>192.168.159.236-238
达梦共享集群内部高速互联网络ip,多个ip间逗号分隔>>176.16.159.236-238
校时服务器IP>>192.168.111.46
----------------------------集群相关参数------------------------------
集群间消息标识[default: 20221207]>>
集群组件组编号[default: 0]>>
表决磁盘路径[default: /dev/PROD/dmasm_vote]>>/dev/CRM/dmasm_vote
集群注册磁盘路径[default: /dev/PROD/dmasm_dcr]>>/dev/CRM/dmasm_dcr
节点CSS服务TCP监听端口[default: 11286]>>
节点ASM服务TCP监听端口[default: 11276,11277 ...]>>11276,11277,11278
节点DB服务TCP监听端口[default: 11236]>>
DMASM存储服务MAL系统TCP监听端口号[default: 11246]>>
各实例是否活动检查端口[default: 11256,11257 ...]>>11256,11257,11258
数据库服务MAL系统TCP监听端口[default: 11266]>>
数据库服务重启时间间隔(s)[default: 0]>>
DMASM服务重启时间间隔(s)[default: 0]>>
超时未启动的数据库节点被踢出集群(s)[default: 111]>>
ASM共享内存key[default: 42424,42425 ...]>>82424,82425,82426
归档磁盘组名称[default: DGARCH01]>>
数据磁盘组名称[default: DGDATA01]>>
在线日志磁盘组名称[default: DGLOG01]>>
----------------------------数据库相关参数------------------------------
数据库名称[default: PROD]>>CRM
系统表空间大小(M)[default: 30720]>>10240
回滚表空间大小(M)[default: 30720]>>10240
在线日志文件大小(M)[default: 2048]>>
在线日志文个数[default: 5]>>
数据页大小(k)[default: 16]>>32
数据区大小(page个数)[default: 16]>>32
字符大小写是否敏感(0-不敏感,1-敏感)[default: 1]>>
数据库字符集(0-gb180301,1-utf8)[default: 0]>>
字符长度单位(0-字节,1-字符)[default: 0]>>
空白填充模式是否兼容oracle(0-不兼容,1-兼容)[default: 1]>>
是否运行于归档模式(0-关归档 1-开归档)[default: 0]>>1
归档文件的大小(M)[default: 2048]>>
归档空间占用大小限制(M)[default: 204800]>>51200
可通过输入sp命令查询所有参数值,建议修改参数后使用该命令确认!
是否有参数需要修改?(y/n)>>SP
----------根据以下输入情况,检查参数配置是否正确-----------
(1)ISO_FILE_NAME =dm8_20220928 (2)HOME_DIR =/dm (3)DSC_NUM =3
(4)SAME_USER_PWD =Dameng@777 (5)MANAGER_IP =192.168.131.178 (6)DSC_PUBLIC_IP =192.168.159.236-238
(7)DSC_PRIVATE_IP =176.16.159.2 (8)TIME_SERVER_IP =192.168.111.46 (9)OGUID =20221207
(10)EP_NUM_START =0 (11)VTD_PATH =/dev/CRM/dmasm_vote (12)DCR_PATH =/dev/CRM/dmasm_dcr
(13)EP_PORT_CSS =11286 (14)EP_PORT_ASM =11276,11277,11278 (15)EP_PORT_DB =11236
(16)EP_MAL_PORT =11246 (17)CHECK_PORT =11256,11257,11258 (18)MAL_PORT =11266
(19)DB_RESTART_INTERVAL =0 (20)ASM_RESTART_INTERVAL =0 (21)AUTO_OPEN_CHECK =111
(22)EP_SHM_KEY =82424,82425, (23)DG_NAME_OF_ARCH =DGARCH01 (24)DG_NAME_OF_DATA =DGDATA01
(25)DG_NAME_OF_LOG =DGLOG01 (26)DB_NAME =CRM (27)SYSTEM_TABLESPACE_SIZE=10240
(28)ROLL_TABLESPACE_SIZE =10240 (29)ONLINE_LOG_SIZE =2048 (30)ONLINE_LOG_NUM =5
(31)PAGE_SIZE =32 (32)EXTENT_SIZE =32 (33)CASE_SENSITIVE =1
(34)CHARSET =0 (35)LENGTH_IN_CHAR =0 (36)BLANK_PAD_MODE =1
(37)OPEN_ARCH =1 (38)ARCH_FILE_SIZE =2048 (39)ARCH_SPACE_LIMIT_SIZE =51200
可通过输入sp命令查询所有参数值,建议修改参数后使用该命令确认!
是否有参数需要修改?(y/n)>>y
请按 参数名=参数值 格式修改参数>>MANAGER_IP=192.168.161.178
MANAGER_IP=192.168.161.178
可通过输入sp命令查询所有参数值,建议修改参数后使用该命令确认!
是否有参数需要修改?(y/n)>>sp
第一步做完之后进行第2步，配置管理节点间的互信，选2之后直接回车执行
选择下面的菜单命令前的数字,执行集群安装前的准备.
(1)确定集群部署参数
(2)建立管理节点和集群节点间的互信
(3)配置共享存储
(4)配置集群网络
(5)传递配置文件
(6)查看配置参数
(7)手动建立互信
>>2
/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub"
The authenticity of host '192.168.159.236 (192.168.159.236)' can't be established.
ED25519 key fingerprint is SHA256:wCycim/YP57oIiWS68nAmmDUk8IXD4kvLv8jdtEI0Z4.
This host key is known by the following other names/addresses:
~/.ssh/known_hosts:19: 192.168.159.231
~/.ssh/known_hosts:22: 192.168.159.232
~/.ssh/known_hosts:23: 192.168.159.233
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed
/usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys
Authorized users only. All activities may be monitored and reported.
root@192.168.159.236's password:
Number of key(s) added: 1
Now try logging into the machine, with: "ssh 'root@192.168.159.236'"
and check to make sure that only the key(s) you wanted were added.
完成管理节点到192.168.159.236的互信操作!
/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub"
The authenticity of host '192.168.159.237 (192.168.159.237)' can't be established.
ED25519 key fingerprint is SHA256:wCycim/YP57oIiWS68nAmmDUk8IXD4kvLv8jdtEI0Z4.
This host key is known by the following other names/addresses:
~/.ssh/known_hosts:19: 192.168.159.231
~/.ssh/known_hosts:22: 192.168.159.232
~/.ssh/known_hosts:23: 192.168.159.233
~/.ssh/known_hosts:24: 192.168.159.236
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed
/usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys
Authorized users only. All activities may be monitored and reported.
root@192.168.159.237's password:
Number of key(s) added: 1
Now try logging into the machine, with: "ssh 'root@192.168.159.237'"
and check to make sure that only the key(s) you wanted were added.
完成管理节点到192.168.159.237的互信操作!
/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub"
The authenticity of host '192.168.159.238 (192.168.159.238)' can't be established.
ED25519 key fingerprint is SHA256:wCycim/YP57oIiWS68nAmmDUk8IXD4kvLv8jdtEI0Z4.
This host key is known by the following other names/addresses:
~/.ssh/known_hosts:19: 192.168.159.231
~/.ssh/known_hosts:22: 192.168.159.232
~/.ssh/known_hosts:23: 192.168.159.233
~/.ssh/known_hosts:24: 192.168.159.236
~/.ssh/known_hosts:25: 192.168.159.237
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed
/usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys
Authorized users only. All activities may be monitored and reported.
root@192.168.159.238's password:
Number of key(s) added: 1
Now try logging into the machine, with: "ssh 'root@192.168.159.238'"
and check to make sure that only the key(s) you wanted were added.
完成管理节点到192.168.159.238的互信操作!
ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.161.178
自动指纹确认.
自动密码输入.
完成192.168.159.236集群节点到管理节点的互信操作!
ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.161.178
自动指纹确认.
自动密码输入.
完成192.168.159.237集群节点到管理节点的互信操作!
ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.161.178
自动指纹确认.
自动密码输入.
完成192.168.159.238集群节点到管理节点的互信操作!
公钥存在,不用再次生成!ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.159.237
自动密码输入.
完成192.168.159.236节点到192.168.159.237节点的互信操作!
公钥存在,不用再次生成!ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.159.238
自动密码输入.
完成192.168.159.236节点到192.168.159.238节点的互信操作!
公钥存在,不用再次生成!ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.159.236
自动密码输入.
完成192.168.159.237节点到192.168.159.236节点的互信操作!
公钥存在,不用再次生成!ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.159.238
自动指纹确认.
自动密码输入.
完成192.168.159.237节点到192.168.159.238节点的互信操作!
公钥存在,不用再次生成!ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.159.236
自动指纹确认.
自动密码输入.
完成192.168.159.238节点到192.168.159.236节点的互信操作!
公钥存在,不用再次生成!ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.159.237
自动指纹确认.
自动密码输入.
完成192.168.159.238节点到192.168.159.237节点的互信操作!
选择下面的菜单命令前的数字,执行集群安装前的准备.
(1)确定集群部署参数
(2)建立管理节点和集群节点间的互信
(3)配置共享存储
(4)配置集群网络
(5)传递配置文件
(6)查看配置参数
(7)手动建立互信
由于我的共享存储和一体机的的共享存储不一样，后面的脚本不适合。
这个执行完成之后在/etc/ansible/roles/dsc_setup/vars 路径下会生成一个mail.yml的文件
文件的内容如下：
---
ISO_FILE_NAME: dm8_20220928_x86_kylin10_64_ent_8.1.2.138_pack3.iso
HOME_DIR: /dm
MASTER_NODE_IP: 192.168.159.236
ORDINARY_PUBLIC_IP:
- 192.168.159.237
- 192.168.159.238
TIME_SERVER_IP: 192.168.111.46
N_GRP: 3
VTD_PATH: /dev/CRM/dmasm_vote
DCR_PATH: /dev/CRM/dmasm_dcr
N_EP: 3
EP_NUM_START: 0
OGUID: 20221207
EP_HOST_CSS:
- 192.168.159.236
- 192.168.159.237
- 192.168.159.238
EP_PORT_CSS: 11286
EP_HOST_ASM:
- 192.168.159.236
- 192.168.159.237
- 192.168.159.238
EP_PORT_ASM:
- 11276
- 11277
- 11278
EP_PORT_DB: 11236
EP_MAL_PORT: 11246
CHECK_PORT:
- 11256
- 11257
- 11258
MAL_HOST:
- 192.168.159.236
- 192.168.159.237
- 192.168.159.238
MAL_PORT: 11266
DB_RESTART_INTERVAL: 0
ASM_RESTART_INTERVAL: 0
AUTO_OPEN_CHECK: 111
EP_SHM_KEY:
- 82424
- 82425
- 82426
DG_NAME_OF_ARCH: DGARCH01
DG_NAME_OF_DATA: DGDATA01
DG_NAME_OF_LOG: DGLOG01
DB_NAME: CRM
SYSTEM_TABLESPACE_SIZE: 10240
ROLL_TABLESPACE_SIZE: 10240
ONLINE_LOG_SIZE: 2048
ONLINE_LOG_NUM: 5
PAGE_SIZE: 32
EXTENT_SIZE: 32
CASE_SENSITIVE: 1
CHARSET: 0
LENGTH_IN_CHAR: 0
BLANK_PAD_MODE: 1
OPEN_ARCH: 1
ARCH_FILE_SIZE: 2048
ARCH_SPACE_LIMIT_SIZE: 51200
dcr_disk: {sylink: /dev/CRM/dmasm_dcr}
vote_disk: {sylink: /dev/CRM/dmasm_vote}
data_disk:
- {sylink: /dev/CRM/dmasm_data0}
arch_disk:
- {sylink: /dev/CRM/dmasm_arch0}
log_disk:
- {sylink: /dev/CRM/dmasm_log0}
发现文件哪里有不对的地方也可以手动修改
2.2.执行 /etc/ansible/roles/dsc_setup/tasks 下main.yml 文件
[root@192-168-161-178 tasks]# cat main.yml
#- include: 001_config_chronyd.yml
#- include: 002_sync_node_time.yml
#- include: 003_create_group.yml
#- include: 004_create_user.yml
#- include: 005_create_dm_home_dir.yml
#- include: 006_init_os_env.yml
#- include: 007_push_setup_file.yml
#- include: 008_setup_dmdbms.yml
#- include: 009_create_misc_dir.yml
#- include: 010_copy_dbms_to_other_node.yml
#- include: 011_copy_storage_conf.yml
#- include: 012_generate_multipath_device.yml
#- include: 013_restart_udev.yml
#- include: 014_generate_dmasm_disk_script.yml
#- include: 015_generate_diskgroup_script.yml
#- include: 016_generate_dmdcr_config_ini.yml
#- include: 017_create_dmasmdisk.yml
#- include: 018_generate_dmasvrmal_ini.yml
#- include: 019_generate_dmdcr_ini.yml
#- include: 020_generate_service_startup_script.yml
#- include: 021_generate_dmcssm_ini.yml
#- include: 022_startup_css_service.yml
#- include: sleepx.yml
#- include: 023_startup_asm_service.yml
#- include: sleepx.yml
#- include: 024_create_dmasmdiskgroup.yml
#- include: 025_generate_dminit_ini.yml
#- include: 026_init_db.yml
#- include: 027_pull_ini.yml
#- include: 028_push_ini.yml
#- include: 029_adjust_file_path.yml
#- include: 030_modify_conf_permission.yml
#- include: 031_generate_db_service_startup_script.yml
#- include: 032_modify_config_path_param.yml
- include: 035_modify_temp.yml
- include: 036_modify_arch.yml
- include: 034_generate_dmarch_ini.yml
- include: 033_startup_db_service.yml
按照脚本的顺序安装数据库
分批执行，遇到错误的时候根据报错和日志排查问题，解决错误
下面是安装过程中碰到的一些报错，供参考
比如说先安装前面9步，发现没有安装成功，第7步
cat 007_push_setup_file.yml
- name: push dameng database iso
copy: src={{ISO_FILE_NAME}} dest=/media owner=dmdba group=dinstall
when: node_seq == {{EP_NUM_START}}
- name: push silent setup xml
template: src=silent_setup.xml.j2 dest=/media/silent_setup.xml
when: node_seq == {{EP_NUM_START}}
[root@dsc01-159-236 media]# ls -al /media
total 1025084
drwxr-xr-x 2 root root 89 Dec 7 13:24 .
dr-xr-xr-x. 21 root root 4096 Dec 7 13:24 ..
-rw------- 1 dmdba dinstall 1049677824 Dec 7 13:24 dm8_20220928_x86_kylin10_64_ent_8.1.2.138_pack3.iso
-rw------- 1 root root 196 Dec 7 13:24 silent_setup.xml
可以看到 silent_setup.xml文件的权限没有改过来
chown dmdba:dinstall silent_setup.xml
在/tmp 目录下把这set_host_env.tmp setup_database.tmp 删掉重新执行OK了
在/etc/ansiable 目录下重新执行ansible-playbook dsc_automation.yml
第22步启动css的时候报错
[root@dsc01-159-236 log]# tail -f dm_unknown_202212.log
2022-12-07 14:27:36.806 [ERROR] dmcss P0000066550 T0000000000000066550 os_file_open_low_real error! desc: Permission denied, path: /dev/CRM/dmasm_dcr, code: 13
2022-12-07 14:27:36.806 [ERROR] dmcss P0000066550 T0000000000000066550 os_file_open_low_real error! desc: Permission denied, path: /dev/CRM/dmasm_dcr, code: 13
2022-12-07 14:27:36.806 [FATAL] dmcss P0000066550 T0000000000000066550 dmcss startup failed:[CODE:-4546],error info:Invalid file path[/dev/CRM/dmasm_dcr]
发现共享磁盘组的权限还是在root下面的
drwxr-xr-x 2 root root 140 Dec 7 10:58 CRM
chown -R dmdba:dinstall /dev/CRM
chown -R dmdba:dinstall /dev
dd if=/dev/zero of=/dev/CRM/dmasm_vote bs=1024k count=1000
dd if=/dev/zero of=/dev/CRM/dmasm_dcr bs=1024k count=1000
重新执行脚本
cd /dm/bin
./dmasmcmd
create dcrdisk '/dev/CRM/dmasm_dcr' 'DCR'
create votedisk '/dev/CRM/dmasm_vote' 'VOTE'
init dcrdisk '/dev/CRM/dmasm_dcr' from '/dm/conf/dmdcr_config.ini' identified by 'dmdsc'
init votedisk '/dev/CRM/dmasm_vote' from '/dm/conf/dmdcr_config.ini'
# create dmasm data disk
create asmdisk '/dev/CRM/dmasm_data0' 'DATA0'
# create dmasm log disk
create asmdisk '/dev/CRM/dmasm_log0' 'LOG0'
# create dmasm arch disk
create asmdisk '/dev/CRM/dmasm_arch0' 'ARCH0'
这一部分手动执行了
执行第24步报不能到达IP，互信也是通的，手动执行了
fatal: [192.168.159.236]: UNREACHABLE! => {"changed": false, "msg": "Failed to connect to the host via ssh: Shared connection to 192.168.159.236 closed.", "unreachable": true}
./dmasmtool dcr_ini=/dm/conf/dmdcr.ini
[root@dsc01-159-236 conf]# cat dmasm_diskgroup.txt
#asm script file
# create dmasm data disk
create diskgroup 'DGDATA01' asmdisk '/dev/CRM/dmasm_data0'
# create dmasm log disk
create diskgroup 'DGLOG01' asmdisk '/dev/CRM/dmasm_log0'
# create dmasm arch disk
create diskgroup 'DGARCH01' asmdisk '/dev/CRM/dmasm_arch0'
第35步modify_temp 是100G,改成10G了，根据实际空间调整
安装完成之后根据具体的cpu和内存信息调整dm.ini参数
安装完成之后验证数据库是否可用
[dmdba@dsc01-159-236 bin]$ ./disql SYSDBA/SYSDBA:11236
Server[LOCALHOST:11236]:mode is normal, state is open
login used time : 6.091(ms)
disql V8
SQL> select * from v$dsc_ep_info;
LINEID EP_NAME EP_SEQNO EP_GUID EP_TIMESTAMP EP_MODE EP_STATUS
---------- ------- ----------- -------------------- -------------------- ------------ ---------
1 CRM0 0 49751298 50103363 Control Node OK
2 CRM1 1 49759141 50111421 Normal Node OK
3 CRM2 2 49828753 50094743 Normal Node OK
数据库启停
集群停止脚本 可以用ep方式，也可以用手工方式
su - dmdba
cd /dm/bin
./dmcssm
ep stop GRP_CRM
ep stop GRP_ASM0
或者
./DmServiceCRM0 stop
./DmServiceCRM1 stop
./DmServiceCRM2 stop
./DmASMSvrServiceCRM0 stop
./DmASMSvrServiceCRM1 stop
./DmASMSvrServiceCRM2 stop
分别在三台机器上
su - dmdba
cd /dm/bin
./DmCSSServiceCRM0 stop
./DmCSSServiceCRM1 stop
./DmCSSServiceCRM2 stop
数据库启动：
先起css，再起asm，数据库
./DmCSSServiceCRM0 start
./DmCSSServiceCRM1 start
./DmCSSServiceCRM2 start
./DmASMSvrServiceCRM0 start
./DmASMSvrServiceCRM1 start
./DmASMSvrServiceCRM2 start
./DmServiceCRM0 start
./DmServiceCRM1 start
./DmServiceCRM2 start
启动asm和数据库的时候也可以用ep方式启动
ep startup GRP_ASM0
ep startup GRP_CRM
对比手工搭建和脚本搭建DSC集群：
脚本安装更规范，步骤简单，不容易出错，效率高。
作者
文章
阅读量
获赞
联系客服
达梦在线服务平台社区用户管理规范
鄂ICP备18017926号-1