1. 达梦8安装
参考文档:https://eco.dameng.com/docs/zh-cn/start/install-dm-linux-prepare.html
2.安装前准备
groupadd dinstall
useradd -g dinstall dmdba -s /bin/bash -m -d /home/dmdba
passwd dmdba
cat >> /etc/security/limits.conf <<EOF
dmdba hard nofile 65536
dmdba soft nofile 65536
dmdba hard stack 32768
dmdba soft stack 16384
EOF
验证
su - dmdba
ulimit -a
3.挂载镜像
mount -o loop dm8_20220304_x86_rh6_64_ent_8.1.2.114.iso /mnt
mkdir /dm8
chown dmdba:dinstall /dm8
chmod -R 755 /dm8
4.开始安装
4.1 图形化安装
su - dmdba
cd /mnt/
export DISPLAY=192.168.18.1:0.0
4.2命令行安装
[dmdba@localhost mnt]$ ./DMInstall.bin -i
Please select the installer's language (E/e:English C/c:Chinese) [E/e]:
Extract install files..........
Welcome to DM DBMS Installer
Whether to input the path of Key File? (Y/y:Yes N/n:No) [Y/y]:N
Whether to Set The TimeZone? (Y/y:Yes N/n:No) [Y/y]:Y
TimeZone:
[ 1]: GTM-12=West Date Line
[ 2]: GTM-11=Samoa
[ 3]: GTM-10=Hawaii
[ 4]: GTM-09=Alaska
[ 5]: GTM-08=Pacific(America and Canada)
[ 6]: GTM-07=Arizona
[ 7]: GTM-06=Central(America and Canada)
[ 8]: GTM-05=East(America and Canada)
[ 9]: GTM-04=Atlantic(America and Canada)
[10]: GTM-03=Brasilia
[11]: GTM-02=Middle Atlantic
[12]: GTM-01=Azores
[13]: GTM=Greenwich Mean Time
[14]: GTM+01=Sarajevo
[15]: GTM+02=Cairo
[16]: GTM+03=Moscow
[17]: GTM+04=AbuDhabi
[18]: GTM+05=Islamabad
[19]: GTM+06=Dakar
[20]: GTM+07=BangKok,Hanoi
[21]: GTM+08=China
[22]: GTM+09=Seoul
[23]: GTM+10=Guam
[24]: GTM+11=Solomon
[25]: GTM+12=Fiji
[26]: GTM+13=Nukualofa
[27]: GTM+14=Kiribati
Please Select the TimeZone [6]:21
Installation Type:
1 Typical
2 Server
3 Client
4 Custom
Please Input the number of the Installation Type [1 Typical]:1
Require Space: 1579M
Please Input the install path [/home/dmdba/dmdbms]:
The directory(/home/dmdba/dmdbms) is not empty, please select other directory.
Please Input the install path [/home/dmdba/dmdbms]:
Available Space:13G
Please Confirm the install path(/home/dmdba/dmdbms)? (Y/y:Yes N/n:No) [Y/y]:
Pre-Installation Summary
Installation Location: /home/dmdba/dmdbms
Require Space: 1579M
Available Space: 13G
Version Information:
Expire Date:
Installation Type: Typical
Confirm to Install? (Y/y:Yes N/n:No):Y
2022-06-23 19:10:33
[INFO] Installing DM DBMS...
2022-06-23 19:10:33
[INFO] Installing BASE Module...
2022-06-23 19:10:35
[INFO] Installing SERVER Module...
2022-06-23 19:10:35
[INFO] Installing CLIENT Module...
2022-06-23 19:10:35
[INFO] Installing DRIVERS Module...
2022-06-23 19:10:36
[INFO] Installing MANUAL Module...
2022-06-23 19:10:36
[INFO] Installing SERVICE Module...
2022-06-23 19:10:37
[INFO] Move log file to log directory.
2022-06-23 19:10:38
[INFO] Installed DM DBMS completely.
Please execute the commands by root:
/home/dmdba/dmdbms/script/root/root_installer.sh
End
[dmdba@localhost mnt]$
5.配置数据库
[dmdba@localhost bin]$ ./dminit help
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2023-03-04
version: 03134283890-20220304-158322-10045
Format: ./dminit KEYWORD=value
Example: ./dminit PATH=/public/dmdb/dmData PAGE_SIZE=16
Keyword Explanation(default value)
--------------------------------------------------------------------------------
INI_FILE dm.ini path
PATH database path
CTL_PATH control file path
LOG_PATH log file path
EXTENT_SIZE extent size of data file(16), optional value: 16, 32, 64, unit: PAGE
PAGE_SIZE page size(8), optional value: 4, 8, 16, 32, unit: K
LOG_SIZE log file size(256), unit: M, range: 256M ~ 2G
CASE_SENSITIVE whether case is sensitive(Y), optional value: Y/N or 1/0
CHARSET/UNICODE_FLAG CHARSET(0), optional value:0[GB18030],1[UTF-8],2[EUC-KR]
SEC_PRIV_MODE security privilege mode(0), optional value⚌⚌0[TRADITION], 1[BMJ], 2[EVAL]
LENGTH_IN_CHAR whether LENGTH for VARCHAR is in characters(N), optional value: Y/N, 1/0
SYSDBA_PWD set SYSDBA password(SYSDBA)
SYSAUDITOR_PWD set SYSAUDITOR password(SYSAUDITOR)
DB_NAME database name(DAMENG)
INSTANCE_NAME instance name(DMSERVER)
PORT_NUM listener port(5236)
BUFFER System buffer size(100), unit: M
TIME_ZONE set time zone(+08:00)
PAGE_CHECK page check mode(0), optional value: 0/1/2
PAGE_HASH_NAME set page check hash algorithm
EXTERNAL_CIPHER_NAME set default encrypt/decrypt algorithm
EXTERNAL_HASH_NAME set default hash algorithm
EXTERNAL_CRYPTO_NAME set crypto name to encrypt svr key
RLOG_ENC_FLAG whether encrypt redo log(N), optional value: Y/N, 1/0
USBKEY_PIN set usbkey pin
PAGE_ENC_SLICE_SIZE slice size for page encryption, optional value: 0, 512, 4096, unit: Byte
ENCRYPT_NAME set algorithm for encrypt the whole database
BLANK_PAD_MODE set blank padding mode(0), optional value:0/1
SYSTEM_MIRROR_PATH mirror path of system data file
MAIN_MIRROR_PATH mirror path of main file
ROLL_MIRROR_PATH mirror path of roll file
MAL_FLAG MAL_INI flag(0) in dm.ini
ARCH_FLAG ARCH_INI(0) flag in dm.ini
MPP_FLAG MPP_INI(0) flag in dm.ini
CONTROL control file path!
AUTO_OVERWRITE whether overwrite all files with the same name(0) 0: no 1: part 2: all
USE_NEW_HASH whether use new hash algorithm for string. (default 1)
DCP_MODE whether is DM CLUSTER PROXY mode(default 0)
DCP_PORT_NUM in DCP mode, set dcp_port_num
ELOG_PATH set the path of log file recording the contents during initialization
AP_PORT_NUM listener port for cooperative worker in distribution environment
DFS_FLAG DFS_INI flag(0) in dm.ini
DFS_PATH default path of db file when dfs_flag is true
DFS_HOST ip of ddfs(localhost)
DFS_PORT port number of ddfs(3332)
DFS_COPY_NUM copy num of dfs file(3)
DFS_DB_NAME database name in ddfs(default same as DB_NAME)
SHARE_FLAG database share flag in ddfs(default 0)
REGION_MODE system tablespace datafile region policy in ddfs(default 0) 0: MICRO 1: GREAT
HUGE_WITH_DELTA Only support to create with delta huge table(default 1) 1: YES 0: NO
RLOG_GEN_FOR_HUGE whether to generate redo log for with delta huge table(default 0) 1: YES 0: NO
PSEG_MGR_FLAG Only use manager segment to record trx info(default 0) 1: YES 0: NO
CHAR_FIX_STORAGE whether CHARACTER type stored by fixed length(N), optional value: Y/N, 1/0
SQL_LOG_FORBID whether forbid SQL log(N), optional value: Y/N, 1/0
DPC_MODE specify instance role in DPC cluster(default 0) 0: None 1: MP 2: BP 3: SP, value MP/BP/SP also works
HELP print help information
[dmdba@localhost bin]$ ./dminit path=/dm8/data db_name=XGQ instance_name=XGQ01 port_num=15238 PAGE_SIZE=16 EXTENT_SIZE=16 CHARSET=1
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2023-03-04
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
log file path: /dm8/data/XGQ/XGQ01.log
log file path: /dm8/data/XGQ/XGQ02.log
write to dir [/dm8/data/XGQ].
create dm database success. 2022-06-23 19:15:04
[root@localhost ~]# /home/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmserver -p DMSERVER -dm_ini /dm8/data/XGQ/dm.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDMSERVER.service to /usr/lib/systemd/system/DmServiceDMSERVER.service.
Finished to create the service (DmServiceDMSERVER)
[dmdba@localhost bin]$ DmServiceDMSERVER start
Starting DmServiceDMSERVER: [ OK ]
6.连接测试
[dmdba@localhost XGQ]$ disql sysdba/SYSDBA@192.168.18.123:15238
Server[192.168.18.123:15238]:mode is normal, state is open
login used time : 1.005(ms)
disql V8
SQL>
SQL> SELECT * from v$instance;
LINEID NAME INSTANCE_NAME INSTANCE_NUMBER HOST_NAME SVR_VERSION DB_VERSION
---------- ----- ------------- --------------- --------------------- -------------------------- -------------------
START_TIME STATUS$ MODE$ OGUID DSC_SEQNO DSC_ROLE BUILD_VERSION
------------------- ------- ------ ----------- ----------- -------- ----------------------------------
BUILD_TIME
--------------------
1 XGQ01 XGQ01 1 localhost.localdomain DM Database Server x64 V8 DB Version: 0x7000c
2022-06-23 19:20:29 OPEN NORMAL 0 0 NULL 1-2-114-22.03.04-158322-10045-ENT
Mar 4 2022 11:52:18
used time: 2.760(ms). Execute id is 55200.
6.配置多个数据库
./dminit path=/dm8/data03 db_name=XGQ02 instance_name=XGQ02 port_num=15239 PAGE_SIZE=16 EXTENT_SIZE=16 CHARSET=1
/home/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmserver -p XGQ02 -dm_ini /dm8/data03/XGQ02/dm.ini
[dmdba@dm8 bin]$ disql sysdba/SYSDBA@192.168.18.123:15239
Server[192.168.18.123:15239]:mode is normal, state is open
login used time : 1.010(ms)
disql V8
SQL> select name from v$instance;
LINEID NAME
---------- -----
1 XGQ02
used time: 21.281(ms). Execute id is 55200.
查看dmserver进程
[root@dm8 dmdba]# ps -ef|grep dm|grep -v grep
dmdba 958 1 0 01:30 ? 00:00:00 /home/dmdba/dmdbms/bin/dmap
root 1349 1307 0 02:08 pts/0 00:00:00 su - dmdba
dmdba 1350 1349 0 02:08 pts/0 00:00:00 -bash
dmdba 1541 1 0 02:13 pts/0 00:00:01 /home/dmdba/dmdbms/bin/dmserver path=/dm8/data/XGQ/dm.ini -noconsole
dmdba 1946 1 1 02:36 pts/1 00:00:07 /home/dmdba/dmdbms/bin/dmserver path=/dm8/data03/XGQ02/dm.ini -noconsole
达梦技术社区:https://eco.dameng.com
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
