There is often a need to work with the Oracle database. There are many ways to install this database. However, those who have deployed Oracle out of the box, know what a tambourine dance is and probably studied more than one ritual. There are several off-the-shelf solutions from Sun Microsystems now, for those who are not suited to Oracle VM VirtualBox they provide the option of using an Oracle Database Enterprise Edition image on Docker Hub. One of the benefits of using Docker is quick and easy preparation. I wanted to try and get the Oracle Database Enterprise Edition up and running quickly for use in a development environment.
|Docker||Oracle Database EE||Mac OS|
It is necessary to execute:
– Installing Docker on MacOs;
– Deploying an Oracle image on Docker;
– Create Database/Tables/Test Records;
– Establish a connection to the database;
First, you need to create account at Docker Hub
Download app: Docker Desktop
Login via terninal. The first time you log in, you need to enter your Docker Hub account username and password.
View running containers
Next, you need to download Oracle Database Enterprise Edition image from Docker Hub. Fill in all the fields.
docker pull store/oracle/database-enterprise:126.96.36.199
Run the container based on the downloaded Oracle image:
docker run -d -p 1521:1521 --name oracle store/oracle/database-enterprise:188.8.131.52
The exec command only works for running containers and is used to execute commands inside Docker containers, establish a connection.
docker exec -it oracle bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
Let’s connect to the database and create a user:
CONNECT sys AS sysdba; -- password as 'Oradoc_db1' ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE; CREATE USER gotoqa IDENTIFIED BY gotoqa; GRANT ALL PRIVILEGES TO gotoqa;
Now you can connect to our created database:
Username: gotoqa Password: gotoqa Hostname: localhost Port: 1521 Service name: ORCLCDB.localdomain
It ended up taking about 15 minutes to start Oracle Database in a Docker container out of the box. In my opinion, really the fastest way to get started with Oracle DB.