antonioanerao/oracle-database repository overview

docker network create proxy

git clone https://github.com/oracle/docker-images.git

cd docker-images/OracleDatabase/SingleInstance/dockerfiles

./buildContainerImage.sh -v 21.3.0 -x

services:

  oracledb:
    container_name: oracledb
    image: oracle/database:21.3.0-xe
    ports:
      - 1521:1521
      - 5500:5500
    networks:
      proxy:
    environment:
      oracle_pdb : "orcl"
      oracle_pwd : "password"
      oracle_bundle: basic
      init_sga_size : "3000"
      init_pga_size : "1000"
    volumes:
      - oracle-data:/opt/oracle/oradata
      - oracle-backup:/opt/oracle/backup

networks:
  proxy:
    external: true

volumes:
  oracle-data:
  oracle-backup:

docker compose up -d

docker exec -it nome-container /bin/bash
sqlplus sys@XEPDB1 as sysdba

CREATE USER laravel IDENTIFIED BY "sua-senha";
GRANT CREATE SESSION TO laravel;
GRANT CREATE TABLE TO laravel;
GRANT ALTER ANY TABLE TO laravel;
GRANT DROP ANY TABLE TO laravel;
GRANT CREATE VIEW TO laravel;
GRANT CREATE PROCEDURE TO laravel;
GRANT CREATE TRIGGER TO laravel;
GRANT CREATE SEQUENCE TO laravel;
GRANT UNLIMITED TABLESPACE TO laravel;
CREATE TABLESPACE laravel DATAFILE 'laravel.dbf' SIZE 1000M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
ALTER USER laravel DEFAULT TABLESPACE laravel;