Shulou(Shulou.com)06/01 Report--

1. Create a user group:

Groupadd dinstall

two。 Create a user:

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

3. Change the password:

Passwd dmdba

4. Modify user resource limits:

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. Create the installation directory:

Mkdir / d08/dmdbms

Chown-R dmdba:dinstall / d08/dmdbms

6. Upload the software and extract it to the appropriate directory 7. Install the dm database

Use dmdba users

To the directory of the decompression software

Execute:

Graphical interface:

. / DMInstall.bin

Slightly

Command line installation:

. / DMInstall.bin-I

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

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

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.-- warned users about resources: dmdba soft nofile 1024 is a little small and can be changed to a larger size after installation.

Welcome to DM DBMS Installer

Whether to input the path of Key File? (Y/y:Yes N/n:No) [Ygamy]: n

Whether to Set The TimeZone? (Y/y:Yes N/n:No) [Ygamy]:

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) [Ygamy]:

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

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

Creates the APservice service and starts the service

Building database by 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-Database file storage directory

Input db name: dmnew-database name

Input port num: 5010-Port

Input page size (4, 8, 16, 32): 8-Page size

Input extent size (16,32): 16-Cluster size

Input time zone (- 12 59): + 8-time zone

String case sensitive? ([y] es, [N] o): y-enable case sensitivity

Which charset to use? (0 [GB18030], 1 [UTF-8], 2 [EUC-KR]): 1-character set

Length in char? ([y] es, [N] o): whether the length of an object of type Y-VARCHAR is in characters

Enable database encrypt? ([y] es, [N] o): n-do not enable database encryption

Page check mode? (0ram 1amp 2): 0-page check

Input elog path: / d08/dmdbms/log-Service log path

Auto_overwrite mode? (0Universe 2): 1-whether the log file is overwritten if it has the same name, 0 does not overwrite, and 2 clears the directory.

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. Start the database:

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

The window under the command line cannot be closed, otherwise the database will be closed

10. Registration service

Under root users:

Cd / d08/dmdbms/script/root

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

Parameter explanation:

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

Start the database as a service

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]

The library is built by default, the instance name is dmserver by default, the sysdba user password is also the default SYDDBA, and the database name is dmnew.

A brief summary:

Dameng database connection identifies the database through ip and port, and there is no need to specify an instance name (instance_name can be changed at any time in the dm.ini file)

In addition, the technical documentation of Dameng is located in the doc directory of the installation directory (this example is / d08/dmdbms/doc)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.