Public | Automated Build

Last pushed: 6 months ago
Short Description
Oracle 12c r1 with sql initdb and web console
Full Description

docker-oracle-12c-R1

Oracle 12c Release 1


Image on docker hub: https://hub.docker.com/r/pengbai/docker-oracle-12c-r1/

Changes as needed:

  • Add startup sql init database feature
  • Impove performance on startup
  • Persist database SID xe in image

Description

Pull image:

docker pull pengbai/docker-oracle-12c-r1

Run with 8080 and 1521 ports opened:

docker run -d -p 8080:8080 -p 1521:1521 pengbai/docker-oracle-12c-r1

NEW! Option: Execute automatically scripts sql when contaner startup:

In folder where you put your *.sql files for database init from /local-initdb to /entrypoint-initdb.d in contaner

docker run -d -p 8080:8080 -p 1521:1521 -v /local-initdb:/entrypoint-initdb.d pengbai/docker-oracle-12c-r1

Connect database with following setting:

hostname: localhost
port: 1521
sid: xe
username: system
password: oracle

Password for SYS & SYSTEM:

oracle

Connect to Oracle Application Express web management console with following settings:

http://localhost:8080/apex
workspace: INTERNAL
user: ADMIN
password: 0Racle$
Docker Pull Command
Owner
pengbai
Source Repository

Comments (8)
william7c8
6 months ago

are these passwords working?

pengbai
9 months ago

Hi munditoro,
You can create a script sql to create users and tablespaces, add volume the script to /entrypoint-initdb.d of container.

munditoro
9 months ago

How could I make users and tablespaces?

pengbai
a year ago

Hi veilchen4ever,
I run container with option --shm-size=2g on my local, it's OK, I can't reproduce the error. (VM boot2docker on 1.12.0, Windows 7)
Could please create an issue on Github if needed ? It's easier for exchange. Thank you ;)

veilchen4ever
a year ago

To fix my problem I increased the sga_target in the spfilexe.ora

  1. creating a pfile from the spfilexe.ora
  2. overwrite the sga_target size in the pfile
  3. generate the spfilexe.ora from the pfile
    Afterwards the startup of the db works. But therefore I had to create my own image out of the configured container.

Now the question which is left open - Is there a way how I can configure the original image pengabi/oracle-12c-r1 on startup so that the db is startet without this error?

veilchen4ever
a year ago

Hello,
when i'm trying to run your image with
docker run -d -p 8080:8080 -p 1521:1521 --shm-size=2g pengbai/docker-oracle-12c-r1
and check with "docker logs -f ..." the startup lock I getting the following error message

 Starting tnslsnr

Starting database
ORA-00821: Specified value of sga_target 384M is too small, needs to be at least 404M
Starting web console on 8080
BEGIN DBMS_XDB.sethttpport(8080); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

Database init...
No volume sql script, ignoring /entrypoint-initdb.d/*

End init.
Oracle started Successfully !

Can somebody help me with this problem?

pengbai
a year ago

version: "stable" is same as "latest" 2016-08-05

pengbai
a year ago

New feature added 2016-03-30:
Execute automatically scripts sql when contaner startup