Skip to content

Archive for

Apex upgrade during database upgrade

While doing upgrade from oracle database 12.2 to 19c, we need to do the upgrade apex as per preupgrade recommendation

Upgrade Oracle Application Express (APEX) manually before the database
upgrade.

  The database contains APEX version 5.0.4.00.12. Upgrade APEX to at least
  version 18.2.0.00.12.

  Starting with Oracle Database Release 18, APEX is not upgraded
  automatically as part of the database upgrade. Refer to My Oracle Support
  Note 1088970.1 for information about APEX installation and upgrades.

Solution :

Download apex

https://www.oracle.com/tools/downloads/apex-downloads.html

you can able to download older apex too.

Unzip apex software

move older apex version directory to somewhere and copy the apex to oracle 12c home path.

From command prompt, go to apex directory location and then execute the following command from sql as sysdba

before that , you need to know

There are two types of APEX installations: development and runtime only. To determine which type is currently installed, run the following query:

select count(*) from <SCHEMA>.WWV_FLOWS where id = 4000;

<SCHEMA> — curent APEX schema Example APEX_5000

If the query returns 0, it is a runtime only installation, and apxrtins.sql should be used for the upgrade. If the query returns 1, this is a development install and apexins.sql should be used.

As administrator command prompt

@apexins.sql SYSAUX SYSAUX TEMP /i/

It will take sometime to upgrade