Docker installs Oracle

Recent work has encountered a performance-related problem, broadly described: The process of bulk task execution caused the database SQL execution time is too long, after the view is due to the bulk task full database connection pool caused, as to why the bulk of the task is not under the control of the system caused the connection pool to fill up not to say, feeling is the company's internal secrets. In order to be able to record this process in their own blog, bloggers want to install a oracle on their own Ubuntu, but downloaded to find that Ubuntu installed Oracle will have a variety of problems, and the online solution is relatively small, so plan to use Docker installation, By the way, review your Docker operations.

First of all the system should have Docker this application, installation can use command: sudo apt-get install Docker.

After installation, it is best to change the source of the Docker, changed to the source of Ali big guy, the reason is 100 times times stronger than the official Docker source. For more information, please refer to http://blog.csdn.net/bwlab/article/details/50542261

Search for Oracle-related docker sources:

password for [email protected]:~$ sudo docker search Oracle[sudo] work: NAME DESCRIPTION STARS official Automatedoraclelinux Oracle Linux is an open-so   Urce operating s ...   402 [OK] frolvlad/alpine-oraclejdk8 the smallest Docker image with Oraclejdk 8 ...   269 [ok]alexeiled/docker-oracle-xe-11g This is a working (hopefully) Oracle XE 11 ...   222 [ok]sath89/oracle-12c Oracle Standard Edition 12c Release 1 with ...   221 [ok]sath89/oracle-xe-11g Oracle XE 11g with database files Mount Su ...   135 [Ok]isuper/java-oracle This repository contains all Java releases ...                   [ok]jaspeen/oracle-11g Docker image for Oracle 11g database 55 [Ok]oracle/glassfish glassfish Java EE application Server on Or ...                   [OK]ORACLE/OPENJDK Docker images containing openjdk Oracle Linux 26   [OK]AIRDOCK/ORACLE-JDK Docker Image for Oracle Java SDK (8 and 7) ...        [OK]INGENSI/ORACLE-JDK official Oracle JDK installed on CentOS.   [ok]wnameless/oracle-xe-11g Dockerfile of Oracle Database Express Edit ...   [Ok]cogniteev/oracle-java Oracle JDK 6, 7, 8, and 9 based on Ubuntu ... [Ok]n3ziniuka5/ubuntu-oracle-jdk ubuntu with Oracle JDK.   Check Tags for ver ...   [Ok]oracle/nosql Oracle NoSQL on a Docker Image with Oracle ...   [Ok]collinestes/docker-node-oracle A container with node.js/oracle instant cl ... 9 [Ok]openweb/oracle-tomcat A Fork off of official Tomcat image with O...   7 [ok]sgrio/java-oracle Docker Images of Java 7/8 provided by Orac ...   7 [Ok]andreptb/oracle-java Debian Jessie based image with Oracle JDK ...                    7 [ok]flurdy/oracle-java7 Base image containing Oracle ' s Java 7 JDK 5 [Ok]davidcaste/debian-oracle-java Oracle Java 8 (and 7) over Debian Jessie 3 [ok]t   Eradatalabs/centos6-java8-oracle Docker image of CentOS 6 with Oracle JDK 8 ...   3 Publicisworldwide/oracle-core The core image based on Oracle Lin ...   1 [ok]spansari/nodejs-oracledb Nodejs with OracleDB installed globally on ...                    1 Sigma/nimbus-lock-oracle 0 [OK]

Here we choose sath89/oracle-12c sudo docker pull sath89/oracle-12c. After replacing the Ali, the speed is still quite fast and can be downloaded in about 10 minutes. View the source of the download, altogether 5.7G

[Email protected]:~$ sudo docker images; REPOSITORY                    TAG                 IMAGE ID            CREATED             SIZEsath89/oracle-12c             latest              17cd1ab9d9a7         2 days ago          5.703  gbkalilinux/kali-linux-docker   latest              8ececeaf404d        9 months ago        1.558 GB

Create a Docker Oracle container

[Email protected]:~/app$ sudo docker run-it sath89/oracle-12cDatabase not initialized. Initializing database. Starting tnslsnrcopying database Files1% Complete3% Complete One% Complete -% Complete -% CompletePanax Notoginseng%completecreating and starting Oracle instance +% Complete $% Complete -% Complete -% Complete About% Complete -% Complete +%completecompleting Database Creation the% Complete -% Complete the% Complete -% Complete the% Complete -%Completelook at the log file"/u01/app/oracle/cfgtoollogs/dbca/xe/xe.log"  forfurther details. Configuring Apex consoledatabase initialized. Please visit http://#containeer: 8080/em http://#containeer: 8080/apex for extra configuration if neededstarting web Management Consolepl/SQL procedure successfully completed. Starting Import from '/DOCKER-ENTRYPOINT-INITDB.D': Found File/docker-entrypoint-initdb.d//docker-entrypoint-initdb.d/*[IMPORT]/entrypoint.sh:ignoring/docker-entrypoint-initdb.d/*Import finisheddatabase ready to use. enjoy! ;)

When the container starts, note that the Oracle user name and password created with this image is: system/oracle, and then we use the local SQL tool to connect to the virtual machine's Oracle.

At this point, using Docker to install Oracle is complete, the installation process is simple and non-production environments can be considered. The following section details the performance issues encountered and the related analysis ideas.

Docker installs Oracle