DM数据库安装、登录和创建用户

DM数据库安装、登录和创建用户

子安

拉取镜像

wget -O dm8_docker.tar -c https://download.dameng.com/eco/dm8/dm8_20220822_rev166351_x86_rh6_64_ctm.tar
docker load -i dm8_docker.tar
docker images

编写docker-compose.yml

version: '3'
services:dm8:image: dm8_single:v8.1.2.128_ent_x86_64_ctm_pack4container_name: dm8environment:# 时区上海TZ: Asia/ShanghaiLD_LIBRARY_PATH: "/opt/dmdbms/bin"# SYSDBA_PWD: "SYSDBA001" # 默认密码就是SYSDBA001 试了下这里改不了，进数据库改ports:- "5236:5236"volumes:- ./data/dm8/data:/opt/dmdbms/data# restart: alwaysnetworks:- my_netdeploy:resources:limits:memory: 1Greservations:# cpus: 0.8memory: 1G
networks:my_net:driver: bridgeipam:config:- subnet: 172.30.0.0/16

启动

docker-compose up -d
docker logs -f dm8

登录

# 进入容器
docker exec -it dm8 bash
# 容器里面执行
cd /opt/dmdbms/bin
# 登录 如果不成功会再次提示输入用户密码
./disql sysdba/SYSDBA001 as sysdba

表空间操作

-- 数据表空间 数据文件越多，数据库并行备份时可指定并行度越大，建议5-10个数据文件即可，根据实际硬盘调整SIZE大小，不够的话会自动扩展
CREATE TABLESPACE ts_data DATAFILE 'ts_data01.dbf' SIZE 10240;
ALTER TABLESPACE ts_data ADD DATAFILE 'ts_data02.dbf' SIZE 10240;
-- 索引表空间
CREATE TABLESPACE ts_idx DATAFILE 'ts_idx01.dbf' SIZE 2048;
ALTER TABLESPACE ts_idx ADD DATAFILE 'ts_idx02.dbf' SIZE 2048;

创建用户

CREATE USER "user" IDENTIFIED BY "pwd" DEFAULT TABLESPACE "ts_data" DEFAULT INDEX TABLESPACE "ts_idx";
GRANT create table,select table,update table,insert table TO "user";
GRANT resource，public TO "user";
GRANT dba TO "user";