DM 企业管理器的英文简称 DM Enterprise Manager (DEM).
提供一个通过 WEB 界面来监控,管理,维护 DM 数据库的集中式管
理平台,可以从任何可以访问 web 应用的位置通过 DEM 来对 DM 数据库进行各种管理和监控。
1、检查JAVA环境
[dmdba@dmdb2 ~]$ rpm -qa | grep -i openjdk
java-1.8.0-openjdk-1.8.0.161-2.b14.el7.x86_64
java-1.7.0-openjdk-headless-1.7.0.171-2.6.13.2.el7.x86_64
java-1.7.0-openjdk-1.7.0.171-2.6.13.2.el7.x86_64
java-1.8.0-openjdk-headless-1.8.0.161-2.b14.el7.x86_64
将java环境添加dmdba用户下
[dmdba@dmdb2 jre]$ vi ~/.bash_profile export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-2.b14.el7.x86_64/jre export PATH=$JAVA_HOME/bin:$PATH
2、修改dm_ini参数
MEMORY_POOL = 200
BUFFER = 1000
KEEP = 64
MAX_BUFFER = 2000 (dm7才有的参数)
SORT_BUF_SIZE = 50
重启数据库实例
[dmdba@dmdb2 bin]$ ./DmServiceTEST restart Stopping DmServiceTEST: [ OK ] Starting DmServiceTEST: [ OK ]
3、在数据库中执行脚本
SQL>set define off
SQL>set char_code utf8
SQL>start /dm8/web/dem_init.sql
4、配置tomcat
解压:
[dmdba@dmdb2 bin]$ unzip apache-tomcat-8.0.20.zip
[dmdba@dmdb2 bin]$ mv apache-tomcat-8.0.20 tomat
编辑配置文件
[dmdba@dmdb2 conf]$ pwd
/dm8/bin/tomat/conf
[dmdba@dmdb2 conf]$ vi server.xml
<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443"
maxPostSize="-1" />
war包放到tomcat下
[dmdba@dmdb2 conf]$ cp /dm8/web/dem.war /dm8/bin/tomat/webapps/
启动tomcat
[dmdba@dmdb2 bin]$ ./startup.sh
Using CATALINA_BASE: /dm8/bin/tomat
Using CATALINA_HOME: /dm8/bin/tomat
Using CATALINA_TMPDIR: /dm8/bin/tomat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /dm8/bin/tomat/bin/bootstrap.jar:/dm8/bin/tomat/bin/tomcat-juli.jar
Tomcat started.
此时web中的war包被自动解压
[dmdba@dmdb2 webapps]$ pwd
/dm8/bin/tomat/webapps
[dmdba@dmdb2 webapps]$ ls
dem dem.war docs examples host-manager manager ROOT
修改web配置文件
[dmdba@dmdb2 WEB-INF]$ pwd
/dm8/bin/tomat/webapps/dem/WEB-INF
[dmdba@dmdb2 WEB-INF]$ vi db.xml
<?xml version="1.0" encoding="UTF-8"?>
<ConnectPool>
<Server>10.0.0.201</Server>
<Port>5237</Port>
<User>SYSDBA</User>
<Password>Dameng123</Password>
<InitPoolSize>5</InitPoolSize>
<CorePoolSize>10</CorePoolSize>
<MaxPoolSize>50</MaxPoolSize>
<KeepAliveTime>60</KeepAliveTime>
<DbDriver></DbDriver>
<DbTestStatement>select 1</DbTestStatement>
<SSLDir>../sslDir/client_ssl/SYSDBA</SSLDir>
<SSLPassword></SSLPassword>
</ConnectPool>
重启tomcat
[dmdba@dmdb2 bin]$ ./shutdown.sh
Using CATALINA_BASE: /dm8/bin/tomat
Using CATALINA_HOME: /dm8/bin/tomat
Using CATALINA_TMPDIR: /dm8/bin/tomat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /dm8/bin/tomat/bin/bootstrap.jar:/dm8/bin/tomat/bin/tomcat-juli.jar
[dmdba@dmdb2 bin]$ ./startup.sh
Using CATALINA_BASE: /dm8/bin/tomat
Using CATALINA_HOME: /dm8/bin/tomat
Using CATALINA_TMPDIR: /dm8/bin/tomat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /dm8/bin/tomat/bin/bootstrap.jar:/dm8/bin/tomat/bin/tomcat-juli.jar
Tomcat started.
5、访问web页面
账号默认admin,密码888888
6、设置代理
修改配置文件
[dmdba@dmdb2 dmagent]$ pwd
/dm8/tool/dmagent
[dmdba@dmdb2 dmagent]$ vi config.properties
##[General]
##run_mode values:
##0 - assist process
##1 - assist process & monitor
##2 - assist process & monitor & deployer
run_mode=2
##id_gen_policy values:
##0: mac&ip, mac preferred
##1: ip
id_gen_policy=0
ap_port=6363
rmi_port=6364
#rmi_data_port \u6570\u636e\u7aef\u53e3\uff0c\u9ed8\u8ba4\u4e3a0,\u968f\u673a\u5206\u914d\u7aef\u53e3
rmi_data_port=0
##[DEM]
center.url=http://10.0.0.201:8080/dem
center.agent_servlet=dem/dma_agent
只修改IP就好!
7、执行脚本
[root@dmdb2 dmagent]# ./DMAgentService.sh install
Detected RHEL or Fedora:
Installing the DMAgentService daemon using systemd...
creating default service file...
Created symlink from /etc/systemd/system/multi-user.target.wants/DMAgentService.service to /usr/lib/systemd/system/DMAgentService.service.
8、启动代理
[root@dmdb2 dmagent]# ./DMAgentService.sh start
Starting DMAgentService...
.......... running: PID:8147
[root@dmdb2 dmagent]# ./DMAgentService.sh install Detected RHEL or Fedora: Installing the DMAgentService daemon using systemd... creating default service file... Created symlink from /etc/systemd/system/multi-user.target.wants/DMAgentService.service to /usr/lib/systemd/system/DMAgentService.service.
8、启动代理
[root@dmdb2 dmagent]# ./DMAgentService.sh start
Starting DMAgentService...
.......... running: PID:8147
页面已经自动检测出主机