Oracle Database Express Edition (XE) contains Application Express (APEX2.1) version 2.1 and yesterday Oracle released version 3.0 . While reading the installation guide regarding the Oracle Database requirement I noticed the following:
Do not install this version of Oracle Application Express on Oracle Database Express Edition (Oracle Database XE).
With the previous release of APEX2.2.1 some people installed this version into their XE database (see this OTN thread: Install APEX 2.2.1 on XE is possible! I think...). So why not try to upgrade my APEX2.1 to APEX3.0 on my XE database? It really sounds like a challenge!
However installing APEX3.0 on XE is an unsupported configuration by Oracle. This does not imply it will not work but if you run into problems there is no technical support available (see this OTN thread Install Apex 3.0 on Oracle XE). Also make a backup before you start the installation. My first attempt to upgrade ended with a database where I could not login into APEX, the images where missing and when trying to find out what went wrong, a BSOD appeared. You are warned...
The installation consists of two parts: running update scripts and copying the images file into the virtual path /i/. The first script to run is
apexins.sql. The good news about this script is this remark:
02/15/2007 - Remove XE check. There is no check on the database edition anymore. And the bad news is
coreins.sql which contains the following code:
Rem Set XE variable to '1' for XE installation, '0' for non-XE installation
define XE = '0'
Set the variable XE to 1 and save this script and run
apexins.sql according to the installation guide.After completion of this script make sure there are no invalid objects. I have still one invalid package body
WWV_FLOW_XE_CONFIG. There are no other objects calling this package, so errors can occur if this package is called with dynamic PL/SQL.
While the script is running you can copy the images into the virtual directory (see Where are the /images of Application Express in OracleXE). The total installation time was 1 hour.
Login and choose About Application Express, you should see something like this picture.