Run Oracle Databases in Containers

Transcript

1. Run Oracle Database in Containers Sean Scott Oracle ACE Director Managing Principal Consultant @oraclesean linkedin.com/in/soscott/ sean.scott@viscosityna.com @ViscosityNA www.viscosityna.com
2. 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/ sean.scott@viscosityna.com @ViscosityNA www.viscosityna.com
3. @ViscosityNA www.viscosityna.com Oracle on Docker Running Oracle Databases in Linux Containers Download a free sample chapter: https:/ /oraclesean.com
4. @ViscosityNA www.viscosityna.com @ViscosityNA www.viscosityna.com Run Oracle in Containers?
5. @ViscosityNA www.viscosityna.com “Don’t use Docker for Databases!”
6. @ViscosityNA www.viscosityna.com "Containers are for developers, not production!"
7. @ViscosityNA www.viscosityna.com "Containers can't/shouldn't support complex applications like Oracle!"
8. @ViscosityNA www.viscosityna.com
9. @ViscosityNA www.viscosityna.com @ViscosityNA www.viscosityna.com Why?
10. @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
11. @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
12. @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…
13. @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?
14. @ViscosityNA www.viscosityna.com Containers are Fast
15. @ViscosityNA www.viscosityna.com @ViscosityNA www.viscosityna.com Run Oracle on Docker
17. @ViscosityNA www.viscosityna.com @ViscosityNA www.viscosityna.com Get Docker Desktop
18. @ViscosityNA www.viscosityna.com @ViscosityNA www.viscosityna.com Get a Database Image
19. @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
20. @ViscosityNA www.viscosityna.com Pull the container image docker pull ${IMAGE_NAME} docker images
21. @ViscosityNA www.viscosityna.com Run a "quick and dirty" database docker run -d \ --name my_db \ ${IMAGE_NAME} docker logs -f my_db
22. @ViscosityNA www.viscosityna.com @ViscosityNA www.viscosityna.com Prepare the Environment
23. @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
24. @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}
25. @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
26. @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
27. @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
28. @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
29. @ViscosityNA www.viscosityna.com @ViscosityNA www.viscosityna.com Run a Container
30. @ViscosityNA www.viscosityna.com Run a "quick and dirty" database docker run -d \ --name my_db \ ${IMAGE_NAME} docker logs -f my_db
31. @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}
32. @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}
33. @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>
34. @ViscosityNA www.viscosityna.com “Login” to the Container docker exec -it ${CONTAINER_NAME} bash
35. @ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Connect to Docker from SQL Developer Host IP Address Mapped Port ORACLE_SID localhost 51521 o193
36. @ViscosityNA www.viscosityna.com Containers are Fast
37. @ViscosityNA www.viscosityna.com @ViscosityNA www.viscosityna.com The oradata Volume
38. @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
39. @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
40. @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.
41. @ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA Mapping the Data Volume ${CONTAINER_NAME}_data = ${ORADATA}/${CONTAINER_NAME}data
42. @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
43. @ViscosityNA www.viscosityna.com Instant database! # Set the source/new container names: SOURCE_CONTAINER=${CONTAINER_NAME} CONTAINER_NAME=CLONE
44. @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
45. @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
46. @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/
47. @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
48. @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
49. @ViscosityNA www.viscosityna.com D @oraclesean e oraclesean.com C https://www.linkedin.com/in/soscott/ ) https://github.com/oraclesean k sean.scott@viscosityna.com P https://youtube.com/@oracle_sean