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_pack4
container_name: dm8
environment:
# 时区上海
TZ: Asia/Shanghai
LD_LIBRARY_PATH: "/opt/dmdbms/bin"
# SYSDBA_PWD: "SYSDBA001" # 默认密码就是SYSDBA001 试了下这里改不了,进数据库改
ports:
- "5236:5236"
volumes:
- ./data/dm8/data:/opt/dmdbms/data
# restart: always
networks:
- my_net
deploy:
resources:
limits:
memory: 1G
reservations:
# cpus: 0.8
memory: 1G
networks:
my_net:
driver: bridge
ipam:
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";
集群安装
标签:DM,登录,数据库,ts,TABLESPACE,dm8,docker,data,SIZE From: https://www.cnblogs.com/muphy/p/16848480.html