Sign inSign up

cuigm85/database

By cuigm85

•Updated over 1 year ago

Image
0

1.1K

cuigm85/database repository overview

⁠Quick Start

⁠Original Documentation

https://github.com/oracle/docker-images/tree/main/OracleDatabase/SingleInstance⁠

⁠Running Oracle Database Enterprise and Standard Edition 2 in a container
docker run --name <container name> \
-p <host port>:1521 -p <host port>:5500 -p <host port>:2484 \
--ulimit nofile=1024:65536 --ulimit nproc=2047:16384 --ulimit stack=10485760:33554432 --ulimit memlock=3221225472 \
-e ORACLE_SID=<your SID> \
-e ORACLE_PDB=<your PDB name> \
-e ORACLE_PWD=<your database passwords> \
-e INIT_SGA_SIZE=<your database SGA memory in MB> \
-e INIT_PGA_SIZE=<your database PGA memory in MB> \
-e INIT_CPU_COUNT=<cpu_count init-parameter> \
-e INIT_PROCESSES=<processes init-parameter> \
-e ORACLE_EDITION=<your database edition> \
-e ORACLE_CHARACTERSET=<your character set> \
-e ENABLE_ARCHIVELOG=true \
-e ENABLE_FORCE_LOGGING=true \
-e ENABLE_TCPS=true \
-v [<host mount point>:]/opt/oracle/oradata \
 cuigm85/database:19.3.0-ee
Parameters:
   --name:        The name of the container (default: auto generated).
   -p:            The port mapping of the host port to the container port.
                  The following ports are exposed: 1521 (Oracle Listener), 5500 (OEM Express), 2484 (TCPS Listener Port if TCPS is enabled).
   --ulimit:      Resource limits. Update according to Oracle Database documentation.
   -e ORACLE_SID: The Oracle Database SID that should be used (default for 23ai Free Edition: FREE; all others, ORCLCDB).
                  Note: The ORACLE_SID for 11g/18c Express and 23ai Free Editions cannot be changed.
   -e ORACLE_PDB: The Oracle Database PDB name that should be used (default for 23ai Free Edition: FREEPDB1; all others, ORCLPDB1).
                  Note: The ORACLE_PDB for 23ai Free Edition cannot be changed.
   -e ORACLE_PWD: The Oracle Database SYS, SYSTEM and PDBADMIN password (default: auto generated).
   -e INIT_SGA_SIZE:
                  The total memory in MB that should be used for all SGA components (optional).
                  Supported by Oracle Database 19.3 onwards.
   -e INIT_PGA_SIZE:
                  The target aggregate PGA memory in MB that should be used for all server processes attached to the instance (optional).
                  Supported by Oracle Database 19.3 onwards.
   -e INIT_CPU_COUNT:
                  Specifies the number of CPUs available for Oracle Database to use. 
                  On CPUs with multiple CPU threads, it specifies the total number of available CPU threads (optional).
   -e INIT_PROCESSES:
                  Specifies the maximum number of operating system user processes that can simultaneously connect to Oracle Database. 
                  Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes (optional).
   -e AUTO_MEM_CALCULATION:
                  To enable auto calculation of the DBCA total memory limit during the database creation, based on
                  the available memory of the container, which can be constrained using the `docker run --memory`
                  option. If set to 'false', the total memory will be set as 2GB (default: true).
                  Note that this parameter is not taken into account if the `-e INIT_SGA_SIZE` or `-e INIT_PGA_SIZE`
                  are set.
                  Supported by Oracle Database 19.3 onwards.
   -e ORACLE_EDITION:
                  The Oracle Database Edition (enterprise/standard).
                  Supported by Oracle Database 19.3 onwards.
   -e ORACLE_CHARACTERSET:
                  The character set to use when creating the database (default: AL32UTF8).
   -e ENABLE_ARCHIVELOG:
                  To enable archive log mode when creating the database (default: false).
                  Supported by Oracle Database 19.3 onwards.
   -e ENABLE_FORCE_LOGGING:
                  To enable force logging mode when creating the database (default: false).
                  Supported by Oracle Database 23ai onwards.
   -e ENABLE_TCPS:
                  To enable TCPS connections for Oracle Database.
                  Supported by Oracle Database 19.3 onwards.
   -e TCPS_CERTS_LOCATION:
                  Location of user provided SSL certificates for TCPS connection
                  Supported by Oracle Database 19.3 onwards.
   -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.
⁠Running Oracle Database 11gR2 Express Edition in a container
docker run --name <container name> \
--shm-size=1g \
-p 1521:1521 -p 8080:8080 \
-e ORACLE_PWD=<your database passwords> \
-v [<host mount point>:]/u01/app/oracle/oradata \
cuigm85/database:11.2.0.2-xe
Parameters:
   --name:        The name of the container (default: auto generated)
   --shm-size:    Amount of Linux shared memory
   -p:            The port mapping of the host port to the container port.
                  Two ports are exposed: 1521 (Oracle Listener), 8080 (APEX)
   -e ORACLE_PWD: The Oracle Database SYS, SYSTEM and PDBADMIN password (default: auto generated)

   -v /u01/app/oracle/oradata
                  The data volume to use for the database.
                  Has to be writable by the Unix "oracle" (uid: 1000) user inside the container!
                  If omitted the database will not be persisted over container recreation.
   -v /u01/app/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 /u01/app/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.

Tag summary

Content type

Image

Digest

sha256:d10771f77…

Size

694.6 MB

Last updated

over 1 year ago

docker pull cuigm85/database