Install Oracle database on Docker and connect with Aqua Data Studio or SQL Developer

In this tutorial I will show you how you can Install Oracle database on Docker and connect with Aqua Data Studio or SQL Developer.

The keynotes which I have used throughout the video can be found below.

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 youtubeoracle store/oracle/database-enterprise:12.2.0.1
4. Connect to container
docker exec -it youtubeoracle 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 Aqua Studio or Sql Developer

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






Tags:

oracle,docker,database,sql developer,how to install oracle 12c,how to install oracle 12c on windows 10,how to install oracle 12c on linux,how to install oracle 12c on oracle linux 7 virtualbox,docker oracle database 12c,oracle 12c docker tutorial,aqua data studio tutorial,oracle 12c aqua data studio,relational databases,oracle sql developer