达梦8以配置文件静默安装

1 准备工作

安装好Linux操作系统，这里选择的是Linux 7：

关闭防火墙 和 Selinux：

systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld
sed -i 's/=enforcing/=disabled/g'  /etc/selinux/config
setenforce 0
getenforce

修改/etc/hosts 文件：

[root@dm1 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.31.166  dm1
[root@dm1 ~]# 


hostnamectl set-hostname

创建DM用户：

groupadd dinstall
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
passwd dmdba

创建目录：存储dm数据库文件的空间需要提前规划并挂载好，我这里放在/dm目录下：

mkdir -p /dm/dmdbms
mkdir -p /dm/dmarch
mkdir -p /dm/dmbak
chown -R dmdba:dinstall /dm/
chmod -R 775 /dm/

配置系统限制，在/etc/security/limits.conf 文件中添加如下内容：

 cat >> /etc/security/limits.conf << EOF   
dmdba  soft  nofile  4096
dmdba  hard  nofile  65536
EOF
ulimit -a

配置环境变量：在dmdba用户的~/.bash_profile 里添加如下内容：

cat >>/home/dmdba/.bash_profile<<EOF
export DM_HOME="/dm/dmdbms"
export LD_LIBRARY_PATH="/dm/dmdbms/bin:\$LD_LIBRARY_PATH"
export PATH="/dm/dmdbms/bin:\$PATH"

export LD_LIBRARY_PATH="\$LD_LIBRARY_PATH:/dm/dmdbms/bin"
export DM_HOME="/dm/dmdbms"
EOF

2 安装DM 数据库

复制安装文件: 将DM的ISO上传到Linux系统，并挂载：

mount -t auto /dev/cdrom  /mnt
[root@dm1 dm]# mount -o loop dm8_setup_rh7_64_ent_8.1.1.45_20191121.iso  /mnt
mount: /dev/loop0 is write-protected, mounting read-only

将安装文件复制到/dm 目录下并修改安装文件权限：

[root@dm1 mnt]# cp DMInstall.bin  /dm/.
[root@dm1 dm]# chown -R dmdba:dinstall /dm

准备配置文件 

<?xml version="1.0"?>
<DATABASE>
<LANGUAGE>en</LANGUAGE>
<TIME_ZONE>+08:00</TIME_ZONE>
<INSTALL_TYPE>0</INSTALL_TYPE>
<INSTALL_PATH>/dm/dmdbms</INSTALL_PATH>
<INIT_DB>Y</INIT_DB>
<DB_PARAMS>
<PATH>/dm/dmdbms/data</PATH>
<DB_NAME>DAMENG</DB_NAME>
<INSTANCE_NAME>DMSERVER</INSTANCE_NAME>
<PORT_NUM>5236</PORT_NUM>
<CTL_PATHS>
<CTL_PATH>/dm/dmdbms/data/DAMENG/dm.ctl</CTL_PATH>
</CTL_PATHS>
<LOG_PATHS>
<LOG_PATH>/dm/dmdbms/data/DAMENG/DAMENG01.log</LOG_PATH>
<LOG_PATH>/dm/dmdbms/data/DAMENG/DAMENG02.log</LOG_PATH>
</LOG_PATHS>
<EXTENT_SIZE>16</EXTENT_SIZE>
<PAGE_SIZE>8</PAGE_SIZE>
<LOG_SIZE>512</LOG_SIZE>
<CASE_SENSITIVE>Y</CASE_SENSITIVE>
<CHARSET>0</CHARSET>
<LENGTH_IN_CHAR>0</LENGTH_IN_CHAR>
<USE_NEW_HASH>1</USE_NEW_HASH>
<SYSDBA_PWD></SYSDBA_PWD>
<SYSAUDITOR_PWD></SYSAUDITOR_PWD>
<SYSSSO_PWD></SYSSSO_PWD>
<SYSDBO_PWD></SYSDBO_PWD>
<TIME_ZONE>+08:00</TIME_ZONE>
<PAGE_CHECK>0</PAGE_CHECK>
<EXTERNAL_CIPHER_NAME></EXTERNAL_CIPHER_NAME>
<EXTERNAL_HASH_NAME></EXTERNAL_HASH_NAME>
<EXTERNAL_CRYPTO_NAME></EXTERNAL_CRYPTO_NAME>
<SVR_KEY></SVR_KEY>
<DB_KEY></DB_KEY>
<ENCRYPT_PWD></ENCRYPT_PWD>
<ENCRYPT_NAME></ENCRYPT_NAME>
<RLOG_ENC_FLAG>N</RLOG_ENC_FLAG>
<USBKEY_PIN></USBKEY_PIN>
<BLANK_PAD_MODE>0</BLANK_PAD_MODE>
<SYSTEM_MIRROR_PATH></SYSTEM_MIRROR_PATH>
<MAIN_MIRROR_PATH></MAIN_MIRROR_PATH>
<ROLL_MIRROR_PATH></ROLL_MIRROR_PATH>
<PRIV_FLAG>0</PRIV_FLAG>
</DB_PARAMS>
<CREATE_DB_SERVICE>N</CREATE_DB_SERVICE>
<STARTUP_DB_SERVICE>Y</STARTUP_DB_SERVICE>
</DATABASE>

安装数据库 

[root@dm1 mnt]# ./DMInstall.bin  -q /dm/dminstall.xml 
Extract install files..........
2020-04-29 07:26:06 
[INFO] Installing DM DBMS...
2020-04-29 07:26:07 
[INFO] Installing BASE Module...
2020-04-29 07:26:09 
[INFO] Installing SERVER Module...
2020-04-29 07:26:10 
[INFO] Installing CLIENT Module...
2020-04-29 07:26:13 
[INFO] Installing DRIVERS Module...
2020-04-29 07:26:14 
[INFO] Installing MANUAL Module...
2020-04-29 07:26:14 
[INFO] Installing SERVICE Module...
2020-04-29 07:26:17 
[INFO] Move ant log file to log directory.
2020-04-29 07:26:17 
[INFO] Change the power of installtion directory successfully.
2020-04-29 07:26:17 
[INFO] Starting DmAPService service...
2020-04-29 07:26:18 
[INFO] Start DmAPService service successfully.
2020-04-29 07:26:18 
[INFO] Installed DM DBMS completely.
2020-04-29 07:26:21 
[INFO] Creating database...
2020-04-29 07:26:24 
[INFO] Create database completed.
2020-04-29 07:26:24 
[INFO] Creating database service...
2020-04-29 07:26:24 
[INFO] Create database service completed.
2020-04-29 07:26:24 
[INFO] Starting the database service(DmServiceDMSERVER)...
2020-04-29 07:26:39 
[INFO] Start the database service(DmServiceDMSERVER) success!

<!­­ 初始化时设置SYSDBA的密码，默认为SYSDBA，长度在6 到48个字符之间 ­­>
<SYSDBA_PWD></SYSDBA_PWD>
<!­­ 初始化时设置SYSAUDITOR的密码，默认为SYSAUDITOR，长度在 6 到48个字符之间 ­­>
<SYSAUDITOR_PWD></SYSAUDITOR_PWD>
<!­­ 初始化时设置SYSSSO的密码，默认为 SYSSSO，长度在6 到48个字符之间，仅在安全版本下可见和可设置 ­­>
<SYSSSO_PWD></SYSSSO_PWD>
<!­­ 初始化时设置SYSDBO的密码，默认为 SYSdbO，长度在6 到48个字符之间，仅在安全版本下可见和可设置 ­­>
<SYSDBO_PWD></SYSDBO_PWD>

[dmdba@dm1 ~]$ disql SYSDBA/SYSDBA@dm1:5236

Server[dm1:5236]:mode is normal, state is open
login used time: 3.849(ms)
disql V8
SQL> select * from v$version;

LINEID     BANNER                   
---------- -------------------------
1          DM Database Server 64 V8 
2          DB Version: 0x7000a

used time: 2.668(ms). Execute id is 989.
SQL> desc v$database;

LINEID     NAME           TYPE$        NULLABLE
---------- -------------- ------------ --------
1          NAME           VARCHAR(128) Y
2          CREATE_TIME    DATETIME(0)  Y
3          ARCH_MODE      CHAR(1)      Y
4          LAST_CKPT_TIME DATETIME(0)  Y
5          STATUS$        TINYINT      Y
6          ROLE$          TINYINT      Y
7          MAX_SIZE       BIGINT       Y
8          TOTAL_SIZE     BIGINT       Y
9          DSC_NODES      INTEGER      Y
10         OPEN_COUNT     INTEGER      Y
11         STARTUP_COUNT  BIGINT       Y

LINEID     NAME              TYPE$       NULLABLE
---------- ----------------- ----------- --------
12         LAST_STARTUP_TIME DATETIME(0) Y

12 rows got

used time: 7.708(ms). Execute id is 990.
SQL> select name from v$database;

LINEID     NAME  
---------- ------
1          DAMENG

used time: 1.471(ms). Execute id is 991.
SQL> 

至此DM8数据安装完成