RedHat7 静默方式安装DM数据库

RedHat7 静默方式安装DM数据库

说明：静默安装适用于非交互式的特殊场景，Linux环境准备不在演示。

1、上传DM安装包

mkdir -p /tmp/soft （安装包上传在此目录，根据实际环境而定）
chown -R dmdba:dinstall /tmp/soft
chmod -R 755 /tmp/soft

2、编写静默参数文件

vi /tmp/soft/auto_install.xml

<?xml version="1.0"?> en +08:00 0 /opt/dmdbms y

<DB_PARAMS>
/home/dameng/data
<DB_NAME>DAMENG</DB_NAME>
<INSTANCE_NAME>DMSERVER</INSTANCE_NAME>
<PORT_NUM>5236</PORT_NUM>
<CTL_PATH>/home/dameng/data/DAMENG/dm.ctl</CTL_PATH>
<LOG_PATHS>
<LOG_PATH>/home/dameng/data/DAMENG/DAMENG01.log</LOG_PATH>
<LOG_PATH>/home/dameng/data/DAMENG/DAMENG02.log</LOG_PATH>
</LOG_PATHS>

<EXTENT_SIZE>16</EXTENT_SIZE>
<PAGE_SIZE>16</PAGE_SIZE>
<LOG_SIZE>256</LOG_SIZE>
<CASE_SENSITIVE>Y</CASE_SENSITIVE>
<LENGTH_IN_CHAR>0</LENGTH_IN_CHAR>
<1CHARSET>0<1/CHARSET>
说明：这里CHARSET前面的“1”不要，这里写文章，不加在前面，就无法显示CHARSET
<USE_NEW_HASH>1</USE_NEW_HASH>
<SYSDBA_PWD>123456789</SYSDBA_PWD>
<SYSAUDITOR_PWD>123456789</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>
<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>
<ELOG_PATH>/opt/dmdbms/log</ELOG_PATH>
</DB_PARAMS>

<CREATE_DB_SERVICE>Y</CREATE_DB_SERVICE>
<STARTUP_DB_SERVICE>N</STARTUP_DB_SERVICE>

3、执行静默安装命令

su - root
cd /tmp/soft/
./DMInstall.bin –q /tmp/soft/auto_install.xml

4、用脚本注册服务

su - root
cd /opt/dmdbms/script/root
./dm_service_installer.sh -t dmserver -dm_ini /home/dameng/data/DAMENG/dm.ini -p TEST3

5、测试数据库可用性

测试demo：
–测试创建表空间，表空间路径根据自己的环境修改
create tablespace TEST3 datafile ‘/home/dameng/data/DAMENG/TEST3.DBF’ size 100 autoextend off;
–测试表增、删、改、查
create table TEST3 (id int,name varchar(10)) storage (on TEST3);
insert into TEST3 values (1,‘张三’);
insert into TEST3 values (2,‘李四’);
insert into TEST3 values (3,‘王五’);
commit;
select id,name from TEST3;
update TEST3 set name=‘张三三三’ where id=1;
commit;
delete from TEST3 where id=3;
commit;
select id,name from TEST3;

6、命令行卸载DM

su - dmdba
cd /opt/dmdbms
./uninstall.sh -i