My APEX 18.2 upgrade in a nutshell

September 30, 2018

1–2 minutes

As always, you should read the Installation/Upgrade manual from top to bottom before upgrading any piece of software, and be aware of all of the pre-requisites and processes. But for me, my Application Express 18.2 upgrade was as simple as:

Download Application Express
Unzip to my target location
sqlplus / as sysdba
- SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
Go to my ORDS installation
- java -jar ords.war validate
sqlplus / as sysdba
- SQL> @apex_rest_config.sql

And voila! A freshly upgraded Application Express in a matter of minutes…

Sweet!

10 responses to “My APEX 18.2 upgrade in a nutshell”

Matt Ball

September 30, 2018 at 10:44 pm

As every upgrade before it then.

BUT

No testing?

No new images/css/js libraries to be dealt with.

Reply
Connor McDonald

October 1, 2018 at 5:50 am

For my *home* machine – testing is the luxury of being an optional extra 🙂

Reply
Agata

December 11, 2018 at 8:03 pm

I am installing 18.2 but on running script apex_rest config.sql it tries to grant on old apex_050000 user which I haven’t got as my user is apex_180200, how silly of me to assume consistency of naming. 😒

Reply
kvinodbabu

February 22, 2019 at 9:00 pm

i get this error after upgrad while loading page

The files for version 5.0.4.00.12 have been loaded, but 18.2.0.00.12 is expected. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide.

Reply
kvinodbabu

February 22, 2019 at 9:12 pm

hitting ctrl+f5 worked force refresh on browser

Reply
1. Connor McDonald
  
  February 27, 2019 at 7:52 am
  
  Ah yes, the browser cache … always gives those “Whoa! What happened” moments 🙂
  
  Reply
Daniel

July 9, 2019 at 3:39 am

Upgraded from 4.2 to 19.1 but the layout comes out all jumbled. The horizontal menu based on a list becomes a vertical menu with no css and all other widgets also does not have css styling. Do you perhaps know what I did wrong?

Reply
1. Connor McDonald
  
  July 9, 2019 at 7:31 am
  
  Make sure you copied the images directory as per the upgrade instructions. (Mine was an inplace upgrade when I unzipped so that was taken care of automatically). And make sure you ran the ORDS validate stage. I’ve had similar issues in the past and this has fixed it.
  
  Good luck!
  
  Reply
Ritesh

December 28, 2022 at 4:02 pm

I want to upgrade my apex 5 to apex 21.2 . Do I need to remove apex5 or not.

I am using 19c CDB/PDB environment

Reply
1. Connor McDonald
  
  December 28, 2022 at 8:58 pm
  
  I am pretty sure you can just upgrade in place. The way APEX upgrades work is that we install a new schema, and then copy the metadata over.
  
  Reply