{"id":4669,"date":"2020-03-15T16:54:46","date_gmt":"2020-03-15T15:54:46","guid":{"rendered":"https:\/\/www.dontesta.it\/?p=4669"},"modified":"2021-04-25T01:19:37","modified_gmt":"2021-04-24T23:19:37","slug":"how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment","status":"publish","type":"post","link":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/","title":{"rendered":"How to setup Docker container Oracle Database 19c for Liferay Development Environment"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">In the previous article <a href=\"https:\/\/www.dontesta.it\/2019\/08\/26\/how-to-setup-docker-container-oracle-database-12c-for-liferay-development-environment\/\">How to setup Docker container Oracle Database 12c for Liferay Development Environment<\/a> we saw how to create an <strong>Oracle 12c<\/strong> Docker container for our Liferay Development Environment. In this article we will see how to get an <strong>Oracle 19c<\/strong> Docker container that we could later use to host the Liferay database.<\/p>\n<p style=\"text-align: justify;\">The following documents (see database section) provide details of the configurations that are certified by Liferay (pay attention to support for Oracle 19c). You can see the complete documents on <a href=\"https:\/\/web.liferay.com\/it\/services\/support\/compatibility-matrix\" rel=\"nofollow\">Liferay Portal<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_4671\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/Liferay_72_Compatibility_Matrix_Database.png\"><img aria-describedby=\"caption-attachment-4671\" decoding=\"async\" loading=\"lazy\" class=\"size-large wp-image-4671\" src=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/Liferay_72_Compatibility_Matrix_Database-1024x464.png\" alt=\"Liferay 7.2 Compatibility Matrix Database Section\" width=\"1024\" height=\"464\" srcset=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/Liferay_72_Compatibility_Matrix_Database-1024x464.png 1024w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/Liferay_72_Compatibility_Matrix_Database-300x136.png 300w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/Liferay_72_Compatibility_Matrix_Database-768x348.png 768w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/Liferay_72_Compatibility_Matrix_Database-1536x695.png 1536w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/Liferay_72_Compatibility_Matrix_Database-2048x927.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><p id=\"caption-attachment-4671\" class=\"wp-caption-text\">Liferay 7.2 Compatibility Matrix Database Section<\/p><\/div>\n<p style=\"text-align: justify;\">I also recommend reading the article <a href=\"https:\/\/www.dontesta.it\/2019\/08\/21\/how-to-build-a-docker-liferay-7-2-image-with-the-oracle-database-support\/\">How to build a Docker Liferay 7.2 image with the Oracle Database support<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h2>1. What are the requirements<\/h2>\n<p style=\"text-align: justify;\">Before proceeding with the Docker container setup, let\u2019s see what the requirements are.<\/p>\n<ol>\n<li>You need to install or update Docker on your PC. Refer to this\u00a0<a href=\"https:\/\/docs.docker.com\/docker-for-windows\/\" target=\"_blank\" rel=\"noopener noreferrer\">article<\/a> for how to install Docker on Windows;<\/li>\n<li>You must have configured Docker with at least 2 CPUs;<\/li>\n<li>You must have configured Docker with at least 6GByte of the memory;<\/li>\n<li>You must have configured Docker with at least 15GByte of free storage for Docker.<\/li>\n<\/ol>\n<p>The docker versions on which I have successfully run the Oracle Docker container are: 17.x, 18.x and 19.x. The version of Docker Engine (Community Edition) that I will refer to in this article is\u00a0<strong>19.03.5<\/strong>\u00a0(you can check version with command\u00a0<code>docker version<\/code>).<\/p>\n<p>What is shown in this article can be performed on Windows, Unix-like operating systems. In my case I use macOS. However, always refer to the documentation of Docker and Oracle for what concerns the minimal requirements that the target system must have.<\/p>\n<p>&nbsp;<\/p>\n<h2>2. Oracle Database 19c Docker Image<\/h2>\n<p style=\"text-align: justify;\">For some years now, Oracle Database Enterprise Edition 12c is available as an image in Docker Store. Unfortunately Oracle 19c is not available on the Docker Store, but this is not a problem, <strong>you can build the Oracle 19c Docker image yourself<\/strong>.<\/p>\n<p style=\"text-align: justify;\">The GitHub <a href=\"https:\/\/github.com\/oracle\/docker-images\" target=\"_blank\" rel=\"noopener noreferrer\">oracle\/docker-images<\/a> repository contains everything needed to build Docker images of some of the Oracle products and in particular the <a href=\"https:\/\/github.com\/oracle\/docker-images\/tree\/master\/OracleDatabase\/SingleInstance\"><strong>Oracle Database<\/strong><\/a>. This project on GitHub offers sample <a href=\"https:\/\/docs.docker.com\/engine\/reference\/builder\/\" target=\"_blank\" rel=\"noopener noreferrer\">Dockerfiles<\/a> for:<\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/oracle\/docker-images\/tree\/master\/OracleDatabase\/SingleInstance\/dockerfiles\/19.3.0\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Oracle Database 19c (19.3.0) Enterprise Edition and Standard Edition 2<\/strong><\/a><\/li>\n<li>Oracle Database 18c (18.4.0) Express Edition (XE)<\/li>\n<li>Oracle Database 18c (18.3.0) Enterprise Edition and Standard Edition 2<\/li>\n<li>Oracle Database 12c Release 2 (12.2.0.2) Enterprise Edition and Standard Edition 2<\/li>\n<li>Oracle Database 12c Release 1 (12.1.0.2) Enterprise Edition and Standard Edition 2<\/li>\n<li>Oracle Database 11g Release 2 (11.2.0.2) Express Edition (XE)<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">The project <a href=\"https:\/\/github.com\/oracle\/docker-images\/blob\/master\/OracleDatabase\/SingleInstance\/README.md\" target=\"_blank\" rel=\"noopener noreferrer\">README<\/a> contains all the information necessary for building and running the Oracle Docker image. In case you would like to know more, I invite you to read the article <a href=\"https:\/\/www.oracle.com\/technetwork\/pt\/articles\/database-performance\/oracle-db19c-com-docker-5592460-ptb.html\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Database 19c com Docker<\/a> published by <a href=\"https:\/\/twitter.com\/alexzaballa\" target=\"_blank\" rel=\"noopener noreferrer\">Alex Zaballa<\/a> on the <a href=\"https:\/\/www.oracle.com\/technetwork\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Technology Network (OTN)<\/a> blog.<\/p>\n<div class='tm-tweet-clear'><\/div>\n<div class='tm-click-to-tweet'>\n<div class='tm-ctt-text'><a href='https:\/\/twitter.com\/share?text=Thanks+to+Alex+Zaballa+%40alexzaballa+for+his+article+where+he+shows+how+to+install+%23Docker+on+%23macOS+and+create+an+%23Oracle+Database+19c+Docker+Image+&via=antonio_musarra&related=antonio_musarra&url=https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/' target='_blank'>Thanks to Alex Zaballa @alexzaballa for his article where he shows how to install #Docker on #macOS and create an #Oracle Database 19c Docker Image <\/a><\/div>\n<p><a href='https:\/\/twitter.com\/share?text=Thanks+to+Alex+Zaballa+%40alexzaballa+for+his+article+where+he+shows+how+to+install+%23Docker+on+%23macOS+and+create+an+%23Oracle+Database+19c+Docker+Image+&via=antonio_musarra&related=antonio_musarra&url=https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/' target='_blank' class='tm-ctt-btn'>Click To Tweet<\/a><\/p>\n<div class='tm-ctt-tip'><\/div>\n<\/div>\n<p style=\"text-align: justify;\">Very well! Once we get our Oracle 19c Docker image, we can go on: running the Docker image and configuring for Liferay.<\/p>\n<div id=\"attachment_4676\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerImageOracle19c.png\"><img aria-describedby=\"caption-attachment-4676\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-4676 size-large\" title=\"Docker image built from the Oracle GitHub project.\" src=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerImageOracle19c-1024x90.png\" alt=\"Docker image built from the Oracle GitHub project.\" width=\"1024\" height=\"90\" srcset=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerImageOracle19c-1024x90.png 1024w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerImageOracle19c-300x26.png 300w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerImageOracle19c-768x67.png 768w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerImageOracle19c-1536x135.png 1536w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerImageOracle19c-2048x180.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><p id=\"caption-attachment-4676\" class=\"wp-caption-text\">Docker image built from the Oracle GitHub project.<\/p><\/div>\n<h2><\/h2>\n<h2>3. How to starting an Oracle Database Server instance<\/h2>\n<p style=\"text-align: justify;\">This Oracle database server image uses\u00a0<a href=\"https:\/\/docs.docker.com\/storage\/volumes\/\" target=\"_blank\" rel=\"noopener noreferrer\">Docker data volumes<\/a> to store data files, redo logs, audit logs, alert logs and trace files. The data volume is mounted inside the container at <strong>\/opt\/oracle\/oradata<\/strong>. To use a directory on the host system for the data volume and SQL Scripts, I created the <strong>~\/OracleData\/19c\/data<\/strong> and <strong>~\/OracleData\/19c\/scripts\/setup<\/strong>\u00a0directory.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"theme:solarized-dark lang:sh decode:true\" title=\"Console 1 - Start Oracle 19c Docker Container\">docker run -d -it --name oracledb-19c \\\r\n\t-p 1521:1521 \\\r\n\t-e ORACLE_SID=ORALFRDEV \\\r\n\t-e ORACLE_PDB=ORALFRDEVPDB \\\r\n\t-e ORACLE_PWD=LwB_27i5Wi8=1 \\\r\n\t-v \/Users\/antoniomusarra\/OracleData\/19c\/data:\/opt\/oracle\/oradata \\\r\n\t-v \/Users\/antoniomusarra\/OracleData\/19c\/scripts\/setup:\/opt\/oracle\/scripts\/setup \\\r\n\toracle\/database:19.3.0-ee<\/pre>\n<p>&nbsp;<\/p>\n<p>The\u00a0<em>docker run<\/em>\u00a0command starts the database with the following features:<\/p>\n<ol>\n<li>Assign the container the name\u00a0<strong>oracledb-19c<\/strong><\/li>\n<li>Exposes the TCP\/IP SQL Net port\u00a0<strong>1521<\/strong><\/li>\n<li>Through the environment variables\n<ol>\n<li>Set the SID to <strong>ORALFRDEV<\/strong><\/li>\n<li>Set the PDB to <strong>ORALFRDEVPDB<\/strong><\/li>\n<li>Set sysdba password to <strong>LwB_27i5Wi8=1<\/strong><\/li>\n<\/ol>\n<\/li>\n<li>Configure volume usage\n<ol>\n<li><strong>~\/OracleData\/19c\/data:\/opt\/oracle\/oradata<\/strong>: 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.<\/li>\n<li><strong>~\/OracleData\/19c\/scripts\/setup:\/opt\/oracle\/scripts\/setup<\/strong>: A volume with custom scripts to be run after database setup.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Obviously you can customize the values of the start parameters to your liking, these are the ones I usually use for my development environment.<\/p>\n<p style=\"text-align: justify;\">Inside the ~\/OracleData\/19c\/scripts\/setup directory are the SQL Scripts (that be run after database setup) needed to create <strong>tablespaces<\/strong>, <strong>user<\/strong> and <strong>grants<\/strong> for Liferay. Following the contents of the file <strong>01_liferay_tablespace.sql<\/strong>, <strong>02_liferay_user.sql<\/strong>, <strong>03_liferay_grant_user.sql<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"theme:solarized-dark lang:plsql decode:true\" title=\"Source Code 1 - Create tablespace for Liferay\">-- Change session to Pluggable DataBase (PDB)\r\nALTER SESSION SET container = ORALFRDEVPDB;\r\n\r\n-- Create tablespace for schema Liferay 7.2 GA2\r\nCREATE TABLESPACE liferay_dev_72_ga2_data logging DATAFILE\r\n'\/opt\/oracle\/oradata\/ORALFRDEV\/ORALFRDEVPDB\/liferay_dev_72_ga2_data.dbf' SIZE 64m\r\nautoextend ON NEXT 32m maxsize 4096m blocksize 8k EXTENT management local;\r\n\r\n--Create temp tablespace for Liferay 7.2 GA2\r\nCREATE TEMPORARY TABLESPACE liferay_dev_72_ga2_temp tempfile \r\n'\/opt\/oracle\/oradata\/ORALFRDEV\/ORALFRDEVPDB\/liferay_dev_72_ga2_temp.dbf' \r\nSIZE 64m autoextend ON NEXT 32m maxsize 2048m blocksize 8k \r\nEXTENT management local;<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"theme:solarized-dark lang:plsql decode:true \" title=\"Source Code 2 - Create the user liferay_dev\">-- Change session to Pluggable DataBase (PDB)\r\nALTER SESSION SET container = ORALFRDEVPDB;\r\n\r\n-- Create user for new schema Liferay Dev\r\nCREATE USER liferay_dev IDENTIFIED BY liferay_dev DEFAULT TABLESPACE\r\nliferay_dev_72_ga2_data TEMPORARY TABLESPACE liferay_dev_72_ga2_temp PROFILE\r\nDEFAULT account unlock;<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"theme:solarized-dark lang:plsql decode:true \" title=\"Source Code 3 - Assign the grants to liferay_dev user\">-- Change session to Pluggable DataBase (PDB)\r\nALTER SESSION SET container = ORALFRDEVPDB;\r\n\r\n-- Assign grant to Liferay User\r\nGRANT CONNECT TO liferay_dev;\r\nGRANT RESOURCE TO liferay_dev;\r\nGRANT UNLIMITED TABLESPACE TO liferay_dev;\r\n<\/pre>\n<p>In this case I created the tablespaces to host the schema for my <strong>Liferay Portal 7.2 CE GA2<\/strong> development environment. I invite you to read the article <a href=\"https:\/\/www.dontesta.it\/2020\/03\/08\/liferay-portal-7-2-ce-ga2-update-oracle-database-driver\/\">Liferay Portal 7.2 CE GA2: Update Oracle Database Driver<\/a>.<\/p>\n<p style=\"text-align: justify;\">You can monitor the start of the container by viewing the logs or using the docker command below.<\/p>\n<pre class=\"theme:solarized-dark lang:sh decode:true\" title=\"Console 1 - Docker ps command for checking status of the oracledb-19c container\">$ docker logs -f oracledb-19c\r\n$ docker ps --format 'table {{.Names}}\\t{{.Image}}\\t{{.Status}}\\t{{.Ports}}' -f name=oracledb-19c<\/pre>\n<p style=\"text-align: justify;\">The first start of the Oracle 19c container will take a few minutes because the whole database setup process must be performed. Here you could see the <a href=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/docker-container-oracledb19c-log.txt\">Docker Container Oracle Database 19c Log<\/a> of the first boot. The figure below shows the output of the docker ps command. You can see the status of the container indicating that it is ready (<strong>healthy<\/strong>) for use and port 1521 is exported.<\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_4680\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerContainerOracleStatus.png\"><img aria-describedby=\"caption-attachment-4680\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-4680 size-large\" title=\"Checking the Oracle Docker Container Status\" src=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerContainerOracleStatus-1024x86.png\" alt=\"Checking the Oracle Docker Container Status\" width=\"1024\" height=\"86\" srcset=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerContainerOracleStatus-1024x86.png 1024w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerContainerOracleStatus-300x25.png 300w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerContainerOracleStatus-768x64.png 768w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerContainerOracleStatus-1536x128.png 1536w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/DockerContainerOracleStatus-2048x171.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><p id=\"caption-attachment-4680\" class=\"wp-caption-text\">Checking the Oracle Docker Container Status<\/p><\/div>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">The following figure shows the execution of the SQL scripts after the Oracle database setup. These scripts will not be executed on subsequent container starts.<\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_4685\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript.png\"><img aria-describedby=\"caption-attachment-4685\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-4685 size-large\" title=\"Executing the SQL Scripts for Liferay\" src=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript-1024x1029.png\" alt=\"Executing the SQL Scripts for Liferay\" width=\"1024\" height=\"1029\" srcset=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript-1024x1029.png 1024w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript-300x301.png 300w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript-150x150.png 150w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript-768x772.png 768w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript-1529x1536.png 1529w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript-160x160.png 160w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript-65x65.png 65w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/ExecuteLiferaySQLScript.png 1680w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><p id=\"caption-attachment-4685\" class=\"wp-caption-text\">Executing the SQL Scripts for Liferay<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>Following is the structure of the OracleData directory after starting the Oracle container.<\/p>\n<pre class=\"theme:solarized-dark lang:sh decode:true\" title=\"Console 3 - Show the structure of the OracleData Volume\"> ~\/OracleData\/19c $ tree                                                                                                 \ue0b2 &#x2714; \ue0b2 16:29:29 \ue0b2 5.81G RAM \ue0b2 89% hdd  \ue0b2 3.31 L \ue0b2 100% &#x1f50b;\r\n.\r\n\u251c\u2500\u2500 data\r\n\u2502\u00a0\u00a0 \u251c\u2500\u2500 ORALFRDEV\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 ORALFRDEVPDB\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 liferay_dev_72_ga2_data.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 liferay_dev_72_ga2_temp.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 sysaux01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 system01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 temp01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 undotbs01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2514\u2500\u2500 users01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 control01.ctl\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 control02.ctl\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 pdbseed\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 sysaux01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 system01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 temp012020-03-15_14-15-40-714-PM.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2514\u2500\u2500 undotbs01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 redo01.log\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 redo02.log\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 redo03.log\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 sysaux01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 system01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 temp01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 undotbs01.dbf\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2514\u2500\u2500 users01.dbf\r\n\u2502\u00a0\u00a0 \u2514\u2500\u2500 dbconfig\r\n\u2502\u00a0\u00a0     \u2514\u2500\u2500 ORALFRDEV\r\n\u2502\u00a0\u00a0         \u251c\u2500\u2500 listener.ora\r\n\u2502\u00a0\u00a0         \u251c\u2500\u2500 orapwORALFRDEV\r\n\u2502\u00a0\u00a0         \u251c\u2500\u2500 oratab\r\n\u2502\u00a0\u00a0         \u251c\u2500\u2500 spfileORALFRDEV.ora\r\n\u2502\u00a0\u00a0         \u251c\u2500\u2500 sqlnet.ora\r\n\u2502\u00a0\u00a0         \u2514\u2500\u2500 tnsnames.ora\r\n\u2514\u2500\u2500 scripts\r\n    \u251c\u2500\u2500 setup\r\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 01_liferay_tablespace.sql\r\n    \u2502\u00a0\u00a0 \u251c\u2500\u2500 02_liferay_user.sql\r\n    \u2502\u00a0\u00a0 \u2514\u2500\u2500 03_liferay_grant_user.sql\r\n    \u2514\u2500\u2500 startup\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>At this point we have our Oracle Database 19c ready to host the Liferay Portal database.<\/p>\n<p>&nbsp;<\/p>\n<h2>4. Connection Test<\/h2>\n<p>At this point we are in a position to perform a connection test to the new scheme using a tool such as\u00a0<a href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/sql-developer.html\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle SQLDeveloper<\/a>. The following figures show the configuration of the database connection, the view of the Liferay tables and the status of the tablespaces created for Liferay.<\/p>\n<p>The parameters to connect to the new Liferay scheme are:<\/p>\n<ul>\n<li>Username\/password: liferay_dev\/liferay_dev<\/li>\n<li>Hostname: localhost<\/li>\n<li>Service Name: ORALFRDEVPDB<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"attachment_4687\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/SQLDeveloperSetupConnectionToLiferayDatabase.png\"><img aria-describedby=\"caption-attachment-4687\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-4687 size-large\" title=\"Configuring connection to the Oracle database via SQL Developer\" src=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/SQLDeveloperSetupConnectionToLiferayDatabase-1024x612.png\" alt=\"Configuring connection to the Oracle database via SQL Developer\" width=\"1024\" height=\"612\" srcset=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/SQLDeveloperSetupConnectionToLiferayDatabase-1024x612.png 1024w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/SQLDeveloperSetupConnectionToLiferayDatabase-300x179.png 300w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/SQLDeveloperSetupConnectionToLiferayDatabase-768x459.png 768w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/SQLDeveloperSetupConnectionToLiferayDatabase-1536x918.png 1536w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/SQLDeveloperSetupConnectionToLiferayDatabase.png 1576w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><p id=\"caption-attachment-4687\" class=\"wp-caption-text\">Configuring connection to the Oracle database via SQL Developer<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_4690\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/LiferaySchemaOnOracleDatabase19c-1.png\"><img aria-describedby=\"caption-attachment-4690\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-4690 size-large\" title=\"View Liferay Tables on Oracle Database 19c\" src=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/LiferaySchemaOnOracleDatabase19c-1-1024x242.png\" alt=\"View Liferay Tables on Oracle Database 19c\" width=\"1024\" height=\"242\" srcset=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/LiferaySchemaOnOracleDatabase19c-1-1024x242.png 1024w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/LiferaySchemaOnOracleDatabase19c-1-300x71.png 300w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/LiferaySchemaOnOracleDatabase19c-1-768x182.png 768w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/LiferaySchemaOnOracleDatabase19c-1-1536x364.png 1536w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/LiferaySchemaOnOracleDatabase19c-1-2048x485.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><p id=\"caption-attachment-4690\" class=\"wp-caption-text\">View Liferay Tables on Oracle Database 19c<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_4691\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/OracleLiferayTableSpace.png\"><img aria-describedby=\"caption-attachment-4691\" decoding=\"async\" loading=\"lazy\" class=\"wp-image-4691 size-large\" title=\"View of the Liferay Tablespace\" src=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/OracleLiferayTableSpace-1024x336.png\" alt=\"View of the Liferay Tablespace\" width=\"1024\" height=\"336\" srcset=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/OracleLiferayTableSpace-1024x336.png 1024w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/OracleLiferayTableSpace-300x99.png 300w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/OracleLiferayTableSpace-768x252.png 768w, https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/OracleLiferayTableSpace.png 1534w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><p id=\"caption-attachment-4691\" class=\"wp-caption-text\">View of the Liferay Tablespace<\/p><\/div>\n<p>&nbsp;<\/p>\n<h2>Conclusions<\/h2>\n<p style=\"text-align: justify;\">In this article I wanted to show you how I usually configure my development environment when I need to have an Oracle Database to be later connected to Liferay. As you have seen, using Docker makes this all very simple and fast. Other useful resources. Do not hesitate to contact me with any questions and I hope this article has been helpful.<\/p>\n<ol>\n<li><a href=\"https:\/\/www.dontesta.it\/en\/2019\/08\/21\/how-to-build-a-docker-liferay-7-2-image-with-the-oracle-database-support\/\" rel=\"nofollow\">How to build a Docker Liferay 7.2 image with the Oracle Database support<\/a><\/li>\n<li><a href=\"https:\/\/www.dontesta.it\/en\/2019\/10\/06\/how-to-build-a-docker-liferay-7-2-image-with-the-sql-server-2017-database-support\/\" rel=\"nofollow\">How to build a Docker Liferay 7.2 image with the SQL Server 2017 Database support<\/a><\/li>\n<li><a href=\"https:\/\/www.dontesta.it\/en\/2018\/10\/07\/liferay-7-1-how-to-add-support-for-oracle-db\/\" rel=\"nofollow\">Liferay 7.1: How to add support for Oracle DB<\/a><\/li>\n<li><a href=\"https:\/\/www.slideshare.net\/amusarra\/come-installare-liferay-7-su-jboss-eap-con-il-support-oracle-database\" rel=\"nofollow\">Come installare Liferay 7 su JBOSS EAP con il supporto Oracle Database<\/a><\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=7fojCjko7Ac\" rel=\"nofollow\">Liferay 7 Wildfly: How to add support for Oracle DB<\/a>\u00a0(video on Antonio Musarra's Blog YouTube Channel)<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=yLVCEl8L8cU\" rel=\"nofollow\">Liferay 7 Community Edition GA5 &amp; Oracle 12c via Docker Composer<\/a>\u00a0(video on Antonio Musarra's Blog YouTube Channel)<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=QaVaP89yWiM&amp;t=848s\" rel=\"nofollow\">Come installare Liferay 7 su JBoss EAP con il supporto per Oracle Database<\/a>\u00a0(video on Antonio Musarra's Blog YouTube Channel)<\/li>\n<\/ol>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>In the previous article How to setup Docker container Oracle Database 12c for Liferay Development Environment we saw how to create an Oracle 12c Docker container for our Liferay Development Environment. In this article&#46;&#46;&#46;<\/p>\n","protected":false},"author":3,"featured_media":4696,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[490,15,58,23],"tags":[671,637,660],"class_list":["post-4669","post","type-post","status-publish","format-image","has-post-thumbnail","hentry","category-blog-2","category-liferay","category-oracle","category-rdbms","tag-docker","tag-liferay","tag-oracle","post_format-post-format-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to setup Docker container Oracle Database 19c for Liferay Development Environment<\/title>\n<meta name=\"description\" content=\"In this article I will explain how to use Docker to setup the Oracle Database Enterprise Edition 19c container for use with Liferay. A few steps to get the result.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to setup Docker container Oracle Database 19c for Liferay Development Environment\" \/>\n<meta property=\"og:description\" content=\"In this article I will explain how to use Docker to setup the Oracle Database Enterprise Edition 19c container for use with Liferay. A few steps to get the result.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/\" \/>\n<meta property=\"og:site_name\" content=\"Antonio Musarra&#039;s Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/antoniomusarrablog\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/antoniomusarrablog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-15T15:54:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-24T23:19:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antonio Musarra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@antonio_musarra\" \/>\n<meta name=\"twitter:site\" content=\"@antonio_musarra\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antonio Musarra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/\"},\"author\":{\"name\":\"Antonio Musarra\",\"@id\":\"https:\/\/www.dontesta.it\/#\/schema\/person\/0c69ed36230e1477875d6171b48b9b24\"},\"headline\":\"How to setup Docker container Oracle Database 19c for Liferay Development Environment\",\"datePublished\":\"2020-03-15T15:54:46+00:00\",\"dateModified\":\"2021-04-24T23:19:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/\"},\"wordCount\":1258,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.dontesta.it\/#\/schema\/person\/0c69ed36230e1477875d6171b48b9b24\"},\"image\":{\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png\",\"keywords\":[\"Docker\",\"Liferay\",\"Oracle\"],\"articleSection\":[\"Blog\",\"Liferay\",\"Oracle\",\"RDBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/\",\"url\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/\",\"name\":\"How to setup Docker container Oracle Database 19c for Liferay Development Environment\",\"isPartOf\":{\"@id\":\"https:\/\/www.dontesta.it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png\",\"datePublished\":\"2020-03-15T15:54:46+00:00\",\"dateModified\":\"2021-04-24T23:19:37+00:00\",\"description\":\"In this article I will explain how to use Docker to setup the Oracle Database Enterprise Edition 19c container for use with Liferay. A few steps to get the result.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#primaryimage\",\"url\":\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png\",\"contentUrl\":\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png\",\"width\":1024,\"height\":512,\"caption\":\"How to setup Docker container Oracle Database 12c for Liferay Development Environment\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dontesta.it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to setup Docker container Oracle Database 19c for Liferay Development Environment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dontesta.it\/#website\",\"url\":\"https:\/\/www.dontesta.it\/\",\"name\":\"Antonio Musarra&#039;s Blog\",\"description\":\"The ideal solution for a problem\",\"publisher\":{\"@id\":\"https:\/\/www.dontesta.it\/#\/schema\/person\/0c69ed36230e1477875d6171b48b9b24\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dontesta.it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.dontesta.it\/#\/schema\/person\/0c69ed36230e1477875d6171b48b9b24\",\"name\":\"Antonio Musarra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dontesta.it\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2024\/06\/cropped-foto_profilo.png\",\"contentUrl\":\"https:\/\/www.dontesta.it\/wp-content\/uploads\/2024\/06\/cropped-foto_profilo.png\",\"width\":512,\"height\":512,\"caption\":\"Antonio Musarra\"},\"logo\":{\"@id\":\"https:\/\/www.dontesta.it\/#\/schema\/person\/image\/\"},\"description\":\"I began my journey into the world of computing from an Olivetti M24 PC (http:\/\/it.wikipedia.org\/wiki\/Olivetti_M24) bought by my father for his work. Day after day, quickly taking control until \u2026 Now doing business consulting for projects in the enterprise application development using web-oriented technologies such as J2EE, Web Services, ESB, TIBCO, PHP.\",\"sameAs\":[\"https:\/\/www.dontesta.it\",\"https:\/\/www.facebook.com\/antoniomusarrablog\",\"https:\/\/www.linkedin.com\/in\/amusarra\/\",\"https:\/\/x.com\/antonio_musarra\",\"https:\/\/www.youtube.com\/channel\/UC5D3_EtVPbZYUhrUcEK_THA\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to setup Docker container Oracle Database 19c for Liferay Development Environment","description":"In this article I will explain how to use Docker to setup the Oracle Database Enterprise Edition 19c container for use with Liferay. A few steps to get the result.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/","og_locale":"en_US","og_type":"article","og_title":"How to setup Docker container Oracle Database 19c for Liferay Development Environment","og_description":"In this article I will explain how to use Docker to setup the Oracle Database Enterprise Edition 19c container for use with Liferay. A few steps to get the result.","og_url":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/","og_site_name":"Antonio Musarra&#039;s Blog","article_publisher":"https:\/\/www.facebook.com\/antoniomusarrablog","article_author":"https:\/\/www.facebook.com\/antoniomusarrablog","article_published_time":"2020-03-15T15:54:46+00:00","article_modified_time":"2021-04-24T23:19:37+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png","type":"image\/png"}],"author":"Antonio Musarra","twitter_card":"summary_large_image","twitter_creator":"@antonio_musarra","twitter_site":"@antonio_musarra","twitter_misc":{"Written by":"Antonio Musarra","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#article","isPartOf":{"@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/"},"author":{"name":"Antonio Musarra","@id":"https:\/\/www.dontesta.it\/#\/schema\/person\/0c69ed36230e1477875d6171b48b9b24"},"headline":"How to setup Docker container Oracle Database 19c for Liferay Development Environment","datePublished":"2020-03-15T15:54:46+00:00","dateModified":"2021-04-24T23:19:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/"},"wordCount":1258,"commentCount":0,"publisher":{"@id":"https:\/\/www.dontesta.it\/#\/schema\/person\/0c69ed36230e1477875d6171b48b9b24"},"image":{"@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png","keywords":["Docker","Liferay","Oracle"],"articleSection":["Blog","Liferay","Oracle","RDBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/","url":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/","name":"How to setup Docker container Oracle Database 19c for Liferay Development Environment","isPartOf":{"@id":"https:\/\/www.dontesta.it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#primaryimage"},"image":{"@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png","datePublished":"2020-03-15T15:54:46+00:00","dateModified":"2021-04-24T23:19:37+00:00","description":"In this article I will explain how to use Docker to setup the Oracle Database Enterprise Edition 19c container for use with Liferay. A few steps to get the result.","breadcrumb":{"@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#primaryimage","url":"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png","contentUrl":"https:\/\/www.dontesta.it\/wp-content\/uploads\/2020\/03\/HowToSetupDockerContainerOracleDatabase19cLiferayDevelopmentEnvironment.png","width":1024,"height":512,"caption":"How to setup Docker container Oracle Database 12c for Liferay Development Environment"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dontesta.it\/en\/2020\/03\/15\/how-to-setup-docker-container-oracle-database-19c-for-liferay-development-environment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dontesta.it\/"},{"@type":"ListItem","position":2,"name":"How to setup Docker container Oracle Database 19c for Liferay Development Environment"}]},{"@type":"WebSite","@id":"https:\/\/www.dontesta.it\/#website","url":"https:\/\/www.dontesta.it\/","name":"Antonio Musarra&#039;s Blog","description":"The ideal solution for a problem","publisher":{"@id":"https:\/\/www.dontesta.it\/#\/schema\/person\/0c69ed36230e1477875d6171b48b9b24"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dontesta.it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dontesta.it\/#\/schema\/person\/0c69ed36230e1477875d6171b48b9b24","name":"Antonio Musarra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dontesta.it\/#\/schema\/person\/image\/","url":"https:\/\/www.dontesta.it\/wp-content\/uploads\/2024\/06\/cropped-foto_profilo.png","contentUrl":"https:\/\/www.dontesta.it\/wp-content\/uploads\/2024\/06\/cropped-foto_profilo.png","width":512,"height":512,"caption":"Antonio Musarra"},"logo":{"@id":"https:\/\/www.dontesta.it\/#\/schema\/person\/image\/"},"description":"I began my journey into the world of computing from an Olivetti M24 PC (http:\/\/it.wikipedia.org\/wiki\/Olivetti_M24) bought by my father for his work. Day after day, quickly taking control until \u2026 Now doing business consulting for projects in the enterprise application development using web-oriented technologies such as J2EE, Web Services, ESB, TIBCO, PHP.","sameAs":["https:\/\/www.dontesta.it","https:\/\/www.facebook.com\/antoniomusarrablog","https:\/\/www.linkedin.com\/in\/amusarra\/","https:\/\/x.com\/antonio_musarra","https:\/\/www.youtube.com\/channel\/UC5D3_EtVPbZYUhrUcEK_THA\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/posts\/4669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/comments?post=4669"}],"version-history":[{"count":0,"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/posts\/4669\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/media\/4696"}],"wp:attachment":[{"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/media?parent=4669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/categories?post=4669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dontesta.it\/en\/wp-json\/wp\/v2\/tags?post=4669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}