达梦数据库

安装准备: 

groupadd dinstalluseradd dinstall -g dinstallpasswd dinstallmkdir /u02/dm7chown dinstall.dinstall /u02/dm7 -Rulimit -avi /etc/profileulimit -n 65536vi .bash_profileexport DM_HOME=/u02/dm7export PATH=$PATH:$HOME:$DM_HOME/bin export DISPLAY=10.85.10.2:0.0mkdir /mnt/dm7 mount -o loop /u02/*.iso /mnt/dm7cd /mnt/dm7cp DMinstall.bin /home/dinstall./DMinstall.in (图形界面)或 ./DMinstall.bin -i (命令交互界面)

x   1

groupadd dinstall

2

useradd dinstall -g dinstall

3

passwd dinstall

4

mkdir /u02/dm7

5

chown dinstall.dinstall /u02/dm7 -R

6

ulimit -a

7

vi /etc/profile

8

ulimit -n 65536

9

10

vi .bash_profile

11

export DM_HOME=/u02/dm7

12

export PATH=$PATH:$HOME:$DM_HOME/bin 

13

export DISPLAY=10.85.10.2:0.0

14

15

mkdir /mnt/dm7 

16

mount -o loop /u02/*.iso /mnt/dm7

17

cd /mnt/dm7

18

cp DMinstall.bin /home/dinstall

19

./DMinstall.in (图形界面)或 ./DMinstall.bin -i (命令交互界面)

停库:/etc/rc.d/init.d/DmServerPROD stop

卸载:./uninstall.sh
卸载达梦软件:

[dinstall@localhost dm7]$ pwd/u02/dm7[dinstall@localhost dm7]$ ./uninstall.shXlib: extension "RANDR" missing on display "10.85.10.2:0.0".[dinstall@localhost dm7]$ ./uninstall.sh -i请确认是否卸载达梦数据库 [y/Y 是 n/N 否]:y正在删除快捷方式删除快捷方式完成正在删除所有数据库库服务删除数据库服务DmAPService删除数据库服务DmJobMonitorService删除数据库服务DmAuditMonitorService删除数据库服务DmInstanceMonitorService删除所有数据库库服务完成正在删除数据库目录删除bin目录删除bin目录完成删除bin2目录删除bin2目录完成删除include目录删除include目录完成删除desktop目录删除desktop目录完成删除doc目录删除doc目录完成删除drivers目录删除drivers目录完成删除jdk目录删除jdk目录完成删除jar目录删除jar目录完成删除samples目录删除samples目录完成删除script目录删除script目录完成删除tool目录删除tool目录完成删除web目录删除web目录完成删除uninstall目录删除uninstall目录完成删除license_en.txt文件删除license_en.txt文件完成删除license_zh.txt文件删除license_zh.txt文件完成删除release_en.txt文件删除release_en.txt文件完成删除release_zh.txt文件删除release_zh.txt文件完成删除uninstall.sh文件删除uninstall.sh文件完成删除数据库目录完成使用root用户执行命令:/u02/dm7/root_uninstaller.sh[root@localhost dm7]# sh /u02/dm7/root_uninstaller.sh删除DmAPService服务error reading information on service DmAPService: No such file or directory 删除/etc/dm_svc.conf文件

58   1

[dinstall@localhost dm7]$ pwd

2

/u02/dm7

3

[dinstall@localhost dm7]$ ./uninstall.sh

4

Xlib: extension "RANDR" missing on display "10.85.10.2:0.0".

5

[dinstall@localhost dm7]$ ./uninstall.sh -i

6

请确认是否卸载达梦数据库 [y/Y  n/N ]:y

7

正在删除快捷方式

8

删除快捷方式完成

9

正在删除所有数据库库服务

10

删除数据库服务DmAPService

11

删除数据库服务DmJobMonitorService

12

删除数据库服务DmAuditMonitorService

13

删除数据库服务DmInstanceMonitorService

14

删除所有数据库库服务完成

15

正在删除数据库目录

16

删除bin目录

17

删除bin目录完成

18

删除bin2目录

19

删除bin2目录完成

20

删除include目录

21

删除include目录完成

22

删除desktop目录

23

删除desktop目录完成

24

删除doc目录

25

删除doc目录完成

26

删除drivers目录

27

删除drivers目录完成

28

删除jdk目录

29

删除jdk目录完成

30

删除jar目录

31

删除jar目录完成

32

删除samples目录

33

删除samples目录完成

34

删除script目录

35

删除script目录完成

36

删除tool目录

37

删除tool目录完成

38

删除web目录

39

删除web目录完成

40

删除uninstall目录

41

删除uninstall目录完成

42

删除license_en.txt文件

43

删除license_en.txt文件完成

44

删除license_zh.txt文件

45

删除license_zh.txt文件完成

46

删除release_en.txt文件

47

删除release_en.txt文件完成

48

删除release_zh.txt文件

49

删除release_zh.txt文件完成

50

删除uninstall.sh文件

51

删除uninstall.sh文件完成

52

删除数据库目录完成

53

使用root用户执行命令:

54

/u02/dm7/root_uninstaller.sh

55

[root@localhost dm7]# sh /u02/dm7/root_uninstaller.sh

56

删除DmAPService服务

57

error reading information on service DmAPService: No such file or directory 

58

删除/etc/dm_svc.conf文件

DBCA 图形介面创建实例

[dinstall@localhost tool]$ pwd /u02/dm7/tool [dinstall@localhost tool]$ sh dbca.sh                              ---dbca命令在tool工具下,可调用图形界面 


dminit 创建实例


[dinstall@localhost bin]$ ./dminit                                    ---在bin目录下,创建数据库实例,类似数据库的静默安装 [dinstall@localhost bin]$ pwd /u02/dm7/bin [dinstall@localhost bin]$ ./dminit

[dinstall@localhost bin]$ ./dminitinitdb V7.1.6.46-Build(2018.02.08-89107)ENTdb version: 0x7000afile dm.key not found, use default license!License will expire on 2019-02-08input system dir: /u02/dm7/data -----数据文件存放路径input db name: damen ----实例名input port num: 53398 ----监听端口input page size(4, 8, 16, 32): 8 ----数据库页大小input extent size(16, 32): 16 ----扩展大小input time zone(-12:59,+14:00): ----时区 ,选东8区input err , input again:+8:00 string case sensitive? ([Y]es, [N]o): N ---字符是否区分大小写,如果是从ORACLE迁移 选 YES,如果是SqlServer 迁移 选 NOwhich charset to use? (0[GB18030], 1[UTF-8], 2[EUC-KR]): 0 ---字符集length in char? ([Y]es, [N]o): y ----字符长度enable database encrypt? ([Y]es, [N]o): n --- 是否启用数据库加密page check mode? (0/1/2): 0 ---是否开启页页检查模式input elog path: ----日志路径auto_overwrite mode? (0/1/2): 0 log file path: /u02/dm7/data/damen/damen01.log log file path: /u02/dm7/data/damen/damen02.logwrite to dir [/u02/dm7/data/damen].create dm database success. 2018-06-02 03:43:39

23   1

[dinstall@localhost bin]$ ./dminit

2

initdb V7.1.6.46-Build(2018.02.08-89107)ENT

3

db version: 0x7000a

4

file dm.key not found, use default license!

5

License will expire on 2019-02-08

6

input system dir: /u02/dm7/data                                            -----数据文件存放路径

7

input db name: damen                                                       ----实例名

8

input port num: 53398                                                      ----监听端口

9

input page size(4, 8, 16, 32): 8                                           ----数据库页大小

10

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

11

input time zone(-12:59,+14:00):                                            ----时区 ,选东8区

12

input err , input again:+8:00                                             

13

string case sensitive? ([Y]es, [N]o): N                                    ---字符是否区分大小写,如果是从ORACLE迁移  YES,如果是SqlServer 迁移  NO

14

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

15

length in char? ([Y]es, [N]o): y                                           ----字符长度

16

enable database encrypt? ([Y]es, [N]o): n                                   --- 是否启用数据库加密

17

page check mode? (0/1/2): 0                                                 ---是否开启页页检查模式

18

input elog path:                                                            ----日志路径

19

auto_overwrite mode? (0/1/2): 0

20

 log file path: /u02/dm7/data/damen/damen01.log

21

 log file path: /u02/dm7/data/damen/damen02.log

22

write to dir [/u02/dm7/data/damen].

23

create dm database success. 2018-06-02 03:43:39

------------------------------------
也可用参数文件指定: [dinstall@localhost bin]$ ./dminit
int_file=dm.ini
path=/u02/dm7/data
但是需要手动注册 [root@localhost dm7]# cd /u02/dm7/script/root/ [root@localhost root]# ls dm_service_installer.sh    dm_service_uninstaller.sh    root_installer.sh
注册成功在 /etc/rc.d/init.d/ 目录有 DmAPService 服务
dminit 支持 裸设备,ASM磁盘组 ,详细参数 

[dinstall@localhost bin]$ ./dminit helpinitdb V7.1.6.46-Build(2018.02.08-89107)ENTdb version: 0x7000afile dm.key not found, use default license!License will expire on 2019-02-08Format: ./dminit KEYWORD=valueExample: ./dminit PATH=/public/dmdb/dmData PAGE_SIZE=16Keyword Explanation(default value)--------------------------------------------------------------------------------INI_FILE dm.ini pathPATH database pathCTL_PATH control file pathLOG_PATH log file pathEXTENT_SIZE extent size of data file(16), optional value: 16,32, unit: PAGEPAGE_SIZE page size(8), optional value: 4,8,16,32, unit: KLOG_SIZE log file size(256), unit: M, range: 64M ~ 2GCASE_SENSITIVE whether case is sensitive(Y), optional value: Y/N or 1/0CHARSET/UNICODE_FLAG CHARSET(0), optional value:0[GB18030],1[UTF-8],2[EUC-KR]LENGTH_IN_CHAR whether LENGTH for VARCHAR is in characters(N), optional value: Y/N, 1/0SYSDBA_PWD set SYSDBA password(SYSDBA), password length must between 9 and 48SYSAUDITOR_PWD set SYSAUDITOR password(SYSAUDITOR), password length must between 9 and 48 DB_NAME database name(DAMENG)INSTANCE_NAME instance name(DMSERVER)PORT_NUM listener port(5236)TIME_ZONE set time zone(+08:00)PAGE_CHECK page check mode(0), optional value: 0/1/2EXTERNAL_CIPHER_NAME set default encrypt/decrypt algorithmEXTERNAL_HASH_NAME set default hash algorithmEXTERNAL_CRYPTO_NAME set crypto name to encrypt svr keyRLOG_ENC_FLAG whether encrypt redo log(N), optional value: Y/N, 1/0USBKEY_PIN set usbkey pinENCRYPT_NAME set algorithm for encrypt the whole databaseBLANK_PAD_MODE set blank padding mode(0), optional value:0/1SYSTEM_MIRROR_PATH mirror path of system data fileMAIN_MIRROR_PATH mirror path of main fileROLL_MIRROR_PATH mirror path of roll fileMAL_FLAG MAL_INI flag(0) in dm.iniARCH_FLAG ARCH_INI(0) flag in dm.iniMPP_FLAG MPP_INI(0) flag in dm.iniCONTROL control file path!AUTO_OVERWRITE whether overwrite all files with the same name(0) 0: no 1: part 2: allUSE_NEW_HASH whether use new hash algorithm for string. (default 1)DCP_MODE whether is DM CLUSTER PROXY mode(default 0)DCP_PORT_NUM in DCP mode, set dcp_port_numELOG_PATH set the path of log file recording the contents during initializationHELP print help information 

  1

[dinstall@localhost bin]$ ./dminit help

2

initdb V7.1.6.46-Build(2018.02.08-89107)ENT

3

db version: 0x7000a

4

file dm.key not found, use default license!

5

License will expire on 2019-02-08

6

Format: ./dminit KEYWORD=value

7

Example: ./dminit PATH=/public/dmdb/dmData PAGE_SIZE=16

8

Keyword Explanation(default value)

9

--------------------------------------------------------------------------------

10

INI_FILE dm.ini path

11

PATH database path

12

CTL_PATH control file path

13

LOG_PATH log file path

14

EXTENT_SIZE extent size of data file(16), optional value: 16,32, unit: PAGE

15

PAGE_SIZE page size(8), optional value: 4,8,16,32, unit: K

16

LOG_SIZE log file size(256), unit: M, range: 64M ~ 2G

17

CASE_SENSITIVE whether case is sensitive(Y), optional value: Y/N or 1/0

18

CHARSET/UNICODE_FLAG CHARSET(0), optional value:0[GB18030],1[UTF-8],2[EUC-KR]

19

LENGTH_IN_CHAR whether LENGTH for VARCHAR is in characters(N), optional value: Y/N, 1/0

20

SYSDBA_PWD set SYSDBA password(SYSDBA), password length must between 9 and 48

21

SYSAUDITOR_PWD set SYSAUDITOR password(SYSAUDITOR), password length must between 9 and 48 

22

DB_NAME database name(DAMENG)

23

INSTANCE_NAME instance name(DMSERVER)

24

PORT_NUM listener port(5236)

25

TIME_ZONE set time zone(+08:00)

26

PAGE_CHECK page check mode(0), optional value: 0/1/2

27

EXTERNAL_CIPHER_NAME set default encrypt/decrypt algorithm

28

EXTERNAL_HASH_NAME set default hash algorithm

29

EXTERNAL_CRYPTO_NAME set crypto name to encrypt svr key

30

RLOG_ENC_FLAG whether encrypt redo log(N), optional value: Y/N, 1/0

31

USBKEY_PIN set usbkey pin

32

ENCRYPT_NAME set algorithm for encrypt the whole database

33

BLANK_PAD_MODE set blank padding mode(0), optional value:0/1

34

SYSTEM_MIRROR_PATH mirror path of system data file

35

MAIN_MIRROR_PATH mirror path of main file

36

ROLL_MIRROR_PATH mirror path of roll file

37

MAL_FLAG MAL_INI flag(0) in dm.ini

38

ARCH_FLAG ARCH_INI(0) flag in dm.ini

39

MPP_FLAG MPP_INI(0) flag in dm.ini

40

CONTROL control file path!

41

AUTO_OVERWRITE whether overwrite all files with the same name(0) 0: no 1: part 2: all

42

USE_NEW_HASH whether use new hash algorithm for string. (default 1)

43

DCP_MODE whether is DM CLUSTER PROXY mode(default 0)

44

DCP_PORT_NUM in DCP mode, set dcp_port_num

45

ELOG_PATH set the path of log file recording the contents during initialization

46

HELP print help information 

总结: DM数据库,结构跟ORACLE大同小异,理解起来相对容易。目前只安装了软件和实例。后面继续了深入了解。

来自为知笔记(Wiz)

相关文章