Oracle Application Express Consulting

Let us help you to build robust, contemporary database applications with Apex. Whether is for the web or mobile, there’s not much we haven’t done before. We can development your application or help your developers do it. Because we think outside of box, we can do incredible things with Apex.

Contact Us

Learn Oracle Apex - Discover the power

We are South Africa’s  only provider of ongoing scheduled Apex training. Whether its development, security or deploy, we’ll give you everything you need to know to unleash the power of Apex.

Read More

Need some help? - On-site or remote

Our expert Oracle consultants are ready to provide you with on-site or remote consulting. Whether for one week or one year, let us help you in a wide variety of Oracle technologies. We can bring years of experience to your development project.

Contact Us

Upgrade from 5.1 to 18.1

Oracle has released the latest version of Apex and keeping in line with their naming convention Apex has jumped from version 5.1.4 to 18.1 . The new version of Apex has many exciting new features.

Setup :
Apex Version : Oracle Apex 5.1.4
Webserver : ORDS Running on Apache Tomcat 9
DB Version : Oracle 12.2 with January 2018 Patchset


1. Download Apex 18.1 from Oracle Website


2. Rename the old apex directory in ORACLE_HOME

mv apex/ apex_old/


3. Go to the new Apex Directory and run the Upgrade

cd apex/

SQL> @apexins.sql apex apex temp /i/

apex – tablespace for apex
apex – tablespace for apex files
temp – temporary tablespace

After a while you will get the below message if you had an earlier version of Oracle Apex

Session altered.

timing for: Phase 1 (Installation)
Elapsed: 00:04:59.21
Phase 2 (Upgrade)

Session altered.


— Now beginning upgrade. This will take several minutes.——-‘)

timing for: Phase 2 (Upgrade)
Elapsed: 00:06:10.38
Phase 3 (Switch)

PL/SQL procedure successfully completed.


Session altered.

Thank you for installing Oracle Application Express

Oracle Application Express is installed in the APEX_180100 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
http://host:port/apex/apex_admin (Oracle REST Data Services)

The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
http://host:port/apex (Oracle REST Data Services)

timing for: Phase 3 (Switch)
Elapsed: 00:00:58.70
timing for: Complete Installation
Elapsed: 00:11:10.83

PL/SQL procedure successfully completed.


4. Load Images Directory for Apex.

@apex_epg_config.sql ORACLE_HOME

@apex_epg_config.sql /u01/app/oracle/product/12.2.0/dbhome_1


5. Copy images from Apex image directory and Restart your Webserver, in my case I have Tomcat, else you will get below error after you access your Web URL for Apex

“There is a problem with your environment because the Application Express files are not up-to-date! The files for version have been loaded, but is expected. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide.”

As tomcat user

cd /u01/app/oracle/product/12.2.0/dbhome_1/apex/images/

cp -R * $CATALINA_HOME/webapps/i



If the error persists, clear all browser cache ,cookies and restart your browser


And Oracle Apex is upgraded to the latest version

Screen Shot 2018-05-28 at 11.17.12 AM

Contact Us

Please let us know your name.
Please let us know your email address.
Invalid Input
Please write a subject for your message.
Please let us know your message.
Invalid Input

Contact Us

Our Address

AppLinks (Pty) Limited
20 Wildebees Street
Alberton, South Africa
+27 (0) 11 902 3688
+27 (0) 83 276 3315