How to install Oracle 18c to docker

prerequisites

1. Docker much run on Linux
2. Git

Step to install oracle

1. pull dockerfile from path “https://github.com/oracle/docker-images.git”

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

2. go to path “D:\test1\docker-images\OracleDatabase\SingleInstance\dockerfiles\18.4.0”

3. build image docker from dockerfiles

docker build -t oracle-db-18c -f Dockerfile.xe .

4. run contrainer from image ( Very long time to process)

docker run — name OracleXE -p 1521:1521 -p 5500:5500 -e ORACLE_PWD=newPassword1234 -e ORACLE_CHARACTERSET=TH8TISASCII -d oracle-db-18c

Status(healty)

5. Create User from Oracle (exec to Contrainer by sqlplus command)

docker exec -it OracleXE sqlplus system/Bas1234

6.SCript to create user

CREATE USER test_user IDENTIFIED BY newPassword1234;
GRANT CONNECT TO test_user;
GRANT CONNECT, RESOURCE, DBA TO test_user;
GRANT CREATE SESSION GRANT ANY PRIVILEGE TO test_user;
GRANT CREATE SESSION GRANT ANY PRIVILEGE TO test_user;

7. I use sqldeveloper to test db

OK!!!!!

Big thank and reference

https://medium.com/pnpsolution/%E0%B8%A7%E0%B8%B4%E0%B8%98%E0%B8%B5%E0%B9%83%E0%B8%8A%E0%B9%89-oracle-18c-%E0%B8%9A%E0%B8%99-docker-7598990401da