How to install APEX 4.2.3

This guide refer to APEX release 4.2.3 and installed on debian like server.

First you must download the package of APEX from Oracle site and then unzip the package on your server with command (use “sudo” if you haven’t  right permission for do this and following S.O. commands):

# unzip apex_4.2.3.zip

Move your apex directory, that it created from unzip command, to oracle folder with command:

# mv apex <oraclefolder>/apex_app

You change directory to apex_app and connect to database with SQLPlus:

# sqlplus /nolog

SQL> CONNECT SYS AS SYSDBA

You run the installation script of APEX

SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/

Where specified params are:

–          the tablespace used to APEX (first and second parameter);

–          temporary tablespace to use;

–          path of images folder.

Now you set password of APEX administration account using the follow script:

SQL> @apxchpwd.sql

When you completed previous operation, you must unlock the public account of APEX and change it password with commands:

SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY <password>;

You change placeholder <password> with the password that you want assign to user.

Oracle’s users, on default setting, have password expiration  set on 180 days. When the password of public user expire, APEX is not more accessible. For prevent this situation, you must create a new profile, set password expire unlimited and assign it to APEX public user:

SQL> CREATE PROFILE Apex_Public_Profile LIMIT PASSWORD_LIFE_TIME UNLIMITED;

SQL> ALTER USER APEX_PUBLIC_USER PROFILE Apex_Public_Profile;

Now, if you want use APEX, you must configure your listener that you want to use (APEX Listener, Oracle HTTP Server, Embedded PL/SQL gateway).