Running Oracle 12c Database on Alibaba Cloud Containers

By Nikesh Gogia, Solution Architect

This tutorial is targeted for any organization that wants to host Oracle 12c on Alibaba Cloud using Docker containers. This document can be used by Solution Architects or Business Development teams for proof of concept (POC) of any customer requirement and gradually can be converted into production grade hosting.

We will be running our Docker containers on an Alibaba Cloud Elastic Compute Service (ECS) Ubuntu 16.04 64 bit 4 Core 8 GB RAM Virtual Machine.

Hosting Oracle 12c using Docker on Alibaba Cloud

With more than 500 new features, Oracle Database 12c is designed to give Oracle customers need for cloud computing, big data, security, and availability. Since Docker is the open source container software that packages applications in containers allowing them to be portal among systems running on Linux. Since Oracle has released the Docker image of Oracle 12 c and Alibaba Cloud has both Container and Linux VM’s this helps to adopt oracle database 12c on Alibaba Cloud.

1. Install Docker on Ubuntu 16.04

The Docker installation package available in the official Ubuntu 16.04 repository may not be the latest version. To get the latest and greatest version, install Docker from the official Docker repository. This section shows you how to do just that.

First, add the GPG key for the official Docker repository to the system:

Add the Docker repository to APT sources:

Next, update the package database with the Docker packages from the newly added repo:

Make sure you are about to install from the Docker repo instead of the default Ubuntu 16.04 repo:

You should see output similar to the follow:

Notice that docker-ce is not installed, but the candidate for installation is from the Docker repository for Ubuntu 16.04. The docker-ce version number might be different.

Finally, install Docker:

Docker should now be installed, the daemon started, and the process enabled to start on boot. Check that it’s running:

The output should be similar to the following, showing that the service is active and running:

Output

2. Setup Oracle Docker Image on Alibaba Cloud

Login to Docker Store with your credentials on above created VM

Once you do the following, you will see below output when you run docker images and docker ps –a commands.

Congratulations! You have successfully configured a Docker image on Alibaba Cloud VM Container.

3. Connecting Oracle DB Container Outside VM from Local Desktop

Install Oracle Client from Oracle Site.

Make sure you have Oracle Client installed on your client machine. You can install it from the following link: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Make sure you install and you have the PATH variable set where you can execute sqlplus command

b. Establish Connection from local desktop

You will see the output as below and you will get Connection Developed.

Note: In the above command, sys/Oradoc_db1@47.74.181.105:32775, sys has the username Oradoc_db1 is password and port is 32775. Make sure you open this port in your security Group and the IP 47.74… is a public IP. Additionally, you need to make sure you keep ORCLCDB.localdomain as service name as it is.

Conclusion

With this we conclude that Alibaba Cloud is capable of hosting Oracle 12c. By running Oracle on Alibaba Cloud Container Service or ECS servers, you can enjoy the latest cloud enabled database with stable and advanced features.

Reference:https://www.alibabacloud.com/blog/running-oracle-12c-database-on-alibaba-cloud-containers_594327?spm=a2c41.12451995.0.0

Follow me to keep abreast with the latest technology news, industry insights, and developer trends.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store