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