达梦8安装主要命令

原创已于 2025-10-18 16:21:02 修改 · 472 阅读

11 ·

CC 4.0 BY-SA版权

文章标签：

#达梦8

于 2024-10-18 17:56:07 首次发布

技术学习杂记专栏收录该内容

22 篇文章

订阅专栏

groupadd -g 12349 dinstall
useradd -u 12345 -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
passwd dmdba

mkdir /dm
mkdir /dmsoft
mkdir /dmdata

systemctl stop firewalld.service
systemctl disable firewalld.service

setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

mount -o loop dm8_20210630_x86_rh6_64_ent_8.1.2.18_pack7.iso /mnt
cp /mnt/DM* /dmsoft

chown -R dmdba:dinstall /dm /dmsoft /dmdata

umount /mnt

cd /dmsoft

su - dmdba
cd /dmsoft
./DMInstall.bin -i

su - root
/dm/script/root/root_installer.sh

## 执行过程，可以修改安装路径为 /dm

# 设置 /home/dmdba/.bash_profile

# 添加 /dm/bin 到 PATH 环境变量

su - dmdba
dminit path=/dmdata PAGE_SIZE=32 EXTENT_SIZE=32 CASE_SENSITIVE=N CHARSET=1 DB_NAME=DMDB1 INSTANCE_NAME=DMINST1 SYSDBA_PWD=xxxxxxx SYSAUDITOR_PWD=xxxxxx

## 以前的版本没有要求 SYSDBA_PWD 和 SYSAUDITOR_PWD ，新版本要求这两个参数了

su - root
cd /dm/script/root
./dm_service_installer.sh -t dmserver -dm_ini /dmdata/DMDB1/dm.ini -p DMSVR1
systemctl enable DmServiceDMSVR1.service
systemctl start DmServiceDMSVR1.service
systemctl status DmServiceDMSVR1.service

# 创建表空间、用户

su - dmdba
disql sysdba

   CREATE TABLESPACE BPS4EOS82DBA DATAFILE 'BPS4EOS82DBA.DBF' SIZE 128;
   create user BPS4EOS82DBA identified by "KGPTdba1234" default tablespace BPS4EOS82DBA default index tablespace BPS4EOS82DBA;
   grant "RESOURCE","PUBLIC","DBA","VTI" to BPS4EOS82DBA;

   CREATE TABLESPACE KGPTDBA DATAFILE 'KGPTDBA.DBF' SIZE 128;
   create user KGPTDBA identified by "KGPTdba1234" default tablespace KGPTDBA default index tablespace KGPTDBA;
   grant "RESOURCE","PUBLIC","DBA","VTI" to KGPTDBA;

   CREATE TABLESPACE NACOSDBA DATAFILE 'NACOSDBA.DBF' SIZE 128;
   create user NACOSDBA identified by "KGPTdba1234" default tablespace NACOSDBA default index tablespace NACOSDBA;
   grant "RESOURCE","PUBLIC","DBA","VTI" to NACOSDBA;

   CREATE TABLESPACE XXLJOBDBA DATAFILE 'XXLJOBDBA.DBF' SIZE 128;
   create user XXLJOBDBA identified by "KGPTdba1234" default tablespace XXLJOBDBA default index tablespace XXLJOBDBA;
   grant "RESOURCE","PUBLIC","DBA","VTI" to XXLJOBDBA;

# 导入导出数据
su - dmdba

dexp userid=BPS4EOS82DBA/SYSDBA123456 FILE=BPS4EOS82DBA.dmp LOG=BPS4EOS82DBA.log SCHEMAS=BPS4EOS82DBA
dexp userid=KGPTDBA/KGPTdba1234 FILE=KGPTDBA.dmp LOG=KGPTDBA.log SCHEMAS=KGPTDBA
dexp userid=NACOSDBA/KGPTdba1234 FILE=NACOSDBA.dmp LOG=NACOSDBA.log SCHEMAS=NACOSDBA
dexp userid=XXLJOBDBA/KGPTdba1234 FILE=XXLJOBDBA.dmp LOG=XXLJOBDBA.log SCHEMAS=XXLJOBDBA

dimp userid=BPS4EOS82DBA/SYSDBA123456 FILE=BPS4EOS82DBA.dmp LOG=BPS4EOS82DBA.log SCHEMAS=BPS4EOS82DBA TABLE_EXISTS_ACTION=TRUNCATE
dimp userid=KGPTDBA/KGPTdba1234 FILE=KGPTDBA.dmp LOG=KGPTDBA.log SCHEMAS=KGPTDBA TABLE_EXISTS_ACTION=TRUNCATE
dimp userid=NACOSDBA/KGPTdba1234 FILE=NACOSDBA.dmp LOG=NACOSDBA.log SCHEMAS=NACOSDBA TABLE_EXISTS_ACTION=TRUNCATE
dimp userid=XXLJOBDBA/KGPTdba1234 FILE=XXLJOBDBA.dmp LOG=XXLJOBDBA.log SCHEMAS=XXLJOBDBA TABLE_EXISTS_ACTION=TRUNCATE