Share
Embed
Run Oracle Databases in Containers
Seán Scott PRO
March 12, 2024
Transcript
49 slides
-
Run Oracle Database in Containers Sean Scott Oracle ACE Director
Managing Principal Consultant @oraclesean linkedin.com/in/soscott/ [email protected] @ViscosityNA www.viscosityna.com -
DATABASE RELIABILITY ENGINEERING ⁘ DEVOPS & AUTOMATION HIGH AVAILABILITY ⁘
BUSINESS CONTINUITY ⁘ DISASTER RECOVERY MODERNIZATION ⁘ OBSERVABILITY ⁘ ENGINEERED SYSTEMS AutoUpgrade ⁘ Zero Downtime Migrations ⁘ Patching Real Application Clusters ⁘ Data Guard ⁘ Sharding Docker/Containers ⁘ Terraform ⁘ Ansible Exadata ⁘ Oracle Database Appliance AHF ⁘ TFA ⁘ GIMR ⁘ CHA Sean Scott Oracle ACE Director Managing Principal Consultant @oraclesean linkedin.com/in/soscott/ [email protected] @ViscosityNA www.viscosityna.com -
@ViscosityNA www.viscosityna.com Oracle on Docker Running Oracle Databases in Linux
Containers Download a free sample chapter: https:/ /oraclesean.com -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Images are Infrastructure as Code •
Manage through Version Control • Reliable and repeatable Images are Artifacts • Portable • Distributable -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Images built on <MY OS> work
on: • Windows • Mac • Linux • Docker • Podman • Compose • Kubernetes • OCI • Azure • AWS • GCP -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Eliminate dependencies Develop SQL, PL/SQL, scripts
Hack, experiment, learn Performance tuning Test without infrastructure Validate patches, upgrades Build labs, training environments Run Oracle on Docker to… -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Vanilla databases Multitenant/Legacy Data Guard Far
Sync Real Application Clusters Sharding …and much, much more! What’s possible? -
@ViscosityNA www.viscosityna.com Chose a version and architecture # 23c Always
Free (Windows, Intel Mac/Linux): IMAGE_NAME=container-registry.oracle.com/database/free:latest # 19c on Intel (Windows, Intel Mac/Linux): IMAGE_NAME=container-registry.oracle.com/database/enterprise:19.3.0.0 docker login container-registry.oracle.com # 19c on ARM (M1/M2 Mac, Linux on ARM): IMAGE_NAME=container-registry.oracle.com/database/enterprise:19.19.0.0 docker login container-registry.oracle.com -
@ViscosityNA www.viscosityna.com Run a "quick and dirty" database docker run
-d \ --name my_db \ ${IMAGE_NAME} docker logs -f my_db -
@ViscosityNA www.viscosityna.com Set up the environment (Windows/Linux) # Add the
oinstall group and oracle user: sudo groupadd -g 54321 oinstall sudo useradd -u 54321 -g oinstall oracle # Add the current user to the oinstall group: sudo usermod -a -G oinstall $USER -
@ViscosityNA www.viscosityna.com Create a database directory # Set the base
database directory path (Windows/Linux): ORADATA=/oradata sudo mkdir -p ${ORADATA} sudo chown -R oracle:oinstall ${ORADATA} sudo chmod 775 ${ORADATA} # Set the base database directory path (Mac): ORADATA=~/oradata mkdir -p ${ORADATA} -
@ViscosityNA www.viscosityna.com Create an NFS-like scripts directory # Set the
base database directory path (Windows/Linux): sudo mkdir -p ${ORADATA}/scripts sudo chown -R oracle:oinstall ${ORADATA}/scripts # Set the base database directory path (Mac): mkdir -p ${ORADATA}/scripts -
@ViscosityNA www.viscosityna.com Set variables # Set the container name: CONTAINER_NAME=ORCL
# Set the database SID and PDB name (not needed for 23c): ORACLE_SID=ORCL ORACLE_PDB=ORCLPDB -
@ViscosityNA www.viscosityna.com Create directories (Windows/Linux) # Create directories for audit,
data, and diagnostics: for dir in audit data diag do sudo mkdir -p ${ORADATA}/${CONTAINER_NAME}/${dir} sudo chown -R oracle:oinstall ${ORADATA}/${CONTAINER_NAME}/${dir} # Clean up existing files: sudo rm -fr ${ORADATA}/${CONTAINER_NAME}/${dir}/* # Create Docker-managed volumes docker volume rm ${CONTAINER_NAME}_${dir} 2>/dev/null docker volume create --opt type=none --opt o=bind \ --opt device=${ORADATA}/${CONTAINER_NAME}/${dir} \ ${CONTAINER_NAME}_${dir} done -
@ViscosityNA www.viscosityna.com Create directories (Mac) # Create directories for audit,
data, and diagnostics: for dir in audit data diag do mkdir -p ${ORADATA}/${CONTAINER_NAME}/${dir} # Clean up existing files: rm -fr ${ORADATA}/${CONTAINER_NAME}/${dir}/* # Create Docker-managed volumes docker volume rm ${CONTAINER_NAME}_${dir} 2>/dev/null docker volume create --opt type=none --opt o=bind \ --opt device=${ORADATA}/${CONTAINER_NAME}/${dir} \ ${CONTAINER_NAME}_${dir} done -
@ViscosityNA www.viscosityna.com Run a "quick and dirty" database docker run
-d \ --name my_db \ ${IMAGE_NAME} docker logs -f my_db -
@ViscosityNA www.viscosityna.com A useful docker run command for an Oracle
DB docker rm -f ${CONTAINER_NAME} 2>/dev/null docker run -d \ --name ${CONTAINER_NAME} \ --volume ${CONTAINER_NAME}_data:/opt/oracle/oradata \ --volume ${CONTAINER_NAME}_diag:/opt/oracle/diag \ --volume ${CONTAINER_NAME}_audit:/opt/oracle/admin \ --volume ${ORADATA}/scripts:/scripts \ -e ORACLE_SID=${ORACLE_SID} \ -e ORACLE_PDB=${ORACLE_PDB} \ -p 1521:1521 \ ${IMAGE_NAME} docker logs -f ${CONTAINER_NAME} -
@ViscosityNA www.viscosityna.com A useful docker run command for 23c Free
Edition docker rm -f ${CONTAINER_NAME} 2>/dev/null docker run -d \ --name ${CONTAINER_NAME} \ --volume ${CONTAINER_NAME}_data:/opt/oracle/oradata \ --volume ${CONTAINER_NAME}_diag:/opt/oracle/diag \ --volume ${CONTAINER_NAME}_audit:/opt/oracle/admin \ --volume ${ORADATA}/scripts:/scripts \ -p 1521:1521 \ ${IMAGE_NAME} docker logs -f ${CONTAINER_NAME} -
@ViscosityNA www.viscosityna.com Customize Database Creation docker run ... \ -e
ORACLE_PWD=<password> -e ORACLE_SID=<sid> -e ORACLE_PDB=<pdbname> -e ORACLE_CHARACTERSET=<characterset> -tz=<timezone> -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Connect to Docker from SQL Developer
Host IP Address Mapped Port ORACLE_SID localhost 51521 o193 -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA ├── ORCLCDB │ ├── ORCLPDB1 │
│ ├── … │ ├── control01.ctl │ ├── pdbseed │ │ ├── … │ ├── redo01.log │ ├── redo02.log │ ├── redo03.log │ ├── sysaux01.dbf │ ├── system01.dbf │ ├── temp01.dbf │ ├── undotbs01.dbf │ └── users01.dbf └── dbconfig └── ORCLCDB ├── listener.ora ├── orapwORCLCDB ├── oratab ├── spfileORCLCDB.ora ├── sqlnet.ora └── tnsnames.ora -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA ├── ORCLCDB │ ├── ORCLPDB1 │
│ ├── … │ ├── control01.ctl │ ├── pdbseed │ │ ├── … │ ├── redo01.log │ ├── redo02.log │ ├── redo03.log │ ├── sysaux01.dbf │ ├── system01.dbf │ ├── temp01.dbf │ ├── undotbs01.dbf │ └── users01.dbf └── dbconfig └── ORCLCDB ├── listener.ora ├── orapwORCLCDB ├── oratab ├── spfileORCLCDB.ora ├── sqlnet.ora └── tnsnames.ora -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Mapping the Data Volume docker run
-d ... \ --volume ${CONTAINER_NAME}_data:/opt/oracle/oradata \ --volume ${CONTAINER_NAME}_diag:/opt/oracle/diag \ --volume ${CONTAINER_NAME}_audit:/opt/oracle/admin \ ... ${IMAGE_NAME} Database files are in the ${CONTAINER_NAME}_data volume directory; diagnostic files are in the ${CONTAINER_NAME}_diag volume directory; and audit files are in the ${CONTAINER_NAME}_audit volume directory. -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Mapping the Data Volume ${CONTAINER_NAME}_data =
${ORADATA}/${CONTAINER_NAME}data -
@ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Which means... The entire database is
saved under: ${ORADATA}/${CONTAINER_NAME}/data Incuding: • Data files • Temp files • Redo logs • Archive logs • TNS configurations • Wallets • /etc/oratab • pfile/spfile -
@ViscosityNA www.viscosityna.com Instant database! # Set the source/new container names:
SOURCE_CONTAINER=${CONTAINER_NAME} CONTAINER_NAME=CLONE -
@ViscosityNA www.viscosityna.com Create directories (Windows/Linux) # Create directories for audit,
data, and diagnostics: for dir in audit data diag do sudo mkdir -p ${ORADATA}/${CONTAINER_NAME}/${dir} sudo chown -R oracle:oinstall ${ORADATA}/${CONTAINER_NAME}/${dir} # Clean up existing files: sudo rm -fr ${ORADATA}/${CONTAINER_NAME}/${dir}/* # Create Docker-managed volumes docker volume rm ${CONTAINER_NAME}_${dir} 2>/dev/null docker volume create --opt type=none --opt o=bind \ --opt device=${ORADATA}/${CONTAINER_NAME}/${dir} \ ${CONTAINER_NAME}_${dir} done -
@ViscosityNA www.viscosityna.com Create directories (Mac) # Create directories for audit,
data, and diagnostics: for dir in audit data diag do mkdir -p ${ORADATA}/${CONTAINER_NAME}/${dir} # Clean up existing files: rm -fr ${ORADATA}/${CONTAINER_NAME}/${dir}/* # Create Docker-managed volumes docker volume rm ${CONTAINER_NAME}_${dir} 2>/dev/null docker volume create --opt type=none --opt o=bind \ --opt device=${ORADATA}/${CONTAINER_NAME}/${dir} \ ${CONTAINER_NAME}_${dir} done -
@ViscosityNA www.viscosityna.com Copy the [g]old data from source to target
# (Windows/Linux): sudo cp -rp ${ORADATA}/${SOURCE_CONTAINER}/data/* ${ORADATA}/${CONTAINER_NAME}/data/ # (Mac): cp -rp ${ORADATA}/${SOURCE_CONTAINER}/data/* ${ORADATA}/${CONTAINER_NAME}/data/ -
@ViscosityNA www.viscosityna.com Instant database! docker rm -f ${CONTAINER_NAME} 2>/dev/null docker
run -d \ --name ${CONTAINER_NAME} \ --volume ${CONTAINER_NAME}_data:/opt/oracle/oradata \ --volume ${CONTAINER_NAME}_diag:/opt/oracle/diag \ --volume ${CONTAINER_NAME}_audit:/opt/oracle/admin \ --volume ${ORADATA}/scripts:/scripts \ -e ORACLE_SID=${ORACLE_SID} \ -e ORACLE_PDB=${ORACLE_PDB} \ -p 1522:1521 \ ${IMAGE_NAME} docker logs -f $CONTAINER_NAME -
@ViscosityNA www.viscosityna.com Resources • Download Docker Desktop: https:/ /www.docker.com/products/docker-desktop/ •
Oracle Container Registry: https:/ /container-registry.oracle.com • Oracle Docker Repository: https:/ /github.com/oracle/docker-images • Sean's Cloud Native Oracle Database Repository: https:/ /github.com/oraclesean/cloud-native-oracle -
@ViscosityNA www.viscosityna.com D @oraclesean e oraclesean.com C https://www.linkedin.com/in/soscott/ ) https://github.com/oraclesean
k [email protected] P https://youtube.com/@oracle_sean