Centos 7下DM8安装操作手册(供参考)

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-22浏览:1

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 ...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息