Upgrading and removing APEX
To upgrade or remove APEX, follow the instructions in this topic:
Upgrading the APEX version
Important
Back up your DB instance before you upgrade APEX. For more information, see Creating a DB snapshot for a Single-AZ DB instance for Amazon RDS and Testing an Oracle DB upgrade.
To upgrade APEX with your DB instance, do the following:
-
Create a new option group for the upgraded version of your DB instance.
-
Add the upgraded versions of APEX and APEX-DEV to the new option group. Be sure to include any other options that your DB instance uses. For more information, see Option group considerations.
-
When you upgrade your DB instance, specify the new option group for your upgraded DB instance.
After you upgrade your version of APEX, the APEX schema for the previous version might still exist in your database. If you don't need it anymore, you can drop the old APEX schema from your database after you upgrade.
If you upgrade the APEX version and RESTful services were not configured in the previous APEX version, we recommend that you configure RESTful services. For more information, see Configuring RESTful services for Oracle APEX.
In some cases when you plan to do a major version upgrade of your DB instance, you might find that you're using an APEX version that isn't compatible with your target database version. In these cases, you can upgrade your version of APEX before you upgrade your DB instance. Upgrading APEX first can reduce the amount of time that it takes to upgrade your DB instance.
Note
After upgrading APEX, install and configure a listener for use with the upgraded version. For instructions, see Setting up Oracle APEX listener.
Removing the APEX option
You can remove the Amazon RDS APEX options from a DB instance. To remove the APEX options from a DB instance, do one of the following:
-
To remove the APEX options from multiple DB instances, remove the APEX options from the option group they belong to. This change affects all DB instances that use the option group. When you remove the APEX options from an option group that is attached to multiple DB instances, a brief outage occurs while all the DB instances are restarted.
For more information, see Removing an option from an option group.
-
To remove the APEX options from a single DB instance, modify the DB instance and specify a different option group that doesn't include the APEX options. You can specify the default (empty) option group, or a different custom option group. When you remove the APEX options, a brief outage occurs while your DB instance is automatically restarted.
For more information, see Modifying an Amazon RDS DB instance.
When you remove the APEX options from a DB instance, the APEX schema is removed from your database.