• 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

• 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).

First-time install only

You can skip these steps if you are upgrading an existing APEX installation...

@apxchpwd.sql

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

Copy Images

Images need to be copied for initial installation and upgrades. This steps is different for Standalone, Tomcat and Weblogic.

Post-Install

• Remember to drop any Guaranteed Restore Point (be sure you don't need to backout first)

• Start ORDS if necessary