数据库安装部署DEM
1.查看jdk安装目录 java -version;1.8以上就可以
[dmdba@localhost web]$ java -version
openjdk version "1.8.0_181"
OpenJDK Runtime Environment (build 1.8.0_181-b13)
OpenJDK 64-Bit Server VM (build 25.181-b13, mixed mode)
2.安装Tomcat
解压
[root@localhost tmp]# tar -axvf apache-tomcat-7.0.77.tar.gz
[root@localhost tmp]# mv apache-tomcat-7.0.77 /tomcat
将dem.war包放到/tomcat/webapps/目录下面
[root@localhost webapps]# cp /dm8/web/dem.war .
[root@localhost webapps]# ls
dem.war docs examples host-manager manager ROOT
启动Tomat ,可以解压dem.war文件
[root@localhost bin]# pwd
/tomcat/bin
[root@localhost bin]# ls
bootstrap.jar commons-daemon.jar daemon.sh setclasspath.sh startup.sh tool-wrapper.sh
catalina.bat commons-daemon-native.tar.gz digest.bat shutdown.bat tomcat-juli.jar version.bat
catalina.sh configtest.bat digest.sh shutdown.sh tomcat-native.tar.gz version.sh
catalina-tasks.xml configtest.sh setclasspath.bat startup.bat tool-wrapper.bat
./startup.sh
[root@localhost bin]# ./startup.sh
Using CATALINA_BASE: /tomcat
Using CATALINA_HOME: /tomcat
Using CATALINA_TMPDIR: /tomcat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /tomcat/bin/bootstrap.jar:/tomcat/bin/tomcat-juli.jar
Tomcat started.
返回到webapps目录,查看dem.war 已经被解压了
[root@localhost bin]# cd ../webapps/
[root@localhost webapps]# ls
dem dem.war docs examples host-manager manager ROOT
4.配置后台数据库的连接信息:ip、port、用户名、密码、连接池大小,SSL登录信息等,在文件WEB-INF/db.xml(dem中)配置;
[root@localhost WEB-INF]# pwd
/tomcat/webapps/dem/WEB-INF
[root@localhost WEB-INF]# ls
classes db.xml dem.properties deploy lib log4j.xml sslDir web.xml
配置文件信息内容如下:
<?xml version="1.0" encoding="UTF-8"?>
<ConnectPool>
<Server>192.168.10.4</Server>
<Port>5236</Port>
<User>SYSDBA</User>
<Password>SYSDBA</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>
5.将/tomcat/webapps/dem/WEB-INF/sslDir路径下的server_ssl拷贝到dm8/bin下
[root@localhost sslDir]# pwd
/tomcat/webapps/dem/WEB-INF/sslDir
[root@localhost sslDir]# ls
client_ssl server_ssl
[root@localhost sslDir]# cp -r server_ssl/ /dm8/bin
6.配置tomcat(路径以自己的环境为准)
(1)在conf/server.xml中 <Connector port="8080" protocol="HTTP/1.1"... 追加属性字段 maxPostSize="-1";
(2)修改jvm启动参数,
Linux:bin/catalina.sh -> JAVA_OPTS="-server -Xms256m -Xmx1024m -XX:MaxPermSize=512m -Djava.library.path=/opt/dmdbms/bi
n" Windows:bin/catalina.bat -> set java_opts= -server -Xms40m -Xmx1024m -XX:MaxPermSize=512m -Djava.library.path=c:\dmdbms\bin
[root@localhost conf]# pwd
/tomcat/conf
[root@localhost conf]# ls
Catalina catalina.policy catalina.properties context.xml logging.properties server.xml tomcat-users.xml web.xml
[root@localhost conf]# vim server.xml
添加 maxPostSize="-1"
<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
maxPostSize="-1"
redirectPort="8443" />
[root@localhost bin]# pwd
/tomcat/bin
[root@localhost bin]# vim catalina.sh
232 JAVA_OPTS="-server -Xms256m -Xmx1024m -XX:MaxPermSize=512m -Djava.library.path=/dm8/bin"
7.创建一个数据库作为DEM后台数据库, 数据库dm.ini参数配置进行优化, 推荐配置:
MEMORY_POOL = 200
BUFFER = 1000
KEEP = 64
MAX_BUFFER = 2000
SORT_BUF_SIZE = 50
- 在该数据库中执行SQL脚本dem_init.sql,此SQL脚本编码为UTF-8,如果使用disql执行SQL脚本,请设置set CHAR_CODE UTF8;
[dmdba@localhost web]$ pwd
/dm8/web
[dmdba@localhost web]$ ls
dem_init.sql DEM.pdf demsdk.jar dem.war readme.txt
如何导入脚本,请参考:
https://blog.csdn.net/weixin_48588449/article/details/107762575
9.启动tomcat
访问
我的本机ip为192.168.10.4,开启浏览器访问url(http://192.168.10.4:8080/dem),登录(admin/888888)
可以登陆表示前面配置没有问题:
10.在需要进行监控的主机上启动dmagent,要求agent和dem所运行主机时间一致;
配置config.properties:
center.url=http://192.168.10.4:8080/dem #DEM访问地址
center.agent_servlet=dem/dma_agent #一般无需调整
cd /dm8/tool/dmagent
配置config.properties:
center.url=http://192.168.10.4:8080/dem #DEM访问地址
center.agent_servlet=dem/dma_agent #一般无需调整
启动agent
[dmdba@localhost dmagent]$ ./DMAgentService.sh start
Starting DMAgentService...
.......... running: PID:27577
点击主机就可以找到数据库实例了