There will of course also be a new APEX release in 2021, which will only be overshadowed by the tragic death of one of the co-founders of APEX: Joel Kallmann
Although I was unfortunately not able to meet him in person, I had contact with him several times via the forum. My respect for his life's work!
Note: In our test with APEX 21.1 some “little things” did not work, you may want to wait until the first patch is released (Update: there is the first patch 32598392):
If you want to install APEX version 21.1 (as of May 12, 2021) in the free Oracle XE database version 18c, please proceed as follows:
First download APEX and Oracle Express (XE) version 18c. We always install the NON-CDB version (as long as it still works :-) )
Update from 2.4.2022: From version 21c XE only a pluggable database installation is now possible!
For LINUX we use the installation path: /u01/software. The APEX zip file should then be unpacked there
To install APEX, start:
UNIX> cd /u01/software
UNIX> sqlplus / as sysdba
If required, you can create your own tablespace for APEX or use the SYSAUX tablespace.
SQL> CREATE TABLESPACE apex_main_tbs DATAFILE '/opt/oracle/oradata/XE/apex_main01.dbf'
SIZE 512M AUTOEXTEND ON NEXT 64M MAXSIZE 2048M;
Now we go to the installation directory and start the APEX installation main script:
$#> cd /u01/software/apex
$#> sqlplus / as sysdba
SQL> @apexins APEX_MAIN_TBS APEX_MAIN_TBS TEMP /i/
or the existing internal SYSAUX tablespace is to be used:
SQL> @apexins SYSAUX SYSAUX TEMP /i/
Copy the images to the corresponding web server folder:
export APEX_IMG=/var/www/html/i
mv $APEX_IMG $APEX_IMG.old
cp -R /u01/software/apex/images $APEX_IMG
chmod -R oracle:tomcat $APEX_IMG
passen Sie den Ordner ggf an, wenn bei Ihnen ein anderer verwendet wird
The last script sets the password for INTERNAL Workspace ADMIN users.
If you are migrating from a lower version of APEX (19.x or 20.x), this step is not necessary.
SQL> @apxchpwd
You will be asked for 3 parameters:
- Username (does not have to be ADMIN)
- Email address: info@muniqsoft-training.de ( Please use your own, or may we manage your APEX server? (we will do almost anything for money :-) )
- Password (must be a complex password with upper and lower case, numbers and special characters)
The last problem (password complexity) can be avoided by running the following command first:
EXEC APEX_INSTANCE_ADMIN.SET_PARAMETER('STRONG_SITE_ADMIN_PASSWORD','N');
In addition, the REST interface is required, which is needed for all REST tasks and the application and workspace files.
If you are migrating from a lower version of APEX (19.x or 20.x), this step is not necessary.
SQL>@apex_rest_config
You can now log in:
http://servername:port/ords/f?p=4550
First create a workspace with an administration user.