dmdsc的相关操作

1.启动命令
–启动主机CSS服务
service DmCSSService start
–启动备机CSS服务
service DmCSSService start
2.关闭命令
service DmServiceRAC0 stop
service DmServiceRAC1 stop
service DmASMSvrService stop
service DmASMSvrService stop
service DmCSSService stop
service DmCSSService stop
3.通过监视器查看dsc集群的状态
/dmcssm ini_path=dmcssm.ini
./dmasmtool DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini
4.创建表空间用户并授权
create tablespace “RSGL” datafile ‘+DMDATA/data/rac/RSGL.DBF’ size 128 autoextend on next 128;
create user “RSGL” identified by “111111111” limit failed_login_attemps 10, password_lock_time 1, password_grace_time 10
default tablespace “RSGL”;
grant “DBA”,“RESOURCE”,“PUBLIC” to “RSGL” ;

5.查看数据库连接数的相关SQL
select * from v$sessions;

select count(*) from v$sessions;

select * from v$sessions where state = ‘ACTIVE’;