Public | Automated Build

Last pushed: 2 years ago
Short Description
Docker image for Oracle 11g database
Full Description

Image for running Oracle Database 11g Standard/Enterprise. Due to oracle license restrictions image is not contain database itself and will install it on first run from external directory.

This image for development use only

Usage

Download database installation files from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index-092322.html and unpack them to install_folder.
Run container and it will install oracle and create database:

docker run --privileged --name oracle11g -p 1521:1521 -v <install_folder>:/install jaspeen/oracle-11g

Then you can commit this container to have installed and configured oracle database:

docker commit oracle11g oracle11g-installed

Database located in /opt/oracle folder
Port: 1521
SID: orcl

OS users:

  • root/install
  • oracle/install

DB users:

  • SYS/oracle

Optionally you can map dpdump folder to easy upload dumps:

docker run -d --privileged --name oracle11g -p 1521:1521 -v <install_folder>:/install -v <local_dpdump>:/opt/oracle/dpdump jaspeen/oracle-11g

To execute impdp/expdp just use docker exec command:

docker exec -it oracle11g impdp ..

On windows under docker-machine you can face the problem:
Exception: ORA-31640: unable to open dump file "/opt/oracle/dpdump/xxx.dmp" for read

Workaround is following:

  • Attach to container: docker exec -it <container>
  • Login as oracle: su oracle
  • Create new directory for dumps on aufs(not mounted from external): mkdir /opt/oracle/dpdump_local
  • Change oracle data_pump_dir via sqlplus under SYS user: create or replace directory data_pump_dir as '/opt/oracle/dpdump_local';
  • Copy necessary dump from dpdump to dpdump_local directory
Docker Pull Command
Owner
jaspeen
Source Repository

Comments (17)
azotov
3 months ago

DB credentials Role: SYSDBA

azotov
3 months ago

-v <install_folder>:/install -- <install_folder> is top level directory, inside which the installation unzipped

lanpishu
3 months ago

get "START DBCA
tail: cannot open '/opt/oracle/app/diag/tnslsnr/9a72de023aeb/listener/trace/listener.log' for reading: No such file or directory
tail: cannot watch parent directory of '/opt/oracle/app/diag/tnslsnr/9a72de023aeb/listener/trace/listener.log': No such file or directory
tail: inotify cannot be used, reverting to polling
tail: cannot open '/opt/oracle/app/diag/rdbms/orcl/orcl/trace/alert_orcl.log' for reading: No such file or directory
tail: cannot watch parent directory of '/opt/oracle/app/diag/rdbms/orcl/orcl/trace/alert_orcl.log': No such file or directory
tail: inotify cannot be used, reverting to polling
/bin/cat: /proc/sys/net/core/wmem_default: No such file or directory
/bin/cat: /proc/sys/net/core/wmem_default: No such file or directory
/bin/cat: /proc/sys/net/core/wmem_default: No such file or directory"

anthonyryck
9 months ago

Hello,
I'm trying to connect in SSH. The system is asking me the password for "oracle" user (it's "install" password), but the response is "Access denied".
My questions :

  • is it possible to connect in SSH ?
  • the password for oracle user is "install" ?
    Thanks for your help.
drroot85
a year ago

Finally , It Working :)

ricardolinero
a year ago

Finally working, great image!!

ricardolinero
a year ago

Hello, everything went well on the installation, i managed to connect to the Database using SQL Developer, but when i try to connect using OJBD from java i gent this exception

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Any ideas?

ricardolinero
a year ago

totorolepacha

This is my docker compose file for what you are asking

version: "2"
services:
detectid-oracle:
container_name: detectid-oracle
image: jaspeen/oracle-11g
ports:

         - "1521:1521"
      volumes:
         - /opt/docker/oracle-database/11g/installation:/install
totorolepacha
a year ago

(Sorry, new to docker)
I ran the first two commands to install the database and everything went good. But how do I run the container now, if I want to connect to the database ?

yinlimin
a year ago

I set 6G mem and 12G disk,