Public | Automated Build

Last pushed: 9 months ago
Short Description
Oracle database 12c Release 1 with Apex 5.0.3
Full Description

Oracle database 12c release 1 with Apex 5.0.3


Content

This Dockerfile is based on my work for [https://hub.docker.com/r/mritschel/oraclebase]. The version is based on the image with Oracle Enterprise Linux 7.1 and Oracle Database 12c R1.
The resulting image contains the following:

  • Oracle Enterprise Linux 7.1
    • Oracle Database 12.1.0.2 Enterprise Edition
  • Apex 5.0.3
  • Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
  • Perl 5.14.1

Pull the latest trusted build from here.

Installation

Using Default Settings (recommended)

Complete the following steps to create a new container:

  1. Pull the image

     docker pull mritschel/docker-oracle12c-apex5
    
  2. Create the container

     docker run -d -p 8080:8080 -p 1521:1521 -h xe --name oracle-apex mritschel/oracle12c-apex
    
  3. wait around 5 minutes until the Oracle Database and APEX is created. Check logs with docker logs oracle-apex.
    The container is ready to uAll entries from the Alert.log and Listener.log are entered into the container logfile.
    The container stops if an error occurs. Check the logs to determine how to proceed.

Options

Environment Variables

You may set the environment variables in the docker run statement to configure the container setup process. The following table lists all environment variables with its default values:

Environment variable Default value Comments
DBCA_TOTAL_MEMORY 1024 Keep in mind that DBCA fails if you set this value too low
ORACLE_BASE /u01/app/oracle Oracle Base directory
ORACLE_HOME /u01/app/oracle/product/12.1.0.2/dbhome_1 Oracle Home directory
ORACLE_DATA /u00/app/oracle/oradata Oracle Data directory
ORACLE_HOME_LISTNER $ORACLE_HOME Oracle Home directory
SERVICE_NAME xe.oracle.docker Oracle service name
PATH $ORACLE_HOME/bin:$PATH Path
NLS_DATE_FORMAT DD.MM.YYYY\ HH24:MI:SS Oracle NLS date format
ORACLE_SID ORCLCDB The Oracle SID
INSTALL_HOME /u01/app/oracle/install Install directory
SCRIPTS_HOME /u01/app/oracle/scripts Scripts directory

Here's an example run call amending the SYS/SYSTEM password and DBCA memory settings:

docker run -e PASS=manager -e DBCA_TOTAL_MEMORY=1536 -d -p 8080:8080 -p 1521:1521 -p 5500:5500 -h xe --name oraclebasis mritschel/oracle12c-apex

Access

Access APEX

http://localhost:8080/apex/

Property Value
Workspace INTERNAL
User ADMIN
Password Manager_12C

Database Connections

To access the database e.g. from SQL Developer you configure the following properties:

Property Value
Hostname localhost
Port 1521
SID xe
Service xe.local.com

The configured user with their credentials are:

User Password
system oracle
sys oracle

Access Linux

User Password
root geheim
oracle geheim

Backup

Complete the following steps to backup the data volume:

  1. Stop the container with

     docker stop oracle-apex
    
  2. Backup the data volume to a compressed file xe.tar.gz in the current directory with a little help from the ubuntu image

     docker run --rm --volumes-from oracle-apex -v $(pwd):/backup ubuntu tar czvf /backup/oracle-apex.tar.gz /u01/app/oracle
    
  3. Restart the container

     docker start oracle-apex
    

Issues

Please file your bug reports, enhancement requests, questions and other support requests within Github's issue tracker:

License

docker-oracle12c-apex is licensed under the Apache License, Version 2.0. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0.

See Oracle Database Licensing Information User Manual and Oracle Database 12c Standard Edition 2 for further information.

Docker Pull Command
Owner
mritschel

Comments (4)
kristjanvall
8 months ago

Hello again. That did the trick (new version). But do you think to ords version of container to? Because i tried to modify the container and install ords 3 but i did not manage to do it correctly and broke the container several timest.

Best requards
Kristjan

mritschel
9 months ago

When i go to localhost:8080/apex i resive i "Your login
information will be sent securely." popup and i can not find what is the username and password for that.

That was a error in the Image! The new Version is this error corrected.

kristjanvall
10 months ago

When i go to localhost:8080/apex i resive i "Your login information will be sent securely." popup and i can not find what is the username and password for that.

steve1607
a year ago

Hi mritschel,
the pull command in your installation guide does not work. "docker pull mritschel/docker-oracle12c-apex5" should be right, shouldn't it?

Best,
Steven