Future Direction for Application Express (APEX) and the Oracle HTTP Server (OHS) / Mod_plsql
(Doc ID 1945619.1)
Last updated on APRIL 12, 2022
Applies to:Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Starting with the 12.1.3 Oracle HTTP Server (OHS), the mod_plsql feature has been deprecated. OHS / mod_plsql will not be included with the 12.2 version of the database or the 12.2 Oracle HTTP Server according to <Note 1576588.1> - Oracle Web Tier - Statement of Direction. This deprecation notice only affects future product direction for the Oracle HTTP Server, and the mod_plsql will continue to be supported according to the dates defined in the Fusion Middleware Lifetime Support Policy document.
For the future, Oracle recommends moving to Oracle REST Data Services (formerly known as Oracle APEX Listener) as an alternative to mod_plsql for APEX applications. Oracle REST Data Services is a J2EE-based servlet which offers increased functionality including enhanced security, and file caching.
For mod_plsql based applications, there are two alternatives:
- Oracle REST Data Services (ORDS)
- The Embeded PL/SQL Gateway (EPG) / Oracle XDB HTTP Server
Neither of these options provides a one to one mapping for mod_plsql applications, so both alternatives need to be examined in order to determine which more closely serves the needs of existing mod_plsql applications. This document covers the ORDS option. For more information on the Oracle XDB HTTP Server / Embeded PL/SQL Gateway (EPG), please see the Developing PL/SQL Web Applications documentation in the Database Advanced Application Developer's Guide documentation for the database.
Oracle REST Data Services (ORDS) is a free product provided under Oracle Technology Network License Terms. Running the standalone Java servlet (war file), provided in the distribution, is *not* supported in production environments until ORDS 3.0.6 and above. For version prior to 3.0.6, standalone is only intended for use in development and test environments.
The free replacement for OHS / mod_plsql is Weblogic with ORDS. As long as WLS is installed on the database server, there is no additional licensing required. The Oracle® Fusion Middleware Licensing Information User Manual states the following:
A license to WebLogic Management Framework includes a restricted-use license to Oracle WebLogic Server Standard Edition. Oracle WebLogic Server Standard Edition may be used solely for hosting the Java servlet that is used by Oracle REST Data Services. The Java servlet is the functional replacement for Oracle HTTP Server mod_plsql.
Please review the Fusion Middleware Lifetime Support Policy for details regarding support dates for your Oracle HTTP Server versions. For additional information on Lifetime Support, please see:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document