X

Deploy Oracle Application Express on Database Instances with Terraform

Ranganath Srirangapatna Ramachandra
Senior Product Manager

Today, we are announcing the launch of a Terraform script for deploying Oracle Application Express (APEX) on Oracle Cloud Infrastructure Database. Oracle APEX is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. By using only a web browser and limited programming experience, you can use Oracle APEX to rapidly develop and deploy professional applications that are both fast and secure for any device, from desktop to mobile.

Until now, customers have had to perform standard installation steps to install Oracle APEX on Oracle Cloud Infrastructure Database instances. To simplify this installation, Oracle has released a Terraform template that fully automates Oracle APEX installation in a customer tenancy. The Oracle Application Express (APEX) on Oracle Cloud Infrastructure Database white paper provides step-by-step guidance for deploying Oracle APEX on Oracle Cloud Infrastructure Database by using the Terraform template. Although the manual installation process is still supported, the Terraform template simplifies the process while implementing best practices for Oracle APEX deployment.

Using the steps in the white paper, you deploy Oracle APEX on the target database and Oracle REST Data Services as a web listener on a compute virtual machine (VM) in your tenancy. At a high level, the Terraform template performs the following actions:

  • Creates a compute instance on a public subnet in a virtual cloud network (VCN)
  • Downloads the relevant binaries to the compute VM: ords.war, JDK, Tomcat (if selected)
  • Installs the downloaded binaries
  • Creates and configures the Oracle APEX database schema
  • Performs SSL configuration on the web container

Following are some advantages of deploying Oracle REST Data Services (sometimes referred to as ORDS) on a separate compute instance:

  • Allows access to the Oracle APEX instance and Oracle REST Data Services even if the target databases are in private networks, removing the requirement to have a public IP address on the database instance.
  • Makes it easy to patch and upgrade Oracle REST Data Services independent of the target databases. To upgrade or patch Oracle REST Data Services, you can simply stop (or terminate) the Oracle REST Data Services VM and run the Terraform template again with the latest version of Oracle REST Data Services.
  • Use a single installation of Oracle REST Data Services with multiple database instances.

In line with Oracle Cloud Infrastructure security standards, the Terraform script supports SSL/HTTPS configuration to access Oracle REST Data Services deployment. You can use IP-based or FQDN-based browser access. IP-based access uses SSL via self-signed certificates, and FQDN-based access uses Let's Encrypt certificates for SSL encryption.

To get started with Oracle APEX deployment using the Terraform script, go to our technical content section to access the white paper.