oracle database on docker

readme.md

setup oracle database using docker

follow instructions of this link to build your desired oracle database

After building your image use this docker-compose.yml

services:
  oracle:
    image: oracle/database:19.3.0-ee
    container_name: oracledb
    network_mode: host
    ports:
      - 1521:1521
      - 5500:5500
    volumes:
      - "oradata:/opt/oracle/oradata"
volumes:
  oradata:

use following docker exec to set oracle password

docker exec oracledb ./setPassword.sh <my_strong_password>

connect to your database with this service name ORCLPDB1

Now sys , system users have access with yout <my_strong_password> password

post process SQL statements

create a new user i called it root with its password and grant necessery access to it for creating inserting rows to tables

-- create a user called root with root password 
CREATE USER root IDENTIFIED BY root
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;

-- grant session access to root user for connecting to database
GRANT CREATE SESSION TO root ;
-- grant creat table to root user for connecting to database
GRANT CREATE TABLE TO root ;


GRANT CREATE VIEW, CREATE PROCEDURE, CREATE SEQUENCE TO root;

GRANT UNLIMITED TABLESPACE TO root;

--- give resource access to new user

alter USER root quota unlimited on USERS;