wezhai/oracle repository overview

docker run -d --name oracle \
        -p 1521:1521 \
        -v /etc/localtime:/etc/localtime \
        -e 'NLS_LANG=Simplified Chinese_CHINA.AL32UTF8' \
        -e ORACLE_ALLOW_REMOTE=true \
        wezhai/oracle:11.2.0.2.0

version: "3.2"
services:
  oracle:
    image: wezhai/oracle:11.2.0.2.0
    container_name: oracle
    environment:
      - NLS_LANG=Simplified Chinese_CHINA.AL32UTF8
      - ORACLE_ALLOW_REMOTE=true
    #volumes:
    #  - /etc/localtime:/etc/localtime
    restart: always
    ports:
      - "1521:1521"

docker exec -it oracle bash -c "ss -atnpl | grep :1521"

docker exec -it oracle bash

source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

sqlplus system/oracle@localhost:1521/xe

CREATE USER testdb IDENTIFIED BY admin123;
GRANT DBA, CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE to testdb;