Oracle Apex 5.0安装教程

6997人阅读 评论(1) 收藏 举报
分类:

1- The installation requires

Before installing  Oracle Application Express (Oracle APEX) you need to:
  1. Install Oracle Database (10g, 11g or 12c)


2- Download Oracle APEX

To download, you need to log in with an account of  Oracle, if not, you can register a free account.

3- Installing Oracle APEX

Decompress zip file you have downloaded in some position of hard disk drive. Here I decompress it at  C:/DevPrograms.
Note: Your folder must be named  apex. This is compulsory.
Open CMD and CD to apex directory:
Next, enter sqlplus statement in order to log in sqlplus (Note: Don't open sqlplus directly. It should be through CMD after CD to apexdirectory).
Sign in to user sys, as sysdba.
Login successful:
Run script apexins.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
--
-- Run script apexins.sql with parameters:
--
-- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
--
-- Where:
-- tablespace_apex is the name of the tablespace for the Oracle Application Express application user.
-- tablespace_files is the name of the tablespace for the Oracle Application Express files user.
-- tablespace_temp is the name of the temporary tablespace or tablespace group.
-- images is the virtual directory for Oracle Application Express images.
-- (To support future Oracle Application Express upgrades, define the virtual image directory as /i/.)
--
 
@apexins.sql sysaux sysaux temp /i/
Wait for about 30 minutes until the above statement is completed.
The above script create some  SCHEMA on Database, you can test by querying view ALL_USERS on  SQLPlus:

4- Configuring APEX

You need log in  SQLPlus again from  CMD and sign in  sys user as sysdba.

apex_egp_config.sql

This script will load the Application Express images into XDB and then configure a DAD for use by Application Express in the Embedded PL/SQL Gateway.
1
2
3
4
5
6
--
-- Running script apex_epg_config.sql with parameter:
-- @apex_epg_config.sql <parent of apex directory>
--
 
@apex_epg_config.sql C:\DevPrograms

Unlock user anonymous:

1
2
3
-- Unlock user anonymous:
 
alter user anonymous account unlock;

apexconf.sql

Run script apexconf.sql 

Used to perform the final configuration steps for Oracle Application Express, including setting the XDB HTTP listener port and Application Express ADMIN password.
1
2
3
4
5
6
7
--
-- Running script: @apxconf.sql
-- Setup password for ADMIN
-- Configuring XDB Http Listener port
--
 
@apxconf.sql
To user, you can use ADMIN by default, and email can be skipped.
To password, the system requires you to enter a strong password:
Password does not conform to this site's password complexity rules.
  1. Password must contain at least 6 characters.
  2. Password must contain at least one alphabetic character (abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ).
  3. Password must contain at least one punctuation character (!"#$%&()``*+,-/:;?_).
  4. Password must contain at least one upper-case alphabetic character.
  5. Password must contain at least one lower-case alphabetic character.
Port default is 8080:
The configuration has been completed.

5- Running Oracle APEX admin

You have successfully logged into the system of management of Oracle APEX:

6- Getting Started with Oracle APEX programming

Next you can be ready with Oracle APEX programming, you can read document:

查看评论

Oracle APEX系列(一) 安装

 在网上粗略的搜索了一下,已经有很多关于Oracle Application Express(APEX)的文章了,真的很高兴看到已经有这么多国内的朋友使用起这个工具了。要知道,在Oracle公司的很多...
  • tinawang11
  • tinawang11
  • 2006-08-29 12:24:00
  • 19383

<em>Oracle</em> <em>APEX</em>深入浅出

全面,深入,有图有例,从<em>oracle</em>安装<em>Apex</em>到精通 综合评分:4 收藏评论(1)举报 所需: 3积分/C币 <em>下载</em>个数: 12 开通VIP 立即<em>下载</em> ...
  • 2018年04月06日 00:00

Oracle Apex 5.0安装教程

1- The installation requiresBefore installing  Oracle Application Express (Oracle APEX) you need to:...
  • sunansheng
  • sunansheng
  • 2017-07-03 14:46:23
  • 6997

Oracle APEX 5.0 新手教程(六) 权限控制

Adding Security to your Database Application Using Oracle Application Express 5.0 Before You ...
  • sunansheng
  • sunansheng
  • 2016-01-06 15:08:59
  • 4105

[精]Oracle APEX 5.0 新手教程(一) Form表单

Oracle APEX Tutorial for Beginners (APEX 5.0) 1- Introduction2- Create Workspace3- Work with Wo...
  • sunansheng
  • sunansheng
  • 2015-12-26 15:18:40
  • 18754

<em>Oracle</em> Application Express: Build Powerful Data

<em>Oracle</em> Application Express: Build Powerful Data-Centric Web Apps with <em>APEX</em> (<em>Oracle</em> Press) by Arie Geller English 5 May 2017 ASIN: B07259XHLF ...
  • 2018年04月05日 00:00

[精]Oracle 11G数据库VMware虚拟机下载

虚拟机文件下载地址: http://pan.baidu.com/s/1pJL5Tub Readme文件: 数据库版本: Oracle Database 11g Enterprise Edition...
  • sunansheng
  • sunansheng
  • 2015-11-06 11:05:55
  • 6348

APEX 5.0新手教程

  • 2016年01月29日 14:39
  • 5.38MB
  • 下载

Oracle APEX installation with ORDS

在开始之前,先介绍下Oracle Application Express(APEX)。 Oracle Application Express—APEX for short, or by its for...
  • yangyangman0
  • yangyangman0
  • 2015-08-04 16:25:36
  • 3068

APEX的安装

http://blog.csdn.net/tinawang11/article/details/1136548 安装APEX还算简单,一步步按照Installation guide就可以。我是装了O...
  • cnbird2008
  • cnbird2008
  • 2012-01-20 08:52:29
  • 2936
    个人资料
    专栏达人 持之以恒
    等级:
    访问量: 197万+
    积分: 1万+
    排名: 850
    技术交流

    苏南生的博客
    主页 | BOOK搜索 | 免费杂志 |
    博客专栏
    最新评论