Uninstallation of APEX from a default Oracle 11gR2 database

Environment: Oracle Linux 6.2, Oracle database 11gR2, APEX 3.2.1

If you use the graphical dbca utility to create a new Oracle 11gR2 database, you will have noticed that this includes Application Express by default, and there is no way to deselect that option (to my knowledge) during the installation process. Here I will explain how you can remove APEX from the 11g database after the installation.

First, you need to figure out what version of APEX is installed. You can do this by looking at the name of the APEX_xxxxxx schema, or by executing the following query (with user SYS as SYSDBA):

SQL> select version from dba_registry where comp_id=’APEX’;


Next, you need to download the exact same version of the software (in this case: version 3.2.1) from Oracle’s website. The last version of APEX as of writing is 4.1.1, but the uninstallation won’t work with this version.

Version 3.2.1 can be downloaded here: http://www.oracle.com/technetwork/developer-tools/apex/3-098787.html. Copy the zip file to your server and unzip it to a temp folder (for example: /tmp). Make sure the user which runs your Oracle software (by default this is user “oracle”) has access to the software. Note: you need about 750MB of free disk space for the zip file and the unzipped content…

Next, change to the directory “apex” and run the apexremov.sql script with user SYS as SYSDBA:

$ sqlplus /nolog

SQL*Plus: Release Production on Fri Apr 6 14:07:26 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

SQL> connect / as sysdba
SQL> @apxremov.sql

When the script executed without errors, you should see the following message at the end:

PL/SQL procedure successfully completed.

…Application Express Removed

You can now query dba_registry again, and you will notice that APEX is uninstalled!




4 Responses to Uninstallation of APEX from a default Oracle 11gR2 database

  1. David Drake says:

    Using dbca one can, in fact, not install Oracle Application Express by clicking on Standard Database Components, on the Step 8 of 12 Database Content screen. A second window will pop up listing Oracle JVM, ORACLE XML DB, Oracle Multimedia and Oracle Application Express. Just deselect Oracle Application Express and click OK. The Key to being able to do this is to select Custom Database in Step 2 of 12: Database Template.

  2. Qasim Ranta says:


  3. Pingback: (De)install Apex in 11GR2 challenge | Mathijs Bruggink

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: