Oracle APEX 5.0 Installation and configuration using oracle http server and mod_plsql

Step-1: Create a new tablespace to act as the default tablespace for APEX.

Step-2: Download the apex software from from oracle edelevery site and Change directory to the directory holding the unzipped APEX software.

      $ cd /home/oracle/apex

Step-3: SQL> CONN sys@pdb1 AS SYSDBA
SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
SQL> 
SQL> @apexins.sql APEX APEX TEMP /i/ 

Step-4: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
Step-5:

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 myPassword ACCOUNT UNLOCK;

If you don't want the password to expire you will need to create a new profile with password expiration disabled and assign it to the user.
Create a DAD in the OHS like below:

Alias /i/ "C:\Middleware\images/"
AddType text/xml xbl
AddType text/x-component htc

<Location /test>
  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride None
  PlsqlDatabaseUsername         APEX_PUBLIC_USER
  PlsqlDatabasePassword         apex123
  PlsqlDatabaseConnectString    ip:1521:dbname
  PlsqlAuthenticationMode       Basic
  PlsqlDefaultPage              apex
  PlsqlDocumentTablename        wwv_flow_file_objects$
  PlsqlDocumentPath             docs
  PlsqlDocumentProcedure        wwv_flow_file_mgr.process_download
  PlsqlNLSLanguage              AMERICAN_AMERICA.AL32UTF8
  PlsqlPathAlias                url
  PlsqlPathAliasProcedure portal.wwpth_api_alias.process_download
</Location>

 Step-6: Copy the image folder into OHS server and check the folder location in the dads.conf

 Step-7: Restart the oracle http server.