Repository files navigation

This repository provides a smalldockercompose.yml file to work with Oracle Enterprise 19c using Docker. This Repository is not affiliated with Oracle in any way.

1. You have Docker+Docker Desktop installed.
2. You have the minimum RAM and Disk Space as specified by Oracle.

An extensive write-up is available at thelinked blog post. A quickstart is provided in this README.

1. Clone this repository to your local system.
2. Download the Oracle Database 19c for LINUX (Enterprise Edition) ZIP file for your Architecture (ARM or AMD64) and place it in thedocker-images/OracleDatabase/SingleInstance/dockerfiles/19.3.0 folder.
3. Run thedocker-images/OracleDatabase/SingleInstance/dockerfiles/buildContainerImage.sh shell script with the appropriate command line tags:./buildContainerImage.sh -e -v 19.3.0 (-e forenterprise,-v 19.3.0 for the appropriate version)
4. Wait for the Build to complete.
5. Set the appropriateORACLE_PWD (oracle database administrator password) and other environment variables etc in thecompose.yml file.
6. Place yourSQL programs in theprograms folder. This folder will be available as the/home/oracle/programs folder inside the docker container.
7. Rundocker compose up. And wait for the database to finish creation/startup.
8. Open up theDocker Desktop and open theexec tab of the created Docker container.
   1. You can treat this as the shell of a virtual machine.
9. Move into theprograms directory from within the Container, and runsqlplus sys/oracle@//localhost:1521/ORCL as sysdba replacingoracle with the password you set and replacing other changed environment variables appropriately.
10. Now you can run SQL commands and programs!

Since port 1521 is exposed, you should also be able to run programs that connect to the database using theJDBC.

1. Remove this repository (its folder) from your computer.
2. Delete the created Docker container
3. Delete the created Docker image.

Thisdocker-run-to-compose converter was used to convert a version of the Docker run command fromthis README from Oracle's Github Repository to acompose.yml file.

This repository is not affiliated with Docker Inc. or Oracle in any way.