Upgrading Oracle Application Express (APEX)
Preparation :-
Ensure the new APEX version is compatible with your Oracle Database version.
Review the release notes and documentation for any specific requirements
Backup: -
Perform a full backup of your database, including the APEX instance and any custom applications
Export the APEX applications and workspace
Download and Unzip :-
Download APEX latest version and latest Patch Set Bundle (36695709)
Installation :-
1) Created Tablespace for APEX
CREATE TABLESPACE APEX_24 DATAFILE '+TEST' SIZE 100M AUTOEXTEND ON NEXT 1M;
2) Upgrade APEX on Database
SQL > @apexins.sql APEX_24 APEX_24 TEMP1 /i/
3) Apply Bundle Patch (36695709)
SQL> @catpatch.sql
4) Copy Static Image File to APEX web server /i/ Location
cp -R /u01_blv/APEX_2024/apex/images i/
cp -rf /u01_blv/APEX_2024/36695709/images i/
5) Once you upgrade an Oracle APEX instance from a previous release, existing applications will work without modification. However, to keep applications maintainable, up-to-date, and to leverage new functionality, developers should perform the steps
Refreshing the Universal Theme
Updating App Compatibility Mode
Running Application Upgrade
Reviewing Old JavaScript
7) Cleaning Up Your Environment
If you installed the prior release into a separate tablespace, you can simply drop the specific tablespace.