Centos 7下DM8安装操作手册(供参考)
1.准备好操作系统分区
![图片.webp](/download/0100e5533f21acd140699d6f65c3865d27d6.webp)
2.添加账号
#./1preusers.sh
#Author:www111
echo "Now create 1 groups named 'dinstall'"
echo "Plus 1 users named 'dmdba',Also setting the Environment"
groupadd -g 1100 dinstall
useradd -u 1100 -g dinstall -d /home/dmdba -s /bin/bash -c "dmdba Software Owner" dmdba
echo "dmdba" | passwd --stdin dmdba
echo "export PS1='[\u@\h \w]\$'" >> /home/dmdba/.bash_profile
echo "export TMP=/tmp">> /home/dmdba/.bash_profile
echo 'export TMPDIR=$TMP'>>/home/dmdba/.bash_profile
echo "export DMDBA_SID=test">> /home/dmdba/.bash_profile
echo "export DMDBA_BASE=/dmdata/app/db">> /home/dmdba/.bash_profile
echo 'export DMDBA_HOME=/dmdata/app/product/dm8/db_1'>> /home/dmdba/.bash_profile
echo "export DM_JAVA_HOME=/dmdata/jdk1.8.0_261">> /home/dmdba/.bash_profile
echo "export DMDBA_TERM=xterm">> /home/dmdba/.bash_profile
echo 'export PATH=/usr/sbin:$PATH'>> /home/dmdba/.bash_profile
echo 'export PATH=$DMDBA_HOME/bin:$DM_JAVA_HOME/bin:$PATH'>> /home/dmdba/.bash_profile
echo "export EDITOR=vi" >> /home/dmdba/.bash_profile
echo "export LANG=en_US" >> /home/dmdba/.bash_profile
echo "export NLS_LANG=american_america.AL32UTF8" >> /home/dmdba/.bash_profile
echo "export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'" >> /home/dmdba/.bash_profile
echo "umask 022">> /home/dmdba/.bash_profile
echo "The Groups and users has been created"
echo "The Environment for dmdba also has been set successfully"
3.上传安装包并挂载安装包
![图片.webp](/download/0100fd350d4e7ba74af1ab354e95b52a180b.webp)
4.切换到dmadm下,运行./DMInstall.bin
![图片.webp](/download/01003367b7de43cc4ea49700632b68a438da.webp)
![图片.webp](/download/0100987e484bbf534b8884789ce10aac90aa.webp)
![图片.webp](/download/0100cab6387f4cba49ba97a41ec4a60a79cd.webp)
![图片.webp](/download/0100513cbc337afe4e16a35b835ca7364351.webp)
这个没有key,多个许可,直接下一步,需要找厂商。见官方文档说明部分。
![图片.webp](/download/01007ee397591b54464a977c06ddb76ad09e.webp)
![图片.webp](/download/01003726c9876b5d4c7a8a6cb455d584afbc.webp)
![图片.webp](/download/010096a604a08ddf409dbeac96601d6055a3.webp)
![图片.webp](/download/01003e1ea295c95240d99b661d7811bb7d30.webp)
![图片.webp](/download/0100cb30064d81144bab9ed936a6b02c6a40.webp)
![图片.webp](/download/01000444ec2906f14a47821978868a322f86.webp)
Root执行安装脚本:
![图片.webp](/download/0100d24a29cba24e4973b187a40d03c4a96a.webp)
![图片.webp](/download/01004501ffe67cc94982932c248c8f85d4af.webp)
![图片.webp](/download/0100f7a64e7e03e148af9fbf732489b4882a.webp)
软件安装完成
5.创建数据库实例(初始化数据库)
![图片.webp](/download/01004e9ae15e3df94a0a9851939b0049a303.webp)
![图片.webp](/download/0100f33016bd6ac047788908fbd054214d6a.webp)
![图片.webp](/download/010043f684acf2714be586a6f9917c8900f1.webp)
指定数据库数据文件位置:
![图片.webp](/download/0100a7b7bf07061641f3b474459b841fdb0e.webp)
数据库名可以与实例名不同:
![图片.webp](/download/0100a6dd9b5038bc4cde955cf0ca42aabb27.webp)
![图片.webp](/download/0100aa0ea1a70409430098bc0f186af7c933.webp)
![图片.webp](/download/010063c6e5bb91b3420da4be9607a3932732.webp)
![图片.webp](/download/0100d7e0bc337ec940eda2a8bd5f7bedd733.webp)
![图片.webp](/download/0100ffad55f41b7e42419f6663d1fb6f017c.webp)
![图片.webp](/download/010077033ab29159411c881fda9fe5bcd398.webp)
EAS新建数据中心时提示页大小要求16k 。
![图片.webp](/download/0100f56606d63bd34600b6deb6c52c4ca099.webp)
![图片.webp](/download/0100974f6d5cc49d4e2bbf722b84a8c5aac3.webp)
![图片.webp](/download/0100ff43586455dd43ddaf81f3327d844cc0.webp)
拷贝自动启动dm8服务文件:mv /dmdata/app/product/dm8/db_1/bin/DmServicetest.service /usr/lib/systemd/system/DmServicetest.service
开启服务自启动:
systemctl enable DmServicetest.service
systemctl start DmServicetest.service
![图片.webp](/download/0100b531a60209294dcdae07ceef2c8b6bd9.webp)
![图片.webp](/download/010028e226bbd4434bda9856495694cd4af4.webp)
![图片.webp](/download/0100627bc5583ec641279fe74a1991b57801.webp)
实例创建完成。
6.通过 disql 登录,用命令行操作达梦数据库
![图片.webp](/download/0100d25673144cc1471ea0819248a83f77d3.webp)
7.打开达梦数据库自带的数据库管理连接工具
Cd $DMDBA_HOME/tool
![图片.webp](/download/0100df8d415316ab4c71a62082b8c569d02e.webp)
![图片.webp](/download/01006f295b73560c454b85bd040128e2f07e.webp)
![图片.webp](/download/01008e0afcb46d0243bb9896d7294254f7c5.webp)
![图片.webp](/download/0100ccd955f9c6d34cf7b185bce20f0e9979.webp)
到此连接正常。
8.创建数据库表空间(单位只认字节)
CREATE TABLESPACE testtps DATAFILE '/dmdata/test/test_01.dbf' SIZE 1024 autoextend on maxsize 5120;
ALTER TABLESPACE testtps ADD DATAFILE '/dmdata/test/test_02.dbf' SIZE 1024 autoextend on maxsize 5120
![图片.webp](/download/01008709195d26fe4df29e503994e65e466a.webp)
9.创建数据库用户并授权
CREATE USER "TESTUSER" IDENTIFIED BY "Kd1234567" DEFAULT TABLESPACE testtps ;
![图片.webp](/download/0100c7925d8b67e540e89257cfe5b4d9b6b5.webp)
GRANT DBA TO TESTUSER;
![图片.webp](/download/01003469e60df5a74d27aeddd305c4d467ab.webp)
Conn testuser/Kd1234567
![图片.webp](/download/01008952f41a073d4b7c915b549fc893bad5.webp)
创建表及插入数据:
![图片.webp](/download/01005fd2bb103ebb43d0a2b64aaa01277faf.webp)
![图片.webp](/download/0100d854c6b383b44892a5056963f95852db.webp)
![图片.webp](/download/0100f042e1dc06d742e0b73e3a476bd7b2a0.webp)
至此,数据库安装操作完成
Centos 7下DM8安装操作手册(供参考)
1.准备好操作系统分区![图片.webp](/download/0100e5533f21acd140699d6f65c3865d27d6.webp)2.添加账号#./1preusers.sh#Author:www111echo ...
点击下载文档
本文2024-09-22 20:30:14发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-114035.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章