您好,登錄后才能下訂單哦!
groupadd dinstall
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
passwd dmdba
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
mkdir /d08/dmdbms
chown -R dmdba:dinstall /d08/dmdbms
使用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服務并啟動服務
[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
dmserver /d08/dmdbms/data/dmnew/dm.ini
命令行下窗口不能關閉,否則數據庫會關閉
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)
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。