Tech Touch Online

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