Installing Oracle Application Express(APEX) in Linux

来源：互联网发布：百诚网络编辑：程序博客网时间：2024/05/29 09:35

APEX is currently supported on on 10.1 and higher. The 11.x version of the database automatically installs Application Express by default.

So at beginning, you need use below query to check whether your database installed APEX or not.

SELECT COMP_ID,COMP_NAME,VERSION,STATUSFROM DBA_REGISTRYWHERE COMP_ID = 'APEX';

1.Download APEX

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

2.Unzip download zip file, and navigate into unzipped directory.

unzip apex_4.2.1.zip

[oracle@bej301441 apex]$ pwd/home/oracle/ptian/apex[oracle@bej301441 apex]$ lsapex_epg_config_core.sql  appins.sql    apxdvins.sql  apxexit.sql    apxremov.sql  builder      endins.sqlapex_epg_config.sql       apxchpwd.sql  apxe101.sql   apxldimg.sql   apxrtins.sql  catapx.sql   imagesapexins.sql               apxconf.sql   apxe102.sql   apxpatch.sql   apxsqler.sql  core         load_trans.sqlapex_rest_config.sql      apxdbmig.sql  apxe111.sql   apxprereq.sql  apxxemig.sql  coreins.sql  owaapexvalidate.sql          apxdevrm.sql  apxe112.sql   apxrelod.sql   apxxepwd.sql  devins.sql   utilities[oracle@bej301441 apex]$

3.sqlplus to execute related scripts

[oracle@bej301441 11.1.0]$ sqlplus sys/xxx as sysdba

Execute apexins.sql

@apexins SYSAUX SYSAUX TEMP /i/

using apxldimg.asl script to install APEX resource

SQL>@apxldimg /home/oracle/ptian

using apxchpwd.sql to set admin password

SQL>@apxchpwd

open browser and type http://host:8080/apex/apex_admin to login

--------------------------------------------------------------------------------------------------------------------------------------------------------

APEX Schema:
---------
APEX_xxxxxx

How to Install and De-Install:
------------------------------
Note 1086415.1 - Master Note for Oracle Application Express (APEX) Installation