My Oracle Support Banner

APEX 3.0.1 to 3.2.0 : APEX Is Shown As INVALID In DBA_REGISTRY After Removing Development Environment (Doc ID 1055160.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Oracle Application Express (APEX) - Version 3.0.1 to 3.2.0
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.


This article is specific to APEX Version 3.0.1 to 3.2.0. For APEX Version 4.0.x, please see <NOTE 1205613.1>



In Oracle Application Express 3.x, if you have a full development version (the default) and you choose to remove the development environment and convert it to a runtime installation only, which is recommended for production installations, then:

  1. The APEX component will be listed as INVALID in DBA_REGISTRY
  2. Errors are not reported during execution of the APEX development removal installation script, apxdevrm.sql, leading you to believe that no errors occurred.

APEX applications will continue to run in this environment, even with the APEX component being marked as INVALID in DBA_REGISTRY. While this does not directly impact the execution of applications, it can impact future upgrade actions.


Moved from development environment to runtime only by running the script apxdevrm.sql.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.