Install Oracle database on Docker and connect with SQL Developer

Published: 09 March 2019
on channel: ShowMeYourCode!
81,983
999

In this tutorial I will show how to run Oracle database on Docker container and connect to it using SQL Developer.

Below useful commands use in the tutorial:

1. Log into Docker hub (in order to access oracle repository)
docker login
2. Download image
docker pull store/oracle/database-enterprise:12.2.0.1
3. Run image
docker run -d -p 1521:1521 --name oracle store/oracle/database-enterprise:12.2.0.1
4. Connect to container
docker exec -it oracle bash -c "source /home/oracle/.bashrc; sqlplus /nolog"

5. Copy below script to open SQL shell

connect sys as sysdba;
-- Here enter the password as 'Oradoc_db1'
alter session set "_ORACLE_SCRIPT"=true;
create user dummy identified by dummy;
GRANT ALL PRIVILEGES TO dummy;

4. Configure SQL Developer

Username: dummy
Password: dummy
Hostname: localhost
Port: 1521
Service name: ORCLCDB.localdomain


On this page of the site you can watch the video online Install Oracle database on Docker and connect with SQL Developer with a duration of hours minute second in good quality, which was uploaded by the user ShowMeYourCode! 09 March 2019, share the link with friends and acquaintances, this video has already been watched 81,983 times on youtube and it was liked by 999 viewers. Enjoy your viewing!