Posts

Implement Oracle TDE and TNS TLS in Oracle 19c running in a Docker Container

Image
  In this article, I share with you implement Oracle TDE and TNS SSL in an Oracle 19.9.0.0 database running as a Docker Container. You can view the accompanying the video at https://youtu.be/RR0rG0QOkgI. I have a Docker network oracledb that I use for the Oracle Database.  [oracle@dockerhost dockerOracle19c]$ cat createNetwork.sh docker network create \   --driver=bridge \   --subnet=172.19.0.0/16 \   --ip-range=172.19.5.0/24 \   --gateway=172.19.5.254 \   oracledb Here is the startup script for the Oracle container. [oracle@dockerhost dockerOracle19c]$ cat startOracleKind.sh docker stop oracle19c docker run -dt --network=oracledb --name oracle19c --hostname dockerdb --user oracle --ip 172.19.5.10 \ -p 192.168.1.45:1521:1521 -p 192.168.1.45:5500:5500 \ -e ORACLE_SID=KIND \ -e ORACLE_PDB=KINDPDB \ -v /oradrive/oradata/KIND/network/admin:/opt/oracle/product/19c/dbhome_1/network/admin \ -v /oradrive/oradata/KIND/dbs:/opt/oracle/product/19c/dbhome_1/...

Oracle 19c in Docker

Image
 You can download all the files I have used from the following locations: https://github.com/tenzin-ravi/docker-applied. The goals: Part I Install and Patch Oracle 19c Enterprise Edition in Docker With Oracle's Approach  With RPMs Part II Create a script to start Oracle 19c in Docker Part III Create Transparently Data Encryption(TDE) for TNS as well as Database Files Create Pluggable Databases in Oracle 19c in Docker Create encrypted tablespaces in Oracle 19c Pluggable Database  Part I - Install and Patch Oracle 19c Enterprise Edition in Docker 1. With Oracle's Docker Files. A.  Build the Docker image for Oracle 19.3.0.0 [oracle@dockerhost withoutrpms]$ pwd /opt/dockerOracle19c/withoutrpms [oracle@dockerhost withoutrpms]$ ./buildDockerImage.sh -v 19.3.0 -e Checking Docker version. Checking if required packages are present and valid... Oracle Image: oracle/database:19.3.0-ee-original   B.  Apply 19.9.0.0 patch [oracle@dockerhost applypatch]$ pwd /o...