Upgrade to Application Express 5.0 and Oracle REST Data Services 2.0.10

Wednesday, September 2, 2015

With the release of Oracle Application Express 5.0, this blog describes how to upgrade Oracle Application Express by downloading a ZIP file from the Oracle Technology Network and then downloading and installing Oracle REST Data Services. These instructions apply on a Linux environment and were tested on an Oracle 11g Release 2 database.

Oracle Application Express‚Äč

1.    Download the ZIP file apex_5.0.zip from the Oracle Application Express download page. http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

2.    Unzip the file as follows:
$ unzip apex_5.0.zip

3.    Change your working directory to apex, the extracted folder from apex_5.0.zip.

4.    Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role.
$ sqlplus /nolog
Enter password: sys_password

5.    Execute the following script:
@apxrtins.sql SYSAUX SYSAUX TEMP /i/
This script will install or upgrade your current installation to 5.0.

6.    Configure static file support:
Once completed, static file support needs to be configured if this is the first time using RESTful Services.

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 configure RESTful Services in new installations and in upgrade installations when RESTful Services were not configured in a previous release.

Run apex_rest_config.sql
$ sqlplus /nolog
Enter password: sys_password

When prompted, enter a password for the APEX_LISTENER and APEX_REST_PUBLIC_USER accounts.

7.    Disabling Oracle XML DB Protocol Server
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.

$ sqlplus /nolog
Enter password: sys_password

Oracle REST Data Services

1.    Download the ZIP file from the Oracle REST Data Services download page.

Note: This guide describes how to install Oracle REST Data Services 2.0.10. On May 4, 2015 Oracle REST Data Services 3.0 was released.

2.    Unzip the file as follows:
$ unzip ords.

3.    Change your working directory to the extracted folder. Configure the services by executing the following command:
$ java -jar ords.war

4.    Complete the following prompts according to you environment. For example:
Enter the location to store configuration data: /opt/software/apex/ords/conf
Enter the name of the database server [localhost]: localhost
Enter the database listen port [1521]: 1521
Enter 1 to specify the database service name, or 2 to specify the database SID [1]: 1
Enter the database service name: ORCL
Enter the database user name [APEX_PUBLIC_USER]: APEX_PUBLIC_USER
Enter the database password for APEX_PUBLIC_USER: public_password
Confirm password: public_password
Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step [1]: 2
Enter 1 if you wish to start in standalone mode or 2 to exit [1]: 1
Enter the APEX static resources location or Enter to skip: /opt/software/apex/images
Enter the HTTP port [8080]: 8080

5.    Once the prompts are completed correctly, Application Express 5.0 is available on http://localhost:httpport/ords.