达梦数据库静默安装

--命令模式参考链接： http://events.jianshu.io/p/7eb539f465a6
1.创建用户
useradd -g dinstall -m -d /oradata/dm/ -s /bin/bash dmdba

创建用户和参数配置
mkdir -p /oradata/dm/{dmdbms,dmarch,dmbak}
chown -R dmdba.dinstall /oradata/dm/
chmod -R 775 /oradata/dm

cat >>/etc/security/limits.conf<<"EOF"
dmdba               soft    nproc   65536
dmdba                hard    nproc   65536
dmdba               soft    nofile  65536
dmdba               hard    nofile  65536
EOF

echo "##############turning off service################"
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl status firewalld.service 

echo "turn off selinux"
SELINUX=`grep ^SELINUX= /etc/selinux/config`

if [ $SELINUX != "SELINUX=disabled" ];then
       cp /etc/selinux/config /etc/selinux/config.bak
       sed -i 's/^SELINUX=/#SELINUX=/g' /etc/selinux/config
sed -i '$a SELINUX=disabled' /etc/selinux/config
else
       echo "SELINUX is already disabled"
fi
echo
echo "all useless services has been closed"
echo "##############turning off service end################"

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

source .bash_profile

2. 上传安装介质
scp DMInstall.bin 192.168.11.73:/dm

3. 安装包
yum install -y gcc 
chown dmdba.dinstall /tmp/DMInstall.bin

4. 文件解压
su - dmdba
cd /dm 
./DMInstall.bin -i
配置路径等等
key：n
时区：21
典型安装

root用户下注册服务：
/oradata/dm/ddbms/script/root/root_installer.sh
Move /oracle/dm/dmdbms/bin/dm_svc.conf to /etc
Modify the files' mode of DM Server 
Create the DmAPService service
Created symlink from /etc/systemd/system/multi-user.target.wants/DmAPService.service to /usr/lib/systemd/system/DmAPService.service.
Finished to create the service (DmAPService)
Start the DmAPService service

5.创建数据库实例
--实际环境
[dmdba@localhost ~]$ dminit  BLANK_PAD_MODE=1 Pagesize = 16
initdb V8
db version: 0x7000b
file dm.key not found, use default license!
License will expire on 2021-09-04
input system dir: /oradata/dm/data
input db name: dmcs
input port num: 5236
input page size(4, 8, 16, 32): 16
input extent size(16, 32, 64): 32
input sec priv mode(0, 1, 2): 0
input time zone(-12:59,+14:00): +08:00
string case sensitive? ([Y]es, [N]o): y
which charset to use? (0[GB18030], 1[UTF-8], 2[EUC-KR]): 1
length in char? ([Y]es, [N]o): Y
enable database encrypt? ([Y]es, [N]o): n
input slice size(512, 4096): 512
page check mode? (0/1/2): 0
input elog path: /oradata/dm/logs
only create huge table with delta? (0/1): 1
rlog generate for huge? (0/1): 0
pseg_mgr_flag (0/1): 0
auto_overwrite mode? (0/1/2): 0

---以下为直接初始化：
dminit  PATH=/oradata/dm/dmdata PAGE_SIZE=16 EXTENT_SIZE=32 LOG_SIZE=2048 CASE_SENSITIVE=1 CHARSET=1 LENGTH_IN_CHAR=1 DB_NAME=dmtest INSTANCE_NAME=dmtest PORT_NUM=5237 PAGE_CHECK=0  RLOG_ENC_FLAG=0 PAGE_ENC_SLICE_SIZE=512 BLANK_PAD_MODE=1 AUTO_OVERWRITE=0 
---

6.## 注册服务及启动
赋权  chown -R dmdba:oracle /oradata/data
find /oradata/dm/data/ -name dm.ini
/oradata/dm/ddbms/script/root/dm_service_installer.sh -t dmserver  -p dm1 -dm_ini /oradata/dm/data/dmcs/dm.ini
systemctl enable DmServicedm1.service && systemctl start DmServicedm1
systemctl start DmServicedm1

--验证
su - dmdba 
disql sysdba/SYSDBA@localhost:5236
select status$ from v$instance;
select * from v$version;

7.创建网页版管理界面
start /oradata/dm/ddbms/web/dem_init.sql
cp /dm/dmdbms/web/dem.war /opt/apache-tomcat-7.0.35/webapps
cd  /opt/apache-tomcat-7.0.35/bin
chmod u+x *.sh 
# ./startup.sh
# ./shutdown.sh

（1）我们的dem.war包已经放在/usr/local/tomcat/webapps目录下了，然后刚刚由于tomcat的启动，我们的dem.war被自动解压成了一个目录dem
# cd /opt/apc..tomcat/webapps/dem/WEB-INF
# vim db.ml

（2）在/usr/local/tomcat/server/conf/server.xml中 <Connector port=“8080” protocol=“HTTP/1.1”…             

         追加属性字段 maxPostSize="-1"
         maxPostSize参数的意思是 使post内容大小不限制
（3）修改jvm启动参数：

修改bin目录下的catalina.sh文件，在文件末尾加一行代码：

JAVA_OPTS="-server -Xms256m -Xmx1024m -XX:MaxPermSize=512m -Djava.library.path=/dm/dmdbms/bin"  #记得把/home/dmdba/dmdbms/dmdbms/bin根据DM实际安装位置修改。         
         
8. 再次启动tomcat 
http://192.168.11.73:8083/dem/
admin/888888
GZYW_2106/GZYW_2106

--------------------------------------新建用户
1、新建表空间
//创建表空间
CREATE TABLESPACE SJQYTEST DATAFILE '/oradata/dm/data/dmuat/SJQYTEST01.DBF' SIZE 2048 autoextend on maxsize 30720;
//向表空间添加数据文件
alter tablespace SJQYTEST add datafile '/oradata/dm/data/dmuat/SJQYTEST02.DBF' size 128 autoextend on maxsize 30720

//创建用户
CREATE USER SJQY IDENTIFIED BY "sjqy.12345" DEFAULT TABLESPACE SJQYTEST;
//给用户授予PUBLIC和RESOURCE权限
grant public,resource,dba to SJQY;

create user ADMIN identified by "ADMIN.12345" default tablespace SYSTEM default index tablespace SYSTEM;

----用户名称
BBTEST/dmdba.123@192.168.11.73:5236   -------------报表测试
SJQY/sjqy.12345@192.168.1.188:5236     -------------信创数据迁移测试
TESTDBA/TESTDBA.12345@192.168.1.188:5236     -------------信创1.188dba用户

----新建DBA管理用户
//创建表空间
CREATE TABLESPACE TESTDBA DATAFILE '/oradata/dm/data/dmuat/TESTDBA01.DBF' SIZE 2048 autoextend on maxsize 30720;
//向表空间添加数据文件
alter tablespace SJQYTEST add datafile '/oradata/dm/data/dmuat/SJQYTEST02.DBF' size 128 autoextend on maxsize 30720

//创建用户
CREATE USER TESTDBA IDENTIFIED BY "TESTDBA.12345" DEFAULT TABLESPACE TESTDBA;
//给用户授予PUBLIC和RESOURCE权限
grant public,resource,dba to TESTDBA;

./DmServiceDmServicedm1 status
------删除表空间
drop tablespace SJQYTEST;
drop user SJQY;
drop user SJQY cascade; 

-------注销及删除实例
cd /oradata/dm/ddbms/script/root
./dm_service_uninstaller.sh -n DmServicedm1=dmuat