Steps to install Apex 4 on linux

Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database.

一、安装需求

Browser Requirement:
To view or develop Oracle Application Express applications, Web browsers must
support JavaScript and the HTML 4.0 and CSS 1.0 standards. The following browsers meet this requirement:
1) Microsoft Internet Explorer 6.0 or later version
2) Firefox 1.0 or later

HTTP Server Requirements:
In order to run, Oracle Application Express must have access to one of the following:
1) Embedded PL/SQL gateway
2)Oracle HTTP Server and mod_plsql
Oracle XML DB HTTP Server with the embedded PL/SQL gateway installs with
Oracle Database 11g. It provides the database with a Web server and also the necessary infrastructure to create dynamic applications.

Oracle Application Express requires the shared_pool_size of the target database to be at least 100 MB.

Disk Space Requirement:
Oracle Application Express disk space requirements are as follows:
1)Free space for Oracle Application Express software files on the file system: 450 MB
2)Free space in Oracle Application Express tablespace: 100MB
3)Free space in SYSTEM tablespace: 85 MB
Free space in Oracle Application Express tablespace for each additional language
(other than English) installed: 30MB

二、安装步骤

1.      Download and Install the latest the APEX

installer:

http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html

 

unzipapex_4.1.zip

Change your working directory to apex.

cdapex

 

$sqlplus /nolog

SQL>CONNECT SYS as SYSDBA

Enterpassword: SYS_password

 

@apexinsSYSAUX SYSAUX TEMP /i/

 

2.      Change the Password for the ADMIN Account

 

$sqlplus /nolog

SQL>CONNECT SYS as SYSDBA

Enterpassword: SYS_password

 

@apxchpwd

Enter a password:

Welcome1

3.       Running the apex_epg_config.sql Configuration Script

Run apex_epg_config.sql passing the file systempath to the base directory where the Oracle Application Express software wasunzipped

 

@apex_epg_config /home/software

 

ALTERUSER ANONYMOUS ACCOUNT UNLOCK;

 

4.    Verifyingthe Oracle XML DB HTTP ServerPort

Enter the following statement to verify the port number:

 

SELECTDBMS_XDB.GETHTTPPORT FROM DUAL;

EXECDBMS_XDB.SETHTTPPORT(8888);

5.      Granting ConnectPrivileges

DECLARE
  ACL_PATH  VARCHAR2(4000);
  ACL_ID    RAW(16);
BEGIN
  -- Look for the ACL currently assigned to '*' and give APEX_030200
  -- the "connect" privilege if APEX_030200 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;
 
  -- Before checking the privilege, ensure that the ACL is valid
  -- (for example, does not contain stale references to dropped users).
  -- If it does, the following exception will be raised:
  --
  -- ORA-20000ORA-29855ORA-44416ORA-06512ORA-44416ORA-06512ORA-44416ORA-20000ORA-29855ORA-44416ORA-06512ORA-44416ORA-06512ORA-44416: Invalid ACL: Unresolved principal 'APEX_030200'
  -- : at "XDB.DBMS_XDBZ", line ...
  --
  SELECT SYS_OP_R2O(extractValue(P.RES, '/Resource/XMLRef')) INTO ACL_ID
    FROM XDB.XDB$ACL A, PATH_VIEW P
   WHERE extractValue(P.RES, '/Resource/XMLRef') = REF(A) AND
         EQUALS_PATH(P.RES, ACL_PATH) = 1;
 
  DBMS_XDBZ.ValidateACL(ACL_ID);
   IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_030200', 
     'connect') IS NULL THEN 
      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH, 
     'APEX_030200', 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_030200', TRUE, 'connect');
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
COMMIT;

三、验证安装是否成功

安装完之后：

(1)shutdown Oracle DB: SQL>shutdown immediate 

(2)重新启动Oracle database listener:

    cd $ORACLE_HOME

    ./lsnrctl start

(3)启动Oracle DB SQL>startup

1.管理界面

http://localhost:8080/apex/apex_admin 

admin/Welcome_1

2.开发界面

http://localhost:8080/apex

参考:

[1]http://www.articlesbase.com/databases-articles/steps-to-install-apex-4-on-linux-3966758.html

[2]http://docs.oracle.com/cd/E11882_01/install.112/e12196/overview.htm