达梦基础操作

达梦基础操作

mkdir /dm7
groupadd dinstall
useradd -g dinstall dmdba
passwd dmdba

chown dmdba:dinstall -R /dm7

cd /home/dmdba
vi .bash_profile
su - dmdba
vi .bash_profile

export DM_HOME=/dm7
export PATH=$D{M}_{H}OME/bin:$DM_HOME/tool:$PATH

exit
ulimit -n 65536
vi /etc/security/limits.conf
dmdba soft nofile 4096
dmdba hard nofile 65536

mount -o loop /installdoc/dm7_setup_rh6_64_ent_7.6.0.142_20190312.iso /mnt

cd /mnt
./DMInstall.bin -i

su - dmdba
cd /dm7/bin
./dminit path=/dm7/data db_name=DM instance_name=DM port_num=5236

–

dminit path=/dm7/data db_name=DM1 instance_name=DM1 port_num=5237

cd /dm7/script/root/
./dm_service_installer.sh -t dmserver -p DM -i /dm7/bin/DM/dm.ini

./dm_service_installer.sh -t dmserver -p DM1 -i /dm7/data/DM1/dm.ini

select status$ from v$instance;
alter database mount;

cd /etc/rc.d/init.d

select para_name,para_value from v$dm_ini where para_name =‘CTL_BAK_PATH’;

select para_name,para_value from v$dm_ini where para_name =‘CTL_BAK_NUM’;

select para_name,para_value from v$dm_ini where para_name =‘MEMORY_TARGET’;

select para_name,para_value from v$dm_ini where para_name =‘MEMORY_POOL’;

select para_name,para_value from v$d{m}_{i}niwherepar{a}_{n}ame{=}^{\prime }BUFFE{R}^{\prime };selectpar{a}_{n}ame,par{a}_{v}aluefromv$dm_ini where para_name =‘MAX_BUFFER’;
select para_name,para_value from v$dm_ini where para_name =‘BUFFER_POOL’;

select name,type from v$parameter where name=‘BUFFER’;

sp_set_para_value(2,‘BUFFER’,1000)

select para_name,para_value from v$dm_ini where para_name =‘DICT_BUF_SIZE’;

select para_name,para_value from V$dm_ini where para_name =‘USE_PLN_POOL’;

select para_name,para_value from V$dm_ini where para_name like ‘%RLOG%’;

select para_name,para_value from V$d{m}_{i}niwherepar{a}_{n}amelik{e}^{\prime }selectpar{a}_{n}ame,par{a}_{v}aluefromV$dm_ini where para_name like ‘%HJ_BUF%’;

select path from v$rlogfile;

alter database add logfile ‘/dm7/bin/DM/DM03.log’ size 100;

alter database resize logfile ‘/dm7/bin/DM/DM03.log’ to 200;

select name from v$tablespaceunionselectnamefromv$huge_tablespace;

create tablespace tbs1 datafile ‘/dm7/bin/DM/tabs.dbf’ size 32;

create tablespace tbs2 datafile ‘/dm7/bin/DM/tabs2.dbf’ size 50 autoextend on maxsize 100;

create tablespace tbs3 datafile ‘/dm7/bin/DM/tabs3.dbf’ size 50 autoextend on next 1 maxsize 100;

create tablespace tbs4 datafile ‘/dm7/bin/DM/tabs4.dbf’ size 50 autoextend on next 1 maxsize 100, ‘/dm7/bin/DM/tabs5.dbf’ size 50 autoextend on next 1 maxsize 100;

alter tablespace tbs4 offline;
alter tablespace tbs4 rename datafile ‘/dm7/bin/DM/tabs4.dbf’ to ‘/dm7/bin/tabs4.dbf’ ;

alter tablespace tbs4 online;

drop tablespace tbs1;

select username from dba_users;

create user test identified by dameng123 limit password_life_time 60 default tablespace tbs2;

select role from dba_roles;

select grantee,granted_role from dba_role_privs where grantee =‘TEST’;
select grantee,privilege from dba_sys_privs where grantee = ‘PUBLIC’;

create table t1(id int);
grant create table to test;

create user test1 identified by dameng123 limit password_life_time 60,failed_login_attemps 2,password_lock_time 5;
alter user test1 account unlock;

grant create table to test1;
grant select on dmhr.employee to test1;
grant select(employee_name,hire_date) on dmhr.employee to test1;
revoke select on dmhr.employee to test1;

Create schema DAMENG AUTHORIZATION SYSDBA;
Drop schema DAMENG;

create table test1.stu(id char(10) not null,sname varchar(20) not null ,constraint pk_id not cluster primary key(id)) storage (on tbs2,clusterbtr);
comment on table test1.stu is ‘xxxx’;
create table test1.t3(id int unique);
create table test1.t4 (id int check(id>5));
alter table test1.t4 add constraint xx primary key (id);
create table test1.t5(id int,id2 int foreign key references test1.t4(id
comment on column test1.t4.id is ‘aaaa’;