SETUP:
Create a new tablespace to act as the default tablespace for APEX.
CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/oradata/ldb/apex02.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M;
Installation
Change directory to the directory holding the unzipped APEX software.
$ cd /u01/app/oracle/product/11.2.0.3/dbhome_1/apex
Connect to SQL*Plus as the SYS user and run the "apexins.sql" script, specifying the relevant tablespace names and image URL.
SQL> CONN sys@pdb1 AS SYSDBA
SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
SQL>
SQL> @apexins.sql APEX APEX TEMP /i/
Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.
SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apxchpwd.sql
Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.
SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apex_rest_config.sql
OHS Configuration
Change the password and unlock the APEX_PUBLIC_USER account. This will be used for any Database Access
Descriptors (DADs).
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY 123 ACCOUNT UNLOCK;
Embedded PL/SQL Gateway (EPG) Configuration
Run the "apex_epg_config.sql" script, passing in the base directory of the installation software as a
parameter.
SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apex_epg_config.sql /u01/app/oracle/product/11.2.0.3/dbhome_1
Unlock the ANONYMOUS account.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
If this is an upgrade to an existing APEX installation, you will also have to run the following script, to
update the images.
SQL> @apxldimg.sql /u01/app/oracle/product/11.2.0.3/dbhome_1
Check the port setting for XML DB Protocol Server.
SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
-----------
0
1 row selected.
SQL>
If it is set to "0", you will need to set it to a non-zero value to enable it.
SQL> EXEC DBMS_XDB.sethttpport(8080);
PL/SQL procedure successfully completed.
SQL>
For future reference, to get to the Apex Administration Services:
http://127.0.0.1:8080/apex/apex_admin
n.b.:https://oracle-base.com/articles/misc/oracle-application-express-apex-5-0-installation
Create a new tablespace to act as the default tablespace for APEX.
CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/oradata/ldb/apex02.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M;
Installation
Change directory to the directory holding the unzipped APEX software.
$ cd /u01/app/oracle/product/11.2.0.3/dbhome_1/apex
Connect to SQL*Plus as the SYS user and run the "apexins.sql" script, specifying the relevant tablespace names and image URL.
SQL> CONN sys@pdb1 AS SYSDBA
SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
SQL>
SQL> @apexins.sql APEX APEX TEMP /i/
Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.
SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apxchpwd.sql
Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.
SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apex_rest_config.sql
OHS Configuration
Change the password and unlock the APEX_PUBLIC_USER account. This will be used for any Database Access
Descriptors (DADs).
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY 123 ACCOUNT UNLOCK;
Embedded PL/SQL Gateway (EPG) Configuration
Run the "apex_epg_config.sql" script, passing in the base directory of the installation software as a
parameter.
SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apex_epg_config.sql /u01/app/oracle/product/11.2.0.3/dbhome_1
Unlock the ANONYMOUS account.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
If this is an upgrade to an existing APEX installation, you will also have to run the following script, to
update the images.
SQL> @apxldimg.sql /u01/app/oracle/product/11.2.0.3/dbhome_1
Check the port setting for XML DB Protocol Server.
SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
-----------
0
1 row selected.
SQL>
If it is set to "0", you will need to set it to a non-zero value to enable it.
SQL> EXEC DBMS_XDB.sethttpport(8080);
PL/SQL procedure successfully completed.
SQL>
For future reference, to get to the Apex Administration Services:
http://127.0.0.1:8080/apex/apex_admin
n.b.:https://oracle-base.com/articles/misc/oracle-application-express-apex-5-0-installation