达梦数据库基本运维操作

一、查看运行进程

[dmdba@localhost DAMENG]$ ps -ef | grep dmserver
dmdba      1371      1  0 09:08 ?        00:00:17 /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/data/DAMENG/dm.ini -noconsole

二、服务启动

[dmdba@localhost ~]$ systemctl status DmServiceDMSERVER.service
● DmServiceDMSERVER.service - DM Instance Service
   Loaded: loaded (/usr/lib/systemd/system/DmServiceDMSERVER.service; enabled; vendor preset: disabled)
   Active: active (running) since Wed 2025-01-22 09:09:08 CST; 1h 28min ago
  Process: 1242 ExecStart=/home/dmdba/dmdbms/bin/DmServiceDMSERVER start (code=exited, status=0/SUCCESS)
 Main PID: 1371 (dmserver)
    Tasks: 115
   CGroup: /system.slice/DmServiceDMSERVER.service
           └─1371 /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/data/DAMENG/dm.ini -nocon...

是否设置为开机自启

[dmdba@localhost ~]$ systemctl is-enabled DmServiceDMSERVER.service
enabled

三、连接数据库

命令行连接

[dmdba@localhost ~]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$ ./disql SYSDBA/SYSDBA@192.168.43.5:5236

服务器[192.168.43.5:5236]:处于普通打开状态
登录使用时间 : 9.339(ms)
disql V8
SQL>

工具连接

工具安装教程：https://www.cnblogs.com/mancheng/articles/18560109

四、基础的SQL语句

DDL创建表空间

create tablespace sw datafile 'sw.dbf' size 200 autoextend on maxsize 1024;

创建用户

create user swtest identified by "swtest1234" default tablespace sw;

DCL授权

grant "RESOURCE","PUBLIC","DBA","VTI" to swtest;

DML插入数据

insert into account values(2,'ll');

 DML语句修改数据

update account set name='hello' where id=2;

 五、查看系统参数

查看系统用户

SQL> select username,account_status,lock_date from dba_users;

行号     USERNAME   ACCOUNT_STATUS LOCK_DATE
---------- ---------- -------------- ---------
1          SYS        OPEN           NULL
2          SWTEST2    OPEN           NULL
3          SWTEST     OPEN           NULL
4          SYSSSO     OPEN           NULL
5          SYSAUDITOR OPEN           NULL
6          SYSDBA     OPEN           NULL

查看系统版本

SQL> select * from v$version;

行号     BANNER
---------- ---------------------------------
1          DM Database Server 64 V8
2          DB Version: 0x7000c
3          03134284294-20240919-243448-20119
4          Msg Version: 21
5          Gsu level(5) cnt: 0

查看实例状态

SQL> select name,instance_name,status$,mode$ from v$instance;

行号     NAME     INSTANCE_NAME STATUS$ MODE$
---------- -------- ------------- ------- ------
1          DMSERVER DMSERVER      OPEN    NORMAL