albmtez/oracle-xe-11g Docker 镜像 - 轩辕镜像 | Docker 镜像高效稳定拉取服务

Oracle Express Edition 11g

Oracle XE 11g image build based on Oracle Database official images.

[***]

Build image and run container

Oracle XE 11g installer file is splitted in directory orainstaller. Before building the image you must recompose the file:

./generateInstaller.sh

You can now build the image executing the following command:

docker build -t oracle-xe-11g .

To run a contanier:

docker run -d --name oracle-xe --shm-size=1g -p 1521:1521 -p 8080:8080 -e ORACLE_PWD=oracle oracle-xe-11g

This command will create a container running Oracle Express Edition 11g. You can customize the parameters:

• name: The name of the container.
• shm-size: Size of the shared memory. Oracle XE requires a minimum of 1GB shared memory.
• Port mapping:
  • 1521: Listener port.
  • 8080: Oracle Application Express web management console port.
• Environment variables:
  • ORACLE_PWD: sys and system users' password. If not specified, a random password will be generated. The password used is shown in Docker run logs, you can inspect by executing docker logs oralce-xe.
  • SCHEMAS: Schemas to be created when creating the container.

Run container from Docker Hub

docker run -d --name oracle-xe --shm-size=1g -p 1521:1521 -p 8080:8080 -e ORACLE_PWD=oracle albmtez/oracle-xe-11g

Schemas creation

Custom database schemas can be created on database initialization by specifying the names in the environment variable SCHEMAS. If no name is specified or the environment variable is not set, no schema will be created.

Example:

docker run -d --name oracle-xe --shm-size=1g -p 1521:1521 -p 8080:8080 -e ORACLE_PWD=oracle -SCHEMAS="EYSD KUSU KFUL" oracle-xe-11g

This command will create 3 database schemas with names EYSD, KUSU and KFUL, using as default tablespace USERS and as temporary space TEMP. The password is set using the name of the schema.

You can customize these values and the grants editing the file template.schema.sql.

Data persisted on container recreation

In order to have your database files persisted, you can mount the container volume /u01/app/oracle/oradata in a host directory.

docker run -d --name oracle-xe --shm-size=1g -p 1521:1521 -p 8080:8080 -v[<host mount point>:]/u01/app/oracle/oradata -e ORACLE_PWD=oracle oracle-xe-11g

Custom scripts execution

It's possible to execute custom scripts (shellscript and/or sql files) on database startup. The files to be executed must be stored in a directory in the host and map this directory to the volume /u01/app/oracle/scripts/startup in the container.

docker run -d --name oracle-xe --shm-size=1g -p 1521:1521 -p 8080:8080 -v /Users/alberto.martinez/data/scripts:/u01/app/oracle/scripts/startup -e ORACLE_PWD=oracle oracle-xe-11g

Database management

You can connect to the Oracle Application Express web management console with the following settings:

url: http://localhost:8080/apex
workspace: INTERNAL
user: ADMIN
password: <ORACLE_PWD>

Using sqlplus:

docker exec -it oracle-xe sqlplus sys/<ORACLE_PWD>@localhost:1521/XE as sysdba
docker exec -it oracle-xe sqlplus system/<ORACLE_PWD>@localhost:1521/XE as sysdba
docker exec -it oracle-xe sqlplus pdbadmin/<ORACLE_PWD>@localhost:1521/XEPDB1 as sysdba