Docker Installation of Oracle Database 12c on Mac

I have been working with Virtual machines for quite a while, most of my testing and demo environments are on VirtualBox. The problem I’ve always faced is the storage and resources requirements to run multiple VMs. Running VMs on a MAC works well, however we all know that MAC storage is a premium that not all of us have.

I have always kept my VMs in an external drive, but quite honestly every time I am on a client or want to demos something, I usually don’t have the drive with me. With that I have been looking for alternatives and for quite a while I wanted to try Docker.

With some available time today, I decided to give it a shot and it worked really well. Below I am demonstrating what I did to get started.

Here are my Steps:

Download and Install Docker for Mac from the Docker Store

https://store.docker.com/editions/community/docker-ce-desktop-mac

Install it

Double-click Docker.dmg to start the install process.

When the installation completes and Docker starts, the whale in the top status bar shows that Docker is running, and accessible from a terminal.

Run it

Open a command-line terminal, and try out some Docker commands.

Run $docker version to check that you have the latest release installed.

Run $docker run hello-world to verify that Docker is pulling images and running as expected.

More information on how to run and install Docker on Mac can be found here:

https://docs.docker.com/docker-for-mac/install/#install-and-run-docker-for-mac

Now that I have downloaded and installed Docker successfully, I will download an existing Database 12c Image public available.

Docker Image to Download:

Go to hub.docker.com and type: Oracle 12c

Search_-_Docker_Hub

Click in the image absolutapps/oracle-ee-12c

Search_-_Docker_Hub2

Copy the Docker Pull Command:

docker pull absolutapps/oracle-12c-ee

absolutapps_oracle-12c-ee_-_Docker_Hub

 Alexs-MBP:~ alexlima$ docker pull absolutapps/oracle-12c-ee
Using default tag: latest
latest: Pulling from absolutapps/oracle-12c-ee
a3ed95caeb02: Pull complete
3f5d218d03fc: Pull complete
7599fba7a3e8: Pull complete
fe1149d58656: Pull complete
d40655be04ce: Pull complete
03835bd35ad5: Pull complete
3924faff9c04: Pull complete
a28a2f0d73a5: Pull complete
Digest: sha256:390a2166d94ea535ba1f82e293406cd91d0b34f1ecd84addf520d42c58f9bc06
Status: Downloaded newer image for absolutapps/oracle-12c-ee:latest
Alexs-MBP:~ alexlima$

Running image on Docker:

Alexs-MBP:~ alexlima$ docker run -d --name oracle-12cR1-ee --privileged absolutapps/oracle-12c-ee
f4a900e3f98755bf36df2cd073a6a81644e6b7c72d46051253ed1111d1b8e6c5

Install Oracle Database on Docker:

Alexs-MBP:~ alexlima$ docker logs -f oracle-12cR1-ee
ls: cannot access /u01/app/oracle/oradata/orcl: No such file or directory
No databases found in /u01/app/oracle/oradata/orcl. About to create a new database instance
Starting database listener

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 30-MAR-2018 16:34:46

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/f4a900e3f987/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=f4a900e3f987)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=f4a900e3f987)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                30-MAR-2018 16:34:46
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/f4a900e3f987/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=f4a900e3f987)(PORT=1521)))
The listener supports no services
The command completed successfully
Copying database files
1% complete
3% complete
11% complete
18% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 30-MAR-2018 16:39:57

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=f4a900e3f987)(PORT=1521)))
The command completed successfully
Database has been created in /u01/app/oracle/oradata/orcl
SYS and SYSTEM passwords are set to [oracle]
Setting HTTP port to 8080

PL/SQL procedure successfully completed.

Please login to http://:8080/em to use enterprise manager
User: sys; Password oracle; Sysdba: true
Fixing permissions...
Running init scripts...
Init scripts in /oracle.init.d/: Ignoring /oracle.init.d/*

Done with scripts we are ready to go

Start oracle Database and note the hostname:

Alexs-MBP:~ alexlima$ docker start oracle-12cR1-ee  (If not started)
Alexs-MBP:~ alexlima$ docker exec -it oracle-12cR1-ee /bin/bash
[root@f4a900e3f987 /]# echo $ORACLE_SID
orcl
[root@f4a900e3f987 /]# sqlplus system/oracle@//localhost:1521/orcl

SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 30 16:42:16 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> desc v$instance
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 INSTANCE_NUMBER				    NUMBER
 INSTANCE_NAME					    VARCHAR2(16)
 HOST_NAME					    VARCHAR2(64)
 VERSION					    VARCHAR2(17)
 STARTUP_TIME					    DATE
 STATUS 					    VARCHAR2(12)
 PARALLEL					    VARCHAR2(3)
 THREAD#					    NUMBER
 ARCHIVER					    VARCHAR2(7)
 LOG_SWITCH_WAIT				    VARCHAR2(15)
 LOGINS 					    VARCHAR2(10)
 SHUTDOWN_PENDING				    VARCHAR2(3)
 DATABASE_STATUS				    VARCHAR2(17)
 INSTANCE_ROLE					    VARCHAR2(18)
 ACTIVE_STATE					    VARCHAR2(9)
 BLOCKED					    VARCHAR2(3)
 CON_ID 					    NUMBER
 INSTANCE_MODE					    VARCHAR2(11)
 EDITION					    VARCHAR2(7)
 FAMILY 					    VARCHAR2(80)

SQL> select INSTANCE_NAME,HOST_NAME from v$instance;

INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
orcl
f4a900e3f987
SQL> select tablespace_name, file_name from dba_data_files;

TABLESPACE_NAME
------------------------------
FILE_NAME
--------------------------------------------------------------------------------
USERS
/u01/app/oracle/oradata/orcl/users01.dbf

UNDOTBS1
/u01/app/oracle/oradata/orcl/undotbs01.dbf

SYSTEM
/u01/app/oracle/oradata/orcl/system01.dbf


TABLESPACE_NAME
------------------------------
FILE_NAME
--------------------------------------------------------------------------------
SYSAUX
/u01/app/oracle/oradata/orcl/sysaux01.dbf

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[root@f4a900e3f987 /]# exit
exit
Alexs-MBP:~ alexlima$ docker container ls
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f4a900e3f987 absolutapps/oracle-12c-ee "/entrypoint.sh" 12 minutes ago Up 12 minutes 1521/tcp, 5500/tcp, 8080/tcp oracle-12cR1-ee
Alexs-MBP:~ alexlima$ docker stop oracle-12cR1-ee
oracle-12cR1-ee
Alexs-MBP:~ alexlima$ docker container ls
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
Alexs-MBP:~ alexlima$ docker image ls
REPOSITORY TAG IMAGE ID CREATED SIZE
hello-world latest f2a91732366c 4 months ago 1.85kB
absolutapps/oracle-12c-ee latest ad9bdfc002e7 23 months ago 6.12GB

Alexs-MBP:~ alexlima$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
Alexs-MBP:~ alexlima$ docker start oracle-12cR1-ee
oracle-12cR1-ee
Alexs-MBP:~ alexlima$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f4a900e3f987 absolutapps/oracle-12c-ee "/entrypoint.sh" 2 hours ago Up 7 seconds 1521/tcp, 5500/tcp, 8080/tcp oracle-12cR1-ee

And that’s it. I now have an working version of Oracle database 12c R1 running on my MAC with Docker.

Next test is to create a GoldenGate Microservices image to test some integrations. Stay tuned.

9 comments

laurent brusa says:

June 12, 2018 at 6:14 am

This did help me a lot!! thanks!

Tariq says:

March 25, 2019 at 6:37 pm

Hi am able to connect but when i am trying to connect with SQL developer , I am getting error:
Test Failed IO error:The network adapter could not establish the connection.
I am suspecting it is due to host name in listener.ora

Could You please help me on this

- Yuhan Qian says:
  
  March 31, 2019 at 5:38 am
  
  same…have you fixed it now?
  
- Karthik Velayudham says:
  
  April 19, 2019 at 12:04 pm
  
  I’m having the same problem too!
  
  - Hoa says:
    
    May 3, 2019 at 9:46 pm
    
    is there any help for this error when using SQL developer: Test Failed IO error:The network adapter could not establish the connection.
Daniel says:

October 26, 2019 at 5:50 am

i have same problem The network adapter could not establish the connection

Jonathan Nolasco says:

May 19, 2020 at 10:51 pm

Hi there, if you need to connect using SQL Developer you will need run the image specifying the public port. You should run this command as follow:

> docker run -d -p 1521:1521 -p 8080:8080 –name oracle-12cR1-ee –privileged absolutapps/oracle-12c-ee

jnolascob says:

May 19, 2020 at 10:52 pm

Hi there, if you need to connect using SQL Developer you will need run the image specifying the public port. You should run this command as follow:

> docker run -d -p 1521:1521 -p 8080:8080 –name oracle-12cR1-ee –privileged absolutapps/oracle-12c-ee

- JianNCI says:
  
  May 26, 2020 at 5:13 pm
  
  this is not working