首页 > 数据库 > 国内数据库 > 达梦DEM工具安装配置
1.在windows机器安装达梦数据库软件
2.初始化一个数据库并进行如下配置
alter system set 'SORT_BUF_SIZE'=200; alter system set 'BUFFER'=1000 spfile; alter system set 'KEEP'=64 spfile; alter system set 'SORT_BUF_SIZE'=50 spfile; create tablespace dem datafile 'E:\dmdbms\data\DAMENG\dem.dbf' size 100 autoextend off; create user dem identified by dameng123 default tablespace dem; grant dba to dem;
3. 在 DEM 后台库中执行 SQL 脚本 dem_init.sql
conn dem/dameng123; set CHAR_CODE UTF8 start E:\dmdbms\web\dem_init.sql
4.安装jdk
5.部署tomcat
6.将包E:\dmdbms\web\dem.war拷贝至tomcat目录D:\Tomcat8.5\webapps
7.修改文件D:\Tomcat8.5\webapps\dem\WEB-INF\db.xml
<?xml version="1.0" encoding="UTF-8"?> <ConnectPool> <Dbtype>dm8</Dbtype> <Server>192.168.18.146</Server> <Port>5236</Port> <User>dem</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> <!-- <Url>jdbc:dm://localhost:5236</Url> --> </ConnectPool>
8.修改文件D:\Tomcat8.5\conf\server.xml
<Connector port="8080" protocol="HTTP/1.1" maxPostSize="-1" #添加 connectionTimeout="20000" redirectPort="8443" />
9.修改D:\Tomcat8.5\bin\catalina.bat
setlocal set java_opts="-server -Xms512m -Xmx1024m -Djava.library.path=E:\dmdbms\bin" #添加
10.修改D:\Tomcat8.5\conf\context.xml
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>
<Resources cachingAllowed="true" cacheMaxSize="200000" /> #添加
11.重启tomcat访问下面网址
admin/888888
12.安装agent
LINUX: cd /dm/dmdbms/dm8/tool/dmagent vi agent.ini center_url = [root@dm1 dmagent]# ./service.sh install input agent home [/dm/dmdbms/dm8/tool/dmagent] : input agent.ini path [/dm/dmdbms/dm8/tool/dmagent/agent.ini] : input service user [dmdba] : installation the service DmAgentService completed. [root@dm1 dmagent]# ./service.sh start Redirecting to /bin/systemctl start DmAgentService.service WINDOWS: E:\dmdbms\tool\dmagent\config.properties #[DEM] center.url= #修改 center.agent_servlet=dem/dma_agent #安装agent C:\Users\wwj_s>E:\dmdbms\tool\dmagent\DMAgentService.bat install wrapperm | DMAgentService service installed. C:\Users\wwj_s>E:\dmdbms\tool\dmagent\DMAgentService.bat start wrapperm | Starting the DMAgentService service... wrapperm | DMAgentService service started.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15412087/viewspace-3116345/ ,如需转载,请注明出处,否则将追究法律责任。