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);
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