Oracle Application Express (APEX) 5.x Installation With Oracle HTTP Server (OHS)

---Create a new tablespace to act as the default tablespace for APEX.
$sqlplus /as sysdba

-- For Oracle Managed Files (OMF).
SQL>CREATE TABLESPACE apex DATAFILE SIZE 1G AUTOEXTEND ON NEXT 100M;

-- For non-OMF.
SQL>CREATE TABLESPACE apex DATAFILE '/path/to/datafiles/apex01.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M;

Remove the existing lower version of apex from database use below command.
---Uninstallation Process---

SQL>select * from dba_registry;

SQL>exit

$ cd $ORACLE_HOME/apex
$sqlplus /as sysdba

SQL>@apxremov.sql

SQL>exit

---Installation Process---

$ unzip apex_5.x.x_en.zip -d $ORACLE_HOME/

cd $ORACLE_HOME/apex

SQL>@apexins.sql APEX APEX TEMP1 /i/

SQL>@apxchpwd.sql

SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY myPassword ACCOUNT UNLOCK;

-----Installation and Configuration Oracle HTTP Server (OHS)----


----Login with oracle database user
#su - oracle

$mkdir -p /testsite/HTTP_Server ----software location
$mkdir -p /testsite/Oracle_WT ------Installation location

$ unzip ofm_webtier_ibm_aix_11.1.1.7.0_64_disk1_1of2 -d /testsite/HTTP_Server
$ unzip ofm_webtier_ibm_aix_11.1.1.7.0_64_disk1_2of2 -d /testsite/HTTP_Server

$cd /testsite/HTTP_Server

$ ls -l
Disk1
Disk2
Disk3
Disk4
Disk5

$cd Disk1

----Ignore Prerequisites.
$./runInstaller -ignoreSysPrereqs

$cd /testsite/Oracle_WT/Oracle_WT/instances/instance1/config/OHS/ohs1/mod_plsql

----Enter the below entry in the dads.conf file

Alias /i/ "/testsite/testdb/db/apex/images/"---Apex Image folder Location
<Location /apex>
   Order deny,allow
   PlsqlDocumentPath docs
   AllowOverride None
   PlsqlDocumentProcedure         wwv_flow_file_mgr.process_download
   PlsqlDatabaseConnectString     erptestappldb:1528:test ServiceNameFormat
   PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
   PlsqlAuthenticationMode        Basic
   SetHandler                     pls_handler
   PlsqlDocumentTablename         wwv_flow_file_objects$
   PlsqlDatabaseUsername          APEX_PUBLIC_USER
   PlsqlDefaultPage               apex
   PlsqlDatabasePassword          myPassword
   PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
   PlsqlPathAlias                 i
   PlsqlPathAliasProcedure        wwv_flow.resolve_friendly_url
   Allow from all
</Location>

$cd Oracle_WT/Oracle_WT/instances/instance1/bin
$pwd
$ls -l
$./opmnctl stopall
$./opmnctl startall

----APEX should now be available from a URL like "http://machine:port/apex".--default port 7777