The steps on this page have been tested with APEX 21.2. Check the installation Guide and Release Notes for later versions before continuing.
WORKAREA_SIZE_POLICY should be AUTO and MEMORY_TARGET should be at least 300M.
If you are following best practice and NOT using AMM, but you are using ASMM and APMM then the sum of SGA_TARGET and PGA_AGGREGATE_TARGET should be at least 300M.
export APXVER=21.2
mkdir -p /u01/img/apex/${APXVER}
Download to /u01/img/apex
unzip /u01/img/apex/apex_${APXVER}.zip -d /u01/img/apex/${APXVER}
rm /u01/img/apex/apex_${APXVER}.zip
Create a Guaranteed Restore Point (or ensure you have another method to backout if necessary).
CREATE RESTORE POINT apexupgrade GUARANTEE FLASHBACK DATABASE;
You will need a version of ORDS, either Standalone or via Tomcat (or WebLogic). If this is your first APEX/ORDS implementation it is probably easier to install APEX before ORDS as the ORDS installation will prompt for details of an APEX installation to connect to.
If this is an Upgrade then temporarily prevent access to APEX (i.e. shutdown ORDS).
If the first or second digit of the version will change as a result of this upgrade (e.g. 4.1 to 4.2) then you need a full install of APEX. If only the third digit will change (e.g. 4.2.2 to 4.2.6) then you just need a patch...
export APXVER=21.2
This should match the version number in your download location path (e.g. for /u01/img/apex/18.1 APXVER is 18.1)cd /u01/img/apex/${APXVER}/apex
sqlplus / as sysdba
@apexins.sql SYSAUX SYSAUX TEMP /i/
If you want APEX to live in a different tablespace update the tablespace names accordingly.The tablespace names relate to "apex", "files", and "temp" segment storage.Homing APEX in SYSAUX is generally appropriate.This usually takes approximately 15 minutes to complete.cd /u01/img/apex/${APXVER}/patch
sqlplus / as sysdba @apxpatch.sql
Review apxpatch.log for errorsYou can skip these steps if you are upgrading an existing APEX installation...
@apxchpwd.sql
Consider using a non-default administrator username.Set the Profile for APEX_PUBLIC_USER to prevent password expiration, unlock the acccount and change the password...
ALTER USER APEX_PUBLIC_USER PROFILE myNoExpireProfile;
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY "Password";
Configure RESTful Services
@apex_rest_config.sql
Images need to be copied for initial installation and upgrades. This steps is different for Standalone, Tomcat and Weblogic.
Remember to drop any Guaranteed Restore Point (be sure you don't need to backout first)
Start ORDS if necessary