How to install Oracle APEX

sqlplus / as sysdba
sql> SELECT dbms_xdb.gethttpport FROM dual;
sql> EXEC dbms_xdb.sethttpport(0);

>COL comp_name FOR A30
>SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';
 
If there is already installed:

cd $ORACLE_HOME/apex
$ sqlplus / as sysdba

sql> @apxremov_con.sql

If the tablespace is not there already:

CREATE TABLESPACE APEX DATAFILE '/u02/oradata/snap11g/apex_01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 1000M LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

 sql> @apexins APEX APEX TEMP /i/
 admin password :

sqlplus / as sysdba
sql> @apxchpwd
Under the old apex versions you can edit the script summoned by the apxchpwd.sql (apxxepwd.sql) such as the password can be as strong or weak as you wish. Under the newer versions, you can decide this only from the admin interface.

 embedded PL/SQL Gateway configuration (EPG)

sql> @apex_epg_config.sql /u01/app/oracle/product/11.2.0.3/db_1

 Update the APEX images for the new release

sql> @apxldimg.sql /u01/app/oracle/product/11.2.0.3/db_1

ALTER USER anonymous ACCOUNT UNLOCK;
ALTER USER xdb ACCOUNT UNLOCK;
ALTER USER apex_public_user ACCOUNT UNLOCK;
ALTER USER flows_files ACCOUNT UNLOCK;
 enable the Oracle XML DB HTTP Server port (8080):

 EXEC dbms_xdb.sethttpport(8080);

Enable remote HTTP connections (optional):
EXEC dbms_xdb.setListenerLocalAccess(l_access => FALSE);