Technology sharing

한어Русский языкEnglishFrançaisIndonesianSanskrit日本語DeutschPortuguêsΕλληνικάespañolItalianoSuomalainenLatina

Tabula contentorum

Prooemium:

1. instruitur et instruere

1. Download

2. crea user ac institutionem Directory

3. Ascende imaginem downloaded

4. configuratione environment

5. Institutionem

2. Basic usus

1. Usus DM instrumenta

2. configuratione Compatibility

2.1 Compatible cum GBK character set modum translitterandi

2.2 Compatible cum UTF-VIII character set modum translitterandi

3. crea user et password, mensa spatium

4. configuratione Organize database

5. Satus scriptor occasus

3. Migrare alias databases ad Dameng

1. Novae constructionis

2. Novam migrationem

Oraculum 3. migratio elige Dameng

4. Iungo ad database migrandum

5. Ingreditur configurationem datorum Dameng in migrare vis.

6. Select agentibus items

7. Denota utentes datorum migrandi et utentes in Dameng migrandi.

8. Select in mensa migrandum

9 Donec adipiscing completed

---

Prooemium:

Rogante patre Factionis A, ad Xinchuang machinam (brachium architecturae transeundum). architectura) sub test

1. instruitur et instruere

1. Download

Log inOfficial websiteDownload unum annum iudicii version

Secundum ad rationem tuam, versionem respondentem elige. Pro meo experimento, delegi "X86" pro suggestu CPU et "RedHat7" pro systemate operante.

2. crea user ac institutionem Directory

创建安装用户和用户组
groupadd dinstall && useradd -g dinstall dmdba && echo root|passwd --stdin dmdba
 
echo "123456" | passwd "dmdba" --stdin
 
在/data目录下新建dm8目录
mkdir /data/dm8
chown -R dmdba.dinstall /data/dm8
 
 
提前准备达梦的bin路径与数据文件存放路径
mkdir -p /opt/dmdbms && chown dmdba:dinstall /opt/dmdbms       #bin路径
 
mkdir -p /dmdata && chown dmdba:dinstall /dmdata               #配置数据文件存储路径

3. Ascende imaginem downloaded

Upload comprimatur sarcina

挂载
mount -o loop dm8_20240408_x86_rh7_64.iso /data/dm8

4. configuratione environment

关闭selinux
setenforce 0  && sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
 
 
修改用户资源限制
vi /etc/security/limits.conf 
 
在配置最后追加
dmdba hard nofile 131072
dmdba soft nofile 131072	
dmdba soft nice 0
dmdba hard nice 0
dmdba soft as unlimited
dmdba hard as unlimited
dmdba soft fsize unlimited
dmdba hard fsize unlimited
dmdba soft nproc 131072
dmdba hard nproc 131072
dmdba soft data unlimited
dmdba hard data unlimited
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft memlock unlimited
dmdba hard memlock unlimited

5. Institutionem

Imperii linea institutionem

切换dmdba用户
su dmdba
 
切换到/data/dm8目录
 
cd /data/dm8
 
chmod 777 *   #赋予BIN文件执行权限
 
./DMInstall.bin -i           #执行安装

Nota: Tentatio versionis

Usor eligere potest utrum clavis lima iter ingrediatur. Si eam non ingredieris, vade ad gradum institutionis proximum. Ingredere in viam file clavis permanere institutionem. Ut infra patebit:

Users potest eligere DM tempus zonam notitia. Ut infra:(21) Est Sina Standard Time

Semita institutionem elige, semita in gressu creata 2

Institutionem completum est

Initialize database exempli gratia

cd /opt/dmdbms/bin          #进入到达梦的BIN目录下
./dminit help              #此处初始化需要配置一些参数，参数的类型列表如下

Enarratio:

1. PIA est via reposita configurationis documenti instantia datorum.

2. UNICODE_FLAG character est descriptam configurationis datorum.

3. LENGTH_IN_CHAR longitudo varcharis characteribus significat

CHARSET=I,LANGTH_IN_CHAR=1

Qualitas talis est utf-8, longitudo varchar characteribus est, et ipse numerus bytes in varchar conditus per 4 tempora augebitur.

Exempli gratia, si varchar definias (10), reponere potes 10 * 4 = 40 bytes notitiarum.

4. CASE_SENSITIVE casum ignorat et sensitivo non est

EX