Sign inSign up

limslee/oracle-database-xe

By limslee

•Updated over 4 years ago

Oracle Database Express Edition Docker Image

Image
Databases & storage
0

433

limslee/oracle-database-xe repository overview

⁠Build parameters
./buildContainerImage.sh -v 21.3.0 -x -t limslee/oracle-database-xe:21.3.0
./buildContainerImage.sh -v 18.4.0 -x -t limslee/oracle-database-xe:18.4.0

For more information about Oracle Database container please visit https://github.com/oracle/docker-images/tree/main/OracleDatabase/SingleInstance⁠


⁠Running Oracle Database 21c/18c Express Edition in a container

To run your Oracle Database 21c, or 18c Express Edition container image use the docker run command as follows:

docker run --name <container name> \
-p <host port>:1521 -p <host port>:5500 \
-e ORACLE_PWD=<your database passwords> \
-e ORACLE_CHARACTERSET=<your character set> \
-v [<host mount point>:]/opt/oracle/oradata \
limslee/oracle-database-xe[:<version 21.3.0 or 18.4.0>]

Parameters:
   --name:        The name of the container (default: auto generated)
   -p:            The port mapping of the host port to the container port.
                  Two ports are exposed: 1521 (Oracle Listener), 5500 (EM Express)
   -e ORACLE_PWD: The Oracle Database SYS, SYSTEM and PDB_ADMIN password (default: auto generated)
   -e ORACLE_CHARACTERSET:
                  The character set to use when creating the database (default: AL32UTF8)
   -v /opt/oracle/oradata
                  The data volume to use for the database.
                  Has to be writable by the Unix "oracle" (uid: 54321) user inside the container!
                  If omitted the database will not be persisted over container recreation.
   -v /opt/oracle/scripts/startup | /docker-entrypoint-initdb.d/startup
                  Optional: A volume with custom scripts to be run after database startup.
                  For further details see the "Running scripts after setup and on startup" section below.
   -v /opt/oracle/scripts/setup | /docker-entrypoint-initdb.d/setup
                  Optional: A volume with custom scripts to be run after database setup.
                  For further details see the "Running scripts after setup and on startup" section below.

Once the container has been started and the database created you can connect to it just like to any other database:

sqlplus sys/<your password>@//localhost:1521/XE as sysdba
sqlplus system/<your password>@//localhost:1521/XE
sqlplus pdbadmin/<your password>@//localhost:1521/XEPDB1

The Oracle Database inside the container also has Oracle Enterprise Manager Express configured. To access OEM Express, start your browser and follow the URL:

https://localhost:5500/em/

On the first startup of the container a random password will be generated for the database if not provided. The password for those accounts can be changed via the docker exec command. Note, the container has to be running:

docker exec <container name> /opt/oracle/setPassword.sh <your password>

Important Note: The ORACLE_SID for Express Edition is always XE and cannot be changed, hence there is no ORACLE_SID parameter provided for the XE build.

Tag summary

Content type

Image

Digest

Size

2.7 GB

Last updated

over 4 years ago

docker pull limslee/oracle-database-xe