Learn about downloading and installing Oracle REST Data Services.
Learn how to download Oracle REST Data Services.
By default, the context root for accessing Oracle Application Express through Oracle REST Data Services is
/ords. If you wish to have a context root of
/apex for accessing Oracle Application Express, rename the
ords.war file to
apex.war before installing Oracle REST Data Services. See "Installing Oracle REST Data Services" in Oracle REST Data Services Installation, Configuration, and Development Guide.
To download Oracle REST Data Services:
Note that the
version.number in the file name reflects the current release number.
CDB$ROOTunless you are configuring Oracle REST Data Services to address PDBs through the URL. See Oracle REST Data Services Installation, Configuration, and Development Guide for more information.
When Oracle Application Express 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 Application Express engine.
The Application Express 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.
Learn about Web Server HTTP POST request limits.
When running Oracle REST Data Services in standalone mode or within a Tomcat Java Container, size limits are being imposed on POST requests which are not file uploads. Application Express 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 kilobytes for Oracle REST Data Services (ORDS) 3.0.8 and below and 10MB for ORDS 3.0.9 and above. For 3.0.8 and below 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 Oracle HTTP Server with
mod_plsql, the default is unlimited. No action is required.
When running on the Embedded PL/SQL Gateway, the limit is 2 Gigabytes. No action is required.
maxPostSizeparameter to change that limit.
"http://tomcat.apache.org/" for more information.
If you were previously using the embedded PL/SQL gateway and now want to use Oracle REST Data Services, you need to disable the Oracle XML DB Protocol Server.
To disable Oracle XML DB Protocol Server:
SYSDBArole. For example:
SYSTEM_DRIVE:\ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
On UNIX and Linux:
$ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password