Skip to content

Quick and easy docker-compose based setup of Oracle DB, including restoring the database from a dump

Notifications You must be signed in to change notification settings

mpern/oracle-docker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Oracle Docker (Compose) Template

A quick and easy way to restore an Oracle DB dump for local development

Prerequisites

You need to build official Oracle docker image for Oracle DB 12.1.0.2 for this setup, if you haven't done so already.

  1. Clone the official oracle/docker-images repository

  2. Download required files into OracleDatabase/SingleInstance/dockerfiles/12.1.0.2

    1. Go to the Oracle Database 12c Release 1 (12.1.0.2.0) for Linux download page
    2. Download linuxamd64_12c_database_1of2.zip
    3. Download linuxamd64_12c_database_2of2.zip
  3. Build the 12.1.02 Enterprise Edition image

    cd OracleDatabase/SingleInstance/dockerfiles
    ./buildDockerImage.sh -v 12.1.0.2 -e

Docker for Mac / Docker for Windows
Make sure to increase the RAM (at least 8GB) and (if necessary) the disk size of the Docker VM!

How to use

  1. Download this repo as zip

  2. Unpack

  3. Rename the unpacked folder to something more meaningful, e.g. project_db

  4. Place your Oracle expdp dump file in ./dump.
    The file must be named dump.dmp.

  5. Tweak docker-compose.yml

    • make sure that SOURCE_SCHEMA and SOURCE_TABLESPACE match the schema and tablespace of the dump
    • you may want to additionally exclude GRANT: EXCLUDE=USER,GRANT, if your dump contains them

    (If you don't know, ask the DBA that created the dump. Or try to import and check the errors in ./dump/import.log)

  6. (optional) Add additional setup files to setup-scripts (initial setup supports*.sql or *.sh files, they are executed in order)

  7. cd project_db
    docker-compose up
    
  8. Grab a pint of ☕ and wait until the database setup including dump import is done.

The password for all Oracle system accounts (SYSTEM, SYS, PDBADMIN) is oracle

The db.* properties for SAP Commerce are:

db.url=jdbc:oracle:thin:@localhost:1521/ORCLPDB1
db.driver=oracle.jdbc.driver.OracleDriver
db.username=localdev
db.password=localdev

Don't forget to place the ojdbc*.jar (Download here) in hybris/bin/platform/lib/dbdriver!

About

Quick and easy docker-compose based setup of Oracle DB, including restoring the database from a dump

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages