Search notes:

Oracle REST Data Services

Oracle REST Data Services (ORDS) is a Java EE-based alternative for Oracle HTTP Server and mod_plsql.

It is provided as a free product under the Oracle Technology Network License.

Before release 2.0.6, ORDS was named Oracle Application Express Listener (or APEX listener).

ORDS requires no Oracle home. Clients connect to Oracle using an embedded JDBC driver.

Running ORDS

Supported configurations of ORDS are to run it on

Oracle WebLogic Server (WLS)
Apache Tomcat
Oracle GlassFish (deprecated)

It's also possible to run the standalone Java servlet (war file) provided in the distribution (which is not supported by Oracle), for example with Jetty which is included in the sources.

$ cd $ORDSINSTDIR
$ unzip -l ords.war | grep jetty

User accounts

User accounts that might be used with ORDS are

APEX_PUBLIC_USER
APEX_REST_PUBLIC_USER
APEX_LISTENER
ORDS_METADATA (always required?)
ORDS_PUBLIC_USER (always required?)

APEX_* users are created when APEX is installed.

As per MOS Note 2049531.1, the ORDS schemas are not required for APEX usage. They are needed to use Oracle RESTful Web Services outside of APEX.

Installation and configuration

Download the latest version of REST.

Unzip the downloaded zip file.

ORDS can then be installed either with

Advanced Installation Using Command-Line Prompts (java -war ords.war install advanced), or
Silent Installation Using a Parameter File (@/path/to/extracted/ords-20.2.1.2227.0350/installerords_installer_privileges.sql exampleuser)

Misc

As per MOS Note 2934273.1, ORDS does not support Kerberos authentication.

Links

The Github repository oracle-db-tools has ORDS SQL examples.

Index