微前端架构如何改变企业的开发模式与效率提升
357
2023-11-23
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 installers 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)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub-/28753971/viewspace-2660287/,如需转载,请注明出处,否则将追究法律责任。
版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。
发表评论
暂时没有评论,来抢沙发吧~