6.4 Downloading and Installing Oracle REST Data Services (ORDS)

Learn about downloading and installing Oracle REST Data Services (ORDS).

The Oracle APEX architecture requires a web server to proxy requests between a web browser and the APEX engine. Oracle REST Data Services meets the requirement but its use goes beyond that of APEX. Oracle REST Data Services simplifies the deployment process because there is no Oracle home required, as connectivity is provided using an embedded JDBC driver.

• Downloading Oracle REST Data Services
  Learn how to download Oracle REST Data Services.
• About Configuring Oracle REST Data Services Behind a Reverse Proxy or Load Balancer
  When Oracle APEX is running behind a reverse proxy or load balancer, it is important to communicate the original HTTP hostname and protocol as seen by the user's browser to the Oracle APEX engine.
• Web Server HTTP POST Request Limits
  Learn about Web Server HTTP POST request limits.

See Also:

• Introduction to Oracle REST Data Services in Oracle REST Data Services Developer's Guide
• Installing and Configuring Oracle REST Data Services in Oracle REST Data Services Installation and Configuration Guide

6.4.1 Downloading Oracle REST Data Services

Learn how to download Oracle REST Data Services.

Tip:

By default, the context root for accessing Oracle APEX through Oracle REST Data Services is /ords. If you wish to have a context root of /apex for accessing Oracle APEX, rename the ords.war file to apex.war before installing Oracle REST Data Services. See Deploying and Monitoring Oracle REST Data Services in Oracle REST Data Services Installation and Configuration Guide.

To download Oracle REST Data Services:

1. Download the latest release of Oracle REST Data Services from the Oracle REST Data Services download page.
2. Unzip the downloaded zip file into a directory (or folder) of your choice:
   • UNIX and Linux: unzip ords.version.number.zip

   • Windows: Double-click the file ords.version.number.zip in Windows Explorer
3. Copy the images directory, apex/images, from the APEX software ZIP to a location on the file system where Oracle REST Data Services is installed.

   Note:

   This step is optional if you use the APEX static resource of the CDN. See Managing Static Resources (Images).
4. Follow and complete all installation and configuration steps described in Installing and Configuring Oracle REST Data Services in Oracle REST Data Services Installation and Configuration Guide.
5. For Oracle Database multitenant architecture, ensure that you configure the connection using the service name of the specific pluggable database (PDB) you want to access. Do not use the service name of the CDB$ROOT unless you are configuring Oracle REST Data Services to address PDBs through the URL. See Using the Multitenant Architecture with Oracle REST Data Services in Oracle REST Data Services Installation and Configuration Guide for more information.

6.4.2 About Configuring Oracle REST Data Services Behind a Reverse Proxy or Load Balancer

When Oracle APEX is running behind a reverse proxy or load balancer, it is important to communicate the original HTTP hostname and protocol as seen by the user's browser to the Oracle APEX engine.

The Oracle APEX engine uses this information to generate valid URLs in HTML responses and HTTP redirects that the user's browser can successfully follow. The exact configuration steps depend on your Java EE application server. For example, for Oracle WebLogic Server, this is accomplished using Oracle WebLogic Server Proxy Plug-Ins. To learn more, see your Java EE application server documentation.

6.4.3 Web Server HTTP POST Request Limits

Learn about Web Server HTTP POST request limits.

When running Oracle REST Data Services (ORDS) in standalone mode or within a Tomcat Java Container, size limits are being imposed on POST requests which are not file uploads. Oracle APEX users will encounter these limits when uploading data in SQL Workshop using copy and paste or when using copy and paste while building an application from spreadsheet.

• When running Oracle REST Data Services in Standalone Mode, the default limit is 200 KB for ORDS 19.4.6 and earlier. It is recommended to increase the limit as follows:

  Set the Java System property  org.eclipse.jetty.server.Request.maxFormContentSize to a higher value in bytes. You can set this property upon startup of Oracle REST Data Services. For example: java -Dorg.eclipse.jetty.server.Request.maxFormContentSize=3000000 -jar ords.war

• When running on Apache Tomcat, the default limit is 2 megabytes. Adjust Apache Tomcat's maxPostSize parameter to change that limit.

  See Also:

  http://tomcat.apache.org/ for more information.