docker启动oracle

renkaige5

已于 2023-11-13 16:29:41 修改

阅读量335

点赞数

分类专栏： docker 数据库文章标签： docker oracle 容器

于 2023-11-13 15:54:03 首次发布

本文链接：https://blog.csdn.net/chenguihua5/article/details/134379226

版权

docker 同时被 2 个专栏收录

8 篇文章 0 订阅

订阅专栏

数据库

2 篇文章 0 订阅

订阅专栏

docker-compose.yml

version: '3.4'
services:
  oracle19:
    image: harbor.insightone.cn/oracle/oracle:19.3.0.0
    container_name: oracle19
    hostname: oracle19
    restart: always
    user: "54321"
    ports:
      - "1521:1521"
      - "5500:5500"
    environment:
      #The Oracle Database SID that should be used (default:ORCLCDB)
      ORACLE_SID: ORCLCDB
      #The Oracle Database PDB name that should be used (default: ORCLPDB1)
      ORACLE_PDB: ORCLPDB1
      #The Oracle Database SYS, SYSTEM and PDBADMIN password (default: auto generated)
      ORACLE_PWD: AbcD1234
      #The total memory in MB that should be used for all SGA components (optional)
      INIT_SGA_SIZE: 4096
      #The target aggregate PGA memory in MB that should be used for all server processes attached to the instance (optional)
      INIT_PGA_SIZE: 4096
      #The Oracle Database Edition (enterprise/standard, default: enterprise)
      ORACLE_EDITION: enterprise
      #The character set to use when creating the database (default: AL32UTF8)
      ORACLE_CHARACTERSET: AL32UTF8
      #To enable archive log mode when creating the database (default: false). Supported 19.3 onwards.
      ENABLE_ARCHIVELOG: "true"
      #设置时区
      TZ: Asia/Shanghai
    volumes:
      #设置数据目录
      - ./oradata:/opt/oracle/oradata
      #数据库startup后执行的脚本
      - ./startup:/opt/oracle/scripts/startup
      #数据库setup后执行的脚本
      - ./setup:/opt/oracle/scripts/setup
    networks:
      test:
        ipv4_address: 172.18.0.19
networks:
  test:
    external: true

宿主机目录授权

linux下运行docker-compose需要给oradata startup setup赋予用户权限,否则启动会报错
mkdir -p /data/rkg/docker-compose/oracle/oradata
mkdir -p /data/rkg/docker-compose/oracle/startup
mkdir -p /data/rkg/docker-compose/oracle/setup
chown -R 54321:54321 /data/rkg/docker-compose/oracle/oradata
chown -R 54321:54321 /data/rkg/docker-compose/oracle/startup
chown -R 54321:54321 /data/rkg/docker-compose/oracle/setup

常用sql

alter session set container=ORCLPDB1;
create user "RKG" identified by "AbcD1234";
grant connect,resource,dba to rkg;

create tablespace rkg  datafile '/opt/oracle/oradata/ORCLCDB/ORCLPDB1/rkg.dbf' size 10g;
alter user RKG default tablespace rkg;