國(guó)產(chǎn)數(shù)據(jù)庫(kù)-達(dá)夢(mèng)數(shù)據(jù)庫(kù)-redhat6.5下達(dá)夢(mèng)8.1安裝

發(fā)布時(shí)間：2020-08-07 15:14:08 來(lái)源：ITPUB博客閱讀：225 作者：西索哥欄目：數(shù)據(jù)庫(kù)

1.創(chuàng)建用戶(hù)組：

groupadd dinstall

2.創(chuàng)建用戶(hù)：

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

3.修改密碼：

passwd dmdba

4.修改用戶(hù)資源限制：

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.創(chuàng)建安裝目錄：

mkdir /d08/dmdbms

chown -R dmdba:dinstall /d08/dmdbms

6.上傳軟件并解壓到合適的目錄

7.安裝dm數(shù)據(jù)庫(kù)

使用dmdba用戶(hù)

到解壓軟件的目錄

執(zhí)行：

圖形界面：

./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.--警告了一下用戶(hù)資源：dmdba soft nofile 1024這條有點(diǎn)小，裝完可以改大一點(diǎn)

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下執(zhí)行/d08/dmdbms/script/root/root_installer.sh

會(huì)創(chuàng)建APservice服務(wù)并啟動(dòng)服務(wù)

8.dminit建庫(kù)

[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 ---數(shù)據(jù)庫(kù)文件存放目錄

input db name: dmnew ---數(shù)據(jù)庫(kù)名稱(chēng)

input port num: 5010 ---端口

input page size(4, 8, 16, 32): 8 ---頁(yè)大小

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

input time zone(-12:59,+14:00): +8 ---時(shí)區(qū)

string case sensitive? ([Y]es, [N]o): Y ---啟用大小寫(xiě)敏感

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

length in char? ([Y]es, [N]o): Y ---VARCHAR類(lèi)型對(duì)象的長(zhǎng)度是否以字符為單位

enable database encrypt? ([Y]es, [N]o): N ---不啟用數(shù)據(jù)庫(kù)加密

page check mode? (0/1/2): 0 ---頁(yè)檢查

input elog path: /d08/dmdbms/log ---服務(wù)日志路徑

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.啟動(dòng)數(shù)據(jù)庫(kù)：

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

命令行下窗口不能關(guān)閉，否則數(shù)據(jù)庫(kù)會(huì)關(guān)閉

10.注冊(cè)服務(wù)

root用戶(hù)下：

cd /d08/dmdbms/script/root

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

參數(shù)解釋?zhuān)?/p>

-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."

以服務(wù)方式啟動(dòng)數(shù)據(jù)庫(kù)

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 ]

完全默認(rèn)方式建的庫(kù)，實(shí)例名默認(rèn)是dmserver ，sysdba用戶(hù)密碼也是默認(rèn)SYDDBA，數(shù)據(jù)庫(kù)名dmnew。

小結(jié)一下：

達(dá)夢(mèng)數(shù)據(jù)庫(kù)連接是通過(guò)ip和端口識(shí)別數(shù)據(jù)庫(kù)的，不需要指定實(shí)例名（instance_name在dm.ini文件隨時(shí)可以換）

另外達(dá)夢(mèng)的技術(shù)文檔都在安裝目錄的doc目錄下（本例是/d08/dmdbms/doc）

向AI問(wèn)一下細(xì)節(jié)