Configuring Oracle REST Data Services requires that you copy the images directory, run a configuration to configure RESTful Services, configure static files support, and secure Oracle REST data service.
How to configure RESTful Services in a new installation is discussed in the following section.
4.6.1 Copying the Images Directory
Whether you are loading a new installation or upgrading from a previous release, you must copy the images directory from the top level of the
apex\images directory, for example
C:\TEMP, to the location used by your Oracle REST Data Services installation.
During an upgrade, you overwrite your existing images directory. Before you begin the upgrade, to ensure that you can revert to the previous version, Oracle recommends that you create a copy of your existing images directory for Oracle Application Express, indicating the release number of the images (for example,
4.6.2 Validating the Oracle REST Data Services Installation
In a new installation or upgrade of Oracle Application Express, you must validate the Oracle REST Data Services installation.
For validating the Oracle REST Data Services installation in a new installation or upgrade of Oracle Application Express, run the following :
java -jar ords.war validate [--database <dbname>]
4.6.3 Configuring RESTful Services
In a new installation or upgrade of Oracle Application Express, you must run the configuration script
apex_rest_config.sql to configure RESTful Services.
Once configured, the instance administrator can control the availability of the feature. If the instance administrator has disabled RESTful Services for this Application Express instance, RESTful Services are not available for this instance and the RESTful Services icon does not display.
To configure RESTful Services in Oracle Application Express:
- Change your working directory to the
apexdirectory where you unzipped the installation software.
- Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. 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
apex_rest_config.sql. For example:
When Prompted, enter a password for the
When configuring RESTful Services in Oracle Application Express, it creates two new database accounts.
APEX_LISTENER- The account used to query RESTful Services definitions stored in Oracle Application Express.
APEX_REST_PUBLIC_USER- The account used when calling RESTful Services definitions stored in Oracle Application Express.
"Controlling RESTful Services for an Instance" in Oracle Application Express Administration Guide
4.6.4 Configuring Static File Support
For configuring static files, you must run
apex_rest_config.sql after a new installation or upgrade of Oracle Application Express .
Oracle Application Express enables application developers to include static files with their applications. Static files can be associated with a workspace, an application, a plug-in, or an application theme. When using Oracle REST Data Services as your web listener, static files are served using RESTful service module built into Oracle Application Express. Therefore, you must run
apex_rest_config.sql after a new installation or upgrade of Oracle Application Express.
4.6.5 Securing Oracle REST Data Service
In a configuration for Oracle Application Express, Oracle recommends setting the parameter
wwv_flow_epg_include_modules.authorize activates the white list of callable procedures which ships with Oracle Application Express and prohibits calls to other procedures.