Install Oracle HTTP Server
Download binary (Oracle Webtier Utilities) from http://www.oracle.com/technetwork/java/webtier/downloads/index2-303202.html
Create user/group
user name: ohs
group: ohs
log on as ohs
extract binary into /var/tmp/ohs
$ cd /var/tmp/ohs/Disk1
$ ./runInstaller
Follow the instructions on screen to create an instance called apex and finish installation, at the end you will see the url to connect to your OHS.
to uninstall it, please run below command in <Web_Tier_ORACLE_HOME>/oui/bin
$ ./runInstaller -deinstall
Download and Install APEX
Download the binary from
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
extract it into /var/tmp/apex
Full development environment
Run apexins.sql passing the following four arguments in the order shown:SQL> @apexins.sql tablespace_apex tablespace_files tablespace_temp images
Where:
tablespace_apex is the name of the tablespace for the Oracle Application Express application user.
tablespace_files is the name of the tablespace for the Oracle Application Express files user.
tablespace_temp is the name of the temporary tablespace or tablespace group.
images is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory as /i/.
connect to your database using sqlplus as sysdba
$ cd /var/tmp/apex/apex
$ sqlplus / as sysdba
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
Change the Password for the ADMIN Account
Login as sysdbaSQL> @apxchpwd.sql
Type in your password when asked.
Configure APEX_PUBLIC_USER Account
Run the following statement:SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK
Changing the Password for the APEX_PUBLIC_USER Account
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password
About Password Expiration in Oracle Database 11g
SQL> CREATE PROFILE UNLIMITED_PASSWORD_LIFETIME LIMIT
SESSIONS_PER_USER DEFAULT
CPU_PER_SESSION DEFAULT
CPU_PER_CALL DEFAULT
CONNECT_TIME DEFAULT
IDLE_TIME DEFAULT
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
COMPOSITE_LIMIT DEFAULT
PRIVATE_SGA DEFAULT
FAILED_LOGIN_ATTEMPTS DEFAULT
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME DEFAULT
PASSWORD_REUSE_MAX DEFAULT
PASSWORD_LOCK_TIME DEFAULT
PASSWORD_GRACE_TIME DEFAULT
PASSWORD_VERIFY_FUNCTION DEFAULT;
SQL> ALTER USER APEX_PUBLIC_USER
PROFILE UNLIMITED_PASSWORD_LIFETIME
ACCOUNT UNLOCK;
Granting Connect Privileges
The following example demonstrates how to grant connect privileges to any host for the APEX_040200 database user. This example assumes you connected to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role.
DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
-- Look for the ACL currently assigned to '*' and give APEX_040200
-- the "connect" privilege if APEX_040200 does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_040200', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
COMMIT;
Enable
Enabling Oracle XML DB Protocol Server
EXEC DBMS_XDB.SETHTTPPORT(8080);
Load Images
if below script failed, user will see blank page when connect to workspace.
SQL> @apxldimg.sql
PL/SQL procedure successfully completed.
Enter value for 1: /var/tmp
PL/SQL procedure successfully completed.
. Loading images directory: /var/tmp/apex/images
Directory created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Commit complete.
Directory dropped.
timing for: Load Images
Elapsed: 00:03:18.77
