Cent OS 7.1下安装DM6数据库

1、查看操作系统版本

[root@ljk02 ~]# uname -a
Linux ljk02.localdomain 3.10.0-229.el7.x86_64 #1 SMP Fri Mar 6 11:36:42 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
[root@ljk02 ~]#

2、查看CPU信息

[root@ljk02 ~]# lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 1
On-line CPU(s) list: 0
Thread(s) per core: 1
Core(s) per socket: 1
Socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 165
Model name: Intel® Core™ i7-10875H CPU @ 2.30GHz
Stepping: 2
CPU MHz: 2303.999
BogoMIPS: 4607.99
Hypervisor vendor: VMware
Virtualization type: full
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 16384K
NUMA node0 CPU(s): 0
[root@ljk02 ~]#

3、查看内存信息

[root@ljk02 ~]# free -m
total used free shared buff/cache available
Mem: 1987 1000 225 6 760 738
Swap: 2047 20 2027

4、查看磁盘空间使用情况

[root@ljk02 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos-root 18G 6.2G 12G 36% /
devtmpfs 985M 0 985M 0% /dev
tmpfs 994M 136K 994M 1% /dev/shm
tmpfs 994M 9.0M 985M 1% /run
tmpfs 994M 0 994M 0% /sys/fs/cgroup
/dev/sda1 497M 107M 391M 22% /boot
[root@ljk02 ~]#

5、关闭防火墙并关闭开机自启动

[root@ljk02 ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled)
Active: active (running) since Mon 2022-10-31 09:36:49 CST; 1 weeks 1 days ago
Main PID: 880 (firewalld)
CGroup: /system.slice/firewalld.service
└─880 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid

Oct 31 09:36:49 ljk02.localdomain systemd[1]: Started firewalld - dynamic fi…
Hint: Some lines were ellipsized, use -l to show in full.
[root@ljk02 ~]# systemctl stop firewalld
[root@ljk02 ~]# systemctl disable firewalld
rm ‘/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service’
rm ‘/etc/systemd/system/basic.target.wants/firewalld.service’
[root@ljk02 ~]#

6、关闭SELinux安全访问控制

[root@dm001 dm_x]# vim /etc/selinux/config
SELINUX=disabled

7、创建数据库安装目录及用户组和用户

[root@dm001 ~]# mkdir -p /dmdbms/dm_x
[root@dm001 ~]# cd /dmdbms/dm_x/
[root@dm001 dm_x]# ls
dm6_CT602.20.06.041roc6.0_64 dm7_20220921_x86_rh6_64_ent dm8_20220927_x86_rh6_64_ent
[root@dm001 dm_x]# chown -R dmdba:dinstall /dmdbms/
[root@dm001 dm_x]# chmod -R 775 /dmdbms/
[root@dm001 dm_x]# groupadd dinstall
[root@dm001 dm_x]# useradd -s /bin/bash -m -d /home/dmdba -g dinstall dmdba
[root@dm001 dm_x]# passwd dmdba
Changing password for user dmdba.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.

8、修改最大可打开文件数

[root@dm001 dm_x]# ulimit -a
[root@dm001 dm_x]# vim /etc/security/limits.conf
Dmdba soft nofile 65536
Dmdba hard nofile 65536

9、安装DM6数据库

[root@dm001 dm_x]# su – dmdba
[dmdba@dm001 ~]$ cd /dmdbms/dm_x/dm6_CT602.20.06.041roc6.0_64/
[dmdba@ljk02 dm6_CT602.20.06.041roc6.0_64]$ ./DMInstall.bin
Extract install files…
Welcome to DM Install Program
Please Input the Path of the Key File[/dmdbms/dm6_CT602.20.06.041roc6.0_64/dm.key]:/dmdbms/dm6_CT602.20.06.041roc6.0_64/dm6.key ####输入key文件目录
Expiration Date: unlimited
Server Series: Enterprise Edition
Server Type: Formal Edition
Customer Name: ����е�f��˾
Authorized User Number: 1
Concurrency User Number: unlimited
Installation Type:
1 Typical
2 Server
3 Client
4 Custom
Please Input the number of the Installation Type [1 Typicail]:1 ###默认经典安装
Require Space: 454M
Please Input the install path [/home/dmdba]:/dmdbms ###输入数据库安装目录
Available Space: 12G
Please Confirm the install path (Y/y,N/n) [Y/y]:Y ####确认安装路径
Whether to Initialize the Database (Y/y,N/n) [Y/y]:Y ###是否初始化数据库
Install Demo Database(Y/y,N/n) [N/n]:Y ####是否安装示例库
Please Input the data install path [/dmdbms/data]: ###输入数据库数据目录
Data Require Space: 415M
Data Available Space: 12G
Please Confirm the data install path (Y/y,N/n) [Y/y]:Y ###确认数据库数据安装目录
Whether to Modify DataBase Initiation Parameter (Y/y,N/n) [N/n]:Y ##是否修改初始参数
Data Page Size, only 4k,8k,16k,32k [8] ###默认8K
Data File Extent Size, only 16 pages or 32 pages [16] ###默认16pages
String case sensitive: Y sensitive;N no sensitive [N]
UNICODE Support: 0 no support;1 support [0]
Empty String(‘’) as NULL: Y yes;N no [N]
Whether to Modify SYSDBA Password (Y/y,N/n) [N/n]:
Whether to Modify SYSAUDITOR Password (Y/y,N/n) [N/n]:
Pre-Installation Summary
Installation Location: /dmdbms
Data Installation Location: /dmdbms/data
Require Space: 454M
Available Space: 12G
Data Require Space: 415M
Data Available Space: 12G
Version Information: Enterprise Edition
Expire Data: unlimited
Installation Type: Typical
Confirm to Install?(Y/y,N/n) [Y/y]:y ####确认开始安装数据库
Buildfile: build.xml

default:
[copy] Copying 10 files to /dmdbms/script
[copy] Copying 6 files to /dmdbms
[copy] Copying 14 files to /dmdbms/desktop/icons
[copy] Copying 1 file to /dmdbms/bin
[copy] Copying 1 file to /dmdbms/bin

。。。。。。。。。。。。。
。。。。。。。。。。。。。
。。。。。。。。。。。。。

 [exec] INSERT INTO OTHER.READER VALUES(11, 'Susan', 18, 'F', 'History');
 [exec] 
 [exec] 1 rows affected
 [exec] time used: 0.046(ms).
 [exec] 
 [exec] INSERT INTO OTHER.READER VALUES(12, 'John', 19, 'M', 'Computer');
 [exec] 
 [exec] 1 rows affected
 [exec] time used: 0.045(ms).

[delete] Deleting: /dmdbms/bin/createdatabase.sql
[delete] Deleting: /dmdbms/bin/CREATESCHEMA.sql
[delete] Deleting: /dmdbms/bin/CREATETABLE.sql
[delete] Deleting: /dmdbms/bin/INSERTSQL.sql

BUILD SUCCESSFUL
Total time: 45 seconds
[dmdba@ljk02 dm6_CT602.20.06.041roc6.0_64]$
至此，数据库安装完成。

10、登录数据库

[root@ljk02 bin]# pwd
/dmdbms/bin
[root@ljk02 bin]# cp .so /lib64/ #####将数据库安装目录下的bin下的.so文件拷贝至/lib64/目录下
[root@ljk02 bin]# ./isql sysdba/SYSDBA ###DM6通过isql登录数据库
isql V6.0.2.80-Build(2020.05.12)
login success
SQL>
SQL>exit

达梦社区：https://eco.dameng.com