Installing Oracle Application Express(APEX) in Linux

最新推荐文章于 2024-06-24 19:52:33 发布

田攀

最新推荐文章于 2024-06-24 19:52:33 发布

阅读量3.4k

点赞数

本文链接：https://blog.csdn.net/pan_tian/article/details/8644638

版权

Oracle APEX 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

本文指导如何在Linux环境下安装Oracle Application Express (APEX)。首先，检查数据库是否已默认安装了APEX，然后从官方网站下载并解压安装文件。使用apxldimg.asl脚本进行安装，并介绍APEX的schema。同时提供了安装和卸载的主笔记链接。

摘要由CSDN通过智能技术生成

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,STATUS
FROM DBA_REGISTRY
WHERE 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]$ ls
apex_epg_config_core.sql  appins.sql    apxdvins.sql  apxexit.sql    apxremov.sql  builder      endins.sql
apex_epg_config.sql       apxchpwd.sql  apxe101.sql   apxldimg.sql   apxrtins.sql  catapx.sql   images
apexins.sql               apxconf.sql   apxe102.sql   apxpatch.sql   apxsqler.sql  core         load_trans.sql
apex_rest_config.sql      apxdbmig.sql  apxe111.sql   apxprereq.sql  apxxemig.sql  coreins.sql  owa
apexvalidate.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