1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
| # 将安装包 dm8_20240712_x86_rh7_64.iso 上传到当前目录下
groupadd dinstall -g 2001
useradd -G dinstall -m -d /home/dmdba -s /bin/bash -u 2001 dmdba
# 给用户 dmdba 设置密码 passwd dmdba
echo "dmdba:Bowei@123" | sudo chpasswd
# 打开文件 /etc/security/limits.conf，添加内容如下
echo "dmdba soft nice 0" >> /etc/security/limits.conf
echo "dmdba hard nice 0" >> /etc/security/limits.conf
echo "dmdba soft as unlimited" >> /etc/security/limits.conf
echo "dmdba hard as unlimited" >> /etc/security/limits.conf
echo "dmdba soft fsize unlimited" >> /etc/security/limits.conf
echo "dmdba hard fsize unlimited" >> /etc/security/limits.conf
echo "dmdba soft nproc 65536" >> /etc/security/limits.conf
echo "dmdba hard nproc 65536" >> /etc/security/limits.conf
echo "dmdba soft nofile 65536" >> /etc/security/limits.conf
echo "dmdba hard nofile 65536" >> /etc/security/limits.conf
echo "dmdba soft core unlimited" >> /etc/security/limits.conf
echo "dmdba hard core unlimited" >> /etc/security/limits.conf
echo "dmdba soft data unlimited" >> /etc/security/limits.conf
echo "dmdba hard data unlimited" >> /etc/security/limits.conf
# 重启服务器
reboot
#
mkdir -p /dmdata/data
#
mkdir -p /dmdata/arch
#
mkdir -p /dmdata/dmbak
chown -R dmdba:dinstall /dmdata/data
chown -R dmdba:dinstall /dmdata/arch
chown -R dmdba:dinstall /dmdata/dmbak
chmod -R 755 /dmdata/data
chmod -R 755 /dmdata/arch
chmod -R 755 /dmdata/dmbak
mount -o loop ./dm8_20240712_x86_rh7_64.iso /mnt
# 切换到 dmdba 用户，安装
su - dmdba
cd /mnt
# 选择安装语言-1，没有 key 文件选择 "n"，时区按需求选择一般选择 “21”，安装类型选择“1”-典型安装，安装目录默认 /home/dmdba/dmdbms
./DMInstall.bin -i
# 切换回到 root 用户
exit
# 创建 DmAPService，否则会影响数据库备份
/home/dmdba/dmdbms/script/root/root_installer.sh
# 配置环境变量
cd /home/dmdba/
# 在文件 .bash_profile 添加内容
echo "export LD_LIBRARY_PATH=\"\$LD_LIBRARY_PATH:/home/dmdba/dmdbms/bin\"" >> /home/dmdba/.bash_profile
echo "export DM_HOME=\"/home/dmdba/dmdbms\"" >> /home/dmdba/.bash_profile
echo "export PATH=\$PATH:\$DM_HOME/bin:\$DM_HOME/tool" >> /home/dmdba/.bash_profile
source /home/dmdba/.bash_profile
# 切换至 dmdba 用户下，执行以下命令，使环境变量生效
su - dmdba
# 初始化服务实例 DAMENG
cd /home/dmdba/dmdbms/bin
./dminit path=/dmdata/data
# 切换回 root 用户
exit
cd /home/dmdba/dmdbms/script/root/
# 注册服务
./dm_service_installer.sh -t dmserver -dm_ini /dmdata/data/DAMENG/dm.ini -p DAMENG
# 启动服务
sudo systemctl start DmServiceDAMENG.service
su - dmdba
cd /home/dmdba/dmdbms/bin
# 创建表空间 dh
./disql SYSDBA/SYSDBA -e "create tablespace \"dh\" datafile '/dmdata/data/DAMENG/dh.dbf' size 128 autoextend on maxsize 16777215"
# 创建用户 root，指定表空间为 dh
./disql SYSDBA/SYSDBA -e "create user \"root\" identified by \"Bowei@123\" default tablespace \"dh\""
# 给 root 授予 dba 权限
./disql SYSDBA/SYSDBA -e "grant dba to root"
# 创建数据库 dh 和 gateway
./disql SYSDBA/SYSDBA -e "CREATE SCHEMA \"dh\" AUTHORIZATION \"root\""
./disql SYSDBA/SYSDBA -e "CREATE SCHEMA \"gateway\" AUTHORIZATION \"root\""
# 切换回 root 用户
exit
# 卸载 iso 文件
umount /mnt
|
