国产数据库-达梦数据库-redhat6.5下达梦8.1安装

1.创建用户组：

groupadd dinstall

2.创建用户：

useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba

3.修改密码：

passwd dmdba

4.修改用户资源限制：

vi /etc/security/limits.conf

dmdba soft nproc 2047

dmdba hard nproc 16384

dmdba soft nofile 1024

dmdba hard nofile 65536

dmdba soft stack 10240

5.创建安装目录：

mkdir /d08/dmdbms

chown -R dmdba:dinstall /d08/dmdbms

6.上传软件并解压到合适的目录

7.安装dm数据库

使用dmdba用户

到解压软件的目录

执行：

图形界面：

./DMInstall.bin

略

命令行安装：

./DMInstall.bin -i

[dmdba@ocp mnt]$ ./DMInstall.bin -i

Please select the installer's language (E/e:English C/c:Chinese) [E/e]:

Extract install files.........

core file size (blocks, -c) 0

data seg size (kbytes, -d) unlimited

scheduling priority (-e) 0

file size (blocks, -f) unlimited

pending signals (-i) 31517

max locked memory (kbytes, -l) 64

max memory size (kbytes, -m) unlimited

open files (-n) 1024

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

real-time priority (-r) 0

stack size (kbytes, -s) 10240

cpu time (seconds, -t) unlimited

max user processes (-u) 2047

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

The max number of open files is too little, suggest to set 65536 or more to number of open files.--警告了一下用户资源：dmdba soft nofile 1024这条有点小，装完可以改大一点

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]:

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 [9]:

Installation Type:

1 Typical

2 Server

3 Client

4 Custom

Please Input the number of the Installation Type [1 Typical]:

Require Space: 941M

Please Input the install path [/home/dmdba/dmdbms]:/d08/dmdbms

Available Space:10G

Please Confirm the install path(/d08/dmdbms)? (Y/y:Yes N/n:No) [Y/y]:

Pre-Installation Summary

Installation Location: /d08/dmdbms

Require Space: 941M

Available Space: 10G

Version Information:

Expire Date:

Installation Type: Typical

Confirm to Install? (Y/y:Yes N/n:No):y

2019-08-02 06:39:45

[INFO] Installing DM DBMS...

2019-08-02 06:39:46

[INFO] Installing BASE Module...

2019-08-02 06:39:49

[INFO] Installing SERVER Module...

2019-08-02 06:39:50

[INFO] Installing CLIENT Module...

2019-08-02 06:39:58

[INFO] Installing DRIVERS Module...

2019-08-02 06:39:59

[INFO] Installing MANUAL Module...

2019-08-02 06:39:59

[INFO] Installing SERVICE Module...

2019-08-02 06:40:01

[INFO] Move ant log file to log directory.

2019-08-02 06:40:01

[INFO] Installed DM DBMS completely.

Please execute the commands by root:

/d08/dmdbms/script/root/root_installer.sh

End

root下执行/d08/dmdbms/script/root/root_installer.sh

会创建APservice服务并启动服务

8.dminit建库

[dmdba@ocp ~]$ dminit

initdb V8.1.0.147-Build(2019.03.27-104581)ENT

db version: 0x7000a

file dm.key not found, use default license!

License will expire on 2020-03-27

input system dir: /d08/dmdbms/data ---数据库文件存放目录

input db name: dmnew ---数据库名称

input port num: 5010 ---端口

input page size(4, 8, 16, 32): 8 ---页大小

input extent size(16, 32): 16 ---簇大小

input time zone(-12:59,+14:00): +8 ---时区

string case sensitive? ([Y]es, [N]o): Y ---启用大小写敏感

which charset to use? (0[GB18030], 1[UTF-8], 2[EUC-KR]): 1 ---字符集

length in char? ([Y]es, [N]o): Y ---VARCHAR类型对象的长度是否以字符 为单位

enable database encrypt? ([Y]es, [N]o): N ---不启用数据库加密

page check mode? (0/1/2): 0 ---页检查

input elog path: /d08/dmdbms/log ---服务日志路径

auto_overwrite mode? (0/1/2): 1 ---日志文件是否覆盖 1是有重名的则覆盖，0是不覆盖，2是清空目录

log file path: /d08/dmdbms/data/dmnew/dmnew01.log

log file path: /d08/dmdbms/data/dmnew/dmnew02.log

write to dir [/d08/dmdbms/data/dmnew].

create dm database success. 2019-08-02 06:49:39

9.启动数据库：

dmserver /d08/dmdbms/data/dmnew/dm.ini

命令行下窗口不能关闭，否则数据库会关闭

10.注册服务

root用户下：

cd /d08/dmdbms/script/root

./dm_service_installer.sh -t dmserver -p dmserver -i /d08/dmdbms/data/dmnew/dm.ini

参数解释：

-t" "Service Type, include: dmimon,dmap,dmserver,dmwatch,dmrww,dmwmon,dmwatcher,dmmonitor,dmcss,dmcssm,dmasmsvr."

-p" "Service Name Postfix, is invalid for dmimon,dmap."

-i" "The path of the ini file, is invalid for dmimon,dmap."

以服务方式启动数据库

service DmServicedmserver start

[root@ocp root]# ./dm_service_installer.sh -t dmserver -p dmserver -i /d08/dmdbms/data/dmnew/dm.ini

Move the service script file(/d08/dmdbms/bin/DmServicedmserver to /etc/rc.d/init.d/DmServicedmserver)

Finished to create the service (DmServicedmserver)

[dmdba@ocp ~]# service DmServicedmserver start

Starting DmServicedmserver: [ OK ]

完全默认方式建的库，实例名默认是dmserver ，sysdba用户密码也是默认SYDDBA，数据库名dmnew。

小结一下：

达梦数据库连接是通过ip和端口识别数据库的，不需要指定实例名（instance_name在dm.ini文件随时可以换）

另外达梦的技术文档都在安装目录的doc目录下（本例是/d08/dmdbms/doc）