--命令模式参考链接: 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