刚开始接触达梦，最头疼的就是打开图形化，命令如下：
su - root
env|grep DISPLAY
xhost +
su - dmdba
export DISPLAY=:2.0
xhost +
然后就是装库：
roupadd dinstall
useradd -g dinstall dmdba
chown dmdba:dinstall /dm8
passwd dmdba

vi /etc/security/limits.conf
dmdba soft nofile 65536
dmdba hard nofile 65536

cd /opt
./DmInstall
dbca
手动创建表空间：
su - dmdba
mkdir /dm8/backup
vi .bash_profile
export Pcreate user DMTEST identified by Dameng123 default tablespace DMTBS;
create role TESTROLE;
grant create table,create view,create index to TESTROLE;
grant RESOURCE, TESTROLE to DMTEST;
grant select on dba_tablespaces to DMTEST;
ATH=$ DM_HOME/bin:$ DM_HOME/tool:$PATH

disql sysdba/xxxx@localhost:5238
create tablespace “XXX” datafile ‘/dm8/data/DMDB/XXX01.DBF’ size 64 autoextend on next 2 maxsize 10240;
alter tablespace “XXX” add datafile ‘/dm8/data/DMDB/XXX02.DBF’ size 64 autoextend on next 2 maxsize 10240;

创建用户和角色：
create user ruy identified by Dameng123 default tablespace XXX;
create role uyt;
grant create table,create view,create index to uyt;
grant RESOURCE, TESTROLE to ruy ;
grant select on dba_tablespaces to ruy;

开启归档：
打开归档：
alter database mount;
alter database add archivelog ‘type=local,dest=/dm8/backup,file_size=64,space_limit=0’;
alter database archivelog;
alter database open;
做全备
SQL> backup database full backupset ‘/dm8/backup/full_bak’;
做增量备份
SQL> backup database increment backupset ‘/dm8/backup/incr_bak’;
创建索引：
create index indeed on xxx.emp(emp_name);

启停数据库：
./DmServiceDBNAME stop
./DmServiceDBNAME start